Player FM 앱으로 오프라인으로 전환하세요!
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.
136 에피소드
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.
136 에피소드
Tüm bölümler
×플레이어 FM에 오신것을 환영합니다!
플레이어 FM은 웹에서 고품질 팟캐스트를 검색하여 지금 바로 즐길 수 있도록 합니다. 최고의 팟캐스트 앱이며 Android, iPhone 및 웹에서도 작동합니다. 장치 간 구독 동기화를 위해 가입하세요.