Explicit Measures Podcast

236: Move From SQL to Fabric OneLake?

Jul 27, 2023

Pros and cons of moving from SQL to Fabric OneLake discussed. Focus on Power BI dev's ability to push to SQL. Different perspectives on using Fabric OneLake for data engineering tasks explored. Importance of Excel in the financial industry highlighted. Limitations of CSV files in data analysis discussed. Lake house concept and Microsoft's One Lake examined.

01:00:16

Creator website

AI Summary

AI Chapters

Episode notes

Podcast summary created with Snipd AI

Quick takeaways

Fabric enables business users to perform data engineering tasks, bridging the gap between business users and data engineers.

Fabric combines the benefits of data lakes and data warehouses, providing a unified platform for data storage, analytics, and reporting.

Fabric empowers business users to refine and enhance data, collaborate with data engineers, and take ownership of the data engineering process.

Deep dives

Fabric and the Blurring Line Between Business Users and Data Engineers

The podcast episode explores the capabilities and implications of using fabric, a new tool that enables business users to perform data engineering tasks. The hosts discuss the role of fabric in bridging the gap between business users and data engineers, allowing business users to manipulate and refine data in a way that was traditionally done by data engineers. They highlight the ease of integration and the ability to push data back into systems, enabling business users to have more control over their data and contribute to the data engineering process.

Introduction

2min

Power BI, Tabular Editor, and Low Code Authoring

10min

Improved Report Building Technology and the Significance of Excel

2min

Reliance on Software and Nostalgia for Excel Automation

2min

Challenges of CSV Files in Data Analysis

11min

Understanding the Concept of a Lake House and Microsoft's One Lake

5min

Business users and data engineers perspectives on Fabric OneLake

28min

Mike, Seth, & Tommy weigh the pros and cons of transitioning from SQL databases to Fabric Lake Houses. They dive into the differences between the two data platforms, and explore the factors that organizations should consider before making the switch. Major focus on the ability for the Power BI dev to push to out to SQL - what does that mean?

Get in touch:

Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page.

Visit PowerBI.tips: https://powerbi.tips/

Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitips

Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv

Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎

Check Out Community Jam: https://jam.powerbi.tips

Follow Mike: https://www.linkedin.com/in/michaelcarlo/

Follow Seth: https://www.linkedin.com/in/seth-bauer/

Follow Tommy: https://www.linkedin.com/in/tommypuglia/