Certificate in Data Analysis · Module 1: Why Data Matters and Excel Fundamentals, 1.1 Why Data Analysis Matters

Free Preview

Course content

Module 1: Why Data Matters and Excel Fundamentals 4

1.1 Why Data Analysis Matters
1.2 Excel Fundamentals and Clean Data Entry
1.3 Organising and Cleaning Your First Dataset
Module 1 Quiz: Data and Excel Basics

Module 2: Formulas for Everyday Analysis 4

2.1 SUM, AVERAGE and COUNT Functions
2.2 IF and COUNTIF Functions
2.3 Finding Records with VLOOKUP
Module 2 Quiz: Excel Formulas

Module 3: Sorting, Filtering and Pivot Tables 4

3.1 Sorting and Filtering Data
3.2 Introduction to Pivot Tables
3.3 Practical Data Exploration
Module 3 Quiz: Sorting, Filtering and Pivot Tables

Module 4: Charts and Basic Statistics 4

4.1 Charts That Tell the Truth
4.2 Mean, Median and Percentages
4.3 Statistics with Maize Yield and Sales Examples
Module 4 Quiz: Charts and Statistics

Module 5: Google Sheets, Power BI and Dashboards 5

5.1 Google Sheets for Shared Work
5.2 Introduction to Power BI Free Version
5.3 Building a Simple Dashboard
5.4 Presenting Your Findings
Module 5 Quiz: Shared Work and Dashboards

Module 1: Why Data Matters and Excel Fundamentals

1.1 Why Data Analysis Matters

Certificate in Data Analysis

60 min

What You Will Learn

By the end of this lesson you will be able to explain what data analysis is in plain language, give three examples of how it helps people in Zambia make better decisions, and describe the difference between raw data and useful information. You will also know how to spot a good question that data can answer.

What Is Data Analysis?

Data analysis is the process of collecting information, organising it, and looking for patterns that help us make better decisions. In simple terms, it means turning numbers and facts into answers. Every time you check which product sells best in your shop, compare school results, or decide how much maize seed to buy, you are doing a form of data analysis.

Data becomes powerful when we write it down, organise it, and look at it carefully. A shop owner in Soweto Market might remember that sugar sells fast, but if she keeps a small notebook of daily sales, she can see exactly how fast, which size of bag sells best, and whether sales rise before public holidays. That knowledge helps her order the right stock and avoid losing money.

Why Data Analysis Matters in Zambia

Data analysis is not only for big companies in Lusaka. It helps ordinary Zambians every day:

CDF project reporting: Constituency Development Fund projects must show how money was spent and what was achieved. Clear data makes reports honest and easy to understand.
Small business sales: A marketeer who records each sale can see which products make profit and which ones waste shelf space.
School results: A teacher who tracks test marks can see which topics learners understand and where extra lessons are needed.
Farming decisions: A smallholder who records maize yield per field can compare seed types and plan better for next season.
Mobile money records: Airtel Money and MTN MoMo agents who reconcile daily float and transaction counts avoid losses from errors or fraud.

From Raw Data to Useful Information

Raw data is a collection of facts before they are organised. Useful information is data that has been sorted, summarised, and presented so someone can act on it. For example, a list of every sale in a shop for one month is raw data. A summary that shows total sales per product, best-selling days, and average transaction size is useful information.

Worked Example: A Shopkeeper's Monthly Review

Mary runs a small grocery shop in Kalomo. For one month she writes down every sale: date, item, quantity, and price. At the end of the month she has 400 lines of raw data. By adding up the totals she learns:

Cooking oil brought in K3,200.
Soap brought in K1,800.
Sales were highest on Fridays and Saturdays.
The average customer spent K45.

Now Mary can decide to order more cooking oil before weekends, reduce the soap variety that sells slowly, and plan promotions for quiet weekdays. The same records that looked like a mess became a tool for profit.

Try It Yourself

Think of one activity you do each week where you make a decision based on memory or guessing. Examples include shopping, selling goods, or planning study time.
On your phone or in a small notebook, record the basic facts for five days. For example, if you sell airtime, write down date, network, amount sold, and profit.
At the end of five days, add up the totals and write one sentence about what you learned.
Share your finding with a friend or classmate and ask if the number surprises them.

Key Terms

Data: Facts, numbers, or details collected for reference or analysis.
Raw data: Unorganised facts before they have been cleaned or summarised.
Information: Data that has been organised so it is meaningful and useful.
Analysis: The process of examining data to find patterns, trends, and answers.
Decision: A choice made after considering information.

Summary

Data analysis helps people in every part of Zambia make better decisions, from CDF project reporting to shopkeeping and farming. The first step is to collect facts carefully, then organise them so patterns become clear. When raw data becomes useful information, ordinary people gain the power to plan, save money, and grow their businesses.