Book a consultation
Resources

Business Intelligence & Dashboards

Business intelligence, explained.

Business intelligence services
Business intelligence stacks sources, a warehouse, a metric layer and a dashboard under each decisionIsometric stack of four data layers ending in a decision.SourcesCRM, ERP, accountingWarehouseOne store, scheduled loadsMetric layerOne definition per KPIDashboardThe view leaders openDecision: approve budgetBusiness intelligence stacks sources, a warehouse, a metric layer and a dashboard under each decisionFour stacked layers, sources at the bottom, then warehouse, metric layer and dashboard, under one decision.Decision: approve budgetSourcesCRM, ERP, accountingWarehouseOne store, scheduledloadsMetric layerOne definition per KPIDashboardThe view leaders open
What it is

What is business intelligence? One trusted view of what happened

Definition

Business intelligence is how a company turns raw data into actionable insights for business decisions. In practice, BI collects data from systems such as the CRM, ERP and accounting platform, organizes it in one consistent model and presents it in reports and dashboards.

  1. The goal is not more reports. It is one shared, reliable view of performance, so meetings focus on what to do instead of whose numbers are right.

  2. It mostly answers descriptive questions: what happened, where and when. Combined with analysis, it also helps explain why results moved. That is where BI and analytics overlap, and why the two are usually planned together.

  3. A simple test shows whether BI is working. Ask three leaders for last month's revenue. If they give the same number, from the same report, without checking, your BI is doing its job. If they give three numbers, the problem is not the dashboard but the definitions and data underneath it.

  4. This guide explains how BI works, how it differs from related fields, and how leadership teams get value from it.

The three-leader test: one revenue number means BI worksTwo panels: three leaders quote three revenue figures from three sources, versus the same $4.82M from one dashboard.The three-leader test: one revenue number means BIworksDemo dataAsk three leaders for last month's revenueBI is not working yetCEO$4.9Mboard deckCFO$4.6Mledger exportCMO$5.1MCRM reportThree numbers, three sourcesBI is workingCEO$4.82Mrevenue dashboardCFO$4.82Mrevenue dashboardCMO$4.82Mrevenue dashboardSame number, same report, no checkingThe three-leader test: one revenue number means BI worksTwo panels: three different revenue numbers versus one shared number.The three-leader test: one revenuenumber means BI worksAsk three leaders for last month's revenueDemo dataBI is not working yetCEO$4.9Mboard deckCFO$4.6Mledger exportCMO$5.1MCRM reportThree numbers, three sourcesBI is workingCEO$4.82Mrevenue dashboardCFO$4.82Mrevenue dashboardCMO$4.82Mrevenue dashboardSame number, same report, no checking
How it works

How business intelligence works is easiest to see as a chain of five links, from the systems that hold the facts to the decision a leader makes.

How business intelligence works

Select a stage, use Next or the arrow keys

Sources. CRM, ERP, accounting, marketing and operations tools hold the facts.

Step 1 of 5

The chain is only as strong as its weakest link. Revenue that means different things in the CRM and the ERP, or a KPI with two formulas, always shows up in the dashboard as numbers nobody trusts. That is why mature BI programs invest as much in integration and definitions as in design.

The decision is the reason the chain exists.

how our business intelligence services work
Comparison

Business intelligence vs business analytics vs decision intelligence: three different questions

These terms overlap, which causes confusion when budgets are set. The simplest way to separate them is by the question each one answers. Business intelligence reports what happened. Business analytics explains why it happened. Decision intelligence links each metric to a named decision, an owner and the options on the table. BI comes first, because the other two depend on the same clean data.

Business intelligenceBusiness analyticsDecision intelligence
Main questionWhat happened and where?Why did it happen?Which option should we choose, and who decides?
Typical outputDashboards and scheduled reportsAnalyses and recommendationsDecision views with owners, thresholds and scenarios
Typical usersExecutives and managersAnalysts and business leadersLeadership teams and decision owners
Data neededGoverned, structured dataGoverned data plus ad hoc sourcesGoverned data plus agreed targets
Time focusPast and presentRecent pastThe next decision cycle
decision intelligence consulting
Benefits

Business intelligence lets leadership decide faster, with fewer arguments

The main benefit of BI is speed with confidence.

