Pewlett-Hackard-Analysis

Purpose

1. Determined the number of retiring employees per title, and identify employees who are eligible to participate in a mentorship program.

2. Created a report of current employees about to reach retirement age.

Technologies Used:

• PostgreSQL
• CSV

Results

• Retirement Titles table that includes employees who are born between January 1, 1952 and December 31, 1955.

  • retirement_titles.csv

• Unique Titles table that contains employee number, first and last name, and most recent title.

  • unique_titles.csv

• Retiring Titles table that contains the number of titles filled by employees who are retiring.

  • retiring_titles.csv

• Mentorship Eligibility table for current employees who were born between January 1, 1965 and December 31, 1965.

  • mentorship_eligibilty.csv

Summary