May 2026

SQL Server Data Warehouse Project

A scalable end-to-end Data Warehouse solution utilizing Medallion Architecture and Stored Procedure ETL logic.

Project Overview

This project demonstrates the implementation of a modern Data Warehouse in Microsoft SQL Server. Following the Medallion Architecture, raw data from CRM and ERP systems is transformed through Bronze, Silver, and Gold layers to create a high-performance Star Schema for business intelligence.

Medallion Architecture Layers

Bronze 🥉

Raw Ingestion: Ingests CSV files from source systems without modification to maintain data lineage.

Silver 🥈

Standardization: Cleanses data, handles nulls, and applies business validation rules.

Gold 🥇

Analytics: Models data into Fact and Dimension tables optimized for reporting and ML.

Project Structure

SQL-Server-Data-Warehouse-Project/
    ├── 01_bronze/      # Raw ingestion layer
    ├── 02_silver/      # Cleaned & transformed layer
    ├── 03_gold/        # Business-ready views
    ├── docs/           # Architecture diagram
    └── README.md

Tech Stack & Concepts

Database: MS SQL Server
Language: T-SQL
Modeling: Star Schema

ETL: Stored Procedures
Optimization: Aggregated Views
Planning: Notion

Business Value

Feature	Value Proposition
Reliability	Layered transformations ensure validated, high-quality data.
Scalability	Reusable warehouse design that accommodates growing data volumes.
Performance	Optimized for BI tools via Gold-layer views.

Source Code