Sales dashboard examples and what yours must include

Monday, 8:30 a.m., sales meeting. The manager opens a 14-tab spreadsheet, filters three columns, and the first half hour disappears into an argument about whether August's number is right or someone forgot to update the proposals tab. Nobody decided anything; the team just audited data. That scene plays out in thousands of companies every week, and its cost is invisible: Salesforce's State of Sales research found that reps spend less than 30% of their time actually selling.

A good sales dashboard exists to kill that meeting. It is not a decoration on the sales floor TV: it is the tool that turns "how are we doing?" into a five-second answer.

In short: a sales dashboard is a visual panel that gathers the essential commercial indicators (revenue against target, pipeline, conversion rate, average deal size and sales cycle) on a single screen, refreshed automatically, so managers and reps can track progress and correct course before the month ends.

What a sales dashboard needs to answer

Before picking charts, define the questions. Every commercial dashboard that works answers three things, in this order: will we hit the target? Where is the bottleneck? What do we do tomorrow morning? If the panel cannot answer the first question at a glance, it has failed, no matter how good it looks.

This matters because a dashboard is not a data repository, it is a decision instrument. McKinsey found that data-driven companies are 23 times more likely to acquire customers than competitors who run on gut feeling. But "data-driven" does not mean owning lots of charts: it means watching the right indicators, at the right cadence, and acting on them.

Which indicators are non-negotiable?

The temptation is to include everything. Resist it. A first-screen sales panel works with six to eight indicators. Everything else belongs on a second level, opened only when something drifts off course.

Indicator	What it shows	Question it answers
Revenue vs. target	Closed sales for the period against the goal	Will we hit the target?
Pipeline coverage	Value in negotiation divided by remaining target	Is there enough opportunity on the table?
Conversion rate	% of opportunities that become sales, by stage	Where does the funnel leak?
Average deal size	Average value per closed sale	Are we selling well or selling cheap?
Sales cycle	Days between opening and closing	Can we trust the cash forecast?
CAC	Cost to win each customer	Does growth pay for itself?
Sales activity	Calls, meetings and proposals per rep	Is the problem effort or efficiency?

CAC and LTV deserve their own panel when marketing and sales share the bill. If those calculations are not second nature yet, read how to calculate CAC and how to calculate LTV before adding them, because a badly calculated indicator is worse than a missing one.

How to structure the dashboard in three layers

The best commercial panels I have seen follow a pyramid logic: results on top, funnel in the middle, activity at the base. You only read downward when the level above raises a flag.

In practice, that is rarely what you find. The typical panel mixes a pie chart of sales by region, a rep ranking and a five-year revenue trend, all on the same screen with no hierarchy. There is no shortage of information; there is a shortage of reading order.

Sales dashboard examples by context

Example 1: distributor with a monthly target

A food distributor in Fortaleza, Brazil, sells R$900k a month against a R$1M target. The director's panel shows accumulated revenue (R$612k on day 18, i.e. 61% of the target with 60% of the month gone), pipeline coverage and weekly conversion. Since the sales cycle is short, the dashboard refreshes daily and yesterday's data shapes today's route for field reps.

Example 2: B2B SaaS with a long cycle

A management SaaS company has a quarterly target of R$300k in new subscriptions. Its panel leads with pipeline coverage: R$750k in negotiation, which means 2.5x coverage. But with a historical conversion of 25% (30 wins out of every 120 opportunities), R$750k of pipeline projects roughly R$187k, below target. Coverage looked comfortable; real conversion shows it is not. That cross-check is exactly what a good dashboard does and a loose spreadsheet hides.

Example 3: e-commerce running paid traffic

An online supplement store investing R$60k a month in ads needs a panel that puts media and revenue side by side: spend, ROAS, orders, average order value and CAC per channel. Keeping the marketing dashboard separate from the sales dashboard, here, is a recipe for a war between teams. If that sounds familiar, the paid traffic metrics worth tracking complete this panel.

Design mistakes that sabotage the reading

The first mistake is excess: 30 charts on one screen is the most expensive way to inform nobody. The second is the wrong chart for the question; an eight-slice pie answers nothing that a sorted table would not answer better. The third is missing comparison: is R$480k in sales good or bad? Without a target, last month or the same period last year, the number is just decoration.

Then there is the subtler mistake: an indicator with no owner and no cadence. A panel nobody opens in the Monday meeting becomes a dead report within three weeks. The rule that works: every indicator gets an owner, a reading cadence and an agreed action for when it drifts out of range. Missing any of the three? It leaves the panel.

Finally, beware of the average that hides the distribution. An average deal of R$10k can be ten R$10k sales, or nine at R$4k and one at R$64k. Depending on which, the right decision changes completely. This shortcut breaks when the base is small or has outliers; mature dashboards show the median or ranges next to the average.

Excel, Power BI or AI: where to build it?

Excel is fine to start with, and there is no shame in that: with one rep and twenty deals a month, a well-structured spreadsheet with simple charts does the job. The limit shows up when the data lives in three places (CRM, targets spreadsheet and ad platform) and someone burns every Monday morning copying and pasting.

Power BI and similar tools solve consolidation but charge in another currency: someone has to model the data and keep the connections alive, and every new question ("what about conversion in the countryside accounts only?") becomes a ticket for whoever knows the tool. The newer third path is AI-powered analytics platforms, where the new question is asked in plain language and answered on the spot, with no ticket queue. The honest criterion for choosing: who will be asking the questions, and how much time does that person have? The KPIs for each funnel stage stay the same in any tool.

Frequently asked questions

Which indicators are essential in a sales dashboard?

Revenue against target, pipeline coverage, conversion rate by stage, average deal size, sales cycle and sales activity per rep. This set answers whether the target will be hit, where the bottleneck is and what to do about it. CAC and LTV join in when the panel also accounts for acquisition spend.

Is it better to build the sales dashboard in Excel or Power BI?

It depends on data volume and dispersion. A small operation with data in one place: Excel does it. Data scattered across CRM, spreadsheets and ad platforms: Power BI or an AI analytics tool avoids the manual consolidation work, which is where most Excel dashboards die.

What is the difference between a sales report and a sales dashboard?

A report is a closed snapshot of a period, built to document; a dashboard is a living panel, refreshed on a defined cadence, built to track and correct course during the period. In practice, the report explains the month that ended and the dashboard helps save the month still running.

How often should a sales dashboard be updated?

At the pace of the decision it feeds. A short sales cycle (retail, e-commerce) calls for daily or real-time refresh; B2B sales with cycles of months work fine with daily refresh and weekly reading. Updating faster than you decide produces anxiety, not results.

Should each sales rep have their own dashboard?

Yes, but as a second level, not as the main panel. Reps track their own targets, pipeline and activities; the manager watches the aggregated team and drills into an individual panel when a number drifts. Public rep rankings work in some cultures and destroy others; use with judgment.

The right panel is the one that changes Tuesday

A sales dashboard is not judged by its looks but by what happens after someone reads it. If Monday's panel changes what the team does on Tuesday, it works; if it only confirms what everyone already knew, it is expensive decoration. Start small: three layers, half a dozen indicators with owners, one central question per screen.

And if the hard part is precisely pulling CRM, spreadsheets and ad platforms into one place, that is the step you can delegate: Sherlok connects those sources and answers questions like "what is this month's conversion per rep?" in plain language, no technical ticket queue required. The panel becomes a conversation, and the Monday meeting goes back to being about decisions, not number-checking.