Blog · Board and management reporting
Beautiful Tableau dashboards make the next business decision clear. Follow a worked sales and margin review, compare practical layouts, and check the source figures before choosing colors and charts.
Beautiful Tableau dashboards help a business reviewer see the decision, the change, and the supporting rows quickly. Begin with measures that reconcile to source exports, then choose a layout that makes exceptions visible. Attractive formatting earns its place when it helps someone read the figures correctly.
A sales director asking whether growth is profitable needs revenue, gross profit, margin, and the comparison with plan. A warehouse manager asking which orders need attention needs a different page. Combining those questions creates a crowded report with competing priorities.
Tableau's dashboard guidance recommends defining the purpose and audience, placing the main view prominently, designing for the actual display size, and generally limiting the dashboard to a few views. Apply those ideas to the meeting the page supports. Decide what the reviewer must approve, investigate, or assign before arranging charts.
The examples below are proposed business layouts, with an illustrative US distributor's figures. They are design specifications a team can adapt, rather than screenshots of a deployed workbook. For a broader range of arrangements, see dashboard design examples.
Riverton Industrial Supply reviews its first quarter of 2026. Finance supplies a monthly net-sales export, matched cost of goods sold, and the approved revenue budget. The period covers January through March; all amounts are USD. Returns and credits are included in net revenue, and the cost definition stays consistent throughout.
The source inputs and calculated measures are:
| Month | Net revenue (USD) | Cost of goods sold (USD) | Revenue budget (USD) | Gross profit (USD) | Gross margin | Revenue variance (USD) |
|---|---|---|---|---|---|---|
| January | 400,000 | 260,000 | 390,000 | 140,000 | 35.0% | +10,000 |
| February | 420,000 | 281,400 | 410,000 | 138,600 | 33.0% | +10,000 |
| March | 450,000 | 315,000 | 460,000 | 135,000 | 30.0% | -10,000 |
| Quarter | 1,270,000 | 856,400 | 1,260,000 | 413,600 | 32.57% | +10,000 |
Gross profit equals revenue minus cost of goods sold. Margin divides that profit by revenue; revenue variance subtracts budget from actual. The detailed definitions belong in gross profit margin and variance analysis, so the dashboard can concentrate on the decision.
Revenue grew by (450,000 - 400,000) / 400,000 = 12.5% from January to March. Over the same interval, gross profit fell by 135,000 - 140,000 = -$5,000 and margin declined from 35.0% to 30.0%, a fall of 5.0 percentage points. A page with only a large revenue card would miss the earnings question.
The quarterly checks are exact: 400,000 + 420,000 + 450,000 = $1,270,000 revenue; 260,000 + 281,400 + 315,000 = $856,400 cost; and 1,270,000 - 856,400 = $413,600 profit. Quarterly margin is 413,600 / 1,270,000 = 32.57%, rounded to two decimal places. Calculate it from totals rather than averaging displayed monthly percentages.
Use the worked figures in a page arranged as follows:
| Position | Proposed content | Business purpose |
|---|---|---|
| Header | Company, quarter, USD, export date, active filters | Establish the scope of every figure |
| Headline strip | Revenue 1,270,000; gross profit 413,600; margin 32.57%; revenue variance +10,000 | State the result and comparison |
| Main left panel | Monthly revenue bars with clearly labeled budget comparison | Show where sales missed or exceeded plan |
| Main right panel | Monthly margin trend with gross profit labels | Show whether growth converted into earnings |
| Lower panel | Monthly table with the source inputs above | Let reviewers verify exact amounts |
Keep month order consistent across panels. Give positive and negative variances explicit signs and use the same dollar scale for comparable revenue views. A caption can say: "March revenue rose, but gross profit fell as cost consumed a larger share of sales."
That caption describes the arithmetic. It does not establish whether supplier prices, discounting, product mix, or accounting timing caused the change. Assign that question to the commercial finance owner and inspect the underlying product rows before naming a cause.
Suppose finance corrects March cost of goods sold from $315,000 to $306,000 after resolving a duplicate cost posting. Every other input stays unchanged. This is a separate variation, not an additional month.
| Measure | Original | Revised | Calculation |
|---|---|---|---|
| March cost (USD) | 315,000 | 306,000 | Revised cost input |
| March gross profit (USD) | 135,000 | 144,000 | 450,000 - 306,000 |
| March margin | 30.0% | 32.0% | 144,000 / 450,000 |
| Quarter gross profit (USD) | 413,600 | 422,600 | 140,000 + 138,600 + 144,000 |
| Quarter margin | 32.57% | 33.28% | 422,600 / 1,270,000 |
The cost correction is 315,000 - 306,000 = $9,000, and quarterly profit increases by the same $9,000. Revenue and its budget variance stay unchanged. The design should expose that distinction: the sales panel is stable while the margin panel changes. Round quarterly margins only for display.
For a weekly exception review, replace the monthly margin trend with a ranked table of accounts or products needing investigation. State the ranking rule, such as the largest dollar shortfall against the approved plan. Keep the whole-business total visible so a selected exception is not mistaken for the company result.
For an operating review, use an output trend and a table of late or incomplete work, with the same cutoff across both. A Tableau supply chain dashboard needs its own delivery and inventory measures; a sales margin is not a substitute for them. If the team is choosing its reporting approach, Tableau alternatives addresses that separate decision.
Readable text matters in every arrangement. Tableau's accessibility documentation discusses keyboard navigation, captions, legends, contrast, and reducing dense views. Use labels alongside color, keep essential conclusions outside hover text, and review the page at the size and with the controls people actually use.
Covirage is not affiliated with Tableau.
Bring your sales, cost, and budget file or Google Sheet: Covirage maps the columns, and its tools compute and check the figures against the supplied rows. The external AI model explains the results with every figure traced to its rows, giving you a checked basis for the business review. Create a free Covirage account and bring a sample of your own data; account creation takes about a minute.
See self-service analytics for the supporting approach.
Use consistent number formats, aligned views, descriptive titles, and restrained color. Put the decision and reporting scope where the reader sees them first. Leave enough space for labels and include a table for exact values, so the design remains useful during a business review.
Choose the fewest views that answer the review question. A headline, a trend, and an exception table often cover the job. Move a separate question to a separate page instead of shrinking every view until the labels become difficult to read.
They can share a reporting period, but keep their units clear. Aligned panels usually make dollars and percentages easier to compare than an unexplained dual axis. Include gross profit dollars as well as margin percentage when the review concerns earnings.