Book a consultation
Sales & Revenue

Sales dashboards your team actually uses

A sales dashboard that shows pipeline, forecast and rep performance in one view, built on clean CRM data for each role.

See how we work
The sales manager view flags three late-stage deals, worth $780K, that have no next stepSales manager dashboard: three KPI tiles and a late-stage deal list where three deals have no next step.Three late-stage deals have no next stepSales manager view, late-stage pipeline, this weekDemo dataLate-stage pipeline$2.3MDeals in late stage9No next step3DealStageValueNext stepDeal 1042Proposal$310KNoneDeal 1057Negotiation$280KNoneDeal 1061Contract$190KNoneDeal 1038Negotiation$420KPricing call, TueDeal 1049Proposal$260KDemo, ThuDeal 1066Proposal$170KLegal review, Fri3 deals, $780K, need a next step this weekThe sales manager view flags three late-stage deals, worth $780K, that have no next stepSales manager dashboard: three KPI tiles and a late-stage deal list where three deals have no next step.Demo dataThree late-stage dealshave no next stepSales manager view, late-stage pipeline,this weekLate-stagepipeline$2.3MDeals inlate stage9No nextstep3Deal, stageValue, next stepDeal 1042$310KProposalNoneDeal 1057$280KNegotiationNoneDeal 1061$190KContractNoneDeal 1038$420KNegotiationPricing call, TueDeal 1049$260KProposalDemo, ThuDeal 1066$170KProposalLegal review, Fri3 deals, $780K, need a next stepthis week

We design and build each sales dashboard in Power BI, HubSpot or Salesforce. Every KPI is defined, every number reconciled and every view matched to the decision its user makes. The result is one sales dashboard per role built for reps, managers, finance and leadership to use every week.

What it is

A sales dashboard is only useful if it leads to an action

Definition

A sales dashboard is a data visualization of the numbers behind sales performance: pipeline, bookings, conversion, deal speed and rep activity. It refreshes from the CRM by itself and replaces the weekly spreadsheet someone builds by hand.

sales and revenue analytics

  1. A useful sales dashboard does three things. It answers set questions for one audience, so a rep, a manager and a CFO each see what they need. It uses definitions everyone agrees on, so the screen matches the board pack. And it runs on trustworthy data, which usually means fixing CRM stages, duplicates and missing fields first.

  2. A native sales dashboard in HubSpot or Salesforce suits day-to-day views close to the pipeline. A BI tool such as Power BI is needed when sales data must join targets, finance or product data, or when leaders need one view across several CRMs. We help you choose, and often combine both. Above all, every view should lead to an action someone can take.

  3. Signs you need a better sales dashboard: pipeline reviews start with exports, finance and sales report different numbers, or reps stop updating the CRM. Each sign points to a fixable cause.

  4. We fix the cause first, then build the sales dashboard.

  5. A better sales dashboard starts with better questions. Start there. A short review of your current reports shows which of these applies to you.

  6. The sections below show who each view serves, which KPIs it carries, what it looks like on demo data and how to build one.

Two questions decide where a sales dashboard lives: if it needs targets, finance or product data, or one view across several CRMs, use a BI tool; otherwise a native CRM dashboardDecision tree: question 1, does the view need targets, finance or product data; question 2, do leaders need one view across CRMs. Yes leads to a BI tool, no to a native CRM dashboard.Native CRM dashboard or BI tool: two questions decideWhere a sales dashboard should live, by what the view needsQuestion 1Does the view need targets,finance or product data?Question 2Do leaders need one viewacross several CRMs?NoNoNative HubSpotor SalesforcedashboardDay-to-day views closeto the pipelineYesYesBI tool such as Power BIJoins targets, finance and product data; one view across CRMsOften both: native views for reps and managers, BI for leadershipWherever a view lives, it should lead to an action someone can take.Two questions decide where a sales dashboard lives: if it needs targets, finance or product data, or one view across several CRMs, use a BI tool; otherwise a native CRM dashboardDecision tree: question 1, does the view need targets, finance or product data; question 2, do leaders need one view across CRMs. Yes leads to a BI tool, no to a native CRM dashboard.Native CRM dashboard or BItool: two questions decideWhere a sales dashboard should live, by whatthe view needsQuestion 1Does the view need targets,finance or product data?YesBI tool such as Power BINoQuestion 2Do leaders need one viewacross several CRMs?YesBI tool such as Power BINoNative HubSpot or SalesforceDay-to-day views close to the pipelineOften both: native views for repsand managers, BI for leadershipWherever a view lives, it should lead toan action someone can take.
Benefits

A sales performance dashboard gives each role a different decision

One crowded sales dashboard serves nobody. We design a view for each role, drawn from the same governed data, so the numbers agree in every meeting. Each view is tested with its users before rollout.

A sales manager dashboard sits at the center of the weekly review. It turns the weekly pipeline review from a list-reading exercise into a coaching session. A CFO view turns the forecast into a planning number. A CEO view shows where the revenue engine needs investment.

