The Dashboard Effect

What an MCP Server Actually Does

An MCP server gives an LLM a standard way to reach your data and run tools against it. Every API is built differently, and the Model Context Protocol puts one interface over all of them, which is why Anthropic's standard gets compared to USB C. This episode covers what the standard defines, how tools and resources set the boundaries on what an AI can do with your systems, and what you get by writing a server yourself. We built one for our own AI-ready data model and hit a context problem along the way: the model would skip the business context files and bluff its way through an answer, then admit it never read them when asked directly. The fix was a token buried in those documents that the server checks before it will run any other tool. If you work in data, BI, or analytics engineering and you are weighing a vendor's MCP server against building your own, start here. Like and subscribe for straight talk on data, AI, and running a modern business on real numbers. Blue Margin builds and manages data platforms on Microsoft Fabric and Power BI for mid-market and private equity backed companies. Our Managed Data Service consolidates your systems into one governed source, delivers the dashboards your team runs on, and maintains them as your business changes. Learn more at bluemargin.com.

• Transcript

The Platinum Layer: Getting Your Data Ready for AI

The platinum layer sits on top of the standard medallion architecture, built specifically to get data ready for LLMs. In this episode, Brick and Landon break down what it takes to build one well. Landon walks through the two foundations that make a platinum layer work: markdown files that give the LLM business context and call out data gotchas, and a modeling approach that goes further than typical BI denormalization. They discuss why AI models need a single grain of data to avoid summing errors, why report-specific columns need to be stripped out, and why the platinum layer gets materialized nightly instead of served through views. They also cover the role of MCP servers in this setup, including why Blue Margin builds tightly scoped servers for business users asking direct questions and more open ones for analysts building queries. If you've been wondering what actually separates a working AI data layer from a frustrating one, this episode covers the fundamentals. Key Moments: 1:00 — Markdown Files & Context 2:05 — What Happens Without Context 2:58 — Fabric Data Agent Test 3:19 — Modeling for AI 4:25 — The Grain Problem 5:11 — Extreme Denormalization 5:28 — Cleaning Columns & Tables 6:37 — Nightly Materialization 7:43 — Why You Need an MCP Server 8:22 — Two Types of MCP Access 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

• Transcript

The Gold Layer: Your Best Data, Ready to Report

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

• Transcript

Bronze, Silver, Gold: A Practical Guide to Medallion Architecture

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.

• Transcript

Can You Run Your BI on AI?

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/

• Transcript

Using Vibe Coding in Real Data Projects

In this episode, the team gets hands-on with vibe coding and what it actually looks like inside real data work. From building API connections to generating synthetic datasets, they walk through where AI is genuinely speeding things up and where it still runs into friction. The big takeaway: writing code might be faster, but everything around the data still matters just as much. Blue Margin helps growing companies make better decisions with their data. From building data pipelines to creating reporting and dashboards, we handle the technical side so teams can focus on using their data—not chasing it.

• Transcript

AI Won't Kill Your Coding Career

AI is replacing software engineers. At least that's what the headlines say. But is it actually true? In this episode of The Dashboard Effect, Brick - CEO of Blue Margin and Landon - Data Platform Manager at Blue Margin, get into what AI coding tools are really doing to software engineering teams right now. They cover why developers who tried AI tools in 2024 gave up too soon, how the best engineers on their teams are using Claude Code and ChatGPT Codex to ship faster without losing the craft, and why software engineering job growth keeps climbing despite all the doom and gloom. If you lead a dev team, work in software, or just want to understand where this is all heading, this episode will change how you think about AI and your career. 👍 Like and subscribe if you want no fluff conversations about data, AI, and running a modern tech business. Blue Margin is a business intelligence and data analytics firm helping companies turn raw data into decisions that drive revenue. With 120+ clients across industries, their team specializes in building dashboards and data platforms that leaders actually use. Learn more at bluemargin.com.

• Transcript

The Hidden Complexity Behind Simple Dashboards

Designing a dashboard might seem straightforward, just add charts, metrics, and a few visualizations. But the dashboards that actually help businesses make decisions often look surprisingly simple. In this episode of The Dashboard Effect, Brick and Landon talk about why the most effective dashboards are usually the simplest to read, and the hardest to build. Behind a clean dashboard is often a lot of complex data modeling, business rules, and engineering work that makes the information accurate and easy to understand. They walk through real examples, including salesperson ROI dashboards, accounts receivable reporting, and price-volume-mix analysis, to show how much work happens behind the scenes to create dashboards that people actually use. If you’ve ever wondered why some dashboards get ignored while others become essential tools for decision-making, this episode explains the difference. Learn more about Blue Margin: https://bluemargin.com

