How many core metrics should an executive dashboard show?
There is no fixed number. Keep a small set that reflects business status and risk on the first screen; place other measures on sales, project, finance and customer detail pages.
How to Build a Metric Definition Table for an Executive Dashboard
Summary: When dashboard numbers disagree after launch, the chart is rarely the root cause. Metric definitions, time ranges, filters or data sources were not aligned. A definition table should record each metric's name, business meaning, formula, period, dimensions, source, update frequency, owner and permissions so every management number can be explained, checked and traced.
Agree on what a number means before deciding which chart should display it.
A definition table needs at least nine fields
| Field | What it must explain |
|---|---|
| Metric name | Displayed label and any short name |
| Business definition | The business question the metric answers and where it applies |
| Calculation formula | Numerator, denominator, aggregation, deduplication and exceptions |
| Reporting period | Calendar day, week, month, quarter, year or rolling period |
| Analysis dimensions | Region, department, customer, product, project, owner and similar categories |
| Data source | System, table, interface or manually maintained location |
| Update frequency | Real time, daily, weekly or at a business milestone |
| Owner | Business-definition approver and data-quality owner |
| Access scope | Which roles may view summaries and details |
Start from management questions, then choose metrics
An executive dashboard should not simply move every existing report onto a screen. First list the questions managers need answered: “Are we on target this month?”, “Which projects are delayed?”, “Which customers have collection risk?” or “Is stock accumulating?” Map each question to outcome, process and risk measures. This prevents the page from becoming a wall of unrelated numbers.
Separate outcome, process and risk measures
- Outcome metrics:Sales, revenue, profit, collections and units delivered show business results.
- Process metrics:Opportunity conversion, contract execution, project milestones, production progress and inventory turnover explain how results develop.
- Risk metrics:Overdue collections, delayed projects, abnormal stock and customer-churn warnings highlight items requiring action.
Examples: how to define common business metrics
| Metric | Definition to confirm | Typical dimensions |
|---|---|---|
| Sales value | Count signed contracts, invoices or collections? Include tax or exclude it? | Region, customer, product, sales representative |
| Collection rate | What is due, when is payment counted, and how are refunds and bad debts handled? | Customer, project, month, owner |
| On-time project rate | Source of planned milestones, delay cut-off and whether paused projects are excluded | Project type, owner, customer, stage |
| Gross margin | When revenue and cost are recognized; which expenses count as project cost | Project, product, customer, region |
| Inventory turnover | How average inventory is calculated, scope of cost of goods issued and reporting period | Warehouse, category, month |
What if the same metric has several versions?
Put each department's current formula, source and use side by side before deleting anything. Then let the business owner choose the primary dashboard definition. If multiple versions are genuinely needed, distinguish them in the names, such as “contracted sales value,” “invoiced revenue” and “cash collected,” and state which pages and users should see each. Do not label all three simply “sales.”
Not every measure needs live refresh
Live updates raise interface, processing and operating costs, but do not necessarily improve decisions. Equipment status and alerts may need real-time or minute-level updates. Sales, projects, collections and profit are often updated daily, weekly or at business milestones. Ask whether a manager needs to act immediately when the value changes.
Record business and data owners separately
The business owner explains meaning and use; the data owner handles source-system fields, quality and sync failures. The technical team implements approved definitions in interfaces, calculations and pages, but should not decide business definitions on behalf of the department. When numbers are disputed, the table identifies who approved the definition and where to check it.
How the table fits the dashboard development process
- List management questions and candidate metrics; remove duplicates that do not help decisions.
- Have business teams complete definitions, formulas, periods, dimensions and owners.
- Have data or technical staff verify source systems, fields, quality and refresh frequency.
- Check calculations with real or masked sample data before moving into prototyping and UI design.
- At acceptance, compare dashboard numbers, filters and details with each approved definition.
A ready-to-use metric definition template
The site's template includes examples for sales, project progress, collection rate, inventory turnover, alert count, new customers and profit margin. Edit or remove them for your own organization.
Download the executive dashboard metric template
Frequently asked questions
What if departments define the same metric differently?
Record existing definitions and uses, then have a business owner approve the primary definition. If several must coexist, give each a clear name and scope.
Should the technical department maintain the definition table?
The technical team implements and maps definitions. Business meaning needs business-owner approval, and the data-quality owner should also be recorded.
Does executive dashboard data need real-time updates?
Not always. Refresh frequency should match the management action. Business performance metrics are often updated daily, weekly or at business milestones.
Related pages
Once a draft is ready, download the BI metric-definition review checklist (Chinese) to record sample recalculations, permissions, review decisions and versions. During integration, launch or change, use the metric definitions and data-lineage acceptance matrix (Chinese) to verify the approved version, upstream and downstream dependencies, dashboards using the metric, sign-off owners and acceptance evidence. Related services: Enterprise executive dashboard development (Chinese), BI project implementation scope (Chinese). Further reading: Common executive dashboard metrics, How enterprise dashboard data is integrated, The difference between data dashboards and management cockpits.