When metrics are defined once and refresh automatically, leaders spend less time reconciling numbers and more time acting on them.

Governed reporting turns merge hours into analysis hoursTwo stacked bars of a 40-hour week: before, 18 h merging, 10 h checking, 12 h analysis; after, 4, 3 and 33 h.Governed reporting turns merge hours into analysishoursDemo dataOne analyst's 40-hour week, before and after automated reportingBefore18 h10 h12 hAfter4 h3 h33 hAnalysis: 33 h, up from 12 hExport and mergeCheck and reconcileAnalysisGoverned reporting turns merge hours into analysis hoursTwo stacked bars of an analyst's week; analysis rises from 12 to 33 hours.Governed reporting turns merge hoursinto analysis hoursOne analyst's 40-hour week, before and afterautomated reportingDemo dataBefore18 h10 h12 hAfter4 h33 hAnalysis: 33 h, up from 12 hExport and mergeCheck and reconcileAnalysis

For the CFO, BI cuts the reporting work after the monthly close and the manual board pack work, because finance and management reporting come from the same model. The decision it supports: where to tighten or release spend.

For the COO, it exposes bottlenecks, such as rising cycle times or capacity limits, while there is still time to respond. The decision: where to add people or change a process.

For the CMO and sales leaders, it links campaigns and pipeline to revenue. The decision: which channels and segments get next quarter's budget.

BI also sharpens accountability. Each KPI has an owner and a target, and everyone who needs it can see progress. Finally, a solid BI foundation prepares the company for AI and data analytics, which rely on the same clean, governed data.

The benefit that matters most is often invisible: the time leaders no longer spend checking numbers. That time goes back into decisions.

There is also a cost benefit. Every hour an analyst spends exporting, merging and reformatting data is an hour not spent on analysis. Automated, governed reporting removes much of that manual work, so the same team can answer more questions, faster, and with fewer errors in the board pack.

Types

Traditional, self-service and embedded BI suit different needs

Traditional BI is run centrally. A data team builds reports and dashboards for business users. Control and consistency are strong, but new questions can take time to answer.

Self-service BI lets business users explore governed datasets and build their own views. It works well when the data model is clean and metrics are defined centrally, otherwise it multiplies conflicting numbers.

Start with the governed core; the other two build on itComparison matrix of traditional, self-service and embedded BI on who builds, where people see it, strength, risk and dependency.Start with the governed core; the other two build on itTraditional, self-service and embedded BI comparedTraditionalSelf-serviceEmbeddedWho builds viewsData teamBusiness usersData team, for anappWhere people see itBI portalBI toolInside a portal orappMain strengthControl andconsistencySpeed on newquestionsUse where peopleworkMain riskSlow on newquestionsConflicting numbersData scope per userDepends onNothing: it is thecoreThe governed coreThe governed coreStart with the traditional, governed core; self-service and embedded BI depend on it.Start with the governed core; the other two build on itThree cards comparing traditional, self-service and embedded BI; traditional marked start here.Start with the governed core; theother two build on itTraditional, self-service and embedded BI comparedTraditional · start hereWho builds viewsData teamWhere people see itBI portalMain strengthControl and consistencyMain riskSlow on new questionsDepends onNothing: it is the coreSelf-serviceWho builds viewsBusiness usersWhere people see itBI toolMain strengthSpeed on new questionsMain riskConflicting numbersDepends onThe governed coreEmbeddedWho builds viewsData team, for an appWhere people see itInside a portal or appMain strengthUse where people workMain riskData scope per userDepends onThe governed core

Embedded BI places dashboards inside other applications, such as a client portal or an internal tool. Users see the data where they already work, which tends to raise adoption.

A common outcome is a mix: a governed core, self-service for analysts, and embedded views for clients or field teams. The right mix depends on who needs answers and how fast. Start with the governed core, because the other two types depend on it.

Use cases

Every function uses business intelligence to make a different decision

