This project is part of the Data Analytics and Visualization Bootcamp at University of Oregon.
Project Intro/Objective -
This repository holds a research project on employees of a corporation from the 1980s and 1990s. Six CSV files were imported into a SQL database to answer questions about the data.
Methods Used -
- SQL
- SQLAlchemy
- Jupyter Notebook
- Pandas
Project Description -
This projects involved data modeling, data engineering, and data analysis. Data modeling was used when the CSVs were inspected and an ERD of the tables was created. Data Engineering was used when the six CSV files were imported into a SQL database. Data Analysis was sued to answer the main questions that were asked of this projects, focusing mainly on gathering information on certain employees by specific criteria.
Needs of this project -
- Data modeling
- Data engineering
- Data Analysis