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- 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, Oplema's browser app for data prep? Build your first data flow on a blank canvas first.
Course outline
See the problem
Make the values trustworthy
Decide which rows count and add context
Reshape and close
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.