A typical sales dashboard rollout starts with the sales manager view in weeks 0 to 4, adds rep and marketing views, then the CFO view and the CEO view lastRollout sequence in weeks: sales manager 0 to 4, RevOps data quality 0 to 6, rep 4 to 7, marketing 6 to 9, CFO 9 to 12, CEO and board 12 to 14.Start with the manager view; the CEO view comes lastTypical rollout order of role views on one governed model, weeksDemo dataSales managerStart here: the weekly reviewRevOps data qualityRuns alongside, keeps views credibleRepMobile layoutMarketingSourced pipelineCFOAfter several reliable reviewsCEO and boardLast, on the same model02468101214WeekEach view is tested with its users before rollout.A typical sales dashboard rollout starts with the sales manager view in weeks 0 to 4, adds rep and marketing views, then the CFO view and the CEO view lastRollout sequence in weeks: sales manager 0 to 4, RevOps data quality 0 to 6, rep 4 to 7, marketing 6 to 9, CFO 9 to 12, CEO and board 12 to 14.Demo dataStart with the manager view;the CEO view comes lastTypical rollout order of role views on onegoverned model, weeksSales managerwk 0–4Start here: the weekly reviewRevOps data qualitywk 0–6Runs alongside, keeps views credibleRepwk 4–7Mobile layoutMarketingwk 6–9Sourced pipelineCFOwk 9–12After several reliable reviewsCEO and boardwk 12–14Last, on the same modelEach view is tested with its users beforerollout.

Each view below names the person, the decision and what they see.

Use the cards to decide which role to build for first. A common starting point is the sales manager dashboard, because the weekly review is where better data changes behavior fastest. The CFO view can follow once the pipeline data has proved reliable over several reviews.

Role views also make adoption easier. People use a sales dashboard that answers their own question in seconds. They ignore one that makes them search. That is why each view stays short, opens on the most important number and links to detail only where its user needs it.

An executive sales dashboard for the CEO and the board comes last, built on the same model.

Manager: coach the deals that stall

Pipeline by rep, stage conversion, deal aging and activity against targets, filtered by team, turn weekly reviews into coaching sessions.

Rep: never miss a next step

Own pipeline, quota attainment and deals at risk, on a mobile layout, so CRM updates come back as useful information.

CFO: plan cash on a solid forecast

Weighted pipeline against plan, forecast changes and bookings matched to invoicing, with stored snapshots to track accuracy over time.

CEO: invest where growth is

Bookings against plan, coverage, win rate and cycle trends by segment and region, ready to share with the board.

RevOps: keep every view credible

Missing close dates, stale deals and duplicate accounts, ranked by reporting impact and listed for weekly cleanup.

Marketing: see sourced pipeline

Opportunities and revenue by source and campaign, so marketing and sales agree on what each channel contributes to revenue.

KPIs we track

Sales KPI dashboard: six metrics answer most pipeline questions

Every metric on a sales KPI dashboard has a written formula, source and owner, agreed by sales and finance together. We add role-specific measures, such as activity for reps or net revenue retention for leaders, only where they support a decision.

GoalHit this quarter's bookings target
  1. Enough pipelineReview first
    • Pipeline coverage
    • Stage conversion
  2. Effective selling
    • Win rate
    • Average deal size
  3. Deal speed
    • Sales cycle length
  4. A trusted commit
    • Forecast accuracy
Goal, drivers, metrics. The highlighted driver is the one to review first.

Know if the target is reachable

Demo

Pipeline coverage: open pipeline / remaining quota, for this quarter and next.

See if selling is improving

Demo

Win rate: closed-won deals / all closed deals, by rep, source and deal size.

Find where deals slow down

Demo

Sales cycle length: average days from opportunity created to closed-won, per stage.

Catch discounting early

Demo

Average deal size: closed-won revenue / closed-won deals, trended monthly.

Locate funnel leaks

Demo

Stage conversion: deals moving to the next stage / deals entering it. Shown by team.

Trust the commit

Demo

Forecast accuracy: actual bookings / forecast at a fixed date, across weekly snapshots. Owned by the CFO.

Each KPI below states the decision it supports first, then the formula.

Six KPIs are enough to start a sales dashboard. A short list gets read; a long list gets ignored. We add metrics only when a leader names the decision a new metric will support, and we retire metrics nobody uses.

Formulas are stored in a metric dictionary everyone can read.

Sample dashboards

Each sales dashboard example answers one question for one audience

These samples are not templates; they use demo data to show layout, metrics and interactions, not client results. Each lists its KPIs and the CRM fields it needs, so you can see what your own version would require. Layouts adapt to HubSpot, Salesforce or Power BI.

Sales dashboard examples by role

Demo data
Open pipeline$3.6M▲ +7% WoW
Late, no next step3▲ +2
Avg. deal aging38 days▲ +4 days
Stage conversion42%▲ +3 pts

Three late-stage deals have no next step

Open pipeline by stage, this week, $K

$0K$500K$1,000K$1,500KDiscoveryDemoProposalNegotiationContract$1,000K in Proposal: $780K late-stage, no next step$0K$500K$1,000K$1,500KDiscoveryDemoProposalNegotiationContract$1,000K in Proposal: $780K late-stage, nonext step
Open pipelineNo next step

