The Dashboard Effect

Landon and Brick unpack the biggest announcements about Microsoft Fabric from the 2025 Microsoft Build Conference. From long-awaited features like Power BI write-back and built-in CICD, to major shifts like Cosmos DB moving into Fabric and Copilot now available at the F2 tier, this is a must-watch for data professionals and business leaders keeping an eye on Microsoft’s data ecosystem.

Whether you're already working i...

In this episode, Blue Margin’s Kate Eberle and Greg explore why forward-thinking private equity firms are investing in firm-level data lakehouses and how it’s transforming deal flow, operations, investor relations, and beyond.

From reducing manual reporting to enabling AI-driven insights and natural language querying, they outline real-world use cases, challenges, and the best first steps to take.

Subscribe for mo...

In this episode, Brick and Kate break down the five most impactful metrics for middle-market companies to focus on when implementing Business Intelligence (BI). These metrics help businesses not only measure performance, but also take strategic action based on real-time insights.

Whether you're in services, manufacturing, or another industry, this conversation dives into practical examples and key considerations for t...

Rolling out a new BI system or dashboard? It's not just about the data; it's about the people. 

In this episode of The Dashboard Effect, Brick and Landon dive into the hidden influence of company culture on BI adoption. From Excel loyalty to leadership modeling and psychological safety, they unpack the human side of digital transformation.

Learn how to overcome resistance, build trust, and drive lasting ...

Are you chasing metrics that look good but don’t do good?

In this episode of The Dashboard Effect, Brick Thompson and Landon Oaks dive into the common trap of vanity metrics, those flashy numbers that don’t actually move the needle. They explore how to identify the right metrics, involve the right stakeholders, and why iteration is key to building dashboards that drive real results.

Whether you’re building your first dashboard or ref...

 In this episode of The Dashboard Effect, host Landon Oaks sits down with Azure Data Architect Mark Bender to discuss Blue Margin’s first internal leap into AI: Project Celeste. 

Still in its early stages, Celeste is designed to boost developer and analyst productivity by using large language models to generate SQL queries from natural language prompts, without exposing sensitive data. Landon and Mark unpack how Celeste works, what ...

Are you trying to decide between Microsoft Synapse and Microsoft Fabric for your data architecture? In this episode of The Dashboard Effect Podcast, we break down the key differences, pros, and cons of each platform to help you make the best decision for your data needs. 

What You’ll Learn:

✅ The biggest limitations of Microsoft Fabric right now
✅ When Synapse is the better choice for large data sets
✅ How...

Revenue seems like a simple metric—just add up the sales, right? Not so fast! 

In this episode of The Dashboard Effect Podcast, Brick and Landon dive into the complexities of defining revenue. Every business calculates revenue differently, whether due to trade discounts, loyalty programs, rebates, or industry-specific rules.

We explore why even CEOs, CFOs, and sales leaders might have different definitions of revenue and how companie...

In this episode, Kate Eberle and Greg Brown discuss the challenges and strategies of portfolio monitoring in private equity. They explore the different approaches firms take, from Excel-based reporting to fully automated Power BI solutions, and discuss the pros and cons of each method.

Things we cover: 

- The evolution of portfolio monitoring in private equity
- Common challenges firms face with data collectio...

Who should see your business data and who shouldn’t? In this episode of The Dashboard Effect, hosts Brick and Landon break down the essentials of role-based security and data access control.

Learn how businesses can ensure the right people have access to the right data while keeping sensitive information secure.

We cover:
- The importance of defining roles & hierarchies
- How to structure access control in ERP,...

In this episode of The Dashboard Effect, host Jon sits down with Lisa Weaver Lambert, author of The AI Value Playbook. Lisa shares her deep expertise in AI, offering practical advice for non-technical leaders on how to leverage AI effectively. From addressing common pitfalls to discussing actionable strategies, Lisa’s insights are a must-hear for anyone looking to implement AI in their organization.

Lisa’s book, The AI Val...

In this episode of The Dashboard Effect, Brick and Landon discuss the importance of truly understanding your data before diving into report building. Whether you’re an analytics engineer or using Power BI, this conversation is packed with actionable insights for making better decisions and creating impactful dashboards.

Key Moments:

[02:15] Why understanding your data source improves report outcomes.
[05:30] H...

Knowing when to use raw data or aggregated data can make or break your analytics strategy. In this video, Brick and Landon explain the key differences between raw and aggregated data, how each affects decision-making, and the best times to use them. Whether you’re managing transactional data or scaling analytics for your business, this discussion has you covered.

Tune in to learn how these data strategies can impact your r...

In this episode of The Dashboard Effect Podcast, Brick and Landon break down the differences between schema on read and schema on write. They discuss when to use each approach, the pros and cons, and real-world applications for businesses of different sizes. If you're navigating the complexities of data lakes, data warehouses, or lakehouses, this episode will give you clarity.

Tune in to learn how these data strategies can impa...

In this episode of The Dashboard Effect Podcast, host Brick Thompson and Blue Margin’s Director of Solutions, Landon Ochs, dive into the nuances of semantic models and the bronze, silver, and gold layers within a data lake house. They explain the roles of each layer, how data is transformed at each stage, and why collaboration with business users is essential for accurate and actionable BI reporting.

Through this episode, ...

In this episode of The Dashboard Effect, Brick chats with Landon, Director of Solutions at Blue Margin, about a surprising challenge faced while extracting data from NetSuite. Despite NetSuite’s well-developed API, handling massive datasets proved problematic. Landon shares how they solved the issue using an unexpected solution—the ODBC connector.

They discuss the limitations of the API, how ODBC outperformed it for large data sets,...

In this episode, Brick Thompson and Caleb Ochs discuss the critical role of good data models in making business intelligence tools like Power BI efficient and scalable. They cover the pitfalls of poor data models, including delayed reporting and data category issues, and offer insights into designing flexible, transactional-level data models that can grow with your business needs.

Key Moments:

- Example of a Bad D...

In this episode of The Dashboard Effect, hosts Brick and Caleb discuss the challenges and best practices for rolling out Business Intelligence (BI) solutions to large audiences. With a real-life example of implementing BI across 600 retail locations, they dive into how to navigate common pitfalls, ensuring user adoption and success. Whether your rollout is for a small team or a large enterprise, these insights will help you optimiz...

In this episode of The Dashboard Effect, hosts Brick and Caleb explore the essential steps to building efficient and reliable data pipelines. They discuss the critical factors in moving data from transactional systems to data lakes, highlight the importance of simplifying pipelines, and share practical strategies for handling pipeline failures, API connections, and ensuring scalability. Whether you're a data professional or a ...