Employee Engagement Survey Dashboard
Project Description
Employee Engagement Survey Dashboard for Pierce County, Washington, dataset using Power BI to convert more than 14,000 survey responses sourced from Maven Analytics Data Playground—into a structured, interactive, and decision-oriented reporting tool.
Data Preparation
A single Excel table with ~15,000 rows required thorough cleaning to address:
-
Removal of duplicate rows
-
Handling of missing assessments
-
Elimination of duplicated questions
-
Adding “Other Role” category for missing role data (~72% of records)
-
Creating relevant DAX measure for calculation
Key Features of the Dashboard
-
Department- and role-level analysis enabled through dynamic slicers.
-
Bookmarks and action buttons for intuitive and seamless navigation between analytical views.
-
Clear, comparative visuals showing response distributions from Strongly Disagree to Strongly Agree.
Key Findings from the Analysis
-
Most Agreed Statement: “I know what is expected of me at work” (Average Score: 3.5/4)
-
Least Agreed Statement: “I have a best friend at work” (Average Score: 2.6/4)
-
Managers and Supervisors reported higher levels of agreement regarding recognition and growth opportunities.
-
Staff feedback highlighted opportunities to strengthen workplace relationships and enhance learning and development initiatives.
This page compares survey responses across different employee roles for a selected statement. It shows the percentage of each response category, highlights satisfaction differences by role, and allows filtering by role and department for deeper analysis.
Recommended Strategic Actions
-
Strengthen Workplace Relationships
Foster connections through team-building, cross-functional projects, and peer recognition. -
Expand Learning & Development
Offer role-based training, continuous learning, and career-linked programs. -
Enhance Leadership Capability
Provide training on clarity, inclusivity, and coaching for consistent management. -
Address Department Gaps
Deliver targeted interventions based on diagnostics and progress tracking.
Why This Approach Matters
Survey results have limited impact unless they are transformed into actionable insights. Presenting data in an interactive, visually intuitive, and role-specific manner empowers leadership teams to quickly identify trends, address gaps, and take evidence-based actions that drive measurable improvements in employee engagement.
This page provides an overview of employee survey results by displaying key metrics, overall satisfaction, the most agreed and disagreed statements, and response distributions. Interactive filters by role and department enable users to explore insights and identify trends across the organization.
This page provides a tabular summary of survey responses for each statement, showing the total response count, overall response rate, and the count and percentage of Strongly Disagree, Disagree, Agree, and Strongly Agree responses. Filters by role and department enable detailed analysis across different employee groups.