Free · Beginner · 8 lessons

Build and publish a dashboard

Free course, nothing to install. Learn Strata and Vista, Oplema's apps for data prep and dashboards, by turning a month-end table into a dashboard by day that the owner can adjust and a colleague can rerun. Each lab up to the project gives you a brief and a figure to check, and the course ends with a project you build alone.

Start the course
Who it's for
People who can prepare a table in Strata and need someone else to read it and rerun it.
If you've finished Combine and reconcile data files, or can already stack files, join a small table and summarize, you're ready.
You'll be able to
  • Filter a dashboard
  • Let a reader test an assumption
  • Write date rules
  • Fill missing days and trend them
  • Store files in Cloud and run flows in your browser
  • Publish a dashboard link
  • Explain what schedules do
You leave with
A published dashboard for fictional Kramerica Bikes that someone else can rerun, then a blank-canvas project on a business you haven't seen.

The first four labs run in their lesson pages. The next three run in the Strata app with a free account, using Run local, so your flows run in your browser, not as hosted runs. The last page lists the tools you haven't needed yet.

Course outline

Build the view by day

  1. 1Add a shop filter to a dashboardLab
  2. 2Add a what-if parameter to a dashboardLab
  3. 3Rolling date filter: last 7 days from todayLab
  4. 4Fill missing dates and calculate a 7-day averageLab

Hand it over

  1. 5Move a flow's files to Cloud and rerun itLab
  2. 6Publish a dashboard and hand over the rerunLab

Build it alone

  1. 7Practice data project: raw files to a reportLab

Tools for later

  1. 8More data tools: when you'd use each oneLab

Start with lesson 1.

Filter a dashboard by shop, let a reader test an assumption, fill missing days, keep files in Cloud, publish, then build a project alone.