This project aims to analyze employee data using PostgresSQL database modeling and queries. Advanced data engineering skills are employed in this project to construct database schemas and entity relationship diagrams.
- PostgreSQL 11 for designing tables, importing data, and querying the database
- QuickDBD for creating Entity Relationship Diagram (ERD)
The project successfully models, imports, and analyzes employee data from the given CSV files. Various insights, such as employee numbers, names, salaries, hire dates, managers, and department details, can be extracted by constructing SQL queries to the database.
- Creating visualizations to better communicate the results to stakeholders
- Implementing advanced analytics, such as forecasting or clustering, to gain deeper insights