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.

The same four parts in three everyday uses
TeamDecisionMeasureView
SalesWhich accounts get a visit this month?Net sales by accountRanked bars
FinanceDo we need to chase late payers?Unpaid invoices by ageTable with totals
OperationsIs the warehouse keeping up?Orders shipped within two daysWeekly 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.

The four parts at Vandelay
PartAt Vandelay
DecisionWhere does the hire go?
MeasureWhat counts as a Q3 sale, and in which region?
DataTwo invoice exports and a customer register
ViewA 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.