Blog · Board and management reporting
A BI dashboard brings business measures, targets and exceptions into one compact view. Learn which workbook rows support it, how to calculate its KPIs and which checks make the results trustworthy.
A BI dashboard is a compact view of the business measures a manager needs to monitor and act on. It puts actual results beside targets or prior periods, then points to the divisions, customers or activities behind the exceptions. The useful test is whether someone can explain each number and identify the next decision.
Business intelligence turns business records into information people can use; the broader BI definition covers that process. A business intelligence dashboard is the summary view at the end of it. It might show revenue, cost, service performance or working capital, depending on who reads it.
Software uses the term differently. For example, Microsoft defines a Power BI dashboard as a single page containing visualizations drawn from underlying reports. That is a specific implementation, rather than a requirement that every business scorecard use the same layout.
Start with the question: does the regional manager need to recover revenue, protect margin or investigate both? A screen full of unrelated indicators cannot answer that clearly. For different audiences and decisions, see the business dashboard examples.
Give each KPI an actual, a comparison and enough context to interpret the gap. Label the reporting period, currency, included business units and whether the numbers are final. Add an owner for the exception so the review ends with an action.
| Dashboard element | What it answers | Source needed |
|---|---|---|
| Revenue actual and budget | Did we achieve the sales plan? | Net revenue export and approved budget |
| Gross profit and margin | What remained after the cost of sales? | Matching revenue and cost records |
| Division comparison | Where did the company result come from? | Stable division identifiers |
| Exception note | What needs investigation? | Supporting records and business explanation |
| Period and status | Are these comparable, approved figures? | Close calendar and file version |
Use a clear table or bar chart for division comparisons and a trend only when comparable history is available. Microsoft's dashboard design guidance recommends designing for the audience, providing context and keeping time frames consistent. Those principles matter more than decorative charts.
There is no single formula for a dashboard. Each KPI has its own definition, and the display must preserve it.
Revenue variance = Actual revenue − Budget revenue
Revenue attainment = Actual revenue / Budget revenue × 100
Gross profit = Actual revenue − Cost of goods sold
Gross margin = Gross profit / Actual revenue × 100
Positive revenue variance means above budget. For an expense measure, positive actual minus budget means spending above budget, which needs a different interpretation. Write the convention beside the measure rather than assuming a green arrow always means good.
For this fictional US distributor, the September 2026 workbook contains one summarized row per division. Revenue is net of credits and returns; cost covers the same sales. All money is USD, and budget uses the same division boundaries as actuals.
| Division | Actual revenue (USD) | Revenue budget (USD) | Cost of goods sold (USD) |
|---|---|---|---|
| East | 120,000 | 125,000 | 78,000 |
| West | 80,000 | 75,000 | 56,000 |
| Total | 200,000 | 200,000 | 134,000 |
These inputs produce the dashboard measures below. Percentages are rounded to one decimal place after calculation; dollar amounts are exact.
| Measure | East calculation | West calculation | Company calculation |
|---|---|---|---|
| Revenue variance (USD) | 120,000 − 125,000 = −5,000 | 80,000 − 75,000 = 5,000 | 200,000 − 200,000 = 0 |
| Revenue attainment | 120,000 / 125,000 = 96.0% | 80,000 / 75,000 = 106.7% | 200,000 / 200,000 = 100.0% |
| Gross profit (USD) | 120,000 − 78,000 = 42,000 | 80,000 − 56,000 = 24,000 | 200,000 − 134,000 = 66,000 |
| Gross margin | 42,000 / 120,000 = 35.0% | 24,000 / 80,000 = 30.0% | 66,000 / 200,000 = 33.0% |
The company achieved its revenue budget, but East missed its target by $5,000 while West exceeded its target by $5,000. West also earned a lower gross margin. The manager should investigate the division differences before describing the month as simply on plan.
The revenue export must sum to $200,000 and tie to the approved revenue total. The cost export must sum to $134,000. Gross profit then reconciles both ways: $42,000 + $24,000 = $66,000, which also equals $200,000 − $134,000.
The company margin is a ratio of totals. Its weighted check is (120,000 × 35% + 80,000 × 30%) / 200,000 = 33%. Averaging the division margins gives 32.5%, which gives different-sized divisions equal influence.
Keep these checks beside the calculation area before designing the display. The Excel dashboard walkthrough covers the workbook presentation steps; the AI dashboard explanation covers what explanation can add to a conventional view.
Bring a sample of your own actuals and budget workbook or Google Sheet; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your export.
See self-service analytics for the supporting business workflow.
Covirage is not affiliated with Microsoft.
A dashboard summarizes the measures someone monitors regularly. A report supplies the supporting detail, such as transactions, categories and explanatory notes. The distinction varies across software, so define the business purpose before deciding which view your team needs.
Choose measures that change a decision for the intended reader. A division manager might need revenue against budget, gross profit and the largest exceptions. Each measure needs a definition, a period, a source and a person responsible for investigating it.
Match updates to the decision and the source's reliability. A monthly financial review needs closed, reconciled results; an operations review may use a more frequent activity export. Always show the reporting period and distinguish provisional figures from approved results.
Yes. A workbook with consistent identifiers, dates, actuals and targets can supply the measures. Keep source rows separate from calculations and presentation. Check the dashboard totals against the workbook and the approved business totals before relying on the display.