Advent of 2023, Day 15 – Building warehouse with Microsoft Fabric
This article is originally published at https://tomaztsql.wordpress.com
In this Microsoft Fabric series:
- Dec 01: What is Microsoft Fabric?
- Dec 02: Getting started with Microsoft Fabric
- Dec 03: What is lakehouse in Fabric?
- Dec 04: Delta lake and delta tables in Microsoft Fabric
- Dec 05: Getting data into lakehouse
- Dec 06: SQL Analytics endpoint
- Dec 07: SQL commands in SQL Analytics endpoint
- Dec 08: Using Lakehouse REST API
- Dec 09: Building custom environments
- Dec 10: Creating Job Spark definition
- Dec 11: Starting data science with Microsoft Fabric
- Dec 12: Creating data science experiments with Microsoft Fabric
- Dec 13: Creating ML Model with Microsoft Fabric
- Dec 14: Data warehouse with Microsoft Fabric
With the basic concepts of data warehouse in Fabric covered, we see and look into the first Fabric warehouse.
In your workspace, you can create a warehouse by selecting and giving it a name.
I have named my as “Advent2023_DWH”.
You can create a warehouse using T-SQL scripts, from data flow gen2, from data pipelines and from the sample data. Let’s select the sample data and grab a coffee.
Once the process is completed, you will be able to see the schemas, views, procedures and tables in your warehouse. This simple – star-schema – warehouse is a super simple example of fact and dimension tables.
You will also see, that the outlook is familiar to the one from SQL analytics and all user capabilities are there. And you can start building a query with visuals.
And store the query as a view with the T-SQL available to be extra modified.
In addition, I have created another warehouse and create a single query that can do cross-warehouse statement (simple UNION) Joined data from two warehouses can also be viewed and created.
When you go to the model (1), you will be able to check the model of your data. You can see that there are no connections made by default, so we would need to create a theme.
When you go to “New report” (2), you will get directly into Power BI designer with all the data (tables and views) from the current warehouse.
And you can create super simple a power BI Report that is built on top of that model.
And also the semantic model will be persistent and presented under the warehouse.
Tomorrow we will start looking building the pipelines / dataflow and populate the warehouse
Complete set of code, documents, notebooks, and all of the materials will be available at the Github repository: https://github.com/tomaztk/Microsoft-Fabric
Happy Advent of 2023!
Please visit source website for post related comments.