Pewlett-Hackard-Analysis

Overview

Pewlett-Hackard is a large company preparing for their “Silver Tsunami”, a cycle-out of retirement eligible employees. Pewlett-Hackard more familiar with Excel’s VBA will be aquainted with PostGreSQL, a more suitable and up-to-date relational database that uses SQL to query, construct, and catalogue data. Working with 6 .csv files of employee data, data-modeling, -engineering, and -analysis will be applied to Excel's dataframes and tabular data to diagram and illustrate the workforce/staffing requirements for the Company's mentorship initiaitive for position transitions.

Data environment:

• PgAdmin 6.10
• PostgresSQL 7.1.1
• QuickDatabaseDiagrams

Result

• The retirement_titles table inaccurately identifies the retiring population. This dataset contains multiple duplicate employee numbers representing more potential vacancies than actual.

• The unique_titles table identifies anticipated vacancy titles more precisely however, its a low level analysis of whats essentially being questioned. How many vacancies can be expected by title, by department? It leaves more work to be done.

• The retiring_titles table is a high level dissolution that is essentially the purpose of the data analysis for the 'Silver Tsunami'

• The mentorship_eligibility table is effective but can be more advantageous if were organized by department, and additionally filtered to identify the total employees by department

Summary

As the Silver Tsunami takes impact Pewlett Hackard will need to anticipate the vacancies of:

• 25,916 Senior Engineers,
• 24,926 Senior Staff,
• 9,285 Engineers,
• 7,636 Staff,
• 3,603 Technique Leaders,
• 1,090 Assistant Engineers, and
• 2 Managers, for a total 72,458 positions.

With further analysis, 2 additional queries were performed to verify if enough retirement-ready employee were available to mentor the next generation of Pewlett Hackard employees. Unfortunately though, there are not enough eligible mentors for the Company’s initiative to be successful. In the mentorship eligibilty initiative there are only 1,549 eligible mentors. There are:

• No Managers,
• Only 291 Senior Engineer,
• 434 Senior Staff,
• 397 Engineers,
• 290 Staff,
• 77 Technique Leaders,
• 60 Assistant Engineers.