.jpg){kind=link}
A sample data-warehouse project implementing the Medallion Architecture (Bronze → Silver → Gold layers)
This project demonstrates the ingestion, transformation, and curation of data using a tiered “Medallion Architecture” approach. The goal is to move raw data through successive refinement stages (Bronze → Silver → Gold) to produce analytics-ready datasets and support insights, reporting, or downstream consumption.
The Medallion Architecture is a layered design pattern used to incrementally improve data quality and readiness as data flows through each layer.
| Layer | Description |
|---|---|
| Bronze | Raw ingestion zone — minimal transformation, store as-is |
| Silver | Cleaned, & enriched layer |
| Gold | Curated, analytics-ready / business-ready layer |
In this project:
- Data is first loaded into the Bronze stage (DDL scripts + raw data).
- Then data is cleansed and structured in the Silver stage.
- Finally, business-friendly tables/aggregations are produced in the Gold stage.
This layered approach helps with traceability, auditability, reuse, and separation of concerns.
.jpg)
