Data4 months

Data Analyst

The fastest credible route into a data role: SQL, spreadsheets, dashboards and business sense.

  1. Step 01

    Spreadsheets

    Pivot tables, lookups, cleaning messy exports and building a repeatable workbook.

    ExcelSheets

  2. Step 02

    SQL

    Joins, aggregation, window functions and writing queries an analyst can hand to engineering.

    SQL

  3. Step 03

    Statistics

    Distributions, significance, sample size and the difference between correlation and a story.

    Statistics

  4. Step 04

    Visualisation

    Dashboard design, chart choice, annotation and avoiding misleading axes.

    Power BIMetabase

  5. Step 05

    Python or R

    Automating recurring analysis, reading APIs and cleaning at scale.

    pandas

  6. Step 06

    Business framing

    Defining metrics, cohorts, funnels and writing findings decision-makers act on.

    MetricsStorytelling