ETL Pipeline case study that simulates a data warehouse implementation. Dataset is gathered from Kaggle Coffee Shop Sample Data (https://www.kaggle.com/ylchang/coffee-shop-sample-data-1113?select=customer.csv)
Related data warehouse tables schema is designed based on star schema procedure. Design is implemented on MySQL Database. Database schema and implementation can be seen from the database_imp file in master branch.
Following design summarizes the database schema
Please check "Dashboard" directory to see the dashboard implementation in PDF format
Please click link below to reach the PowerBI based dashboard implementation: