The purpose of this analysis is to conduct a Database analysis for Pewlett Hackard with detailed information on the number of future retirees from all departments currently working as the “silver tsunami”, to prepare a plan to hire new staff and also to prepare a mentorship initiative.
1. First to see the relatiop between the data tables by creating ERD (Entity Relationship Diagram) to facilitate the analysis. Here in the ERD
2. Total number of retiring senior employee is 72,458 as shown here by title:
3. Total number of eligible mentorship candidates is 1549 as shown below:
At the moment at Pewlett Hackard, 72,458 employees are getting ready for retirement, which will mean that they are likely going to need an extensive hiring process in the upcoming years. Since a significant amount of future retirees hold Senior positions the mentorship program should provide a capacitation buffer for the extensive expertise that will be leaving the company in the years to come. Resources;
Data Sources: departments.csv, dept_emp.csv, dept_manager.csv, employees.csv, salaries.csv, titles.csv