Calendar
The month grid needs JavaScript. Use the List tab instead.
Unit 1 · Data sources and extraction
| Date | Class | What to do |
|---|---|---|
| Wed 23 Sep 2026 | Data do not speak alone | Anscombe's quartet and the four stages of the data lifecycle |
| Mon 28 Sep 2026 | Data sources | Databases, CSV, Excel, JSON, APIs and open data |
| Wed 30 Sep 2026 | Connecting Superset | Host, port, user, driver — and your first CSV upload |
| Mon 5 Oct 2026 | SQL Lab: filters | SELECT, WHERE, ORDER BY and LIMIT |
| Wed 7 Oct 2026 | SQL Lab: groups | Aggregates, GROUP BY and HAVING |
| Wed 14 Oct 2026 | SQL Lab: joins | Two tables, one key: INNER JOIN and LEFT JOIN |
| Mon 19 Oct 2026 | Datasets and destination | Physical and virtual datasets, storing results, APIs as a source |
| Wed 21 Oct 2026 | Getting data with Power BI | Connectors and import in the commercial tool |
| Mon 26 Oct 2026 | Exam | Covers the eight lessons of the unit |
Unit 2 · Cleaning and transforming data
| Date | Class | What to do |
|---|---|---|
| Wed 28 Oct 2026 | Data quality | Auditing a table before you touch it |
| Wed 4 Nov 2026 | Types and formats | Text, numbers, dates and the casts between them |
| Mon 9 Nov 2026 | Units and duplicates | Units, hidden characters and repeated rows |
| Wed 11 Nov 2026 | Categorisation | Grouping values into bands with CASE |
| Mon 16 Nov 2026 | Imputation | What to put where a value is missing |
| Wed 18 Nov 2026 | Synthetic variables | Calculated columns and aggregate metrics |
| Mon 23 Nov 2026 | Power Query | The same cleaning, with applied steps instead of SQL |
| Wed 25 Nov 2026 | Exploratory statistics | Mean, median, spread and distribution |
| Mon 30 Nov 2026 | The descriptive report | Describing a dataset in numbers and words |
| Wed 2 Dec 2026 | Exam | Covers the nine lessons of the unit |
| Wed 9 Dec 2026 | First evaluation close (Units 1 and 2) | Marks for Units 1 and 2 |
Unit 3 · Data visualisation
| Date | Class | What to do |
|---|---|---|
| Mon 14 Dec 2026 | Visual perception | How the eye reads a chart |
| Wed 16 Dec 2026 | Bar and line charts | Comparing categories, following change over time |
| Mon 21 Dec 2026 | Histogram and scatter plot | Distributions and relationships |
| Mon 11 Jan 2027 | Pie, heatmap and others | Parts of a whole, and two categories at once |
| Wed 13 Jan 2027 | Choosing the right chart | From the question to the chart |
| Mon 18 Jan 2027 | Configuring charts | Dimensions, metrics, titles and formats |
| Wed 20 Jan 2027 | Misleading charts | How charts lie, and how to catch them |
| Mon 25 Jan 2027 | Exam | Covers the seven lessons of the unit |
Unit 4 · Dashboards and reports
| Date | Class | What to do |
|---|---|---|
| Wed 27 Jan 2027 | Dashboards and KPIs | What goes on the screen, and where |
| Mon 1 Feb 2027 | Building a dashboard | Charts, rows, tabs and big numbers |
| Wed 3 Feb 2027 | Filters and cross-filters | Letting the reader explore |
| Mon 8 Feb 2027 | Publishing and permissions | Drafts, roles and who can see what |
| Wed 10 Feb 2027 | Reports with Power BI | Visuals, pages and slicers |
| Mon 15 Feb 2027 | Storytelling with data | Comparing the tools and communicating conclusions |
| Wed 17 Feb 2027 | Project workshop | Checklist, KPI check and timed rehearsal |
| Mon 22 Feb 2027 | Project presentations | Present your project |
| Wed 24 Feb 2027 | Closing session | Last presentations, recovery and wrap-up |