• Transcript

Should You Build a Data Team or Borrow One?

Many companies assume the best way to build a data capability is to hire an internal team. But is that always the right move? In this episode of The Dashboard Effect, Brick and Landon break down one of the most common questions they hear from prospective clients: Why outsource your data work instead of hiring in-house? They talk through the real tradeoffs companies face when building a data team, from the challenge of finding a single person who can do everything (the “Batman” hire), to the hidden costs of recruiting, training, and managing multiple specialists. They also discuss why outsourced teams can sometimes deliver more value than a single internal hire, thanks to a broader bench of expertise and the ability to scale resources up or down as business needs change. Whether you're considering building your own data team or looking for ways to get more out of your data infrastructure, this conversation offers a practical look at the pros and cons of each approach.

• Transcript

How a PE-Backed Rollup Escaped Excel Chaos

Pulling financial data together sounds simple, until you’re dealing with 20+ acquired companies, multiple ERPs, and a reporting process held together by massive Excel files. In this episode of The Dashboard Effect, Brick Thompson sits down with Senior Account Executive Kate Eberle to walk through a real client example: a PE-backed, billion-dollar organization struggling to consolidate financial data across a highly fragmented system landscape. They break down what went wrong, why Excel stopped scaling, and how moving to a modern data platform eliminated weeks of manual FP&A work, while giving leaders faster, more actionable insight into the business. About Blue Margin Blue Margin helps growing companies make better decisions with their data. We work with finance and technology leaders to consolidate messy, disconnected systems into reliable, usable data foundations, so teams can spend less time wrangling spreadsheets and more time understanding what’s actually happening in the business. Learn more: https://bluemargin.com If your reporting process depends on manual work, fragile Excel files, or month-old data, we help you move to a more scalable, trustworthy approach.

Your Finance Stack Is Broken: Stop Trusting the Magic Spreadsheet

Most finance and ops teams aren’t short on data, they’re short on trust in the numbers. This podcast digs into why reporting breaks down, why Excel becomes a crutch, and what actually changes when companies move to cleaner, more reliable data foundations. We talk with CFOs, operators, and data leaders about the messy reality behind budgets, forecasts, board decks, and “magic spreadsheets” and how teams can get out of survival mode and make better decisions with confidence. At Blue Margin, we help companies stop guessing and start leading with data. Our dashboards turn business performance into a daily habit, giving executives visibility that drives results. Visit https://bluemargin.com to see how we make data your biggest advantage.

Antidote for Failed Data Projects

In this episode of The Dashboard Effect, hosts Brick and Landon break down why so many data projects fail and how to fix them. Instead of “boiling the ocean” with massive, months-long BI initiatives that never gain traction, they share a practical, proven approach to delivering fast ROI, user adoption, and sustained data success. Whether you’re leading a data transformation, building dashboards, or just trying to get your first BI win, this episode will help you reset your mindset and find your “real antidote” to failure. At Blue Margin, we help companies stop guessing and start leading with data. Our dashboards turn business performance into a daily habit, giving executives visibility that drives results. Visit bluemargin.com to see how we make data your biggest advantage.

ROI for AI: Why Most Projects Fail (and How to Get Yours Right)

AI adoption is booming but most initiatives still fail to deliver real ROI. In this episode, Brick and Landon unpack why 60–95% of AI projects miss the mark and what companies can do differently. From the importance of a solid data foundation to starting small with practical use cases, they outline a smarter approach to AI that focuses on results, not hype.

The Data Governance Behind Trusted AI

In this episode of The Dashboard Effect, Brick and Landon unpack why so many AI projects fail and how the right data foundation can make all the difference. From breaking down what a semantic model actually is to exploring the role of governance, they explain how structure, quality, and oversight in your data environment directly impact the reliability of AI. Whether you’re an executive planning your first AI initiative or a developer struggling to wrangle messy data, this conversation offers a clear look at what it really takes to make AI work in the real world. Blue Margin helps middle-market companies turn their data into a strategic advantage. Through Power BI solutions and modern data platforms, we make data visible, reliable, and actionable—so your team can make smarter decisions and drive performance. Learn more at https://bluemargin.com

