Skip to main content
Metricwise

Metricwise Academy · BI

A business intelligence course for beginners.

Learn to model data, define useful metrics, and design charts people can understand.

  • Beginner friendly
  • 8 modules
  • 30 lessons
  • Practice in your browser
Start learning for freeView curriculum

Three preview lessons, no account needed. Starter includes free modules after sign-in; Pro, Team, and Enterprise include the full course. Compare access.

Looking for the analytics platform? Explore Metricwise BI.

Lesson preview What does one row represent?

In orders, what does one row represent?

order_idcustomer_idamount (GBP)
O1C140
O2C160
O3C230
Reveal the answer

One order. Each order_id identifies one order. A customer can place several orders.

What you will learn

Build the reasoning behind a useful dashboard. Learn what a row represents, how dimensions and measures differ, and when a count or sum answers the question you are asking.

  • Identify a table’s grain and recognize repeated records.
  • Distinguish dimensions, measures, counts, and sums.
  • Choose a table and a visual that fit the question.
  • Build shared measures and retain useful filter columns.

Before you begin

You can begin without prior business intelligence experience. You do not need a connected warehouse or a company dataset. The course uses guided examples to introduce data and reporting decisions.

Put it into practice

Apply these habits when reviewing a KPI, checking a dashboard total, or deciding how to present a trend. They help you ask better questions about the source data before you design a visual or share an answer.

Inside the free preview

In the preview, identify what one row represents, sort dimensions and measures, and choose between count and sum. Work through the provided data and questions to see why a small modeling decision can change a reported result.

Your learning path

The first three lessons are open to everyone. Sign in for Starter modules; full course access is included with Pro, Team, and Enterprise.

01Read tables and count correctly6 lessons

Identify grain, dimensions, measures, filters, and repeated records.

  1. What does one row represent?Free preview
  2. Sort dimensions and measuresFree preview
  3. Choose count or sumFree preview
  4. Count users onceSign in
  5. Group rows and apply filtersSign in
  6. Avoid counting joined rows twiceSign in
02Choose a table for the question4 lessons

Use events, current state, snapshots, and milestones for the questions they support.

  1. Use event tables for activitySign in
  2. Use current-state tables for nowSign in
  3. Use snapshots for balancesSign in
  4. Use milestone tables for progressSign in
03Choose a clear visual7 lessons

Use bars, lines, stacked bars, pies, and dated KPI cards.

  1. Use bars to compare categoriesSign in
  2. Use lines to show change over timeSign in
  3. Use stacked bars for totals and partsSign in
  4. Use a pie for one period’s sharesSign in
  5. Label KPI cards with a periodSign in
  6. Distinguish activity on a date from a balanceSign in
  7. Compare CAC and LTV on a line chartSign in
04Build shared measures5 lessons

Define users, stage counts, and conversion in a semantic layer.

  1. Understand the semantic layerSign in
  2. Add a reusable Users measureSign in
  3. Count users who reach each stageSign in
  4. Build a conversion rate from two measuresSign in
  5. Keep the same filters on both measuresSign in
05Keep useful filter columns2 lessons

Use medium, source, and lead quality without discarding needed detail.

  1. Filter leads by medium source and qualitySign in
  2. Keep detail to keep filter optionsSign in
06Project: marketing channels and filters2 lessons

Build a monthly channel view with usable lead filters.

  1. Project: build a monthly channel chartSign in
  2. Project: add useful lead filtersSign in
07Project: monthly KPIs and acquisition economics2 lessons

Select KPI periods and compare CAC with estimated LTV.

  1. Project: choose the right KPI datesSign in
  2. Project: check the CAC and LTV gapSign in
08Project: stage counts and conversion2 lessons

Reuse stage measures and apply a common signup filter.

  1. Project: publish stage-count measuresSign in
  2. Project: add a filtered conversion rateSign in

Questions, answered

BI course questions

Is this the Metricwise BI product?
This is the Academy course about business intelligence concepts. Metricwise BI is the separate analytics product for connected warehouse data, shared metrics, and dashboards. You can take the course without setting up a BI workspace.
Will I learn about chart choices?
Yes. After the foundational modules, the curriculum covers clear visuals, shared measures, useful filters, and applied projects. The overview below shows where these topics fit.
How do I continue after the preview?
Sign in from the lesson gate to carry your preview progress into the app on the same browser and device. Your local draft stays available while you complete sign-in. Starter includes free Academy modules; Pro, Team, and Enterprise include full Academy access.
Can I return to a lesson?
Yes. Use the curriculum to revisit a preview lesson and practice again. Progress is kept in your browser when local storage is available; clearing site data can remove that local copy.

Start with one lesson

A little practice goes a long way.

Open what does one row represent? and try the exercises at your own pace.

Start learning for free

Keep building your skills

Excel course

Get comfortable with spreadsheets, formulas, and the shortcuts that make everyday work easier.

SQL course

Read databases, write queries, and find the answers hidden in your tables.

Typing course

Build accuracy and confidence at the keyboard with focused, hands-on practice.

Ready to present your data? Create a chart online.