A dashboard succeeds when a busy manager understands the situation in under a minute. Most beginner dashboards fail not because of wrong numbers, but because they show too much, in no particular order.
Plan before you build
1. Start with the audience and their questions
Write down who will use the report and the three to five questions they need answered. Every visual should answer one of them. If it does not, remove it.
2. Sketch the layout on paper
A five-minute sketch saves hours of moving visuals around.
Layout
3. Use a clear reading order
People read top-left to bottom-right. A layout that works for most reports:
- Top: KPI cards with the headline numbers.
- Middle: the main trend and the main comparison.
- Bottom: detail (a table or breakdown) for those who want to dig in.
4. Align everything
Use a grid, equal spacing and consistent visual sizes. Misaligned visuals make a report look careless even when the analysis is good.
5. One page, one purpose
Put an overview on page one and use drill-through or separate pages for detail.
KPI cards
6. Give every number context
A card showing a number alone is hard to judge. Add a comparison: versus target, versus last month or versus last year, and show the direction.
Charts
7. Pick the simplest chart that answers the question
- Trend over time: line chart.
- Comparing categories: bar chart, sorted.
- Part of a whole with few parts: stacked bar or, sparingly, a donut.
- Detail: table or matrix with conditional formatting.
Avoid 3D visuals, gauges for everything and pie charts with many slices.
8. Write titles that state the point
"Claims settlement time rose in the North zone since July" is more useful than "Settlement time by zone". Dynamic titles with DAX can update with the selected filters.
Colour
9. Use colour with meaning
Use a neutral palette for most visuals and one accent colour to highlight what matters. Keep meanings consistent: if red means "below target" on one page, do not use it as a decorative colour elsewhere. Choose colours that remain distinguishable for colour-blind viewers.
Interaction
10. Few, well-placed slicers
Put slicers in one consistent place (top or left). Date and region are usually enough on an overview page. Sync slicers across pages where it makes sense.
11. Use tooltips and drill-through for detail
Tooltips can show extra numbers on hover without cluttering the page. Drill-through lets a user right-click a region and open a detail page filtered to it.
Performance and trust
12. Keep it fast and explain the numbers
- Remove unused columns, and prefer a star schema.
- Use measures rather than many calculated columns.
- Add a small "About this report" note: data source, refresh time and metric definitions.
Practise on a real brief
A good test of design is building for a specific stakeholder. Our motor claims dashboard project gives you a head of claims with clear questions, so you can practise designing around them rather than around the data.
Practise what you just read
Reading helps; writing the code yourself is what sticks. Start here: