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

  1. 1Build your first data flow from a CSVLab
  2. 2Load a CSV file into a data flowLab

Make the columns usable

  1. 3Choose columns and set data types in a flowLab
  2. 4Clean up inconsistent text in a CSVLab
  3. 5Convert text to numbers and dates, European formatLab

Pick the week and total it

  1. 6Filter rows by date and account for what's left outLab
  2. 7Add a calculated column to a tableLab
  3. 8Total rows by group and prove the total is rightLab

Ship it and keep it working

  1. 9Export results to CSV and make a first chartLab
  2. 10Fix a data flow when next week's file changesLab

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.