What is a dashboard: definition, types and examples
A dashboard is a single screen that shows a company’s key metrics as charts, numbers and tables. It takes figures that are already calculated in accounting systems, CRMs or spreadsheets and presents them so that in a few seconds you can see how the business is doing and decide what to do next.
A dashboard in plain words
Think of a car’s instrument panel: speed, fuel and engine temperature are all in front of you, and you do not need to open the bonnet to know whether everything is fine. A business dashboard does the same for a company: revenue, profit, cash, customer debt and sales plan progress on one screen, updated automatically.
The main difference from a report: a report answers “what happened”, while a dashboard answers “what is happening now and where should I look”. People open it daily for a few seconds rather than read it once a month.
What a dashboard looks like
Below is a real small-business dashboard on demo data. Hover over a chart to see the values, change the period or category in the filters:
One screen shows cash in the bank, plan progress, average order value, gross margin and sales by channel. This is a typical owner’s dashboard: a few headline numbers at the top, trends and structure below.
The core principle: display, not calculation
- Data is prepared in advance. Sales, margin, EBITDA or ROI are calculated by the accounting system, CRM or a script — where the source data lives.
- The dashboard pulls the results through an API, the web service of an accounting application or from files (CSV, Excel, Google Sheets) and shows them in a convenient form.
- Speed comes from the fact that the dashboard does not recalculate data but only requests ready values.
- Accuracy is guaranteed by a single source of truth: the figures on the dashboard match the books because they come from them.
Types of dashboards
By purpose
| Type | Purpose | Example metrics |
|---|---|---|
| Operational | Daily control of current processes | Today’s revenue, number of orders, stock levels |
| Analytical | Finding causes and trends | Monthly sales trend, margin by product, ROI by channel |
| Strategic | Progress on long-term goals | Company KPIs, annual plan vs actual, profitability |
| Project | Project tasks and resources | Stage status, budget, team workload |
By department
- Financial dashboard — revenue, net profit, margin, cash flow, accounts receivable.
- Sales dashboard — plan vs actual, average order value, lead-to-deal conversion, sales by manager and channel.
- Warehouse dashboard — stock levels, inventory turnover, lead time, on-time delivery.
- Marketing dashboard — leads, customer acquisition cost (CAC), ROMI / ROAS, LTV.
- HR dashboard — headcount, staff turnover, time to hire, cost per hire.
The full list of metrics by area is in the article KPIs — key performance indicators.
Who uses dashboards
- Owner and CEO — the overall picture: revenue, profit, cash, plan progress.
- CFO — cash flows, bank balances, debts of customers and to suppliers.
- Sales director and sales managers — plan vs actual, the funnel, team results.
- Marketers — channel and campaign performance, cost per lead and per customer.
- Operations and warehouse — stock, shipments, lead times, quality.
- HR — headcount, turnover, hiring.
Benefits of dashboards
- Speed. Data refreshes automatically, so deviations from the plan are visible immediately, not at the end of the month.
- One screen instead of a dozen reports. Metrics from different systems are brought together.
- Clarity. A chart compared with a target reads faster than a table of numbers.
- A shared picture. Department heads look at the same figures, so there are fewer arguments about whose data is right.
- Any device. A dashboard opens in the browser on a computer, tablet or phone and can be shown on an office screen.
Dashboard vs report
| Dashboard | Report | |
|---|---|---|
| Question | What is happening now? | What happened over the period and why? |
| Updates | Automatic, daily or more often | Produced as of a date |
| Scope | 5–12 key metrics | Detailed tables and commentary |
| Time to read | Seconds | Minutes to hours |
A dashboard does not replace reports but complements them: it shows where the deviation is, and the report helps to dig into the details.
How to build a dashboard in 5 steps
- Set the goals. What do you need to control: sales, profitability, cash, inventory, the team?
- Pick 5–12 metrics. Each one should serve a goal and suggest an action. Leave the rest to reports.
- Prepare the data. Metrics should be calculated in the accounting system, CRM or spreadsheet; the dashboard only shows them.
- Connect the source and set up widgets. For each metric choose a view: a number, a chart, a plan gauge, a table.
- Share and review. Give the team access and adjust the set of metrics as needed.
In Dashboard these steps take minutes: you can try the demo, upload an Excel file or connect a Google Sheet, and for an accounting system use its web service. The finished dashboard opens by link, embeds into a website or CRM and goes full screen.
Common mistakes
- Too many metrics. Nobody reads a dashboard with 40 charts — keep what matters.
- Metrics without targets. A number without a plan or a comparison with the previous period does not tell you whether it is good or bad.
- Calculations inside the dashboard. Formulas belong in the books, otherwise the figures will diverge.
- Stale data. People stop opening a dashboard that is updated by hand once a week.
Questions and answers
What is a dashboard in simple terms?
What is the difference between a dashboard and a report?
What types of dashboards are there?
Can I build a dashboard from Excel or Google Sheets?
How many metrics should a dashboard have?
How much does a dashboard cost?
Conclusion
A dashboard is not a calculation tool but a way to see a business’s ready-made metrics on one screen. It brings together data from different systems, speeds up decisions and makes the team’s work transparent. Start with a few key metrics and grow the dashboard together with the business.