🏭 Data Warehouse Project (ERP & CRM)

📝 Table of Contents

1. Project Overview
2. Project Architecture
3. Credits
4. Contact

🔬 Project Overview

This project demonstrates a Data Warehouse implementation designed following the Medallion Architecture (Bronze, Silver, and Gold layers).

It is executed entirely within Microsoft SQL Server using T-SQL scripts. The goal of this project is to demonstrate proficiency in SQL, and the basic idea of Data Warehousing concept.

Key Features:

• Medallion Architecture: Separation of raw, cleansed, and curated data.
• SQL-Based ETL: All transformations are handled via native SQL code.
• Data Modeling: Implementation of Star Schema Schema.

🏗️ Project Architecture

Below is the high-level architecture of the data flow:

📋 Credits

This project was inspired by the educational content provided by Data with Baraa.

• Source Tutorial: Build a Data Warehouse from Scratch (YouTube)

📨 Contact Me

If you have any questions about this project or would like to connect: