Microsoft Fabric End to End Ecommerce Project - Building Medallion Architecture in Lakehouse

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- https://1drv.ms/f/s!Ak57yG1_Qg0iey_2D...

---------- 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 Data Pipeline: Cr...  

Microsoft Fabric data Lakehouse end to end project -    • 003 Microsoft Fabric Lakehouse: Lakeh...  

If you want to know more about Microsoft Fabric data Warehouse, Please watch below videos-
1. Create Microsoft Fabric Data warehouse:    • 001 Microsoft Fabric Data Warehouse: ...  
2. load data into Microsoft Fabric data warehouse using Data Pipeline:    • 02 Microsoft Fabric Data Warehouse: H...  
3. Create table in Microsoft Fabric data warehouse:    • 003 Microsoft Fabric Data Warehouse: ...  
4. load data into Microsoft Fabric data warehouse using Copy into Command:    • 003 Microsoft Fabric Data Warehouse: ...  
5. Transform and load data into Microsoft Fabric data warehouse using T-SQL Procedure -    • 004 Microsoft Fabric Data Warehouse: ...