Dashboards people actually open
A dashboard with forty charts is opened once. One that answers the three questions a manager asks every Monday is opened every Monday. Start from the decision, not the data.
Many dashboards are built by connecting a database and charting every column. The result looks thorough, and it is rarely used. People do not open a dashboard to browse; they open it to answer a question and decide what to do next.
Start with the Monday questions
Before any chart, we ask each person who will use the dashboard what they need to know each week and what they do with the answer.
- Sales manager: are we ahead or behind target this month, and which branch is pulling us down?
- Store manager: which items will run out before the next delivery?
- Finance: which customers owe the most, and for how long?
- Owner: is this month better than the same month last year?
One screen, top to bottom
- Top: three to five headline numbers, each compared with target or last period.
- Middle: one or two trends that explain the headline numbers.
- Bottom: a short list of things that need action, such as overdue accounts or items running out.
- Everything else goes on a second page or in a filter, not on the first screen.
Headline numbers, the trend behind them, then what to act on. The rest can wait for page two.Trust comes before design
Agree the definitions
The fastest way to kill a dashboard is one wrong number. If the sales figure does not match what accounts reported, nobody will open it again. Before building visuals, we agree definitions in writing and reconcile the numbers with the team.
Definitions worth agreeing in writing before building any chart.| Term | The question to settle |
|---|
| Sales | Before or after returns, discounts and tax? |
| Active customer | Ordered in the last 30, 60 or 90 days? |
| Month | Calendar month, or the business's own closing date? |
| Stock | In the warehouse only, or including goods in transit? |
Small details that matter
- Show when the data was last refreshed, on the page itself.
- Use the currency and number format people use: lakh and crore in Pakistan, not millions.
- Make it readable on a phone, because many managers check it there first.
- Send a short weekly summary by email or WhatsApp with a link, so the dashboard comes to them.
A dashboard is finished when it answers a question someone asks every week, not when every column has a chart.
Frequently asked questions
Power BI or a custom web dashboard?
Power BI is quick to build and familiar to finance teams, with licence costs per user. A web dashboard costs more to build but has no per-user licence and can include actions, such as approving or assigning, not just charts.
Our data is in Excel files. Is that a problem?
Not at the start. Many dashboards begin from a shared folder of spreadsheets. Once the reports prove useful, moving the data into a proper database makes them faster and more reliable.
How often should it refresh?
As often as the decisions it supports. Daily is enough for most sales and stock reports; live data is only worth it when someone acts within the hour.
Who should own the dashboard after launch?
Someone on your side who knows the business. We hand over definitions, data sources and a short guide so they can add filters and pages without us.