Data Analyst

Clean, explore and communicate data so teams can make better decisions with evidence.

In short— Utageuza spreadsheet chaos ikuwe insights watu wanaelewa bila calculator stress.

Free roadmap

What you'll learn

Click any stage kufungua full details.

01Stage 01Spreadsheet fluencyFormulas, lookups and pivot tables • Cleaning, validation and formatting

Use spreadsheets quickly while keeping analysis reproducible and understandable.

Focus on

  • Formulas, lookups and pivot tables
  • Cleaning, validation and formatting
  • Charts and business calculations
Build check: Build an interactive sales workbook.

Ukimaliza hapa, usirush next stage—build kitu kwanza.

02Stage 02SQLSELECT, filtering and aggregation • JOINs, subqueries and CTEs

Ask precise questions of structured data and combine tables safely.

Focus on

  • SELECT, filtering and aggregation
  • JOINs, subqueries and CTEs
  • Window functions and query optimization
Build check: Answer ten business questions from a sample database.

Ukimaliza hapa, usirush next stage—build kitu kwanza.

03Stage 03StatisticsDescriptive statistics and distributions • Sampling, confidence and hypothesis tests

Choose useful measures and avoid misleading conclusions.

Focus on

  • Descriptive statistics and distributions
  • Sampling, confidence and hypothesis tests
  • Correlation, regression and experiment basics
Build check: Analyze an A/B test and explain uncertainty.

Ukimaliza hapa, usirush next stage—build kitu kwanza.

04Stage 04Data cleaningMissing values and outliers • Python with pandas or R

Prepare messy datasets for consistent analysis.

Focus on

  • Missing values and outliers
  • Python with pandas or R
  • Reproducible notebooks and documentation
Build check: Clean and document a public dataset.

Ukimaliza hapa, usirush next stage—build kitu kwanza.

05Stage 05Visualization and BIChart selection and visual hierarchy • Power BI or Tableau

Match the chart and dashboard to the decision being made.

Focus on

  • Chart selection and visual hierarchy
  • Power BI or Tableau
  • Dashboard filters and data storytelling
Build check: Build an executive dashboard with recommendations.

Ukimaliza hapa, usirush next stage—build kitu kwanza.

06Stage 06Portfolio casesBusiness problem definition • Insight writing and stakeholder communication

Frame analysis around a real question, not random charts.

Focus on

  • Business problem definition
  • Insight writing and stakeholder communication
  • Portfolio case-study structure
Build check: Publish three end-to-end analysis case studies.

Ukimaliza hapa, usirush next stage—build kitu kwanza.

Now build kitu real.

Pick one project that solves an actual problem, ship it, then explain what you learned. Hapo ndio portfolio inaanza kuhit different.

Choose another path