Behind the Scenes in Power BI: Tips to Streamline Data Modeling

Behind the Scenes in Power BI: Tips to Streamline Data Modeling

Author: Brick Thompson, Jon Thompson, Caleb Ochs, Landon Ochs April 11, 2024 Duration: 8:55
This week, Brick and Caleb get a bit technical and discuss how to improve Power BI report performance through effective semantic modeling and minimizing data transformation with Power BI. They unpack the challenges of managing data transformations directly within Power BI and highlight the advantages of using serverless SQL views instead. Their insights will help Power BI report developers avoid common pitfalls, streamline data processing, and improve Power BI report performance. Jump to a S...

Every other Thursday, The Dashboard Effect cuts through the noise around business data. Host Brick Thompson of Blue Margin sits down with operators and leaders who are actually using analytics to steer their companies, moving beyond theory to the tangible realities of implementation. This isn't about abstract concepts; it's a focused discussion on building clarity and accountability through dashboards and reporting that people actually use. You'll hear specific stories about the hurdles mid-market and private equity-backed firms face when trying to make data-driven decisions a daily habit, not just an aspiration. The conversations in this podcast are built for leaders who need practical frameworks, whether it's about selecting the right metrics, fostering a data culture, or justifying the investment in business intelligence tools. Each episode aims to simplify a complex landscape, providing listeners with a clearer path to turning their information into a strategic advantage. Tune in for grounded advice that translates data from a potential asset into a genuine driver of business performance.
Author: Language: en-us Episodes: 100

The Dashboard Effect
Podcast Episodes
How to Generate Realistic, Synthetic Data for Power BI with ChatGPT [not-audio_url] [/not-audio_url]

Duration: 12:37
Brick and Caleb explain how Blue Margin is using ChatGPT for generating synthetic data to populate data models in Power BI reports. Caleb shares his insights on how this approach has streamlined the process of creating s…
How to Structure Your Data for Power BI Copilot [not-audio_url] [/not-audio_url]

Duration: 13:17
Brick and Caleb call out key aspects of Microsoft's Power BI Copilot documentation related to structuring datasets for Large Language Models (LLMs) and explain how to get these best practices in place. Data structure and…
A Closer Look at Microsoft Fabric's Direct Lake and Data Pipelines [not-audio_url] [/not-audio_url]

Duration: 10:41
While some features are not quite up to par (yet) with Azure Synapse Pipelines, Brick and Caleb discuss Microsoft Fabric's Direct Lake mode and Data Pipelines and the speed and advances they're bring to data management.…
How to Prepare Your Data for AI Advances [not-audio_url] [/not-audio_url]

Duration: 13:47
For months, Brick and Caleb have been recommending that companies start preparing their data infrastructure to leverage the current and upcoming AI technologies. In this episode, however, they break down how to prepare.…
How (& Why) to Prioritize Data Projects During ERP Transitions [not-audio_url] [/not-audio_url]

Duration: 9:24
In this episode, hosts Brick and Caleb discuss the hesitation many companies have to pursue data projects during ERP (Enterprise Resource Planning) implementations. They dissect the risks of delaying these initiatives an…
Agile Data: How New Tech is Transforming Business Operations [not-audio_url] [/not-audio_url]

Duration: 15:57
Brick and Jon, founders of Blue Margin, talk about the advancements in data technology and its impact on mid-market businesses. They discuss how rapid developments in data technology, particularly in data lakes and data…