Sales Team Performance Dashboard: KPIs and Real Example
Ask a sales manager how their team did last month and the answer usually starts with "give me a few days". Visit counts sit in the CRM, sales figures in another system, targets in a spreadsheet and the org chart in an HR file, and someone has to merge them and apply the scoring rules by hand. A sales team performance dashboard does that work in one place by combining those sources and scoring every person against the same rules.
BI Solusi built one for a field sales organization where reps and managers each had their own KPIs and the scores were rebuilt every month before anyone could discuss them. Managers wanted one view of their team, and each person wanted to see where they stood. This guide covers which KPIs to track, how the scores work, what each dashboard view is for and what the finished dashboard looks like.
Why Sales Team Performance Is Hard to Track
Sales team performance is hard to track because it is rarely one number: a fair score mixes activity (are people doing the right things, often enough?) with results (is it turning into sales?). Each of those comes from a different system, different roles have different KPIs, and the rules change from one period to the next. Without a single layer that combines them, each team ends up with its own spreadsheet and its own numbers.
Tracking performance manually costs you review time and trust in the numbers. If any of the following sound familiar, a well-built KPI dashboard will pay for itself:
Meetings get stuck on the data: Performance reviews spend more time checking whose numbers are right than talking about how to improve.
People find out too late: Reps only learn they are below the passing grade when the month is already closed.
Scores get disputed: If the weights and targets behind a score aren't visible, every unexpected number starts an argument.
Comparison has no context: A score of 82 means little until you know where the rest of the team sits, but sharing everyone's numbers openly isn't an option.
A dashboard also needs BI adoption across teams, because people only use scores they can see and understand.
What to Measure: Sales KPIs and How Scoring Works
A sales team performance dashboard should measure two things for every person: activity KPIs, which show effort, and results KPIs, which show outcomes. The examples below are typical for a field sales team, and your own list will depend on your roles and sales process.
Score | Example KPIs | Question it answers |
|---|---|---|
Activity | Customer visits per week, meetings completed, new customers contacted | Are people doing the right things often enough? |
Results | Sales against target, visit-to-order conversion rate, new customers won | Is that activity turning into sales? |
Each KPI then becomes a score in four steps:
Set a target: Agree on a target for every KPI, role and period.
Calculate achievement: Divide the actual result by the target.
Apply the weight: Multiply the achievement by the KPI's weight, which sets how many points it can contribute.
Add up the scores: Sum the weighted KPI scores into an Activity score and a Results score, then combine them into a total and compare it with the passing grade.
For example, a rep with a target of 40 customer visits who completes 36 has 90% achievement. If that KPI carries a weight of 20 points, it adds 18 points to the Activity score.
How a Sales Team Performance Dashboard Works
A good sales team performance dashboard pulls the KPI data from each source into one model and turns it into a single score per person, split into an Activity score and a Results score. A Power BI implementation organises that model around the questions each audience actually asks:
Team overview: How is my team doing this month, and who is below the passing grade?
Individual breakdown: For each KPI, what was the target, the weight, the achievement and the score?
Peer comparison: Where do I stand against everyone else in the same role?
The table below shows what changes once the dashboard replaces manual reporting.
Area | Before | After |
|---|---|---|
Data sources | CRM, sales system, target sheets and HR files combined by hand | One data model refreshed automatically |
Monthly scores | Rebuilt in spreadsheets every period | Calculated in the dashboard as soon as data refreshes |
Visibility for each person | Results sent out after month-end | Everyone sees their own score and KPI breakdown anytime |
Comparison with peers | Not shared, or shared as an open ranking | Anonymous: you see yourself against everyone else, without names |
Changing KPIs or weights | Report changes by a developer | Update a configuration table |
Real Example: Field Sales Team Performance Dashboard
BI Solusi designed and built the Power BI dashboard on top of the company's Microsoft Fabric data warehouse. It has one performance page for each of the four field roles. All pages follow the same scoring method, and a manager and a rep read their numbers the same way. The design follows the same logic as a centralized dashboard for cross-team product launches: one entry point, one set of definitions.
Each page supports a different decision:
Score summary: Total, Activity and Results scores for the selected period, year, month and team. Managers use it to decide which teams need attention first.
KPI breakdown: Passing grade, target, weight, achievement and score for every indicator. Reps see exactly what drove their number, and managers see which behavior to coach.
Team detail: Every team member's achievement and scores in one table for managers to see who needs support.
Anonymous benchmarking: A bubble chart plots each person against everyone in the same role. You see your own dot, and the others stay unnamed.
Performance reviews now start from the same numbers for everyone, managers can spot who is falling behind during the month instead of after it, and each person knows where they stand without seeing anyone else's name. For more layouts to borrow from, see these Power BI dashboard examples.
Preparation Before You Build
Before building a team performance dashboard, agree on these four things:
KPIs and weights per role: List each role's indicators, targets, weights and passing grade, and who approves changes.
Who sees what: Decide what reps, managers and leadership can each see, including how peer comparison is anonymised.
One source for the org structure: Keep a single, maintained file or table of who reports to whom, because security and team views depend on it.
Refresh and QC routine: Agree when data refreshes and how the business will check numbers before reviews.
If your sales data spans several branches, bring those sources together first with a multi-branch sales dashboard.
Build a Team Performance Dashboard with BI Solusi
Every team measures performance differently. We build custom Power BI dashboards around the KPIs and scoring rules you already use, with role-based pages for each manager and team member. Share how you measure performance today and we will show you what it could look like.
BI Solusi is your trusted partner for data-driven success in Indonesia, serving companies in the Southeast Asia region and beyond. We specialize in implementing cutting-edge Data Analytics, Business Intelligence platform, and Big Data solution, complemented by expert Data Science services.
We offer flexible nearshore and offshore BI implementation models to meet your specific needs and deliver the highest-quality results.
Our BI Consulting expertise encompasses Data Integration services (ETL), Data Warehousing, and the utilization of Data Visualization tools such as Microsoft Power BI, Qlik Sense, and Tableau for Reports and Dashboards implementation.
Let us help you unlock the full potential of your data and achieve your business goals.
Comments