Employee Satisfaction Dashboard: What to Track in Power BI
What to track in an employee satisfaction dashboard in Power BI: overall score, four pillars, survey trend and department gaps, with sample-data screenshots.
A single satisfaction score is easy to put on a slide and hard to act on. In the sample Employee Satisfaction Pulse dashboard, the company-wide score is 3.82 out of 5. Pick HR and the same card reads 4.35. Pick Customer Service and it reads 3.52. Same survey, same quarters, a gap of 0.83 points that the headline number hides completely.
That is the real job of an employee satisfaction dashboard: not to report one number, but to show where the number comes from. This guide covers what to track in an employee satisfaction survey dashboard in Power BI and how to read each part, using the Employee Satisfaction Dashboard template as the worked example. Every figure below comes from that template's published demo, which runs on sample data (1,999 sample survey responses across 2024 to 2026), not from real employees. Treat the numbers as illustrations of how to read a dashboard, not as benchmarks for your own company.
The employee satisfaction dashboard at a glance
The whole report is one page, so it helps to know what each block is for before reading the numbers.
| Block | The question it answers | Where it sits |
|---|---|---|
| Overall score (of 5) | How do employees rate the workplace overall, and is that up or down on last year? | KPI card, top left |
| Satisfaction, Engagement, Work-Life Balance, Would Recommend | Which pillar is the weakest? | Four donut charts next to the card |
| Scores by survey wave | Are Satisfaction, Engagement and Management scores moving the right way? | Line chart, top right |
| Department satisfaction against the 80% target | Which departments are above or below the bar? | Gauge strip, middle |
| By job level | Does sentiment change with seniority? | Bar chart, bottom left |
| By work model | Do on-site, hybrid and remote employees feel differently? | Bar chart, bottom middle |
| Department scorecard | How many responses stand behind each score? | Table, bottom right |
| Department, Work Model and Year slicers | Can I look at one group at a time? | Top of the page |
1. Start with one score, then four pillars
The top-left card is the headline: an overall score out of 5 (3.82), the change against last year (+0.9%) and the number of responses behind it. The card rounds that count to 2K; the report header gives the exact figure, 1,999. Next to it, four donuts split the score into the pillars HR teams most often ask about: Satisfaction 76.5%, Engagement 73.1%, Work-Life Balance 72.3% and Would Recommend 69.4%.
Read the four together. Satisfaction is how people rate their job and workplace, Engagement is how connected and motivated they feel, Work-Life Balance asks whether the workload is sustainable, and Would Recommend is the most demanding question because it asks whether people would put their name behind the company. In this sample the pillars step down in exactly that order, and the gap of about 7 points between Satisfaction (76.5%) and Would Recommend (69.4%) is the first thing a manager should ask about: people are fairly content but less willing to recommend the company.
A note on units. The score is out of 5 and the donuts are percentages, so they describe the same survey on two scales. In every department we opened, the Satisfaction donut sits within a tenth of a point of the score multiplied by 20 (4.35 out of 5 is 87.1%). Put the scale on the card, as this template does with "Overall score (of 5)", so nobody has to guess.
2. Track the trend by survey wave
A snapshot says where you are. A trend says whether the last thing you did worked. The line chart plots Satisfaction, Engagement and Management scores across ten quarterly survey waves, from 2024-03 to 2026-06. With no filter applied, the Satisfaction line starts at 75.6%, dips to 72.7% in the 2024-09 wave and then climbs to 80.3% in the latest wave.
Three habits keep a trend chart honest. Compare the same quarter across years before you call a dip seasonal. Look at all three lines instead of one. And notice when one line moves while the others do not. In this sample the Engagement line sits below Satisfaction in most waves, which is worth watching: people can be satisfied with their conditions without feeling engaged with the work.
One more trap is the difference between the donut and the line. With no filter, the Satisfaction donut reads 76.5% while the newest point on the line reads 80.3%. One summarizes every response in scope (all three years unless you pick one in the Year slicer), the other is the latest wave. Both are correct, and the dashboard should make clear which is which so nobody quotes the wrong one in a meeting.
3. Compare departments against a target
The gauge strip answers a simple question: who is above the bar? The template sets an 80% target for department satisfaction and shows IT at 80.4%, Sales at 70.5%, Operations at 75.6%, HR at 87.1% and Finance at 80.9%. Three of the five clear the target. Sales and Operations do not, and Sales is almost ten points short.
Three things to know before relying on it.
The 80% line is a design choice, not a standard. Set your target from your own previous wave or from a level leadership has agreed. In the template, the target value can be changed in the formatting pane or in the underlying DAX measure.
The strip shows five departments, the slicer lists seven. Customer Service and Marketing are only visible through the slicer and the scorecard, so add them to the strip if they matter to your audience.
Picking a department does not change the gauges. They stay a side-by-side comparison, which is what you want from a benchmark strip, while everything else on the page follows the slicer.
4. Slice by department: where the average hides the problem
Click a department and the page redraws for that group, except the gauge strip. Customer Service shows 3.52 out of 5 on 399 responses, with Satisfaction 70.3%, Engagement 66.2%, Work-Life Balance 65.5% and Would Recommend 63.2%. HR shows 4.35 on 136 responses, with 87.1%, 78.8%, 82.5% and 78.7%.
Two things stand out. First, the whole Customer Service profile is lower, not one pillar: all four donuts sit between 63% and 70%, so this is not a single-question problem that one policy fixes. Second, Customer Service is also the biggest group. Its 399 responses are about one fifth of the 1,999 total, which is why it pulls the company score down to 3.82. IT (4.02 out of 5, 339 responses) and Finance (4.05, 196 responses) both sit above the company figure, and none of the four departments we opened sits at 3.82.
Weight matters. A large, unhappy group moves the average more than a small, happy one: HR is the most positive of the departments we opened, but its 136 responses are only about 7% of the total. The practical rule is simple: when the headline number moves, open the department slicer before you open the meeting.
5. Job level and work model
The bottom-left chart splits sentiment by job level (Manager, Staff, Senior, Director) and the bottom-middle chart by work model (On-site, Hybrid, Remote). Company-wide, Manager is highest at 78.1% and Director lowest at 72.0%, a spread of about 6 points. Work model barely matters: On-site 76.6%, Hybrid 76.5% and Remote 76.1% sit within half a point of each other, so in this sample remote work is not what separates happier teams from unhappier ones.
Do not carry the company-wide ranking into a department. Filter to Customer Service and the order flips: Director is highest (75.0%) and Staff is lowest (69.3%). Filter to IT and Director is again the lowest at 73.3%, with Senior on top at 81.3%. A pattern that holds for the company can be reversed inside one team, which is exactly why these splits sit next to the department slicer.
One design note: the bars are drawn against a 0 to 100 scale, so they all look nearly the same height and the labels carry the information. Keep the data labels switched on.
6. Use the scorecard to see how many people stand behind each score
The Department Scorecard lists, per department, the number of responses, the average satisfaction on the 5-point scale, the Would Recommend percentage and the Work-Life Balance percentage, plus a Total row (1,999 responses, 3.82, 69.4% and 72.3%). It is sorted by average satisfaction and scrolls to show every department. Use it as the reference table behind the other visuals: if a gauge says a department is at 70.5% and the table says only a handful of people answered, treat it as a conversation starter rather than a verdict.
What to put on your own employee satisfaction dashboard
The template is one way to arrange it. Whatever you build, these are the parts worth keeping:
One overall score with its scale and response count on the card.
Three to five pillars, each with a plain definition in the report: which survey question feeds it.
A trend by survey wave, never only the latest snapshot.
A target chosen on purpose, with a note on where it came from.
Splits by department, job level and work model, each next to its response count.
A minimum group size. Decide it before you publish (many HR teams use 5 to 10 responses) and make the measure return blank below it, so a small team cannot be identified from its scores.
Scores only. Keep open-ended comments out of the dashboard and review them separately, with the same care for anonymity.
How to load your own survey data
The template includes a structured data model ready for survey response import and works with standard CSV or Excel exports from HR survey tools. The path is the usual one: export your results, open Transform Data in Power BI, map your columns to the model's fields, then rename the departments and job levels to match your organization. The 80% target is adjustable as described above. Our guide to connecting your own data to a Power BI template explains the column-matching rule that keeps visuals from breaking when you swap the source. In practice it comes down to four steps:
Export the survey results as CSV or Excel (survey tools usually give you one row per response).
In Power BI Desktop, open Transform Data and point the queries at your file.
Map your columns to the model's fields: department, job level, work model, survey wave and the scores for each question.
Rename the departments and job levels, then reset the target if 80% is not your bar.
Power BI Desktop is required to edit the file, and the dashboard and its labels are in English. The layout is built for desktop viewing and can be adapted for phones in Power BI's mobile layout editor.
Mistakes that make satisfaction dashboards useless
Reporting one average. It describes nobody, as the 3.82 against 3.52 and 4.35 shows.
Hiding the response count. Without it, nobody can tell a signal from noise.
Treating the target as the goal. A department at 79% that is rising is healthier than one at 81% that is falling.
Comparing groups of very different size without saying so. A group of 136 and a group of 399 do not move the average equally.
Changing the question wording between waves. You break the trend line and cannot tell why a score moved.
Ranking individual managers on small teams. Scores from a handful of people are too noisy and too easy to trace back.
Where this fits in your HR reporting
Satisfaction is one view of the workforce, not the whole picture. Our guide to the 6 HR dashboards every team needs in Power BI shows where it sits next to headcount, attrition, hiring and attendance. If you would rather start from a finished layout than build each visual yourself, the Employee Satisfaction Pulse template gives you the KPI card, the four pillar donuts, the survey-wave trend, the department gauges, the job level and work model bars and the department scorecard on one page, with Department, Work Model and Year slicers. You can open the template page to try the live demo, or browse all Power BI templates.
All screenshots in this article were captured from the template's own published demo. The data in it is sample data, so no score describes real employees.
What should an employee satisfaction dashboard include?
At minimum: an overall score with its scale and response count, a few clearly defined pillars (for example Satisfaction, Engagement, Work-Life Balance and Would Recommend), a trend across survey waves, department results against a target, splits by job level and work model, and a table showing how many people answered in each group. Slicers for department, work model and year let each manager see their own team.
How do I build an employee satisfaction dashboard in Power BI?
Export your survey results to CSV or Excel, load them into Power BI Desktop, model them with one row per response and columns for department, job level, work model, survey wave and each question score, then add a KPI card, donut charts for the pillars, a line chart by survey wave, gauges against a target and a department table. Starting from a ready template and mapping your columns to its model through Transform Data is faster than building every visual from zero.
What is a good employee satisfaction score?
There is no universal benchmark, because it depends on the survey questions, the scale and the organization. The useful comparison is your own previous wave and your own target. In the template's sample data the company score is 3.82 out of 5 (about 76%) against an 80% department target, with HR at 4.35 and Customer Service at 3.52.
How often should we run an employee satisfaction survey?
Many HR teams run a short pulse survey every quarter and a longer one once a year. The template's sample data follows a quarterly program with ten waves from 2024-03 to 2026-06. What matters more than the frequency is keeping the questions the same between waves so the trend line means something.
How do I show employee satisfaction by department in Power BI?
Put department in a slicer so every card, chart and table reacts to it, add a gauge or bar for each department against a target, and finish with a scorecard table listing responses, average score and recommendation percentage per department. Always show the number of responses next to each score, because a small department can swing widely from one wave to the next.
Does the template use real employee data, and can I load my own survey?
The demo uses sample data, so none of the scores describe real employees. The template includes a structured data model for survey response import and works with standard CSV or Excel exports: open Transform Data in Power BI Desktop, map your columns to the model's fields and rename departments and job levels to match your organization. The dashboard and its labels are in English.