Most dashboards fail for the same reason: they're built around the data that was available, not the questions someone actually has. Here's a framework that flips that.
1. Start with the questions, not the data
Before opening any tool, write the three to five questions the dashboard must answer. "How are we tracking against target this month?" "Which products are growing?" "Who are our top customers?" Everything you build should earn its place by answering one of them.
2. Know your audience
A CEO wants the headline in five seconds. A sales manager wants to drill into a rep or region. Decide who reads this — it changes the layout completely. When in doubt, build a clean summary on top and let detail live one click below.
3. Gather and model the data
Pull your sources together — CRM, orders, targets — and shape them into a simple star schema: one central facts table (the sales transactions) surrounded by dimension tables (date, product, customer, region). This single step is what makes everything afterward fast and flexible.
4. Write the core measures
A handful of well-named measures power the whole report. A few essentials in DAX:
Total Sales = SUM( Sales[Amount] )
-- vs last year
Sales LY = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR( Dates[Date] ) )
-- growth %
YoY % = DIVIDE( [Total Sales] - [Sales LY], [Sales LY] )
5. Choose the right visuals
- A few big KPI cards on top: revenue, vs target, growth.
- A trend line for sales over time.
- A bar chart ranking products or regions.
- One table for the detail people inevitably ask for.
Resist the temptation to add more. Every extra chart competes for attention with the ones that matter.
Most important number, top-left. We read like a page — put the headline where the eye lands first, and let detail flow down and right.
6. Make it refresh and share it
Connect the report to a live source so it updates on a schedule — no manual exports. Then publish it and give the right people access. A dashboard nobody can open is just a screenshot.
7. Watch how it's used, then trim
After a couple of weeks, see which visuals people actually touch. Cut what they ignore. The best dashboards get simpler over time, not busier.