{"id":5137,"date":"2026-02-25T08:41:36","date_gmt":"2026-02-25T07:41:36","guid":{"rendered":"https:\/\/www.beeminds.nl\/insights\/what-is-bronze-silver-and-gold"},"modified":"2026-02-25T08:41:36","modified_gmt":"2026-02-25T07:41:36","slug":"what-is-bronze-silver-and-gold","status":"publish","type":"knowledge_pt","link":"https:\/\/www.beeminds.nl\/en\/insights\/what-is-bronze-silver-and-gold","title":{"rendered":"What is Bronze, Silver and Gold?"},"content":{"rendered":"<h2>Bronze: the raw data<\/h2>\n<p>The <strong>Bronze layer <\/strong>contains data as it comes directly from the source. Think files, APIs or sensors. The data has not yet been cleaned or processed.  <\/p>\n<ul>\n<li>Example: a CSV file containing sales orders, including typos, duplicate records or empty fields.<\/li>\n<li>Goal: <strong>keep everything as it is<\/strong>, so you can always go back to the original source.<\/li>\n<\/ul>\n<h2>Silver: the cleaned &#038; properly modeled data<\/h2>\n<p>The <strong>Silver layer <\/strong>is cleaned up and standardized data. Here you remove errors, make sure all columns have the same meaning and establish relationships between tables. Also, these tables are well defined and reflect recognizable terms for the business and are therefore disconnected from source systems.  <\/p>\n<ul>\n<li>Example: a table of sales orders with customer numbers validated, dates formatted correctly and duplicate records removed.<\/li>\n<li>Goal: <strong>reliable, consistent data <\/strong>ready for analysis.<\/li>\n<\/ul>\n<h2>Gold: the enriched data<\/h2>\n<p>The <strong>Gold layer <\/strong>is data set up specifically for reports or dashboards. Often this is already summarized or grouped together so that end users can start working with it immediately. <\/p>\n<ul>\n<li>Example: a table of monthly sales by region and product category.<\/li>\n<li>Goal: <strong>Instant insight <\/strong>for business users and managers.<\/li>\n<\/ul>\n<h2>Why is this important?<\/h2>\n<ul>\n<li><strong>Transparency<\/strong>: everyone knows where the data came from and how it was processed.<\/li>\n<li><strong>Quality<\/strong>: errors are corrected in the appropriate step.<\/li>\n<li><strong>Scalability<\/strong>: new resources can be easily added without having to redo everything.<\/li>\n<\/ul>\n<h2>Bronze, Silver and Gold in Power BI<\/h2>\n<p>In Power BI, you often see that the <strong>Gold layer <\/strong>is the source for dashboards and reports. Because the data has already been cleaned and summarized there, reports are faster, more reliable and easier to use. The Silver and Bronze layers are primarily used by data engineers to ensure that the data is properly prepared.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>In modern data platforms, you often hear the terms Bronze, Silver and Gold. These are layers in a data architecture that indicate how &#8220;clean&#8221; or processed data is. The idea comes from the Medallion architecture, a commonly used approach in Microsoft Fabric, Databricks and other data solutions.  <\/p>\n","protected":false},"featured_media":0,"template":"","knowledge_type":[58],"knowledge_category":[],"class_list":["post-5137","knowledge_pt","type-knowledge_pt","status-publish","hentry","knowledge_type-simplified"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt\/5137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt"}],"about":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/types\/knowledge_pt"}],"wp:attachment":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/media?parent=5137"}],"wp:term":[{"taxonomy":"knowledge_type","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_type?post=5137"},{"taxonomy":"knowledge_category","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_category?post=5137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}