Data Literacy and Analytics Roadmap

The skill every role is starting to expect: ask a question, get the data, and show an answer people can trust.

8 milestones · ~112 hours total

1. 1

   Thinking in data

   ~6h

   Rows, columns, types, units, missing values, and asking a question that data can actually answer.

   Practice this →
2. 2

   Spreadsheets properly

   ~10h

   Formulas, lookups, pivot tables and charts. Most business analysis still starts here.

   Practice this →
3. 3

   SQL for analysis

   ~20h

   SELECT, filters, joins, GROUP BY, window functions and CTEs to answer business questions.

   Practice this →
4. 4

   Statistics you will use

   ~14h

   Mean vs median, distributions, variance, sampling, correlation vs causation and confidence intervals in plain terms.

   Practice this →
5. 5

   Python for data

   ~20h

   pandas for cleaning, reshaping and summarising, plus a notebook workflow you can share.

   Practice this →
6. 6

   Charts that communicate

   ~8h

   Pick the right chart, remove clutter, label clearly and avoid misleading axes.

   Practice this →
7. 7

   Dashboards and storytelling

   ~14h

   Build a dashboard in a BI tool and write a one-page summary with a clear recommendation.

   Practice this →
8. 8

   A portfolio analysis

   ~20h

   Pick a public dataset, answer a real question end to end and publish the method and findings.

   Practice this →