In this scenario, I'm an analyst at Pewlett Hackard. My latest assignment is to analyze employee data from 1980's and 1990's. This data needs some cleaning up and organizing so let's get started!
- Data Modeling
-
Data Engineering
This is the schema I used to create tables for the data.
-
Data Analysis
I used these queries to analyze the tables I created.
Bonus Analysis:
QuickDBD: https://app.quickdatabasediagrams.com/
pgAdmin4
jupyter notebook