Free · Beginner · 10 lessons
Build a report from a CSV export
Free course, nothing to install. Learn Strata, Oplema's browser app for data prep, on a real job: turn one bike shop's till export into a weekly report you can check. The first lab starts on a blank canvas, and each one after starts where the last left off.
Start the course- Who it's for
- People who get exports, have never used Strata and want to learn it on a real job.
- No Strata experience needed. If you've opened a spreadsheet, you're ready.
- You'll be able to
- Build a flow from a blank canvas
- Clean text, numbers and dates
- Filter rows and account for every row left out
- Total a table and prove the total
- Ship a file and a chart
- Repair a flow when next week's file changes
- You leave with
- One shop's weekly report for fictional Kramerica Bikes, shipped as a file and a chart, and a flow you've repaired after the export changed.
Each lesson has one job and a figure to check your result against. Every lab runs in its lesson page, except one, which loads a file from your computer in the Strata app.
Course outline
Get the file onto a canvas
Make the columns usable
Pick the week and total it
Ship it and keep it working
Start with lesson 1.
Build a data flow on a blank canvas, load a CSV, filter it, account for every row and ship a report you can check.