In this video, we will explore the Data Warehouse component of Microsoft Fabric. This Data Warehouse utilizes a SQL-enabled analytics engine, ensuring structured data is systematically stored in OneLake using the Delta-Parquet format. This approach provides both efficiency and flexibility in data management and analysis.

📚 What you will learn in this video:
- Introduction to Microsoft Fabric Data Warehouse.
- Lakehouse vs. Warehouse.
- Benefits Fabric Warehouse.
- Hands-on Demo: walk through the creation of a data warehouse in Microsoft Fabric.

🔍 Timecodes:
00:00 - Introduction.
00:31 - What is Microsoft Fabric Warehouse?
01:05 - Difference between a data warehouse and database.
02:28 - Comparing the Lakehouse and Warehouse in Fabric.
03:28 - Benefits of Fabric Warehouse.
05:05 - Creating a data warehouse in Fabric.
06:14 - Ways to import data to a warehouse.
07:13 - Creating tables and importing data using SQL scripts (DDL and DML).
10:29 - Import tables using data pipeline.
13:14 - Import data using Dataflows Gen2.
16:58 - Creating relationships between tables and the Sales measure.
18:37 - Building a matrix in Power BI.

🔗 Useful links:
Sample SQL scripts: [ Ссылка ]
Fabric Data Warehouse: [ Ссылка ]

🤝 Let's Connect:
LinkedIn: [ Ссылка ]
Website: [ Ссылка ]

​​Centida GmbH
34 ​​Kernenhofstrasse​, Oberkirch​​
77704, ​German​​y
Email: info@centida.com

#MicrosoftFabric #PowerBI #DataWarehouse

👍 If you found this video helpful, please give it a thumbs up, and consider subscribing to stay updated with our series. Your engagement helps us create more valuable content for the community.

свернуть