Microsoft Fabric Deep Dive: Fabric Guide

Master Microsoft Fabric: A Practical Guide to Data Integration, Analytics, and Governance from Basics to Advanced Techni

What you'll learn

Master Data Integration Techniques

Develop Proficient Data Analytics Skills

Implement and Manage Data Governance

Optimize Data Workflows for Efficiency

Requirements

No coding is required, simple UI based learning, you will learn whatever you need here

Description

"This course offers a comprehensive journey through Microsoft Fabric, guiding you from foundational concepts to advanced techniques. You’ll learn how to integrate diverse data sources, leverage powerful analytics tools, and implement robust data governance practices. Through practical exercises and real-world case studies, you’ll gain hands-on experience to optimize data workflows and apply Microsoft Fabric's capabilities effectively in your projects.""Dive deep into Microsoft Fabric with this practical course designed to take you from basics to mastery. Explore essential data integration methods, advanced analytics techniques, and effective data governance strategies. Engage with real-world scenarios and hands-on exercises to enhance your skills and optimize data workflows, preparing you to leverage Microsoft Fabric’s full potential in your data management and analytics tasks.""Master Microsoft Fabric with our in-depth course that covers everything from foundational principles to advanced applications. This guide will teach you how to seamlessly integrate data, perform advanced analytics, and manage data governance within Microsoft Fabric. Through practical exercises and real-life case studies, you will develop the skills needed to design efficient data workflows and apply Microsoft Fabric's tools to solve complex data challenges.""This course provides a practical and thorough exploration of Microsoft Fabric, moving from fundamental concepts to advanced mastery. You will learn how to integrate various data sources, utilize analytics tools for actionable insights, and enforce effective data governance. Hands-on practice and real-world examples will equip you with the skills to optimize data workflows and apply Microsoft Fabric's features to enhance your data management and analytics capabilities."

Overview

Section 1: Introduction

Lecture 1 Introduction to Microsoft Fabric || Getting Started with Microsoft Fabric

Lecture 2 Hands-On : Create Your First Workspace in Fabric | General Terminology | Roles

Lecture 3 Hands-On : Create your First Lakehouse | Install OneLake Explorer &Data Studio

Lecture 4 Hands-On : Create Your First warehouse in Fabric | | Lakehouse vs Warehouse

Lecture 5 Hands-On : Create your First Shortcuts to Lakehouse | Warehouse | Data Lake

Section 2: Development of Data Pipeline and Dataflow Gen2

Lecture 6 Hands-On : Introduction to Data Factory Experience | Pipelines & Dataflows

Lecture 7 Hands-On : End-to-End Scenario with Data Factory Pipelines and Dataflows Gen2

Lecture 8 Hands-On : End-to-End Mini Project : Data Factory Pipelines and Dataflows Gen2

Lecture 9 Hands-On :Copy data from Azure SQL DB to Lakehouse Table | Query | Stored proc

Lecture 10 Hands-On :Copy Multiple tables from Azure SQL DB to Lakehouse dynamically

Lecture 11 Hands-On : Moving Multiple Folders from Data Lake Storage Gen2 to Lakehouse

Lecture 12 Hands-On : Copy data from REST API to Lakehouse in Fabric using Bearer Token

Section 3: Data Pipelines which ingest data from On Premise to Cloud

Lecture 13 Hands-On : Ingest Data From On Premise SQL Server to Lakehouse| Data Gateway

Lecture 14 Hands-On : Ingest data from On premise server to fabric| Install Data Gateway

Section 4: Incremental data pipelines and pipeline logging and scheduling

Lecture 15 Hands-On : Ingest data from On premise SQL server to Warehouse Incrementally

Lecture 16 Hands-On : Copy data from Azure SQL DB to Warehouse using table, query & SP

Lecture 17 Hands-On : Logging Fabric Pipeline Logs to Warehouse table using stored proc

Lecture 18 Hands-On Incremental data ingestion from Azure SQL DB to Warehouse in Fabric

Lecture 19 Hands-On : Microsoft Fabric: Multiple table Incremental data load from Azure SQL

Lecture 20 20. Hands-On: Filter file using data pipelines in Fabric || Filter Activity

Section 5: Advanced pipelines like dependency pipelines and dynamic schema and cross cloud

Lecture 21 Hands-On: How to run pipeline when dependency job is completed || Event Based

Lecture 22 Hands-On :Combining Excel Files from different data providers 2 Unified Table

Lecture 23 Hands-On: Copy data from AWS S3 Storage to Lakehouse using Data Pipelines

Lecture 24 Hands-On: Multiple tables Dynamic mapping in Copy Activity using config table

Lecture 25 Hands-On: Merge Different Excel data of different sheets to unified table

Lecture 0 Hands-On: How to handle data pipeline concurrency issue in Microsoft Fabric

Lecture 0 Hands-On: How to Implement custom pipeline template for reusability |Template

Lecture 0 Hands-On: Copy data from On premise SQL Server to Lakehouse using pipelines

Lecture 0 Hands-On: Copy data from On premise File System to Lakehouse using pipelines

Lecture 0 Hands-On: Copy data from snowflake to Lakehouse |Snowflake Free Trail Account

Data Engineers, Data Architects, Data Science and Data Analyst,Anybody who wants to become Data Architect