Employee SQL Challenge
Conducted data engineering and data analysis on employee data scattered across six CSV files:
- Graphically illustrated the relationship between tables with an ERD and created table schemas--specifying data types, primary keys, etc.--into which each corresponding CSV file was imported
- Wrote SQL queries to retrieve the requested information
- Imported the SQL database into Pandas to create a histogram to visualize the most common salary ranges for employees and a bar chart of average salary by title