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

The Dashboard Effect

Innehåll tillhandahållet av Brick Thompson, Jon Thompson, Caleb Ochs, Brick Thompson, Jon Thompson, and Caleb Ochs. Allt poddinnehåll inklusive avsnitt, grafik och podcastbeskrivningar laddas upp och tillhandahålls direkt av Brick Thompson, Jon Thompson, Caleb Ochs, Brick Thompson, Jon Thompson, and Caleb Ochs eller deras podcastplattformspartner. Om du tror att någon använder ditt upphovsrättsskyddade verk utan din tillåtelse kan du följa processen som beskrivs här https://sv.player.fm/legal.

7M ago 8:55

MP3•Episod hem

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.

140 episoder

#Business #Brick Thompson Jon Thompson And Caleb Ochs #Brick Thompson #Caleb Ochs #Jon Thompson #Data #Analytics #Private Equity #Business Intelligence #Data Analytics #Dashboard #Blue Margin