The same data model can serve every function, as long as each view starts from the decision that team owns. Each card below names the decision first and the metrics second, which is the order a good dashboard follows.

  • Finance

    Decide where to tighten spend

    Budget versus actual, margin analysis, cash flow and receivables.

  • Sales

    Decide which deals need help

    Pipeline coverage, win rate, forecast accuracy and rep performance.

  • Marketing

    Decide which channels get budget

    Channel performance, cost per opportunity and revenue attribution.

  • Operations

    Decide where to add capacity

    Cycle time, on-time delivery, utilization and backlog by team.

  • Projects

    Decide which projects need rescue

    Budget burn, milestones and resource allocation across the portfolio.

  • HR

    Decide where to hire next

    Headcount against plan, time to hire, attrition and workload by team.

  • Customer success

    Decide which accounts to renew first

    Renewal dates, usage trends, open cases and churn risk by account.

  • Supply chain

    Decide which suppliers to review

    Supplier delivery, lead times, inventory turns and stock against demand.

Sample dashboards

Business intelligence dashboard examples: each one names its insight

A good BI dashboard does not just show data. Its title states what the data means. The examples below, built on demo data, show how one model serves different leaders, each with a view built around a decision. Notice that each title tells you what to think, not only what you are looking at. The interactive version shows the CEO, CFO and COO views; a CMO view follows the same pattern. That one habit makes dashboards far easier to act on.

One model, three leaders, three insight titles

Demo data
Revenue vs plan98.4%▼ -1.6 pts
Gross margin36.8%▼ -2.4 pts
Cash$2.7M▲ +3%
Pipeline coverage2.8x▲ +0.2x

The year is on track for revenue, but margin is slipping

Revenue vs plan, year to date by quarter, $M

$0M$2M$4M$6MQ1Q2Q3$4.4M in Q3: Widest gap to plan$0M$2M$4M$6MQ1Q2Q3$4.4M in Q3: Widest gap to plan
ActualPlan

So what: Ask the CFO which costs moved before approving Q4 spend.

MeasureActualPlanVariance
Revenue YTD$12.5M$12.7M-1.6%
Gross margin36.8%39.2%-2.4 pts
Operating cash flow$1.1M$1.0M+10%
View 1

CEO: see if the year is on track

Revenue against plan, margin, cash and pipeline coverage on one page, with variance flags.

View 2

CFO: find the cost that moved

Profit and loss by entity, expense variance and receivables aging, with drill-down.

View 3

COO: fix today's exceptions

Throughput, cycle time and exceptions by site, team or project.

View 4

CMO: move budget to what works

Pipeline and revenue by channel, cost per opportunity and conversion by stage.

dashboard development services
Tools

The right business intelligence tool depends on the systems you already run

Widely used business intelligence tools include Power BI, Tableau and Looker, plus the reporting built into CRMs and ERPs. The right choice depends on your existing systems, security needs, licensing model and team skills.

Power BI, Tableau, Looker and Excel each fit a different stack, skill set and licensing modelChoose the BI tool that fits the stack you runFour common options by fit, skills needed and licensing modelPower BITableauLookerExcelBest fitMicrosoft 365teamsAnalysts exploringdata visuallyTeams on GoogleCloud dataSmall, simplereportingSkills neededDAX anddata modelingDrag-and-dropvisual analysisSQL and LookMLmodelingSpreadsheetformulasLicensingPer user,predictablePer user,by rolePlatformcontractNo newlicensePower BI, Tableau, Looker and Excel each fit a different stack, skill set and licensing modelComparison of four BI tools by best fit, skills needed and licensing.Choose the BI tool that fits thestack you runFour common options by fit, skills needed andlicensing modelPower BIBest fitMicrosoft 365 teamsSkills neededDAX and data modelingLicensingPer user, predictableTableauBest fitAnalysts exploring data visuallySkills neededDrag-and-drop visual analysisLicensingPer user, by roleLookerBest fitTeams on Google Cloud dataSkills neededSQL and LookML modelingLicensingPlatform contractExcelBest fitSmall, simple reportingSkills neededSpreadsheet formulasLicensingNo new license
Strong fit for Microsoft 365 usersPower BI: data modeling, connectors and predictable licensing.
Flexible visual explorationTableau: suited to analysts who explore data visually.
A governed semantic layerLooker: metrics defined once in LookML, suited to teams on Google Cloud data.
Small needs, no new licenseExcel dashboards for simple, low-volume reporting.

