آموزش مهندسی داده با Microsoft Fabric: بیش از ۱۰ پروژه عملی و واقعی - آخرین آپدیت

سرفصل ها و درس ها

INTRODUCTION

• Introduction

• COURSE INTRODUCTION

• NOTES

• Dataset

Microsoft Fabric & Lakehouse - One Lake

• Introduction to Microsoft Fabric

• create azure free accounts

• How to Create Fabric Account

• FABRIC COST AFTER 30 DAYS

• Fabric Hierarchy And Terminology

• Fabric Overview

• How to Create Workspace in Fabric

• Onelake in Fabric

• What is Lakehouse in Fabric

• How to Create Lakehouse in Fabric

• OneLake File Explorer in Fabric

• Create Tables in Lakehose Fabric

• Shortcuts in Fabric

• Shortcuts Practical in Fabric

• External shortcuts practical in fabric

• Cache in Fabric

• SQL endpoints in fabric

Data Factory - Data Pipeline in Fabric

• Data Factory in fabric

• Create Data Factory in Fabric

• Copy Data Activity

• Delete Activity in Fabric

• Getmeta Data Activity in Fabric

• Filter Activity in Fabric

• Lookup Activity in Fabric

• Parameterization in Fabric

• For Each Activity in Fabric

• If Condition Activity in Fabric

• Notification in Fabric

• Invoke Pipeline Activity in Fabric

• Schedule Pipeline in Fabric

• Monitor Pipeline in Fabric

• Wait Activity in Fabric

Data flow Gen2 - Microsoft Fabric

• DATAFLOW GEN2 in fabric

• DATAFLOW GEN2 - Connect sources in fabric

• DATAFLOW GEN2 -String transformation in fabric

• DATAFLOW GEN2 -Mathematical transformation in fabric

• DATAFLOW GEN2 -Diagram View in fabric

• DATAFLOW GEN2 -Join in fabric

• DATAFLOW GEN2 -Load destination table in fabric

Spark - Microsoft Fabric

• SPARK Introduction in fabric

• Spark pools in fabric

• Create your first spark notebook in fabric

• Create Data Frame Using Pyspark

• Pyspark select , drop and limit command

• Typecast in pyspark

• Sort in pyspark

• Group By in pyspark

• Filter in pyspark in fabric

• Handle Nulls in pyspark in fabric

• Spark SQL in fabric

• Visualization in pyspark notbeook fabric

• Create manage and external tables

• Notebookutils in fabric notebook

• Environment in fabric

• Schedule and monitor notebook in fabric

Data Warehouse - Microsoft Fabric

• WHAT IS DATAWAREHOUSE & USECASE

• DatawareHouse in fabric

• Load the data in warehouse

• Copy into command in DatawareHouse fabric

• CTAS - Create Table as Select load data in DWH

• Views in DWH fabric

• Store procedure in TSQL

• New visual query in DWH fabric

• Download SQL database project feature

• Write T-SQL in Notebook fabric

POWER BI

• COURSE INTRODUCTION

• What is Power BI

• Power BI Desktop Installation

• Power BI Desktop Overview

• Load Data in Power BI Desktop

• Dashboard - Set header and Logo

• Card Visuals

• Create Bar Chart Visuals

• Line Chart Visual

• Line & Stack Column Chart

• Pie Chart Visual

• Slicer in Power BI

• Static Visuals Using Power BI

• KPI in Power BI

• Gauge Chart

• Create Clear Slicer Button

• MAP in Power BI

• Q&A Chart in Power BI

• TOOLTIP in Power BI

• Filters in Power BI

• Drill in Power BI

• Data Model in Power BI

• Introduction to DAX

• DAX Format

• DAX Datediff And If Condition Usecase

• DAX Switch Condition

• DAX Variable

• DAX - Calculate & Filter Functions

• Group in Power BI

• Measures in Power BI

• Measures Practical in Power BI

• RANKX Practical in Power BI

• Power Query Editor

• Power Query Editor - Data Transform

• Power Query - Text Modification

• Power Query - Column Quality Check

• Power Query - Null Values Handle

• Power Query - Conditional Columns

• Power Query- Merge Columns

• Append Query Using Power Query

ECommerce Project - ADLS + DATA PIPELIEN + PYSPARK + POWER BI

• PROJECT INTRODUCTION

• PROJECT SETUP & SOURCE SETUP

• FABRIC WORKSPACE & LAKEHOUSE

• DATA PIPELINE - ADLS TO LAKEHOUSE COPY

• DATA CLEANING & REPORTING - PYSPARK + POWER BI

MEDALLION ARCHITECTURE - END TO END PROJECTS

• PROJECT INTRODUCTION

• DATA PIPELIENE - ADLS TO LAKEHOUSE

• DATA CLEANING & REPORTING- PYSPARK & POWER BI

DATA MIGRATION PROJECT - END TO END DATA PIPELINE

• PROJECT INTRODUCTION

• BUSINESS USE CASE & PROBLEM

• PRACTICAL - END TO END DATA PIPELINE

ECommerce Order Analytics Project - SPARK SQL + DATA PIPELINE + POWER BI

• PROJECT INTRODUCTION

• PROJECT PRACTICAL - DATA PIPELINE + LAKEHOUSE + SPARK SQL

• POWER BI & REPORTING

HR ANALYTIC PROJECT - DATA FLOW GEN2 + DATA PIPELINE + POWER BI

• PROJECT INTRODUCTION & BUSINESS USE CASE

• PROJECT PRACTICAL - DATA PIPELIEN + LAKEHOUSE + DATA FLOW GEN2 + POWER BI

INCREMENTAL DATA LOAD - END TO END DATA PIPELINE

• PROJECT INTRODUCTION & BUSINESS USE CASE

• END TO END DATA PIPELINE

INSURANCE PROJECTS - DATA PIPLINE + LAKEHOUSE + PYSPARK + REPORTING

• PROJECT INTRODUCTION & BUSINESS USECASE

• PROJECT PRACTICAL - ADLS + LAKEHOUSE+ PYSPARK + REPORTING

RETAIL DATA ENGINEERING PROJECTS

• PROJECT INTRODUCTION

• PROJECTS PRACTICAL - DATA PIPELINE + PYSPARK + LAKEHOUSE + REPORTING

SCD TYPE -1 DATA PIPELINE PROJECT

• PROJECT INTRODUCTION - SCD TYPE 1

• END TO END PROJECTS- DATA PIPELINE

SCD TYPE -2 DATA PIPELINE PROJECT

• PROJECT INTRODUCTION

• DATASET UNDERSTANDING - SCD TYPE-2

• PROJECT PRACTICAL