So what: Start the weekly review with late-stage deals that have no next step booked.

DealStageValueNext step
Deal 1042Proposal$310KNone
Deal 1057Negotiation$280KNone
Deal 1061Contract$190KNone
Deal 1038Negotiation$420KPricing call, Tue
View 1

Run a sharper pipeline review

Sales manager dashboard: pipeline by rep and stage, deal aging and deals with no next step; drills to deal level.

View 2

Prepare the board pack faster

Executive dashboard: bookings against plan, coverage, win rate and cycle trends by region and segment. Ready for leadership.

View 3

Agree one forecast number

Forecast dashboard: categories by rep, weighted pipeline, changes since last snapshot and past accuracy. Shared by sales and finance.

View 4

Keep reps updating the CRM

Rep dashboard: quota, pipeline, close dates and deals at risk, with a mobile layout. Kept simple.

View 5

See source-to-revenue

Marketing view: opportunities and closed revenue by source and campaign, joined from CRM and GA4.

View 6

Prove retention: renewals view

Upcoming renewals, expansion pipeline and at-risk accounts, so account managers decide which renewals to work first.

Each sample answers one question for one audience. Use them to decide which view to build first: for example, the one closest to your next pipeline review or forecast call.

The interactive sample below shows the first three: manager, executive and forecast. Every sales dashboard sample can be adapted to your own CRM fields and KPIs.

All samples share one data model, so a number on one view always matches the same number on another. That consistency is what keeps sales and finance from building their own versions.

Step by step

How to build a sales dashboard that people keep using

Whether you build it in-house or with us, a sales dashboard that sticks follows six steps. Steps two and three are the easiest to skip, and skipping them sinks a sales dashboard. Charts get built before definitions are agreed or before CRM data is fixed. Users lose trust the first time a number does not match.

The six steps at a glance

Select a stage, use Next or the arrow keys

Name audience and decisions. Write down who uses it and which decisions it supports before choosing any chart. Keep each audience to one page. Three to five questions per audience is usually enough.

Step 1 of 6

Step one often removes many of the charts people first ask for. Step three prevents many repeat issues, through required fields and validation rules. Step six keeps the dashboard lean: usage data shows which views earn their place.

Plan for maintenance from day one. Sales processes change, and a sales dashboard that does not change with them loses users. Name an owner, schedule a quarterly review and keep a short change log, so everyone knows what changed and why.

Each step below names the outcome first, then the action.

Use the steps as a checklist before any build. If a step is missing, the sales dashboard is likely to fail at that point. Teams that skip definitions end up arguing about numbers; teams that skip data fixes end up with charts nobody trusts.

A sales dashboard is a product, not a project. Treat it like one and it keeps earning its place.

How we work

We build your sales dashboard, prove it matches finance, then keep it current

We start with a consultation on your questions and CRM data, and build once the data and your team are ready. Delivery runs as a defined project, with training and optional support from a fractional analytics team. Timelines depend on CRM data quality and audiences; we agree them in discovery and aim to ship a first working view early. You own every model and dashboard we build.

How we build and maintain your sales dashboard

Select a stage, use Next or the arrow keys

Agree the questions. Interviews with sales leaders and finance produce a written spec of audiences and KPIs. Signed off.

Step 1 of 4

Every step of the sales dashboard build has an owner and a sign-off.

The four steps below group the six build steps above into four stages, with our team doing the work and your team approving each stage. You always know what is live and what comes next.

Book a consultationdata modernization projectsanalytics as a service
Frequently asked questions

Sales dashboard: questions buyers ask before a build

What should be included in a sales dashboard?

Include only the KPIs that support the decisions of its audience. For a B2B team, that usually means pipeline coverage, win rate, sales cycle length, stage conversion, average deal size and forecast accuracy, plus a list of deals that need attention. Each metric needs a written definition and source.

Should I use CRM dashboards or a BI tool?

Native HubSpot or Salesforce dashboards suit day-to-day views built only on CRM data. A BI tool such as Power BI is better when you need to combine sales with targets, finance or product data, apply complex logic or give leaders one view across systems through CRM integration. A sales dashboard can also combine both.

How often should a sales dashboard be refreshed?

A sales dashboard for reps and managers usually refreshes several times a day or daily, so pipeline reviews use current data; real-time data is rarely needed. Executive and forecast dashboards usually refresh daily, with fixed weekly or monthly snapshots to track how the forecast changes and how accurate it proves.

How much does a custom sales dashboard cost?

Cost depends on the number of data sources, the state of your CRM data, the number of audiences and whether a BI model is needed. We scope each project in writing with fixed deliverables, so you know exactly what will be built before work begins.

Get a sales dashboard built on your CRM data and trusted by finance

Tell us which CRM you use and which decisions your dashboard must support. We propose a scope and a sample sales dashboard layout. The first conversation is a working session.

Book a consultation and we will review your current reports with you.

No preparation needed.

We aim to reply within one business day with clear next steps.

sales forecastinglead scoringchurn analysisrevenue operationsSaaSprofessional servicesstrategic planning advisoryAI readiness assessment
See how we work