0-10 subscribers
Chuyển sang chế độ ngoại tuyến với ứng dụng Player FM !
Podcast đáng để nghe
TÀI TRỢ BỞI
Understanding Semantic Models and Data Lake House Layers
Manage episode 448912997 series 3366322
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, you'll learn why different layers serve different purposes—from storing raw data to pre-joining tables for efficiency to creating finalized data ready for reporting. They also discuss how the semantic model is designed to simplify complex data relationships, making reporting easier for non-technical users.
Thank you for tuning into The Dashboard Effect Podcast! Subscribe for more insights on data, BI, and analytics.
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.
For a free, downloadable copy click https://bit.ly/3RmBGWQ, or buy a hardcopy or Kindle version on Amazon (https://amzn.to/3UTvTLm).
Get more episodes of The Dashboard Effect podcast on your favorite podcast app or at https://podcast.thedashboardeffect.com/
Visit Blue Margin's library of additional BI resources here: https://bit.ly/3fwNmcg
152 tập
Manage episode 448912997 series 3366322
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, you'll learn why different layers serve different purposes—from storing raw data to pre-joining tables for efficiency to creating finalized data ready for reporting. They also discuss how the semantic model is designed to simplify complex data relationships, making reporting easier for non-technical users.
Thank you for tuning into The Dashboard Effect Podcast! Subscribe for more insights on data, BI, and analytics.
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.
For a free, downloadable copy click https://bit.ly/3RmBGWQ, or buy a hardcopy or Kindle version on Amazon (https://amzn.to/3UTvTLm).
Get more episodes of The Dashboard Effect podcast on your favorite podcast app or at https://podcast.thedashboardeffect.com/
Visit Blue Margin's library of additional BI resources here: https://bit.ly/3fwNmcg
152 tập
Tất cả các tập
×
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 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 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
Chào mừng bạn đến với Player FM!
Player FM đang quét trang web để tìm các podcast chất lượng cao cho bạn thưởng thức ngay bây giờ. Đây là ứng dụng podcast tốt nhất và hoạt động trên Android, iPhone và web. Đăng ký để đồng bộ các theo dõi trên tất cả thiết bị.