---
title: "Free data preparation and BI courses | Oplema"
description: "Learn data preparation and business intelligence in five free courses that run in your browser, from a first CSV in Strata to a published dashboard."
url: "https://oplema.com/learn"
updated: "2026-11-04"
---

# 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 lessons Build a data flow on a blank canvas, load a CSV, filter it, account for every row and ship a report you can check.](https://oplema.com/learn/export-to-report)
- [
  ### Combine and reconcile data files
  Beginner · 9 lessons Stack files with renamed columns, remove repeated rows, explain unmatched joins, match misspelled names, unpack JSON and reshape a budget.](https://oplema.com/learn/many-sources)
- [
  ### Build and publish a dashboard
  Beginner · 8 lessons Filter a dashboard by shop, let a reader test an assumption, fill missing days, keep files in Cloud, publish, then build a project alone.](https://oplema.com/learn/table-to-dashboard)

## 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 lessons Reconcile two conflicting reports to the euro, parse values, remove duplicates, audit joins and hand over a table you can defend.
  - See the problem 1–2
  - Make the values trustworthy 3–6
  - Decide which rows count and add context 7–11
  - Reshape and close 12–15
  ](https://oplema.com/learn/data-preparation)
- [
  ### Business intelligence
  Beginner · 15 lessons Write metrics that hold up, test reports by reconciling them, and turn the result into a dashboard and a decision memo.
  - Decide what you're measuring 1–2
  - Test the evidence 3–6
  - Make it repeatable 7–8
  - Show it 9–12
  - Keep it true 13–15
  ](https://oplema.com/learn/business-intelligence)

### 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, Sales** Slide 1 of 1

€15,850

South is winning.

Source: Don.

€5,682 apart

**Sydney Swell, Finance** Tab 14 of 31

<table class="my-auto w-full tabular-nums"><tbody><tr class="border-b border-slate-200 dark:border-white/10"><th scope="row" class="py-1.5 text-left font-normal">North</th><td class="text-right">€5,578</td></tr><tr class="border-b border-slate-200 dark:border-white/10"><th scope="row" class="py-1.5 text-left font-normal">South</th><td class="text-right">€4,590</td></tr></tbody><tfoot><tr class="font-semibold text-slate-950 dark:text-slate-100"><th scope="row" class="py-1.5 text-left font-semibold">Q3 total</th><td class="text-right">€10,168</td></tr></tfoot></table>

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.

- [Reconciliation bridge](https://oplema.com/learn/data-preparation/messy-file-to-table#bridge-template)
  Walk one report's total to the other's, step by step.
- [Metric contract](https://oplema.com/learn/business-intelligence/kpis-metrics#contract-template)
  Write down what a number means and who owns it.
- [Decision memo](https://oplema.com/learn/business-intelligence/messy-export-to-dashboard#memo-template)
  State the decision, the evidence and what would change it.

### Sample files

- [vandelay-invoices-jul-aug.csv](https://oplema.com/learn/files/vandelay-invoices-jul-aug.csv)
- [vandelay-invoices-sep.csv](https://oplema.com/learn/files/vandelay-invoices-sep.csv)
- [vandelay-invoices-oct.csv](https://oplema.com/learn/files/vandelay-invoices-oct.csv)
- [vandelay-customers.csv](https://oplema.com/learn/files/vandelay-customers.csv)

## Your exports. Your number.

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

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [Open Vista](https://oplema.com/editor?path=%2F%3Fopen%3Dvista)
