Building a modern data warehouse with SQL server, including ETL processes, data modelling, and analytics
This project involves:
Data Architecture: Designing a Modern Data Warehouse Using Medallion Architecture Bronze, Silver, and Gold layers. ETL Pipelines: Extracting, transforming, and loading data from source systems into the warehouse. Data Modeling: Developing fact and dimension tables optimized for analytical queries. Analytics & Reporting: Creating SQL-based reports and dashboards for actionable insights.
This project is based on the original work by Baraa Khatib Salkini and follows the structure and logic from their project repository: sql-data-warehouse-project.
The original project is licensed under the MIT License.
All rights and credits go to the original author. This version is intended for learning and educational purposes.