Data Analytics and AI

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

  1. Totals (Sum) – e.g., total sales in August = β‚Ή1,500.

  2. Averages (Mean) – e.g., average daily sales = β‚Ή300.

  3. Maximum / Minimum – e.g., highest sales in a day = β‚Ή500, lowest = β‚Ή100.

  4. Count – e.g., number of transactions = 30 days.

  5. 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.)