Free · Beginner · 15 lessons

Business intelligence

Free course, nothing to install. Define KPIs, test reports, design dashboards and write the decision they support, using one fictional company deciding where to place a new hire, and two reports that disagree.

Start the course
Who it's for
People who use reports to understand performance or guide business decisions.
If you've worked with rows and columns, you're ready. You don't need SQL or dashboard experience.
You'll be able to
  • Write a metric definition that holds up in an argument
  • Test a report by reconciling it
  • Choose a chart for each question
  • Notice when a successful refresh changes what a number means, and say where the data stops
You leave with
A dashboard and a one-page decision memo for fictional Vandelay Coffee Supply's hire, with contract and memo templates for your own work.

Every lesson opens with its data in place. The table comes from Data preparation, but you don't need that course first.

New to Strata, Oplema's browser app for data prep? Build your first data flow on a blank canvas first.

Course outline

Decide what you're measuring

  1. 1What is business intelligence?Concept
  2. 2KPI vs metric: how to define what you measureConcept

Test the evidence

  1. 3Where business data lives: systems and exportsConcept
  2. 4Data quality dimensions and how they move a metricLab
  3. 5Join fan-out: how joins inflate metricsLab
  4. 6Mean, median and weighted average in reportingLab

Make it repeatable

  1. 7ETL vs ELT: what's the difference?Lab
  2. 8What is a star schema? Facts and dimensionsConcept

Show it

  1. 9How to choose the right chart for your questionConcept
  2. 10Dashboard design best practices and a checklistLab
  3. 11Dashboard filters: scope, selections and limitsLab
  4. 12What is self-service BI, and what does it need?Concept

Keep it true

  1. 13How to check a dashboard after a data refreshLab
  2. 14What is data governance? Owners and change notesLab
  3. 15How to write a decision memo from a dashboardLab

Start with lesson 1.

Write metrics that hold up, test reports by reconciling them, and turn the result into a dashboard and a decision memo.