// 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.
- emp_hourlydemo
- employee_salary_demo
- emp_satisfaction
- emp_sources
- 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]