Microsoft Fabric | Workspace, Lakehouse, Data Warehouse,Data pipeline, Notebooks,Auto-create reports
In this video, we will try our first hands-on experience on a free trial of Microsoft Fabric.
We will create a Lakehouse and compare it with data warehouse. Use data pipelines to load some data into lakehouse and test the AI Based Auto-create reports.
We will also create a data warehouse and use the SQL Query editor for DMLs.
🧑💼Add me LinkedIn : / ramakant-dadhichi
📸Add me on Instagram: / fitnessgeek_ig
📕Add me on Facebook: / ramakant.dadhichi
ABOUT MY CHANNEL:
Hi! I’m Ramakant Dadhichi, On my channel, I provide tech tutorials and insights on the latest cloud technologies, DevOps practices, and data management strategies. Whether you're a beginner or an experienced professional, my videos offer step-by-step guides and best practices for optimizing your workflow and mastering the latest tools and platforms. Join me on a journey of continuous learning and innovation in the fast-paced world of cloud tech and data management.
Feel free to add me on Instagram/Facebook/LinkedIn
0:00 Introduction
0:02 Creating a MS Fabric Workspace
0:36 Exploring Available Options
4:45 Creating a Lakehouse
5:08 Creating a Pipeline to load data into Lakehouse
8:16 Exploring the delta table from lakehouse view
9:39 Lineage View
10:16 Workspace Settings
13:27 The AI based 'Auto Create Report'
15:01 Another dataset 'holidays' created via a pipeline loading the lakehouse as table.
19:05 Creating our first notebook
27:46 The Lakehouse Explorer
28:48 Lakehouse SQL Endpoint (Read-only)
34:45 File loaded as delta table
35:10 Creating our first Fabric Data Warehouse
36:18 Navigating the Datawarehouse UI
39:41 Loading data into the data warehouse using data pipeline
45:28 Auto-Created Report from Warehouse dataset
49:17 Using the SQL Query Editor in MS Fabric