---
title: "Free Strata course from CSV export to report | Oplema"
description: "Learn Strata in a free hands-on course: build a data flow on a blank canvas, load and clean a CSV, account for every row and chart the result in Vista."
url: "https://oplema.com/learn/export-to-report"
updated: "2026-11-04"
---

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](https://oplema.com/learn/export-to-report/first-data-flow)

**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](https://oplema.com/strata) app.

## Course outline

### Get the file onto a canvas

1. [1 Build your first data flow from a CSV Lab](https://oplema.com/learn/export-to-report/first-data-flow)
2. [2 Load a CSV file into a data flow Lab](https://oplema.com/learn/export-to-report/load-a-csv-file)

### Make the columns usable

3. [3 Choose columns and set data types in a flow Lab](https://oplema.com/learn/export-to-report/choose-columns-and-types)
4. [4 Clean up inconsistent text in a CSV Lab](https://oplema.com/learn/export-to-report/clean-up-text)
5. [5 Convert text to numbers and dates, European format Lab](https://oplema.com/learn/export-to-report/convert-numbers-and-dates)

### Pick the week and total it

6. [6 Filter rows by date and account for what's left out Lab](https://oplema.com/learn/export-to-report/filter-rows-by-date)
7. [7 Add a calculated column to a table Lab](https://oplema.com/learn/export-to-report/add-a-calculated-column)
8. [8 Total rows by group and prove the total is right Lab](https://oplema.com/learn/export-to-report/total-and-prove)

### Ship it and keep it working

9. [9 Export results to CSV and make a first chart Lab](https://oplema.com/learn/export-to-report/export-and-chart)
10. [10 Fix a data flow when next week's file changes Lab](https://oplema.com/learn/export-to-report/fix-a-broken-flow)

## 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.

[Start the course](https://oplema.com/learn/export-to-report/first-data-flow) [Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata)
