Blog · Board and management reporting
The best designed dashboards connect a business question to a verified measure and an accountable action. Compare three layouts using the same regional sales and cost figures, then see how changing one cost input changes the review.
The best designed dashboards make a business decision clear before they draw attention to their styling. They show what changed, where the change came from and who should act. These layouts use the same verified regional figures so that the differences in presentation have a clear purpose.
Write the decision above the layout: approve the monthly response, investigate a regional shortfall, or assign a corrective action. A page trying to do all of these at once often buries the useful comparison under equally prominent cards.
Choose the audience and reporting cutoff next. A finance leader reviewing a closed month needs actual results against the approved plan. A regional manager needs the same results broken down by territory. An action owner needs a named issue and a next step.
The underlying workflow belongs in how to create a BI dashboard. This gallery concentrates on where the verified answers go on the page. If your choice of platform is already settled, Tableau dashboard design examples address that nearby search separately. Covirage is not affiliated with Tableau.
Consider an illustrative US industrial distributor reviewing September 2026. The reporting workbook has one row per region, with approved revenue plan, net revenue and matching cost of goods sold. Revenue and cost cover the same closed month and use USD throughout.
| Region | Revenue plan (USD) | Net revenue (USD) | COGS (USD) | Revenue variance (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|---|---|
| East | 400,000 | 380,000 | 268,000 | -20,000 | 112,000 | 29.5% |
| Central | 300,000 | 315,000 | 201,000 | 15,000 | 114,000 | 36.2% |
| West | 200,000 | 185,000 | 144,000 | -15,000 | 41,000 | 22.2% |
| Total | 900,000 | 880,000 | 613,000 | -20,000 | 267,000 | 30.3% |
Revenue variance = Net revenue − Revenue plan
Gross profit = Net revenue − COGS
Gross margin = Gross profit / Net revenue
For East, the calculations are 380,000 − 400,000 = -20,000 and 380,000 − 268,000 = 112,000. Its margin is 112,000 / 380,000 = 29.5%. Percentages throughout are rounded to one decimal place; calculations use unrounded amounts.
The proof is in the totals. Regional variances sum to -20,000 + 15,000 − 15,000 = -20,000, which equals 880,000 − 900,000. Regional gross profit sums to 112,000 + 114,000 + 41,000 = 267,000, which equals 880,000 − 613,000. Total margin divides those totals; it does not average the regional percentages. The full measure definition belongs in gross profit margin.
Use an overview when the decision is whether the business needs a coordinated response. Give the total result the most space, then show its explanation immediately below.
| Page area | Left panel (amounts in USD) | Right panel (amounts in USD) |
|---|---|---|
| Header | September 2026 closed month | All US regions; USD |
| Main result | Revenue: 880,000 against 900,000 plan | Gross profit: 267,000; margin: 30.3% |
| Comparison | Revenue variance: -20,000 | Revenue variance: -2.2% of plan |
| Explanation | Regional variance bars | Regional margin comparison |
| Action strip | East revenue review | West cost and margin review |
Revenue variance percentage is -20,000 / 900,000 = -2.2%. Keep that comparison beside revenue; placing it beside gross profit would suggest the wrong denominator. Use a horizontal zero line for the variance bars so Central's favorable result and the shortfalls have an obvious reference.
This layout answers the overall performance question. It also prevents the total from hiding the offset: Central's favorable revenue variance partially masks the shortfalls elsewhere. Add a monthly trend only when the workbook includes comparable prior months; a single reporting month cannot establish a trend.
Use a comparison view when leaders need to choose where to investigate. Keep revenue attainment and margin together so that a large sales region does not automatically receive all the attention.
| Region panel, ordered by margin | Revenue attainment | Gross margin | Review focus |
|---|---|---|---|
| West | 92.5% | 22.2% | Investigate cost and sales mix |
| East | 95.0% | 29.5% | Explain the revenue shortfall |
| Central | 105.0% | 36.2% | Understand the favorable result |
Revenue attainment divides actual revenue by plan. West is 185,000 / 200,000 = 92.5%; East is 380,000 / 400,000 = 95.0%; Central is 315,000 / 300,000 = 105.0%.
Show aligned bars with the same scale and direct region labels. Sort by the question being reviewed, and state that order. Sorting by margin is useful for margin investigation; sorting by revenue variance answers a different question. Keep the displayed dollar values available so the reader can distinguish a low percentage from a large financial effect.
Use an action table once the review has identified issues. The visual hierarchy should move from the exception to the owner and then to the evidence needed to resolve it.
| Exception | Source evidence (amounts in USD) | Accountable role | Next review question |
|---|---|---|---|
| East below revenue plan | Variance: -20,000 USD | East sales leader | Which accounts explain the gap? |
| West lowest regional margin | Margin: 22.2% | West general manager | Is cost, price or mix responsible? |
| Central favorable revenue | Variance: 15,000 USD | Central sales leader | Can the gain repeat? |
Label these as review questions. The summary figures identify where to look; they do not prove a cause. A territory total cannot establish whether customer pricing or product mix caused its margin.
Add text such as “below plan” alongside any status color. W3C's use-of-color guidance says color should not be the sole way to convey information. Test meaningful chart marks against their backgrounds as well; W3C's non-text contrast guidance covers graphics needed to understand the content.
Suppose the only revision is West COGS, increased from $144,000 to $164,000 after a cost correction. Revenue and plan stay unchanged.
| Dollar measure | Original (USD) | Revised (USD) |
|---|---|---|
| West COGS (USD) | 144,000 | 164,000 |
| West gross profit (USD) | 41,000 | 21,000 |
| Total COGS (USD) | 613,000 | 633,000 |
| Total gross profit (USD) | 267,000 | 247,000 |
Revised West profit is 185,000 − 164,000 = 21,000. Its margin falls from 22.2% to 11.4%. The company check is 880,000 − 633,000 = 247,000, and total margin falls from 30.3% to 28.1%. The executive view now gives a different margin result, while every revenue comparison stays the same. The regional view and action board should make the West correction visible rather than suggesting a sales deterioration.
Bring your regional reporting workbook or Google Sheet with actuals, plan and cost columns. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See self-service analytics for the supporting business workflow.
A well designed dashboard answers a specific decision with measures the reader can verify. It gives each figure a period, definition and comparison, then shows the underlying groups and accountable owners. Consistent units and readable labels matter as much as visual style.
There is no universal count. Start with the measures needed to make the page's decision and remove figures that do not change it. Put detailed diagnostic measures below the overview or in a separate view rather than making every number equally prominent.
Either background can work when text and meaningful graphics have sufficient contrast. Test the actual display and printed version. Direct labels, clear units and text descriptions of status are more useful than choosing a background simply because a gallery looks polished.
No. A single verified result with a comparison can be a plain number. A trend needs a time series, a regional comparison can use bars, and an action list usually needs a table. Choose the form that makes the decision easiest to inspect.