SQL/PGAdmin Employee Information Database

Project Overview

Task was to create a research project on employees of the corporation from the 1980s and 1990s. All that remains of the database of employees from that period are six CSV files.I designed tables to hold data from the original CSVs, imported the CSVs into a SQL database and analyzed the data for trends. In other words, I performed data modeling, data engineering, and data analysis.

I then imported the SQL database into Pandas, created a histogram to visualize the most common salary ranges for employees, & created a bar chart of average salary by title.