Saltar al contenido principal

Data Analytics

SQL, statistics and visual communication. The rare skill is not the query — it is knowing which question is worth answering and presenting the answer so someone changes their mind.

3 stages14 steps~355 hours~6 months
Track this roadmap free
  1. 1

    Query and clean

    Beginner~8 weeks

    SQL and spreadsheets, plus the discipline of trusting nothing.

    • SQL: SELECT, JOIN, GROUP BY, subqueries

      Skill~30h

    • Spreadsheet modelling: pivot tables, lookups, what-if

      Skill~15h

    • Data cleaning: nulls, duplicates, type coercion, outliers

      Skill~20h

    • Analyse a public dataset end to end and write up the finding

      Project~25h
  2. 2

    Analyse and visualise

    Intermediate~10 weeks

    Statistics that hold up under scrutiny, and charts that do not mislead.

    • Descriptive and inferential statistics

      Skill~30h

    • Python with pandas, or R with the tidyverse

      Skill~35h

    • Visualisation principles: encoding, scale, honest axes

      Skill~18h

    • Tableau or Power BI to a publishable standard

      Skill~25h

    • Build a dashboard someone else uses weekly

      Project~30h
  3. 3

    Influence

    Advanced~10 weeks

    Experimentation, warehouse-scale modelling, and getting the recommendation adopted.

    • A/B testing: power, significance, and common traps

      Skill~25h

    • dbt and analytics engineering fundamentals

      Skill~30h

    • Cohort, funnel and retention analysis

      Skill~20h

    • Google Data Analytics or Microsoft PL-300 certification

      Certification~40h

    • Present an analysis to non-technical stakeholders

      Project~12h