0-10 subscribers
Gå offline med appen Player FM !
Podcasts der er værd at lytte til
SPONSORERET


1 The Secret To Getting Inspired: Millie Bobby Brown & Chris Pratt Go Behind The Scenes 21:04
Behind the Scenes in Power BI: Tips to Streamline Data Modeling
Manage episode 411885415 series 3366322
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 Section:
0:40 How Blue Margin approaches semantic modeling with serverless SQL views
1:45 Power BI is not an ETL tool, so use SQL instead
2:34 How tight does governance around semantic models need to be?
5:23 What is the optimal level of complexity for a semantic model?
Watch this episode on our YouTube channel.
Blue Margin increases enterprise value for PE-backed, mid-market companies by serving as their fractional data team. We advise on, build, and manage data platforms. Our strategy, proven with over 300 companies to-date, expands multiples through data transformation, as presented in our book, The Dashboard Effect.
Subscribe here to get more episodes of The Dashboard Effect podcast on your favorite podcast app.
Visit Blue Margin's library of additional BI resources.
152 episoder
Manage episode 411885415 series 3366322
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 Section:
0:40 How Blue Margin approaches semantic modeling with serverless SQL views
1:45 Power BI is not an ETL tool, so use SQL instead
2:34 How tight does governance around semantic models need to be?
5:23 What is the optimal level of complexity for a semantic model?
Watch this episode on our YouTube channel.
Blue Margin increases enterprise value for PE-backed, mid-market companies by serving as their fractional data team. We advise on, build, and manage data platforms. Our strategy, proven with over 300 companies to-date, expands multiples through data transformation, as presented in our book, The Dashboard Effect.
Subscribe here to get more episodes of The Dashboard Effect podcast on your favorite podcast app.
Visit Blue Margin's library of additional BI resources.
152 episoder
Alle episoder
×
1 If You Build It, Will They Use It? Culture’s Role in BI Success 9:38

1 Vanity Isn’t Strategy: Smarter Metrics for Smarter Teams 8:36

1 Safe, Smart, and Internal: Our Experimental Leap with AI 7:03

1 The Future of Microsoft Fabric: Will It Replace Synapse? 9:04

1 Revenue Reporting: It's Not as Simple as It Seems 5:55

1 Breaking Down Portfolio Monitoring Solutions 20:31

1 Role Based Security: Keeping Data in the Right Hands 8:47

1 From Theory to Practice: Making AI Work in the Real World 40:37

1 How to Build Smarter Reports with Power BI 9:48

1 Is Raw or Aggregated Data Better for Analytics Decisions? 7:57

1 Schema on Write vs. Schema on Read: What’s Faster for Your Business? 6:57

1 Understanding Semantic Models and Data Lake House Layers 10:25

1 NetSuite Data Pipeline: Surprising API Challenges & ODBC Solution 7:22

1 How Bad Data Models Can Sabotage Your Reports 10:51

1 The Blueprint for Rolling Out BI to Hundreds of Users 10:06

1 Simplifying Your Data Pipeline for Maximum Performance 16:31

1 The Data Team Dilemma: Strategies for Surviving High Turnover 8:48

1 The Strategic Edge of Outsourcing Your Data Platform 13:27

1 Generative AI Analytics: Hype vs. Reality 11:18

1 Handling Multiple Currencies in Power BI 8:57

1 Modern Reporting with Power BI: Moving Beyond Email Reports 8:47

1 The Pitfalls of Augmenting Transactional Data with Excel for Reporting 9:19

1 Mastering Delta Loads: Caleb's Best Practices, Tips, and Workarounds 8:58

1 A Speed-Trust Equation: Fast Power BI Reports Increase End User Confidence 9:17

1 Watch Out for These Data Model Red Flags 9:12

1 Blueprints for Building an Internal BI Team 15:58

1 How to Use Leading and Lagging Metrics for Better Business Agility 12:06

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

1 How to Democratize Data and Avoid the Chaos of Data Sprawl 8:30

1 The Human Side of AI Readiness - How to Prepare Your Team and Business Logic 9:07

1 Laying the Groundwork for Gen AI in Business Analytics 8:56

1 The Layman's Guide to Data Terminology: Part Three 11:40

1 The Layman's Guide to Data Terminology: Part Two 10:43

1 The Layman's Guide to Data Terminology: Part One 9:36

1 The KPIs You're Overlooking: Better Data Insights for Manufacturers 14:31

1 A Case Study: Unifying Data Sources with Azure Data Lake and Serverless SQL 10:18

1 From Data Setup to Power BI Reports: Considerations for Your Data Model (Semantic Layer) 10:13

1 How to Generate Realistic, Synthetic Data for Power BI with ChatGPT 12:37

1 How to Structure Your Data for Power BI Copilot 13:17

1 A Closer Look at Microsoft Fabric's Direct Lake and Data Pipelines 10:41

1 How to Prepare Your Data for AI Advances 13:47

1 Data Quality Sets the Stage for Generative AI: AWS's CDO Agenda for 2024 11:37

1 Data is Gold in AI's Wild West: Insights from Salesforce's State of Data & Analytics Report 15:04

1 How (& Why) to Prioritize Data Projects During ERP Transitions 9:24

1 Agile Data: How New Tech is Transforming Business Operations 15:57
Velkommen til Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.