Lesson 1 of 15 · Concept
What is business intelligence?
Business intelligence, or BI, uses business data to support decisions. It connects a question to a defined measure, data you can check and a view someone can act on. A dashboard is only the last of those.
| Team | Decision | Measure | View |
|---|---|---|---|
| Sales | Which accounts get a visit this month? | Net sales by account | Ranked bars |
| Finance | Do we need to chase late payers? | Unpaid invoices by age | Table with totals |
| Operations | Is the warehouse keeping up? | Orders shipped within two days | Weekly line |
One decision, two reports that disagree
This course follows one fictional company, Vandelay Coffee Supply, which sells equipment and beans to hospitality businesses. Its people and figures are fictional.
Max Thrust, the founder, can fund one more account manager, in North or South, and has to decide by Friday. Don Tremendous in Sales and Sydney Swell in Finance have each sent him a Q3 report.
Same quarter, same invoices. Don reports €15,850 and Sydney €10,168, and the hire can only go to one place.
Which report would you believe? Pick one, and note your reason.
Keep your answer. The last lesson comes back to it. People tend to pick the report that looks more careful, or the one they expected, and neither is evidence yet. Two totals €5,682 apart can't be measuring the same thing, and nothing on the chart says which measure Max needs.
Start with the decision, not the dashboard
BI work has four parts, and the order matters.
| Part | At Vandelay |
|---|---|
| Decision | Where does the hire go? |
| Measure | What counts as a Q3 sale, and in which region? |
| Data | Two invoice exports and a customer register |
| View | A page Max can read in 30 seconds |
Most projects start at the bottom, when someone asks for a dashboard. The argument about what the numbers mean then happens in front of the person deciding, which is where Don and Sydney are now. A sharper chart would only make their disagreement look more official.
Data won't make this decision. It can narrow it, and show what would change your mind. Max is still the one hiring.
BI vs data analytics
The two overlap, and people use the words loosely. BI usually means recurring questions with agreed definitions: what happened, where and against which target. Analytics usually means one-off investigation of why it happened or what may happen next, often with statistics.
Use BI when the same question comes back every week or quarter. Use analysis when the question is new and you don't yet know which measure answers it. A good analysis often ends up as a BI measure, once the question proves worth asking twice.
The kinds of tool involved
- Spreadsheets. Excel or Google Sheets, fine for one report and one owner.
- Data preparation tools, such as Strata, clean and combine files repeatably. Our Data preparation course covers the skills.
- Warehouses. Shared databases, usually queried with SQL, that keep history in one place.
- BI platforms. Power BI, Tableau, Vista and similar tools hold models, dashboards and sharing.
The four parts stay in the same order in all of them. Only the view looks different.
Try Strata and Vista, Oplema's apps for data prep and dashboards, in your browser: no account needed.