Embedded Files
Tags: Data Preparation, Data Visualization, Data Analysis
Excel
● GOAL
● GOAL
Analyze Job Satisfaction survey response data to identify opportunities for increasing employee satisfaction and engagement.
● OVERVIEW
● OVERVIEW
A survey of approximately 1500 employees from the U.S. Department of Public Works was conducted to assess job satisfaction levels. The HR leadership team seeks insights and recommendations to enhance employee engagement through a visual summary of the survey data.
● APPROACH
● APPROACH
➜ Data exploration and profiling: examine the data to identify and correct any quality issues.
➜ Data preparation: reformat and clean the data to ensure it is suitable for visualization.
➜ Data visualization: create a visual summary to uncover key insights and provide recommendations.
● KEY INSIGHTS AND RECOMMENDATIONS
● KEY INSIGHTS AND RECOMMENDATIONS
Work Expectations and Accountability:
High agreement in knowing job expectations across all groups.
Lower ratings on accountability among Staff and unspecified levels.
Learning and Growth Opportunities:
Balanced responses, but some dissatisfaction was noted from the Staff group.
Opportunity to improve training and career development, particularly for Staff.
Job Satisfaction and Fulfillment:
Moderate to high agreement on job satisfaction and the opportunity to use skills.
Strong alignment with the organization’s mission, except for some disconnection at the Staff level.
Recognition and Support:
Low agreement on receiving recent recognition, especially among Staff.
High agreement on departmental inclusiveness and diversity support across all groups.
Workplace Relationships and Culture:
Lower agreement on having a best friend at work, indicating a potential lack of camaraderie.
Moderate ratings on supervisors showing care, with Directors reporting the lowest scores.
Summary Insights
Summary Insights
Directors exhibit the highest levels of agreement across all aspects, except for workplace relationships, which score low across all groups. Overall, the organization appears to have strengths in clarifying job expectations and providing opportunities for employees to utilize their skills. However, there are notable areas for improvement, such as enhancing employee recognition, fostering social connections, and strengthening alignment with the mission for Staff members.
● PROJECT SNAPSHOTS
● PROJECT SNAPSHOTS
Page updated
Google Sites
Report abuse