Data & Analytics, Fast Focus

W13 Fast Focus: Data Lakehouses, Data Warehouses and Datamarts: When to use Which in Microsoft

05/01/2024

2:00pm - 2:20pm

Level: Introductory to Intermediate

Andrew Brust

Founder and CEO

Blue Badge Insights

With its new Fabric end-to-end analytics platform, Microsoft provides numerous options for where to store your data and how to manage and query it. Your choices: data lakehouses, data warehouses and datamarts. All of them have relational tables and are queryable with SQL, but depending which one you select will impact whether you're using SQL Server technology for the tech stack, leveraging open table formats for storage, hitting your Fabric compute capacity to power the queries, running at departmental or enterprise scale, and doing your data modeling work in Power BI Desktop or in the cloud. Come to this Fast Focus session to learn when to use which type of repository, what the cost factors are, which ones interoperate better with non-Microsoft data platforms, and where you'll get the best time-to-value and ROI.

You will learn:

  • The basics of data lakehouses, warehouses and marts
  • How to choose the right platform for the right job
  • Aligning platform choice with your org's current skillsets
  • The right strategy for creating Power BI reports on your data