Business Dashboards: Start With Decisions Before Charts

A dashboard earns its place when it helps someone decide what to do. A colourful display of revenue, visitors and orders may still leave managers asking why performance changed. Start with the recurring decisions your team makes, then identify the data and comparisons needed to make those decisions with confidence.

Define the metric before calculating it

Agree what counts as a sale, an active customer or an overdue order. Specify whether revenue includes refunds, which date applies and how different currencies are presented. Two teams can use the same label and arrive at different numbers. Keep definitions beside the reporting process so a chart remains interpretable when staff or systems change.

Check the path from source to report

Map each metric to its source system and identify missing, duplicate or delayed records. Display the data refresh time and distinguish incomplete periods from completed ones. A manager should be able to move from a summary to the underlying records when a number looks unusual. Restrict access where reports include sensitive customer or employee information.

A first dashboard brief

• Name the decision and the person accountable for it.
• Define the metric and the source of each input.
• Choose a comparison period that reflects the business cycle.
• Set the required refresh frequency and acceptable delay.
• Specify the action or investigation a change should trigger.

Worked example: two revenue reports disagree

An illustrative sales team reports order totals by creation date, while finance reports settled payments after refunds. Both reports say “revenue”, but they answer different questions. Write separate definitions and compare the same period before asking a developer to make the charts agree. Otherwise, the dashboard can hide the difference instead of resolving it.

A useful metric definition records its purpose, source, date field, exclusions and refresh interval. For the sales manager, a view of proposals awaiting a response may be more actionable than either revenue chart. Include the drill-down records needed to understand an unusual change.

Planning worksheet

Build one useful view first

A sales manager may need proposals awaiting follow-up rather than an elaborate forecasting model. An operations manager may need overdue deliveries by service area. Review whether the first view changes behaviour before adding more charts. INFACT Solutions includes data analytics and BI among its services. Bring a sample report, the decisions it supports and known data problems to scope a dashboard that can become a dependable part of your workflow.