Design a KPI Dashboard
Recommend a KPI dashboard layout for this workbook. Choose 6-8 KPIs, map each to a cell or range, suggest card titles, and explain the order. Use a 3x2 or 4x2 grid that fits one screen.
Choose 6-8 KPIs that fit one screen.
FIELD GUIDE 02 · DASHBOARDS
Use Claude for Excel to choose the KPIs that belong on the first screen, build the summary tables behind them, and write the takeaway the numbers are trying to tell.
Most dashboards answer every question except the one that matters. Start with the decision, then choose the KPI, the chart, and the sentence that explains it.
Claude can draft the KPI tree, aggregate the table, and write the commentary. The design decision stays with you: what belongs on the first screen, and what can wait.
Twenty metrics on one screen means no one knows where to look.
A chart that does not change a decision is decoration.
If finance and the dashboard define churn differently, the meeting starts with a fight.
Pick the prompt that matches the decision on the screen. Copy it into Claude in Excel and adapt the cell references to your workbook.
Recommend a KPI dashboard layout for this workbook. Choose 6-8 KPIs, map each to a cell or range, suggest card titles, and explain the order. Use a 3x2 or 4x2 grid that fits one screen.
Choose 6-8 KPIs that fit one screen.
Create a summary table that aggregates the selected data by month and region, with current, prior, variance, and variance percentage columns. Explain the formulas and the sorting logic.
Create the table behind the cards.
Build a variance dashboard comparing actuals to budget. Include absolute and percentage variance, conditional formatting rules, and a short list of the largest drivers. Explain how to update it each month.
Show actual vs budget and the biggest drivers.
Recommend the best chart type for each KPI in this workbook. Explain why, and warn about chart types that distort the comparison. Include a short layout suggestion for a dashboard.
Match the chart to the decision.
Add month-over-month and year-over-year trend columns to this KPI table. Use arrows or plus and minus signs, and explain the formula for each column. Keep the table easy to scan.
Make direction visible at a glance.
Write a concise executive commentary for this dashboard. Summarize the three most important movements, the likely drivers, and one recommended action. Keep it under 150 words.
Turn movement into a three-sentence takeaway.
Design the decision first. The layout, formulas, and commentary follow from the question the dashboard has to answer.
Write the question the dashboard must answer. If it cannot change a decision, it is not a KPI.
Deliverable: Decision statementLink each KPI to a cell, owner, definition, and refresh cadence.
Deliverable: KPI dictionaryCreate the summary table and variance columns before styling anything.
Deliverable: Summary tableDraft a three-sentence commentary: what moved, why, and what to do next.
Deliverable: Executive noteA dashboard is finished when someone can make a decision without asking a follow-up question.
The dashboard answers a specific operating question.
Every KPI has one owner, formula, and refresh cadence.
The title states the insight, not just the metric.
A reviewer can follow every number back to the source.
Someone is responsible for the monthly update.
The first screen works beyond your desktop.
Three workflows for the spreadsheet work that matters most.
Answers for the spreadsheet team building the first version.
Aim for 6-8 KPIs on the first screen. Everything else belongs in a detail view, a tooltip, or a follow-up workbook.
Claude can recommend chart types, build summary tables and formulas, and write the commentary. Excel charts and formatting are still applied in the workbook; review the result.
Put definitions in one KPI dictionary, use persistent Instructions in Claude, and assign an owner for each metric.
Yes, if you provide the period, the comparison, and the three largest movements. Keep the final edit human.
Yes. Design for the decision, not the data volume. The first screen should answer what changed and what to do next.
Claude can help with the table and commentary each cycle, but the refresh process and data sources still need an owner.
THE NEXT MOVE
Start with the six prompts above, then explore the full library for formulas, dashboards, audits, and forecasts. Download the PDF for a printable field guide.