The short answer
Dashboards fail from too many charts, numbers finance disputes, and no meeting using them. One gets used when:
- every measure serves a decision leaders make,
- each has one written definition and one owner,
- figures reconcile to the ledger or system of record,
- it shows what changed and needs attention,
- it anchors a regular review (weekly or monthly), actions recorded.
Start with five to nine measures; add more once trusted.
Why dashboards get ignored
- No decision behind it: it shows what was easy to extract, not what leaders need.
- Numbers disagree: sales says revenue is one figure, finance another; after one argument, nobody trusts either.
- Stale data: it last refreshed on Tuesday, and nobody can tell.
- Too much at once: forty charts on one screen means no chart gets attention.
- No rhythm: without a standing meeting that opens it, it becomes a link in a bookmark folder.
Start from decisions, not data
Work backwards with each leader: decision, question, measure, source.
| Decision | Question | Measure | Source |
|---|---|---|---|
| Do we hire another technician? | Are we keeping up with demand? | Open work orders older than 5 days, trend by week | ERP or service system |
| Do we chase a customer segment harder? | Where is margin coming from? | Gross margin by customer group, this quarter vs last | ERP sales and cost data |
| Do we need to draw on the credit line? | Will cash cover the next 8 weeks? | Receivables due vs payables due, rolling 8 weeks | Accounting |
These rows illustrate the method; they are not recommended measures for your organisation.
A measure that changes no decision stays off the executive view; it may belong in a team report.
Write a definition card for every measure
Arguments about numbers are usually about definitions. Settle each in writing:
- Definition
- Includes
- Excludes
- Source
- Refresh and timestamp
- Owner
- Reconciles to
- Target and threshold
Example definition card
Measure: Gross margin by customer group
- Definition: (net sales minus cost of goods sold) divided by net sales, for invoices posted in the period.
- Includes: credit notes; freight charged to customers.
- Excludes: unposted draft invoices; intercompany sales.
- Source: posted sales invoices and stock ledger in the ERP.
- Refresh: nightly; timestamp shown on the dashboard.
- Owner: controller.
- Reconciles to: gross margin in the monthly income statement, within an agreed tolerance.
- Target and threshold: set by the leadership team; below threshold shows as "needs attention" with a text label.
Design for a five-minute read
A good page answers: are we on track, what changed, what needs attention?
- Top rowHeadline measures against target, prior period or last year.
- MiddleTrends, so leaders see direction, not a snapshot.
- BottomExceptions (overdue invoices, low stock, projects over budget) linked to detail.
A number without a comparison is hard to act on. Many people cannot tell red from green, and WCAG 2.2 says colour should not be the only way information is conveyed (W3C): add labels or icons. A visible "data as of" timestamp prevents decisions on stale figures.
Make the data trustworthy
The build is the easy part; trust takes discipline.
- Reconcile before launch: each financial measure against posted accounts for two or three past periods; explain or fix differences.
- Pick the right layer: ERP dashboards for daily monitoring (ERPNext points to Frappe Insights for custom or cross-module charts); Power BI or eventually a data warehouse when data spans systems.
- Control who sees what: executive views hold payroll, margin or customer data. In Power BI, row-level security applies only to users with the Viewer role, not to workspace Admins, Members or Contributors (Microsoft Learn), which catches many teams out.
- Monitor refreshes: a failed overnight refresh should alert someone before the Monday meeting, not during it.
Rather talk it through? If your leadership team argues about whose numbers are right, we can agree the definitions, reconcile the data and build a dashboard people rely on. Talk to a Promatics specialist
Build the habit
A dashboard earns its place when a meeting depends on it. Open it at the start of the weekly or monthly leadership meeting, review exceptions first, record who does what. After a quarter, drop measures nobody discussed; add questions that kept coming up.
When to bring in help
One system with decent reporting and someone with time to learn it? Start there: many organisations get a useful first dashboard from their ERP or accounting package. Help pays off when systems disagree, definitions are contested, sensitive data needs access control, or two attempts went unopened. AI can suggest KPIs in seconds; it cannot spot freight posted to the wrong account, or reconcile last quarter with your controller.
- Decision workshops
- Definitions
- Data preparation
- Reconciliation
- Build
- Access testing
- Handover
Our data analytics and business intelligence service covers that full path, plus the ERPNext side when it is your system of record, so data is right at the source.
Launch checklist
- Each measure links to a named decision and a named owner.
- Every measure has a written definition card, agreed by the leaders who use it.
- Financial measures reconcile to posted accounts for at least two past periods.
- Each headline number has a comparison (target, prior period or last year).
- Status is shown with text or icons, not colour alone.
- A "data as of" timestamp is visible.
- Access has been tested with real user accounts in each role.
- Failed refreshes send an alert to a named person.
- The dashboard has a standing place in a leadership meeting.
- A review date is set to remove unused measures.
Sources and further reading
Product capabilities and guidance change. These are the primary sources this article relies on, checked on the review date above.
- Dashboard, ERPNext documentation (Frappe)
- Frappe Insights, Frappe documentation
- Row-level security (RLS) with Power BI, Microsoft Learn
- Web Content Accessibility Guidelines (WCAG) 2.2, W3C
This article is general information, not legal, accounting or security advice for your specific situation. Examples are hypothetical unless stated otherwise.