Free data preparation and BI courses

Free, hands-on courses in data preparation and business intelligence. Every lab runs in your browser, with nothing to install.

Hands-on courses: from CSV export to dashboard

Hands-on courses, taken in order. You inherit Kramerica Bikes' spreadsheets and build the flows that answer the owner's questions, then build a practice project alone.

Data preparation and business intelligence courses

What data preparation and business intelligence mean, whatever tool you use. Each lesson stands on its own and opens with its data in place.

The case

Vandelay Coffee Supply, a fictional company, has one new hire to place and two reports on the same quarter. Max Thrust, the founder, has to pick a region. You get the raw exports and work out which number to believe.

Don Tremendous, SalesSlide 1 of 1

€15,850

South is winning.

Source: Don.

€5,682 apart

Sydney Swell, FinanceTab 14 of 31

North€5,578
South€4,590
Q3 total€10,168

North is ahead.1

1 Subject to review.

Same invoices, same quarter. Type not to scale; Don insisted.

How lessons work

  • Most lessons do one job on a fictional company's files: Kramerica Bikes in the Strata courses and Vandelay Coffee Supply in the concept courses. The last Strata course's practice project is on a business you haven't seen.
  • Most labs put a real Strata or Vista canvas in the page, and it runs there. Some start on a blank canvas, some pick up where the last lab left off and some start part-built and wrong for you to fix.
  • A few Strata lessons move to the full app in your browser: one to load a file from your computer, and later ones to save to Cloud, publish a dashboard and build the final project, which need a free account.
  • Each exercise ends on a self-check, usually a figure, so you know whether your change did what you predicted.
  • Concept lessons cover what the labs can't, such as what a metric means and who owns it.

Templates and files

Plain tables that work in any tool, and Vandelay's raw exports with their faults intact.

Your exports. Your number.

Strata and Vista open in your browser, with no account.