Microsoft Fabric: Set Up Data Warehouse

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:

🤝 Let's Connect:

​​Centida GmbH
34 ​​Kernenhofstrasse​, Oberkirch​​
77704, ​German​​y

#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.

[rkneti]

Thanks for the tutorial. You have provided the SQL scripts for creating the tables etc. How about the SQL Server set up for use in the data pipeline?

[official_westhostel]

I have one Lakehouse and one warehouse in one workspace. And I read from Lakehouse and load those tables to warehouse by pipeline with option auto create table in destination. But when I again run that pipeline it add double data to the same table. Is there any way to solve this issue?