What it means
Most companies already hold the numbers they need, scattered across an accounting system, a sales platform, a spreadsheet and a warehouse system. Business intelligence is the plumbing and the presentation layer that bring those sources together and answer questions quickly.
The emphasis is on what happened and why, rather than on predicting what will happen next. The usual pipeline has four steps.
Data is extracted from each source system, transformed into consistent definitions, loaded into a central store such as a data warehouse, then modelled into measures and presented through dashboards and reports. Each step can fail quietly, which is why definitions and reconciliations matter more than chart design.
The business case rests on decision speed and on one version of the truth. When sales, finance and operations each calculate gross margin differently, meetings get spent arguing about numbers instead of acting on them.
A BI layer fixes one definition, documents it and applies it everywhere. In practice the most valuable output is usually unglamorous.
A weekly dashboard showing margin by product, days sales outstanding by customer and cost per order by site will change more decisions than an elaborate model, because managers can see the exception and act on it the same week. Start with the three numbers that would change behaviour and build outward from there.
Governance decides whether people trust the output. Each metric needs a written definition, a named owner, a refresh schedule and a reconciliation back to the financial statements, so any figure on a dashboard can be defended in a board meeting.
Without that, a single wrong number destroys confidence in every other one. It is worth separating business intelligence from analytics and data science.
BI reports and monitors what has happened using agreed definitions, while analytics and data science build models that explain or forecast using statistical methods. Most companies get far more value from doing BI properly than from skipping ahead.
In practice
Real-world examples.
Example
A distributor replaces a monthly spreadsheet pack with a dashboard refreshed each night from the accounting and warehouse systems. The sales director spots that the fastest growing customer sits on a 12% gross margin against a 28% average, and renegotiates the price list before the next quarter.
Example
A multi-site clinic group builds a report showing cost per appointment and missed appointment rate by site. One site's 19% missed appointment rate turns out to be a broken reminder setting, and fixing it recovers roughly $8,000 of monthly revenue.
Example
A manufacturer finds that finance and operations report different production volumes because one counts units packed and the other counts units passing final test. The BI project forces a single agreed definition, and the monthly board pack stops carrying two versions of the same figure.
Formula
Calculation
Business intelligence has no single formula, but every BI layer is built from metric definitions, and gross margin percentage is a typical one:
Gross margin % = ((revenue - cost of sales) / revenue) x 100
Worked example: a dashboard reports two product lines for one month. Line A has revenue of $400,000 and cost of sales of $260,000, so gross profit is 400,000 - 260,000 = $140,000 and the margin is 140,000 / 400,000 = 35%. Line B has revenue of $150,000 and cost of sales of $120,000, so gross profit is $30,000 and the margin is 30,000 / 150,000 = 20%. Combined revenue is $550,000 and combined gross profit is $170,000, a blended margin of 170,000 / 550,000 = 30.9%. The value of the BI layer is that the blended figure no longer hides the 20% line.Case study
Seen in the real world.
Thornbury Garden Centres is a fictional retail chain used here as an illustrative example. With nine sites, it closed its books each month and circulated a 40-page spreadsheet pack that arrived three weeks after month end, by which point the trading decisions it informed had already been made.
The company built a small BI layer: nightly extracts from the till and purchasing systems into one central store, with four agreed metrics, sales per square metre, gross margin by category, stock cover in weeks and wastage percentage. Each metric had a written definition and reconciled to the monthly accounts to the dollar.
Within two quarters the chain cut wastage on fresh stock from 11% to 6%, worth about $340,000 a year across the nine sites, mostly by letting site managers see their own figure every Monday morning. The illustrative lesson is that the win came from four trusted numbers delivered weekly, not from a large reporting system.
Watch out
Common mistakes.
- Starting with dashboard design before agreeing metric definitions, which produces attractive reports that different departments calculate differently.
- Building reports nobody is required to act on, so the BI layer becomes wallpaper made of charts rather than a decision tool.
- Skipping reconciliation to the financial statements, which means the first time a dashboard figure is challenged in a board meeting it cannot be defended.
Questions
People also ask.
Do we need a data warehouse to start?
No, a small company can begin with scheduled extracts into one tidy database, or even one well-governed spreadsheet, and add a warehouse when the number of sources demands it.
How is BI different from financial reporting?
Financial reporting produces statutory statements to accounting standards, while BI produces management information using whatever definitions the business finds useful, usually faster and in far more detail.
Who should own a BI metric?
A named manager who can explain the definition and act on the number, rather than the technical team that built the report, because ownership is what keeps a metric honest.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%