Making Data Work for Small Firms Without a Big Budget

Think you need a big BI team and a big budget to get value from your data? Think again. In this episode, Brick Thompson and Landon Ochs share how small professional services firms can start using data effectively—by focusing on one meaningful problem, starting simple, and iterating over time. Hear practical tips, common pitfalls, and a real-world success story that added millions to the bottom line. At Blue Margin, we help middle-market companies turn their data into a competitive advantage. As a Microsoft Gold Partner specializing in Power BI, we build simple, actionable dashboards that give leaders instant visibility into their business. Our proven process and deep expertise in data strategy help organizations boost accountability, accelerate growth, and achieve their goals—without the complexity or overhead of a full data team.

Beyond the Wrapper: Making AI Work for Data Teams

In this episode of The Dashboard Effect, Brick and Landon give an update on Celeste, the internal AI tool Blue Margin has been building to help data teams query, explore, and visualize client data. They dive into what’s worked, what hasn’t, and the fork in the road between making Celeste valuable for engineers versus business users. Along the way, they share lessons about AI adoption, the limits of “wrappers,” and where emerging tools like Azure’s AI Foundry could take things next. If you’ve ever wondered what it’s really like to build and test an AI tool inside a data company, this conversation pulls back the curtain. Blue Margin helps middle-market companies use their data to create focus, accountability, and growth. We specialize in building modern data platforms and Power BI dashboards that turn information into a competitive advantage. Learn more at https://bluemargin.com

From Custom Builds to Fivetran: Evolving Our Data Pipeline Strategy

In this episode of The Dashboard Effect, Brick and Landon discuss their shift in thinking on whether to build custom data connectors or use third-party tools like Fivetran. They share the pros, cons, and lessons learned from their proof-of-concept with Fivetran, and why APIs are changing the data pipeline game. Key Moments: 1:15 – Why custom connectors made sense in the past 2:00 – The rise of APIs and the challenge of building connectors for them 2:39 – Realizing the variety of systems—and limits of pre-built connectors 4:03 – How Fivetran’s dedicated API teams save time and reduce risk 4:57 – Turnaround times and when a custom build is still needed 5:56 – Cost trade-offs: upfront development vs. subscription model 6:30 – Support considerations for in-house vs. third-party connectors 6:41 – Exploring other tools and continuing custom pipeline work 7:11 – Closing thoughts and advice for data teams Blue Margin helps middle-market companies turn their data into a strategic asset through automated dashboards and data solutions. By simplifying the flow of information, we empower leaders to make confident, data-driven decisions that drive growth and efficiency. Learn more at bluemargin.com.

Preparing Your Data for AI: What Most Companies Get Wrong

In this episode of The Dashboard Effect, host Brick is joined by Blue Margin account executive Greg to demystify what it really means to “prepare your data for AI.” Rather than focusing on flashy tools and hype, they dig into the foundational steps, like building a modern data lakehouse and semantic layer, that are essential for long-term ROI. You’ll also hear why many companies are pulling back on generative AI pilots and what it takes to avoid falling into the “trough of disillusionment.” Whether you’re just starting your AI journey or looking to get real results from your investments, this episode offers a grounded, strategic perspective. Learn more: https://bluemargin.com

Choosing the Right Data Platform for Your Business: Fabric or Snowflake?

Choosing between Microsoft Fabric and Snowflake? In this episode of The Dashboard Effect, Brick Thompson and Landon Ochs break down when, why, and how to choose the right data platform for your organization. From ecosystem compatibility and AI capabilities to cost management and developer experience, we unpack the real-world trade-offs we see every day at Blue Margin. Whether you're building from scratch or evaluating a transition, this conversation will help you make a smarter, more informed decision. Don’t forget to subscribe for more data strategy insights!

Inside Microsoft Build: The Rise of AI Agents

This episode dives into the biggest theme from the 2025 Microsoft Build conference: AI agents. Brick and Landon unpack what Microsoft unveiled, from Copilot Studio to Azure AI Foundry, and what it all means for businesses adopting custom AI tools. Whether you're curious about how AI agents can automate tasks, what it takes to build and govern them effectively, or how Microsoft is pushing this technology forward, this episode is your insider look at the future of business automation.