This is the first type of analytics β it answers the question:
π βWhat happened?β
Once your data is cleaned, the first step is to summarize it.
πΉ Common Techniques in Descriptive Analytics
-
Totals (Sum) β e.g., total sales in August = βΉ1,500.
-
Averages (Mean) β e.g., average daily sales = βΉ300.
-
Maximum / Minimum β e.g., highest sales in a day = βΉ500, lowest = βΉ100.
-
Count β e.g., number of transactions = 30 days.
-
Percentages / Growth β e.g., Week 1 sales vs Week 2 sales (growth rate).
πΉ Example (from cleaned data)
Date | Product | Sales |
---|---|---|
01-08-25 | Product A | 100 |
02-08-25 | Product A | 0 |
03-08-25 | Product B | 200 |
04-08-25 | Product A | 1000 |
05-08-25 | Product C | 150 |
-
Total sales = 1450
-
Average sales = 290 per day
-
Highest sales = 1000 (on 4th Aug)
-
Lowest sales = 0 (on 2nd Aug)
This already tells a story:
π On one day sales boomed (1000), on another day there were none (0). Thatβs important for business.
πΉ Tools you can use
-
Excel: SUM, AVERAGE, COUNT, MAX, MIN, Pivot Tables.
-
SQL: SUM(), AVG(), COUNT(), MAX(), MIN().
β
Checkpoint for you:
If you were showing this sales data to a manager, which 2 descriptive analytics points would you highlight first? (Total sales, average, highest, lowest, etc.)