SQL Data Warehouse Project

I designed and built a full data warehouse from scratch.

The project follows the Medallion Architecture approach to structure the data into clear and manageable layers:

- Bronze Layer:

Raw data ingestion directly from the source systems.

No heavy transformations — just preserving the original data for traceability and auditing.

- Silver Layer:

Data cleaning, standardization, and transformation.

Handled null values, removed duplicates, and applied business rules to ensure data quality.

- Gold Layer:

Business-ready data modeled using Fact and Dimension tables (Star Schema).

Optimized for reporting and analytics.

What I focused on during this project:

• Designing a structured data flow

• Applying proper data modeling techniques

• Improving data quality across layers

• Writing optimized SQL transformations

• Keeping the architecture scalable and maintainable