Employee-Database: Part 1

The intial purpose of this assignment was to conduct Data Engineering and Modeling for an employee database. This was done using a Quick DBD tool that created the schema an was exported to PostgreSQL for analysis. Below is the schema...


QuickDBD Schema

QuickDBD Schema

Employee-Database: Part 2

The second part of the assignment was to conduct an analysis of the Employee Database using not only PostgreSQL, but also Jupyter Notebooks. From there, the data was loaded into a Pandas DF and Average Salary by Title was plotted with Matplotlib.


Average Salary By Title

Average Salary By Title