---
title: "Free beginner business intelligence course | Oplema"
description: "Learn to define KPIs, test reports, choose charts, design a dashboard and write a decision memo in a free course with nothing to install."
url: "https://oplema.com/learn/business-intelligence"
updated: "2026-11-04"
---

Free · Beginner · 15 lessons

# Business intelligence

Free course, nothing to install. Define KPIs, test reports, design dashboards and write the decision they support, using one fictional company deciding where to place a new hire, and two reports that disagree.

[Start the course](https://oplema.com/learn/business-intelligence/what-is-bi)

**Who it's for**

People who use reports to understand performance or guide business decisions.

If you've worked with rows and columns, you're ready. You don't need SQL or dashboard experience.

**You'll be able to**

- Write a metric definition that holds up in an argument
- Test a report by reconciling it
- Choose a chart for each question
- Notice when a successful refresh changes what a number means, and say where the data stops

**You leave with**

A dashboard and a one-page decision memo for fictional Vandelay Coffee Supply's hire, with contract and memo templates for your own work.

Every lesson opens with its data in place. The table comes from Data preparation, but you don't need that course first.

New to [Strata](https://oplema.com/strata), Oplema's browser app for data prep? [Build your first data flow](https://oplema.com/learn/export-to-report/first-data-flow) on a blank canvas first.

## Course outline

### Decide what you're measuring

1. [1 What is business intelligence? Concept](https://oplema.com/learn/business-intelligence/what-is-bi)
2. [2 KPI vs metric: how to define what you measure Concept](https://oplema.com/learn/business-intelligence/kpis-metrics)

### Test the evidence

3. [3 Where business data lives: systems and exports Concept](https://oplema.com/learn/business-intelligence/where-data-lives)
4. [4 Data quality dimensions and how they move a metric Lab](https://oplema.com/learn/business-intelligence/data-quality)
5. [5 Join fan-out: how joins inflate metrics Lab](https://oplema.com/learn/business-intelligence/joins-integration)
6. [6 Mean, median and weighted average in reporting Lab](https://oplema.com/learn/business-intelligence/aggregation)

### Make it repeatable

7. [7 ETL vs ELT: what's the difference? Lab](https://oplema.com/learn/business-intelligence/what-is-etl)
8. [8 What is a star schema? Facts and dimensions Concept](https://oplema.com/learn/business-intelligence/star-schemas)

### Show it

9. [9 How to choose the right chart for your question Concept](https://oplema.com/learn/business-intelligence/chart-choice)
10. [10 Dashboard design best practices and a checklist Lab](https://oplema.com/learn/business-intelligence/dashboard-design)
11. [11 Dashboard filters: scope, selections and limits Lab](https://oplema.com/learn/business-intelligence/filters)
12. [12 What is self-service BI, and what does it need? Concept](https://oplema.com/learn/business-intelligence/self-service)

### Keep it true

13. [13 How to check a dashboard after a data refresh Lab](https://oplema.com/learn/business-intelligence/refresh-schedule-share)
14. [14 What is data governance? Owners and change notes Lab](https://oplema.com/learn/business-intelligence/governance)
15. [15 How to write a decision memo from a dashboard Lab](https://oplema.com/learn/business-intelligence/messy-export-to-dashboard)

## Start with lesson 1.

Write metrics that hold up, test reports by reconciling them, and turn the result into a dashboard and a decision memo.

[Start the course](https://oplema.com/learn/business-intelligence/what-is-bi) [Open Vista](https://oplema.com/editor?path=%2F%3Fopen%3Dvista)
