Create entity relationship diagrams, perform data modeling & complete analysis on an employee SQL techniques
- PostgreSQL 11, Pgadmin 4.20
- ERD(entity relationship diagrams)
To perform analysis on a large-scale of employee data for a company with over 300,000 employees. The company Pewlett Hackard is reviewing staffing metrics, namely retirement and needs assistance wrangling the data that will help translate who may be and is eligible for retirement. would be able to;
- Design an ERD that will apply to the data.
- Create and use a SQL database.
- Import and export large CSV datasets into pgAdmin.
- Practice using different joins to create new tables in pgAdmin.
- Write basic- to intermediate-level SQL statements
- Of the 300,024 employees within the company, 90,398 (30.13%) are eligible for retirement.
- Senior Engineer, Senior Staff and Engineer's hold the largest share (23.9%) of employees likely preparing for retirement.
-
The departments with the highest number of potential retirees are Development(25.45%),Production(22.30%) and Sales(7.27%).
-
Only 1549 total employees qualify for mentorship/training for an internal promotion
According to my finding analysis Pewlett Hackard is potentially facing over 90,000 vacant positions company wide. Taking into consideration the low amount of employees who are eligible for mentorship, Pewlett hackard will face a great deficit once a majority of eligible employees retire.