Project information

  • Tools: SQL, PostgreSQL, SQLAlchemy, Python, Pandas, Jupyter Notebook
  • Project URL: Github

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