Analyzing HP employee data to extract and analyze department and employee metrics such as sex, salary, hiring rates, and departments to find any key insights to improve company support to employees.
- Inspect the CSVs and sketch out an ERD of the tables.
- Created six relational tables within pgAdmin housing HP employee data
- Performed data modeling and data analysis on the data using SQL queries in Python.
- Using SQLAlchemy and Pandas to connect to Postgres database and visualize employee information
It seems that in 1980s and 1990s the most frequency of Males is 4847 and for the most females is 3305 in the Development department. Also, in 1980s there is a greater total increase of hires for both Males and Females however, hiring rate percentages between 1980s and 1990s have stayed relatively the same with Males (60%) and Females (40%) in each department.
It seems that the highest paid position is Staff with a salary of $129492 and the lowest paid position is tied between Enginner, Staff, Senior Engineer, and Technique Leader with a salary of $40000.
The bar graph shows that senior staff and staff are paid roughly $10000 higher than other positions.
The bar graph shows that a majority of employees in the Customer Service, Development, Human Resources, Production, Quality Management, Research departments are paid below average salary. However, in Marketings and Sales there seems to be an even number of employees paid above and below average.
It seem that the salary range is a left skewed distribution with a greater number of employee receiving a salary of $40000 and very few employees receiving a salary of $120000.
Mockaroo, LLC. (2021). Realistic Data Generator. https://www.mockaroo.com/