In Microsoft Fabric, we have the data warehouse, the lakehouse and the KQL database as options to choose from if we want to store some data, BUT which of these should YOU choose? And how should you begin to decide?
This video steps through the data warehouse, the lakehouse and the KQL database in detail, comparing their features and limitations, so that can make the right decision for your business.
Towards the end of the video, we look at how to combine these data stores into endtoend architectures (medallion architecture).
Catch up on the Power BI to Microsoft Fabric Transition Guide series here: • Power BI to Fabric Transition Guide
Timeline
0:00 Intro
1:08 It's all delta parquet
2:30 Lakehouse overview
7:17 Data Warehouse oveview
8:28 KQL Database overview
11:05 Sidebyside comparison
12:07 Data Types
13:08 Languages
15:00 Copilot + low/no code
16:45 Ecosystems
18:40 Security granularity options
20:55 Typical Workloads
22:33 Other unique features (including Git)
23:49 Personas
24:36 Practical applications (endtoend examples)
#microsoftfabric #powerbi #dataanalytics