Free · Beginner · 9 lessons
Combine and reconcile data files
Free course, nothing to install. Learn Strata, Oplema's browser app for data prep, on month-end work: stack three shops' till files and work through the register, repairs, web payments and budget, explaining every row that doesn't fit, then build the month-end table. Each lab starts part-built and wrong, and you complete it.
Start the course- Who it's for
- People who can build a simple flow in Strata and now have several files that must agree.
- If you've finished Build a report from a CSV export, or can already place and wire blocks, read a preview and filter rows, you're ready.
- You'll be able to
- Stack files despite renamed columns
- Remove repeated rows
- Attach and explain unmatched rows
- Match misspelled names
- Unpack crammed cells and JSON
- Reshape a wide sheet
- Fix someone else's flow
- You leave with
- A month-end table for fictional Kramerica Bikes' three shops, with every gap explained and built mostly unaided.
Each lesson ends with one line for the owner and a figure to check your result against. The last lesson fixes a colleague's flow, then has you build month-end yourself. Every lab runs in its lesson page.
Course outline
Bring the files together
Untangle what the files hide
Fix and build month-end
Start with lesson 1.
Stack files with renamed columns, remove repeated rows, explain unmatched joins, match misspelled names, unpack JSON and reshape a budget.