---
title: "Free beginner data preparation course | Oplema"
description: "Learn to clean, combine and reshape messy data in a free course with nothing to install: reconcile two reports, parse dates and remove duplicates."
url: "https://oplema.com/learn/data-preparation"
updated: "2026-11-04"
---

Free · Beginner · 15 lessons

# Data preparation

Free course, nothing to install. Learn to clean, combine and reshape messy data, and to show your work. The course follows one fictional company whose two reports of the same quarter are €5,682 apart, and you find out why.

[Start the course](https://oplema.com/learn/data-preparation/what-is-data-prep)

**Who it's for**

People who get exports and spreadsheets, and have to answer for what they add up to.

If you've worked with rows and columns, you're ready. You don't need any programming experience.

**You'll be able to**

- Read numbers and dates the way the file wrote them
- Find duplicate rows and decide which copy to keep
- Catch a join that loses and doubles rows while its count stays the same
- Reconcile two totals to the euro, and explain each step

**You leave with**

The prepared Q3 table for fictional Vandelay Coffee Supply, with both reports reconciled to the euro, and a bridge template for your own files.

Each lesson starts with the plain answer and its Excel and SQL equivalents, and opens with its data in place, so you can go straight to the topic you need.

New to [Strata](https://oplema.com/strata), Oplema's browser app for data prep? [Build your first data flow](https://oplema.com/learn/export-to-report/first-data-flow) on a blank canvas first.

## Course outline

### See the problem

1. [1 What is data preparation? Concept](https://oplema.com/learn/data-preparation/what-is-data-prep)
2. [2 What is data grain? How each step changes a table Concept](https://oplema.com/learn/data-preparation/how-tables-change)

### Make the values trustworthy

3. [3 Append vs join: stacking rows from two tables Lab](https://oplema.com/learn/data-preparation/append)
4. [4 Data types and casting: CAST vs parsing Lab](https://oplema.com/learn/data-preparation/types-and-casts)
5. [5 Parsing dates from text: day first or month first Lab](https://oplema.com/learn/data-preparation/parse-text-and-dates)
6. [6 Null vs blank vs zero: cleaning missing values Lab](https://oplema.com/learn/data-preparation/cleanse-and-nulls)

### Decide which rows count and add context

7. [7 Sorting data by one or more columns Lab](https://oplema.com/learn/data-preparation/sort)
8. [8 Finding and removing duplicate rows Lab](https://oplema.com/learn/data-preparation/unique-and-duplicates)
9. [9 Filtering rows: WHERE, conditions and nulls Lab](https://oplema.com/learn/data-preparation/filter-rows)
10. [10 Inner vs left: joining tables by key Lab](https://oplema.com/learn/data-preparation/joins)
11. [11 Calculated columns vs aggregates explained Lab](https://oplema.com/learn/data-preparation/formulas)

### Reshape and close

12. [12 GROUP BY: grouping and summarizing rows Lab](https://oplema.com/learn/data-preparation/summarize)
13. [13 Wide vs long data: pivot and unpivot Lab](https://oplema.com/learn/data-preparation/transpose-and-crosstab)
14. [14 Running totals and rolling averages Lab](https://oplema.com/learn/data-preparation/rolling-windows)
15. [15 How to reconcile two reports that disagree Lab](https://oplema.com/learn/data-preparation/messy-file-to-table)

## Start with lesson 1.

Reconcile two conflicting reports to the euro, parse values, remove duplicates, audit joins and hand over a table you can defend.

[Start the course](https://oplema.com/learn/data-preparation/what-is-data-prep) [Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata)