Power BI is a common choice for companies already on Microsoft 365, thanks to strong data modeling and many connectors. Tableau is known for flexible visual exploration. Looker centers on a governed semantic layer. Spreadsheet dashboards still work for small, simple needs. Whatever you choose, the tool matters less than the data model and definitions underneath it. A short platform comparison against your own requirements usually settles the choice quickly.

Power BI consulting
Common challenges

Most BI challenges come from definitions and adoption, not technology

The most common BI problems are conflicting metric definitions, poor data quality, dashboards with no clear user and low use after launch. Each has a plain fix. Define each KPI once. Fix data at the source. Design every dashboard around a specific decision. Track usage after release and retire views nobody opens. Good design matters too: a clear order, context for each number and fewer, more meaningful charts.

A useful habit is to review dashboards every quarter. Ask which views drove a decision, which were ignored and which questions came up that no view answered. Remove, fix and add accordingly. BI is never finished, but it should get simpler over time, not more cluttered.

Three of ten dashboard views are almost never openedSorted bars of opens per dashboard view last quarter; the last three views have 4, 1 and 0 opens.Three of ten dashboard views are almost never openedDemo dataOpens per view in the last quarter, one companyRevenue vs plan412Pipeline305Cash position198Margin by product144Operations backlog96Regional sales61Marketing mix38Inventory detail4Legacy KPI pack1Old forecast0Retire at the quarterly reviewThree of ten dashboard views are almost never openedSorted bars of dashboard view opens; three views are almost never opened.Three of ten dashboard views arealmost never openedOpens per view in the last quarter, one companyDemo dataRevenue vs plan412Pipeline305Cash position198Margin by product144Operations backlog96Regional sales61Marketing mix38Inventory detail4Legacy KPI pack1Old forecast0Retire at the quarterly review
Data maturity self-check

How mature is your business intelligence?

7 questions on common data practices. The result is an illustrative level, not a benchmark score.

Illustrative
1. Ask three leaders for last month's revenue. What happens?
2. Are your KPIs written down with formulas and owners?
3. How does reporting data get from source systems to reports?
4. How good is the data in your CRM and ERP?
5. Does each dashboard have a named user and a decision?
6. Do dashboard titles state the insight?
7. Do you track dashboard usage after release?
0 of 7 answered
Frequently asked questions

Business intelligence: questions leaders ask before they invest

Business intelligence reports what happened, using governed data and dashboards. Business analytics goes further and explains why results moved, using analysis and scenarios. The two work best together. They share the same data foundation, which is why they are often planned and delivered together.

Common business intelligence tools include Power BI, Tableau and Looker, along with reporting modules in CRM and ERP platforms such as HubSpot, Salesforce, NetSuite and Odoo. Integration and warehouse tools sit underneath them. The right mix depends on your systems, budget, security needs and team skills.

Cost depends on the number of data sources, the state of the data, the number of dashboards and audiences, and platform licensing. Projects that need data cleanup or a new warehouse cost more than projects on clean, connected data. A structured assessment is the most reliable way to estimate scope.

It varies with scope. A phased approach delivers the first trusted dashboards early, then adds departments and sources. Projects slow down most when metric definitions are not agreed or source data needs heavy cleanup, so plan those steps at the start rather than discover them later.

Both are capable. Power BI often suits companies already on Microsoft 365 that want strong data modeling at a predictable license cost. Tableau is valued for flexible visual exploration. The better choice depends on your current stack, governance needs and the people who will build and use reports.

Design dashboards around specific decisions, involve users in reviews before launch, train people by role and make the dashboard part of regular meetings. Track usage after release and retire views nobody opens. Adoption rises when leaders refer to the dashboard instead of asking for separate spreadsheets.

A BI consultant helps a company decide what to measure, where the data comes from and how to present it. The work covers KPI definitions, data modeling, dashboard design and adoption. Good consultants spend as much time on definitions and training as on the technology itself, because that is where BI projects tend to succeed or fail.

Plan your BI rollout around agreed KPIs and a phased roadmap

Planning a BI rollout? Book a consultation to define your KPIs, architecture and phased roadmap. We advise first and propose implementation only when your organization is ready. Consultations are remote and there is no obligation. You leave with a clear next step.

Explore our business intelligence services
See how we work
Related resources

Next: turn this guide into dashboards your leaders use