jeffstpeterson / hr-demographic-analysis

An examination of the demographics of a unnamed company. The analysis presupposes the organization is undergoing an HR transformation. As a part of this HR transformation the organization is reviewing employee demographics in various departments. The goal was to determine next action steps in this hypothetical HR transformation.

// HR Demographic Analysis

-- Project Status: [Active, On-Hold, Completed]

Completed

// Project Intro/Objective The purpose of this project was to take a fictious company and hypotheize that the company was in the midst of an HR transformation effort focused on their talent acquistion efforts. The final output included a ppt creatd from the Tableau dashboard and and outcome of the project and recommendations.

Methods Used

• Python Data Cleaning, Merging and Loading Data
• Data Visualization

Technologies

• Python, Pandas, Jupyter
• CSV files
• Tableau Desktop/Public
• PostgreSQL

// Project Description

Starting with a Kaggle dataset https://www.kaggle.com/rhuebner/human-resources-data-set, there was a need to increase some of the data and randomize columns to allow for more robust data analysis.

I utilized Pandas to clean and reorganize the data. The data was then loaded into PostgreSQL. Several queries were completed and downloaded to csv that were used as the Tableau source files to create Visualizations.

1. emp_hourlydemo
2. employee_salary_demo
3. emp_satisfaction
4. emp_sources
5. temp_emp

After downloading the csvs, Tableau spreedsheets were created. There comparisons completed between hourly/salary populaton and gender/race. Additional comparisons between Employee Engagement and Satisdaction based on race and each department.

//ROADBLOCKS

• Lack of access to real data to create the model. Even an absence of really complete datasets for hypothetical models

//Images

Contact Jeff "JP" Peterson [email protected]