Microsoft Fabric: Practical Hands-on Project course

Microsoft Fabric: Practical Hands-on Project course, available at $84.99, with 36 lectures, 9 quizzes, and has 5 subscribers.

You will learn about Set Up Data Ingestion In Fabric using different methods Pipelines, Dataflows Gen 2 and Pyspark Notebooks Clean and Transform Data : Set up data flows in Data Factory to clean and transform the raw data. Apply filters and remove duplicates as necessary. Aggregate and Process Data: Create additional data flows or Stored Proc to aggregate and process the cleaned data. Store the processed data in the GoldenDWH. Prepare Data for Reporting: Prepare the final dataset for the Power BI report, optimizing it for performance. Use the Gold Layer data to create the BI reports Automate the Workflow: Schedule the data pipelines to run daily. Set up triggers and alerts in Data Factory to notify stakeholders via email about the pipeline Configure Access Control Implement role-based access control (RBAC) to manage access to each layer of the medallion architecture. This course is ideal for individuals who are Data engineers or Data Analysts or Data Architects or Power Bi developers or BI developers or Students in data related fields It is particularly useful for Data engineers or Data Analysts or Data Architects or Power Bi developers or BI developers or Students in data related fields.

Enroll now: Microsoft Fabric: Practical Hands-on Project course

Summary

Title: Microsoft Fabric: Practical Hands-on Project course

Price: $84.99

Number of Lectures: 36

Number of Quizzes: 9

Number of Published Lectures: 36

Number of Published Quizzes: 9

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Number of Practice Tests: 2

Number of Published Practice Tests: 2

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Set Up Data Ingestion In Fabric using different methods Pipelines, Dataflows Gen 2 and Pyspark Notebooks
Clean and Transform Data : Set up data flows in Data Factory to clean and transform the raw data. Apply filters and remove duplicates as necessary.
Aggregate and Process Data: Create additional data flows or Stored Proc to aggregate and process the cleaned data. Store the processed data in the GoldenDWH.
Prepare Data for Reporting: Prepare the final dataset for the Power BI report, optimizing it for performance. Use the Gold Layer data to create the BI reports
Automate the Workflow: Schedule the data pipelines to run daily. Set up triggers and alerts in Data Factory to notify stakeholders via email about the pipeline
Configure Access Control Implement role-based access control (RBAC) to manage access to each layer of the medallion architecture.

Who Should Attend

Data engineers
Data Analysts
Data Architects
Power Bi developers
BI developers
Students in data related fields

Target Audiences

Data engineers
Data Analysts
Data Architects
Power Bi developers
BI developers
Students in data related fields

Get ready to dive into the practical aspects of data management with Fabric in this hands-on, project-based course. Designed for data professionals and engineers, this course walks you through real-world scenarios, focusing on a use case scenario frequently encountered when working with Microsoft Fabric

What you’ll learn:

Creating and Managing Data Warehouses: Learn how to set up Bronze, Silver, and Gold data warehouses in Fabric.
Create a modern Lakehouse architecture:Medallion architecture
Automating Data Refresh: Master the creation and execution of stored procedures to automate data refreshes.
View and Table Management: Understand how to create, drop, and manage views and tables efficiently.
Learn about the semantic models in MS Fabric
Power BI Integration: Link your data warehouse to Power BI, and create dynamic reports and dashboards.
Troubleshooting Common Issues: Gain the skills to troubleshoot and resolve common data management challenges.

Who this course is for:

Data Analysts and Business Intelligence Professionals looking to enhance their practical skills with Fabric.
IT Professionals responsible for managing data warehouses.
Anyone interested in learning how to manage data efficiently and create dynamic reports with Power BI.

Course Features:

Step-by-Step Instructions: Follow along with detailed steps to set up and manage your data warehouse.
Real-World Example: Engage with practical examples and tasks based on real-world scenarios.
Interactive Projects: Apply what you learn through interactive projects that simulate actual data management tasks.
Resources and Support: Access supplemental resources and get support to help you succeed in your learning journey.

Course Curriculum

Chapter 1: Quick Introduction Microsoft Fabric ( Optional if you Already know Fabric)

Lecture 1: Welcome and Course Overview

Lecture 2: Introduction to Microsoft Fabric

Lecture 3: Setting Up Your Fabric Environment

Lecture 4: Set up Fabric Environment without work email

Lecture 5: Explore MS Fabric Interface and create the workspace

Chapter 2: ETL – Data Ingestion

Lecture 1: Welcome to Section 2 of this course

Lecture 2: Introduction to ETL/ ELT processes

Lecture 3: Medallion architecture overview

Lecture 4: Explain the requirements and acceptance criteria of the project

Lecture 5: Explore existing Power Bi reports the Data model and the excel sheets used

Lecture 6: Create the medallion architecture in Fabric using lakehouse and datawarehouses

Lecture 7: Create a New semantic model instead of the default one

Lecture 8: Install SSMS, SQL Server and Restore the Adventure works Database

Lecture 9: Install Fabric Gateway to connect On – Prem SQL server to the cloud

Lecture 10: Connect to SQL server data source and import data – Method 1 : Dataflow Gen 2

Lecture 11: Troubleshooting common errors that might occur in this step

Lecture 12: Connect to and import data – Method 2: Data Factory Pipeline (Optional)

Lecture 13: Ingest Data from Onprem Excel worksheets to Bronze Lakehouse tables

Lecture 14: Explore the Data in Bronze Lakehouse

Chapter 3: ETL – Data Transformation and Loading

Lecture 1: Welcome to Section 3

Lecture 2: Data movement from Bronze Lakehouse to Silver DWH – Method 1: Data flow Gen 2

Lecture 3: Transform the Data from Bronze to Silver – Method 2: Stored procedure

Lecture 4: Create The Silver Datawarehouse views that joins and clean the Data

Lecture 5: Prepare data for reporting : Create GoldDWH tables

Lecture 6: Data Quality Frameworks

Lecture 7: Prepare the Gold semantic model

Lecture 8: Create Data model Entities relationship

Chapter 4: Power BI Integration, Reporting and Automation

Lecture 1: Introduction to Section 4

Lecture 2: Automate data workflows, Set up triggers

Lecture 3: Connect Power BI to Semantic Model – Measure -Calculated column and Date Table

Lecture 4: Creating Power BI Reports in Fabric

Lecture 5: Create a power Bi report for Orders Analysis

Chapter 5: Additional Lectures

Lecture 1: Introduction to DAX

Lecture 2: The usage metrics report

Lecture 3: Thoughts on Microsoft Fabric for Data Warehousing and Analytics

Lecture 4: Known issues about Fabric- August 2024

Instructors

Makram Amor
Azure Big Data Engineer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu