The gold layer is where cleaned, validated data lives in a medallion architecture, ready for reporting and analysis. In this episode, Brick and Landon break down what actually makes a gold layer good.

Landon covers what "good" means in practice: deduplicated data, validated numbers, and a structure business users can trust without checking behind the curtain. They discuss why star schema still holds up as the standard modeling approach, how to handle naming conventions that make sense to analysts instead of source systems, and what happens when six different systems all claim to have "the customer table."

They also get into the messier parts of building a gold layer: matching source system reports to catch hidden filters, deciding how to relate keys across systems without collapsing records that only look the same, and building exception reports to flag duplicates back to the business instead of quietly fixing them downstream.

If you've ever wondered what separates a gold layer that works from one that just exists, this episode covers the fundamentals.

Key Moments:

0:36 — What is the gold layer?
1:00 — Combining data silos
2:01 — Modeling the gold layer
2:22 — A preview of the platinum layer
2:30 — Naming conventions
3:39 — D_ and F_ naming standards
4:08 — Validating the gold layer
4:36 — Hidden filters and reporting errors
5:13 — Relating fact tables
5:57 — Handling duplicates
6:52 — Exception reports

About Blue Margin

Blue Margin is a Microsoft Fabric and Power BI consultancy based in Fort Collins, Colorado. We help mid-market and private equity-backed companies build data platforms that hold up: clean architecture, trustworthy reporting, and dashboards teams actually use. The Dashboard Effect is where we talk through the technical decisions behind that work.

Learn more: https://bluemargin.com

How does raw data from a system like Salesforce become a dashboard your team can actually trust? On this episode of the Dashboard Effect, Brick and Landon walk through medallion architecture and the three stages data moves through on its way to becoming useful.

They keep it simple: the first stage holds an exact copy of your source data, the middle stage cleans it up and combines data from different systems, and the final stage delivers a polished, analytics-ready view for tools like Power BI and Tableau. Landon also makes the case for keeping things lean rather than forcing every dataset through every step, and shares where speed and scale change the approach.

If you're building or refining how your data flows, this is a clear, approachable starting point.

About Blue Margin -

Blue Margin is a fractional data and analytics team for mid-market and PE-backed companies. Acting as an extension of your team, they build and manage your data platform, shape your data strategy, and deliver Power BI dashboards that give leaders a clear, real-time view of what's driving the business. The goal is simple: turn scattered data into decisions and build a culture of accountability and growth along the way.

Everyone's asking the same question: why can't I just run all my business intelligence through AI? In this episode of The Dashboard Effect, Brick and Landon break down the real answer. You probably can, but only if your data foundation is built for it.

They cover where AI analytics fit alongside traditional Power BI, why a strong medallion architecture is the difference between reliable answers and confident wrong ones, and the practical engineering that makes natural language query trustworthy. They also dig into rising token costs, vendor lock-in, and how to decide what belongs in a dashboard versus a chat window.

If you run a data-driven business and you're weighing how far to push AI into your reporting stack, this one is for you.

Subscribe for more conversations on data, dashboards, and getting real value from your BI.

About Blue Margin -

We build and manage the data foundation that turns scattered systems into reliable, AI-ready reporting, so your team gets trustworthy answers without the overhead of an internal data team.

Learn more: https://www.bluemargin.com/