This project is intended to build a SQL Database using PgAdmin to assemble a group of CSV files containing employee data of "Pewlet Hackard".
The main purpose of this project is to create a data analysis to better understand the situation of employees soon to be retired, which company-wide is bein called "The Silver Wave". With such analysis we will be able to determine how many employees are soon to be retired, what positions will need to be replaced and whom of the retiring employees can still stay on board on a mentorship program for the future generation.
Pewlet Hackard is a large company with many departments and employees, inevitably there will be employees retiring from vearious positions. Therefor during Our Analysis we discovered there will be retirees from 7 different titles for that including: *Engineer *Senior Staff *Staff *Senior Engineer *Technique Leader *Assistant Engineer *Manager
During the analysis we discovered that amongst the retirees there will be many employees eligible for mentorship programs, which would allow for a smoother transition for those leaving and those joining the team. The mentors would pass on the knowledge of many years of service and help the company. Through the analysis we discovered that there are 1,549 employees that meet the criteria to become mentors for the newer Generation of Pewlet Hackard professionals.
When creating the analysis of the EMployee Data we decided to create a set of Tables to store the Data in PostgreSQL and create relationships using Keys and Foreing Keys between the tables in the Database.
