Рет қаралды 16,335
Microsoft Fabric End to End Solution - Building Medallion Architecture in Lakehouse #microsoft #microsoftfabric #azure #lakehouse #dataengineering #dataengineering #modelling #facts #dimesions #technology #ai #chatgpt #india
Note: Download the whole folder
Dataset and Code Link- 1drv.ms/f/s!Ak...
---------- Project chapters ---------
0:01 Project Overview - Microsoft fabric lakehouse end to end solution
01:37 Creating Workspace and Lakehouse
02:38 Ecommerce Dataset Overview
03:31 Lakehouse - Upload Files from Local System
04:30 Loading Bronze Table - Bronze Sales
14:39 Dimensional Model Overview
15:38 Loading Order Return Dimension - Gold Layer
24:44 Loading Order Priority Dimension - Gold Layer
38:54 Loading Ship Mode Dimension - Gold Layer
48:32 Loading Customer Dimension - Gold Layer
54:34 Loading Product Dimension - Gold Layer
01:01:52 Loading Date Dimension - Gold Layer
01:11:23 Loading Fact Sale Dimension - Gold Layer
01:24:17 Mounting to Lakehouse and Archiving Files
01:30:01 Running Notebooks inside a Notebooks
01:34:01 Creating Data Pipeline to run Final Notebook
01:36:16 Creating Semantic Model and Creating Auto Generated Report
01:38:55 Creating Auto Generated Report from Semantic Model
01:39:50 Connecting to Semantic Model Using Power BI Desktop in Direct Lake and Direct Query Mode
Microsoft fabric data pipeline script activity: • 03 Microsoft Fabric Da...
Microsoft Fabric data Lakehouse end to end project - • 003 Microsoft Fabric L...
If you want to know more about Microsoft Fabric data Warehouse, Please watch below videos-
1. Create Microsoft Fabric Data warehouse: • 001 Microsoft Fabric D...
2. load data into Microsoft Fabric data warehouse using Data Pipeline: • 02 Microsoft Fabric Da...
3. Create table in Microsoft Fabric data warehouse: • 003 Microsoft Fabric D...
4. load data into Microsoft Fabric data warehouse using Copy into Command: • 003 Microsoft Fabric D...
5. Transform and load data into Microsoft Fabric data warehouse using T-SQL Procedure - • 004 Microsoft Fabric D...