The Silver Tsunami

An Analysis of Retirees at Pewlett Packard

Analysis Overview

The purpose of this Analysis is to prepare for the upcoming exit of baby boomers from the workplace. To prepare, we have summarized all employee information into a database (using SQL) for easy viewing. Ultimately, we need to be able to support our remaining workforce. To understand the impact, we have parsed employee information and generated a comprehensive list that is easy to view and understand.

Results: Provide a bulleted list with four major points from the two analysis deliverables.

• Retirement Table and Data

Initially we are provided with large set of data. Pretty much all the employee data from the company. Employee numbers, department titles, birth dates, hire dates, and end hire dates are included. This means that information for employees who no longer work there are included in the table and needed to be parsed out. To obtain the most current list of employees meeting the retirement requirement, employee data was filtered using the birth_date, hire_date, and to_date variables.

• Unique Titles and Data

The final list for retires was obtained by adding the department name to the table. All that remained was to add the department names to the current_emp table . After using the SELECT and JOIN functions, we view our data and realize that there are names listed twice. By using the DISTINCT ON, GROUPBY, and COUNT() functions we can remove duplicate rows in the table.

• Retiring Titles and Data

The unique_titles table lists each individual employee that meets the retirement requirement. Information included are the emp_no, first_name, last_name, and title. The unique titles table provides a summary total of retirees per department. The table shows that there are 90,398 associates who met the retirement requirement.

• Mentorship Eligibility and Data

You have finally finished extracting and recreating the data, and you have a good idea of what to expect in the future. The company would like to adopt a mentorship program for associates born between the dates of 01/01/1965 and 12/31/1965. The SELECT DISTINCT ON function and two inner joins pull the information into the table. There are 1549 employees who are currently eligible for retirement.

Summary

The hardest hit departments will be the Senior Engineering, Senior Staffing, and Engineering departments. These three departments account for almost 80 percent of the workforce retiring. With only a little over 1500 associates eligible for the mentorship program, Pewlett Hackard is already behind the ball. Over 90,398 associates are currently eligible for retirement. A breakdown of associates by location would help to identify the locations needed the most. Additionally, expanding the age requirement for mentorship might help to bridge the gap in the mentorship program.