Login
Register

HR Survey Analysis Project

Categories: Guided Project
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

HR Survey Analysis Project 

About the Dataset

You will be working with an Excel dataset containing 14,725 records and 10 survey fields collected from approximately 1,500 public works employees in Washington State. The data is structured in a single table and includes numerical and categorical responses across multiple departments and survey questions.

 

What Will You Learn?

  • Perform data profiling and quality assessment on real-world survey data.
  • Clean and prepare large datasets for visualization and analysis.
  • Calculate and interpret response distributions and Likert scale averages.
  • Build insightful 100% stacked bar charts and Likert scale visualizations.
  • Generate actionable HR insights and recommendations based on employee feedback.
  • Use Excel functions to transform raw survey data into compelling visuals.

Course Content

Project Brief
HR Survey Analysis – Project Brief The Situation You’ve just been hired as a Human Resources (HR) Associate for the Seattle Department of Public Works. The Assignment The city recently surveyed approximately 1,500 public works employees to measure job satisfaction and identify opportunities to keep staff motivated and engaged. You’ve been asked to analyze the survey response data and prepare a visual summary for the HR leadership team using Microsoft Excel. The Objectives Explore and profile the data using Excel to correct any quality issues. Prepare and reformat the data in Excel for effective visualization. Visualize the data using Excel charts and dashboards, and identify key insights and recommendations for the HR leadership team. Excel | Intermediate | Human Resources | Government | Survey DOWNLOAD PROJECT DATA BELOW Employee+Survey+Responses

  • The Project Brief
    00:00
  • What will I learn from this project?

Objective 1 – Profile & QA the data
Your first objective is to explore and QA the data by calculating basic profiling metrics, removing blank and duplicate records, and standardizing inconsistent text fields.

Objective 2 Prepare the data for visualization
Your second objective is to produce clean source data for visualization by calculating response frequencies and proportions for each of the 10 survey questions.

Objective 3 – Visualize the data and summarize findings
Your final objective is to visualize the data using stacked bar charts and Likert scales, and derive insights and recommendations to share with the HR leadership team based on your findings.

Student Ratings & Reviews

No Review Yet
No Review Yet

Contacts

  • 23 Whitestone Way, Weatherill House Business Centre, New South Quarter, Croydon CRO 4WF
  • +442082482537

Quick Links

Benefit from our trainings and recordings by subscribing here

Follow us

Instagram X-twitter Facebook Linkedin

Copyright © 2025 Clap Academy. All Rights Reserved.