Creating your first Data Warehouse in Microsoft Fabric

It's time to show the Data Warehouse within Microsoft Fabric some love! Patrick walks you through how you can get started with your first Data Warehouse using Data Pipelines.

What is data warehousing in Microsoft Fabric?

Microsoft Fabric decision guide: data warehouse or lakehouse

Data warehouse tutorial introduction

Ingest data into the Warehouse


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#MicrosoftFabric #Synapse #GuyInACube

[davelaff]

Do you know how many videos out there that I've found that shows me how to set up a data warehouse like this? One. This one. Thank you for this!

[Successpeace]

Suggestion: Please do more Fabric videos with focus on Notebooks and analytics like common enterprise needs around price prediction, demand forecasting etc. This will help us the power bi users learn some data science and learn how to use notebooks as well.

[NoCompM]

Patrick, can you please do some videos on how to take weekly raw data files and save them each week with a date stamp to keep historical records? That would be awesome. Basically same files each week, and append them to create a large system of weekly records

[balajisuriyanarayanan]

Thanks you so much for the wonderful videos. Its really helped me a lot and Today I have cleared my DP-600 exam🎉

[lukaszk]

Hey Patrick ! This is great video showing example . I wold like to see more store procedures examples like making scds . Cheers !

[petrnovotny]

thanks! you are the best, nice summary!!

[mirrrvelll]

This is actually great with DWH. But, after I am seeing this, there is a lot of options here, lot of clicks, and you need to know what you are doing. I was considering to get Fabric in our company, but I think the good thing is to have someone who is doing ETL (SQL programming) with Management Studio and prepare all the stuff. This way from Power BI (Fabric) is okay, but why to complicate when there is no need to it.

[rdeheld]

I used SSIS for some years but this is next level 😀

[MohanadPC]

Q: why would we need Fabric when we can use Azure SQL and grab data from there? Any response is appreciated, thanks

[Sandroider]

It was all fun and games until I needed premium capacity.

[bennetturner]

This is great. What I would like to achieve with all these new MS tools is ETL that watches a folder inside OneLake (or SharePoint) and when I add a new flat file (csv) to the folder it parses it and appends parsed rows to OneLake db. Then this data is available in PBI.

This would be an amazing tutorial if you could provide one.

[didiermaignan]

Great video, Patrick 🙃
If I look at Datamart, which you demoed last year, I can see common ideas, such as having everything together, but very different way of doing things and different audiences (Datamart for citizen dev and datamesh oriented, Data WareHouse for Data Office and IT). Since datamart are in preview since feb 2022 (2 years ago, waouh!) and have a proximity with Dataware House (Get data, create measure, do SQL queries etc...Do Microsoft intend to give up datamart in favor of Fabric Data Warehouse?

[sathyamanikantabk]

All this what you showed Can we do it also if we are having Microsoft Developer account?

[SilvanoPaxia]

Great, unfortunately for now Identities columns are missing. Can you do some video on SCD Type 2 Dimensions?

[IrishJimmyPA]

Q: Is any of the configuration scriptable, or do you have to go through the GUI?

[Fernando_Calero]

Q: How often do you update the Producers list credits at the end?

[jasonlarson]

Curious to know how to deal with encrypted data in Fabric, and how we can decrypt those values in power automate/apps.

[artus]

Isn't fabric the next version of Synapse ? Also what are your thoughts on Databricks delta lake tables ? As a seasoned SQL developer, fabric is very familiar, it's T-SQL and GUI !

[naveenhasan]

is the data warehouse only available in premium capacity or also as part of PPU or Pro. what would be the advatnage of using this over and above a data warehouse deployed on my local server?

[DanielWillen]

I assume Data Warehouse would be better than a lakehouse if you are heavy on TSQL. I am curious though if it would be worth migrating from something like serverless sql pool to a datawarehouse. Serverless can already read csv and parquet files from the azure storage account . What are the advantages?