Skip to content

Created a model database of retiring employees for Pewlett Hackard using SQL. Designed an ERD, imported and exported large CSV datasets into pgAdmin and used joins to create new tables in pgAdmin.

Notifications You must be signed in to change notification settings

MiracleOny/Pewlett-Hackard-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 

Repository files navigation

Overview

The purpose of this analysis is to determine the number of retiring Pewlett-Hackard employees per title and identify retiring-employees who are eligible to participate in a mentorship program. The mentorship program is designed to pair experienced and successful employees with new hires. This allows retirement-eligible employees to step back into a part-time role instead of retiring completely.

Analysis

Retirement-eligible employees are employees born between 01/1952 and 12/1995.

  • Pewlett-Hackared has 240,124 employees of which 30% (72,458) are retirement-eligible.
  • 50% (36,291) of retirement-eligible employees work as Engineers.
  • About 70% of retirement-eligible employees hold a senior-level position.
  • 50% of senior-level employees hold either a Senior Engineer (35.8%) or a Senior Staff (34.4%) position.

Alt Retiring Employees by Title

Summary

As the "silver tsunami" begins to make an impact, two roles will need to be filled: Senior Engineer and Senior Staff. These two positions hold the most employees who are nearing retirment.

Table 1 Alt Retiring Employees by Title

Table 2 Alt Employees in Mentorship Program by Title

In the current mentorship program, there are 1,549 qualified, retirement-ready employees. 36.7% hold a Senior Staff position while only 10.9% of mentors hold a Senior Engineer position. There is not enough qualified Senior Engineers to adequately mentor the next generation. However, across departments, there are enough employees.

Below are graphs of retiring employees and mentors by title and department.

Graph A Alt Retiring Employees by Title: Bar Graph

Graph B Alt Mentors by Title: Bar Graph

Graph A.2 Alt Retiring Employees by Department: Bar Graph

Graph B.2 Alt Mentors by Department: Bar Graph

About

Created a model database of retiring employees for Pewlett Hackard using SQL. Designed an ERD, imported and exported large CSV datasets into pgAdmin and used joins to create new tables in pgAdmin.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published