The purpose of this analysis was to use PostgreSQL to determine which employees would soon be retiring, as well as which employees are eligible for the mentorship program. SQL queries were used to create the necessary databases- these can be seen in the Queries folder.
Here is the schema that we used to determine the relationships between employee data at Pewlett Hackard.
- First, we wrote query that first determined who the employees were who were at or near retirement age.
- Employees held multiple titles so a query was written to use their most recent titles only, and place them into tables:
- Employee titles were counted so we could see how many employees who held unique titles were eligible.
- A new table was created with all employees who were eligible for mentorship by being born from January 1st, 1965 to December 31st, 1965.
As the silver tsunami begins to make an impact, approximately 72,459 roles will need to be filled. This can be seen by summing up the chart below, using this query:
Yes, there are more than enough qualified, retirement-ready employees in the departments to mentor the next generation of Pewlett Hackard employees. There is a need for more people to potentially receive mentoring helping to help fill all the roles. In fact, there are so many employees about to retire compared with the number of people that would need to receive mentoring, that more employees may need to be trained.
We could use the following query to allow for a broader mentorship eligibility search over the course of 5 years to find a larger pool of potential mentors to choose from, if necessary.
If there were too many potential candidates who were going to retire, we could use this query to select only individuals born in 1952 to better narrow down our choices.
