Udoka Estate, Awka, Anambra State A Subsidiary of Diaspora Digital Media

Introduction to Data Analytics

What does a data analyst do?

A data analyst turns raw data into insights that help people make better decisions: which product sells best, why customers leave, where to spend the marketing budget.

The analysis process

  1. Ask – define the business question clearly.
  2. Prepare – collect the data (spreadsheets, databases, surveys, apps).
  3. Process / clean – fix errors, remove duplicates, handle missing values.
  4. Analyse – summarise, compare, find trends and relationships.
  5. Share – charts, dashboards and a clear story.
  6. Act – recommend decisions.

Types of analytics

  • Descriptive – what happened? (sales last quarter)
  • Diagnostic – why did it happen?
  • Predictive – what will happen?
  • Prescriptive – what should we do?

Core tools

Excel / Google Sheets · SQL · Power BI or Tableau · Python or R.

Exercise: Write three business questions a supermarket in Awka could answer with its sales data. For each, state what data you would need.

Knowledge check

Lesson quiz

Enroll in the course to take the quiz and track your progress.

Enjoying this preview? Enroll to unlock every lesson and earn your certificate.

Enroll in this course