Member-only story
The Medallion Architecture
Gold, Silver and Bronze Layer
The Medallion Architecture organizes the data journey from its original state to a version that is ready to support decision-making.
Bronze preserves files, events, and records exactly as they arrive from source systems. This layer retains the level of detail needed to trace errors and reconstruct processes.
Not a Medium paid member yet ? Read the article here for free
Silver cleans, standardizes, deduplicates, and validates the data. At this stage, formats are corrected, codes are aligned, and data quality checks are applied.
Gold incorporates business rules and prepares tables, metrics, and data products for dashboards, analytics, and models.
Consider a company that needs to decide which products to replenish this week.
Using sales and inventory records directly can lead to poor decisions when transactions are duplicated, the same product appears under different codes, or dates are incomplete.
The Silver layer resolves these inconsistencies. The Gold layer then combines demand, available inventory, replenishment lead time, and service-level targets to determine which products are at risk of a stockout and how much should be ordered.
