← All courses

📊 BI & Data Visualization

Choose the right chart, define a metric once, and build dashboards people act on — plus operational reporting and delivery.

No lessons published yet — this is the roadmap, so you can see exactly what the course will cover before it lands.

Before you start: Learn SQL — Series 2. A chart is a GROUP BY you can see. Series 2 · 15 in particular — a widget built on a fanned-out join shows a number that is confidently, plausibly too big.

Short on time? The 26 episodes marked core are the shortest path to being productive at work. Start there and pick up the rest whenever a job asks for them.

Series 1 · Charts That Tell the Truth

pick the right chart, and build one that is not misleading

  1. 01

    Why Visualize — What a Chart Shows That a Table Does Not

    corebeginnercoming soon
  2. 02

    Visual Encoding — Position, Length, Colour and What the Eye Reads First

    corebeginner#cleveland-mcgillcoming soon
  3. 03

    Choosing the Right Chart — Match the Chart to the Question

    corebeginnercoming soon
  4. 04

    Building a Chart Without SQL — Pick the Data, Pick the Shape

    corebeginnercoming soon
  5. 05

    Bar & Column — Comparing Categories (Revenue by Category)

    corebeginnercoming soon
  6. 06

    Line & Area — Trends Over Time (Monthly Orders)

    corebeginnercoming soon
  7. 07

    Pie, Donut & Part-to-Whole — And Why to Use Them Sparingly

    beginnercoming soon
  8. 08

    KPIs, Gauges & Big Numbers — When a Number Beats a Chart

    corebeginnercoming soon
  9. 09

    Colour — Meaning, Scales and Accessibility

    beginnercoming soon
  10. 10

    Honest Charts — Axes, Scales and How Not to Mislead

    corebeginner#tuftecoming soon
  11. 11

    Project — From a Query to a Chart Someone Else Can Read

    corebeginner#projectcoming soon

Series 2 · From Charts to Answers

harder chart types, and one agreed definition per metric

  1. 01

    Aggregation & Granularity — What One Mark Actually Represents

    coreintermediatecoming soon
  2. 02

    Multi-Series & Small Multiples — Compare Without Clutter

    intermediatecoming soon
  3. 03

    Distributions — Histograms & Box Plots, Beyond the Average

    coreintermediate#tukeycoming soon
  4. 04

    Geospatial — Choropleth Maps (Sales by ShipCountry)

    intermediatecoming soon
  5. 05

    Sankey & Scatter — Flows, Relationships and Two Measures at Once

    intermediatecoming soon
  6. 06

    Time Intelligence — MTD, YTD, YoY, Moving Averages & Sparklines

    coreintermediatecoming soon
  7. 07

    Pivot Tables — Cross-Tab Analysis (Category × Quarter)

    coreintermediatecoming soon
  8. 08

    Metrics & KPIs — Defining What 'Good' Means, Once

    coreintermediatecoming soon
  9. 09

    The Semantic Layer — One Definition of Revenue the Whole Org Uses

    coreintermediatecoming soon
  10. 10

    Filters, Drill-Down & Cross-Filtering — Let People Ask the Next Question

    coreintermediatecoming soon
  11. 11

    Custom SQL for One Widget — What to Do When Point-and-Click Runs Out

    coreintermediatecoming soon
  12. 12

    Project — One Metric, Defined Once, Correct Everywhere

    coreintermediate#projectcoming soon

Series 3 · Dashboards, Delivery & Adoption

build a dashboard, then schedule, share and secure it

  1. 01

    Dashboard Layout — Information Hierarchy and What Belongs at the Top

    coreadvanced#fewcoming soon
  2. 02

    Exploratory vs Explanatory — Design for Who's Looking

    advancedcoming soon
  3. 03

    Build a Multi-Widget Dashboard — Layout, Filters and One Story

    coreadvancedcoming soon
  4. 04

    Dashboards as Files — Version Control, Review and Rebuilding From Scratch

    advancedcoming soon
  5. 05

    Linked Views & Cross-Widget Drill-Down — Click a Bar, Filter the Page

    advancedcoming soon
  6. 06

    Operational & Pixel-Perfect Reporting — When the Layout Is the Requirement

    coreadvancedcoming soon
  7. 07

    Dashboard Performance — Why It Takes Forty Seconds, and What to Cache

    coreadvancedcoming soon
  8. 08

    Live Dashboards — Refresh, Poll or Push, and Whether Anyone Is Watching

    advancedcoming soon
  9. 09

    Report Bursting — One Report, Many Recipients, Each Seeing Only Theirs

    coreadvancedcoming soon
  10. 10

    Scheduled Delivery — Email, Portals and Files, on a Schedule

    coreadvancedcoming soon
  11. 11

    Self-Service Portals — Secure, Personalized Access Without a Ticket

    advancedcoming soon
  12. 12

    Governance & Row-Level Security — Same Numbers for Everyone, and Only Their Rows

    coreadvancedcoming soon
  13. 13

    Data Storytelling — Annotation, Narrative and Sequence

    advanced#knafliccoming soon
  14. 14

    Embedded Analytics — BI Inside Your Own Application

    advancedcoming soon
  15. 15

    Project — A Northwind Executive Suite: Cube → Dashboards → Delivery

    coreadvanced#projectcoming soon

Not here, on purpose

  • Writing the queries behind the widgets — covered in Learn SQL
  • Building the warehouse and designing the cubes themselves — covered in Data Warehousing, which is where a cube gets designed and built. In this course, Series 1 · 12 uses one that already exists
  • Natural-language questions and AI-assisted analysis — covered in AI for Data
  • Plotting for your own exploration in Python — covered in Python for Data — this track is about charts other people read
  • Implementing the metric as version-controlled, tested code — covered in Analytics Engineering with dbt, Series 3 · 30, which writes the agreed definition as code. In this course, Series 2 · 40 is the earlier job of agreeing what it should mean
  • Getting the dashboard's data there on time — covered in ETL & Data Pipelines and Data Ops — here the numbers are assumed to have arrived