SQL-Data-Warehouse-Project
Building a modern data warehouse with Microsoft SQL Server, including ETL processes with Bronze Layer, Silver Layer and the Gold Layer, data modeling and as well as analytics.
- 11
- TSQL
- MIT
- 12 mo ago
Building a modern data warehouse with Microsoft SQL Server, including ETL processes with Bronze Layer, Silver Layer and the Gold Layer, data modeling and as well as analytics.
SQL-based EDA project exploring a retail data warehouse. Includes database setup and analysis scripts for data exploration, dimension profiling, date range discovery, measures analysis, magnitude breakdowns and ranking using aggregates and window functions.