This project involved designing a data warehouse schema, developing an ETL pipeline, and performing data analysis to extract insights from an e-commerce dataset.
- DW Schema
- ETL Pipeline
- Analysis: Business insights on peak season, user behavior, payment preferences, delivery delays, and logistics performance.
- Database: MYSQL
- ETL
- Analytics: SQL