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.
Build a report from a CSV export
Beginner · 10 lessonsBuild a data flow on a blank canvas, load a CSV, filter it, account for every row and ship a report you can check.Combine and reconcile data files
Beginner · 9 lessonsStack files with renamed columns, remove repeated rows, explain unmatched joins, match misspelled names, unpack JSON and reshape a budget.Build and publish a dashboard
Beginner · 8 lessonsFilter a dashboard by shop, let a reader test an assumption, fill missing days, keep files in Cloud, publish, then build a 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.
Data preparation
Beginner · 15 lessonsReconcile two conflicting reports to the euro, parse values, remove duplicates, audit joins and hand over a table you can defend.- See the problem1–2
- Make the values trustworthy3–6
- Decide which rows count and add context7–11
- Reshape and close12–15
Business intelligence
Beginner · 15 lessonsWrite metrics that hold up, test reports by reconciling them, and turn the result into a dashboard and a decision memo.- Decide what you're measuring1–2
- Test the evidence3–6
- Make it repeatable7–8
- Show it9–12
- Keep it true13–15
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.
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.
- Reconciliation bridge
Walk one report's total to the other's, step by step.
- Metric contract
Write down what a number means and who owns it.
- Decision memo
State the decision, the evidence and what would change it.
Your exports. Your number.
Strata and Vista open in your browser, with no account.