Microsoft Fabric - The Complete Guide

Master Microsoft Fabric from Foundation to Mastery: A Practical and Comprehensive Guide

  • 0.0 (0 Reviews)
  • 0 Students
  • 106 Lessons
  • Nikolai Schuler

Course Overview

Mastering Microsoft Fabric: The Future of Analytics

This is your definitive guide to master every aspect of Microsoft Fabric.

Dive deep into practical, hands-on learning to be equipped you with all you need to excel in Microsoft Fabric.


Why This Course?


  • Complete & Comprehensive: This course covers every aspect of Microsoft Fabrics's expansive suite. Just one course with real and practical outcomes.

  • Real-World Scenarios: Learn how to automate data flows, deploy and automate machine learning models, create real-time analytics pipelines and how everything is connected.

  • Conceptual Understanding: From understanding OneLake infrastructure to unlocking the potential of the Data Activator. This course is meticulously designed to provide an extensive understanding of the Microsoft Fabric's suite.

  • Practical, Hands-On Experience: Engage with real-world scenarios and apply what you learn directly within the Microsoft Fabric environment.


What Will You Achieve?

From foundational principles to advanced applications, this course equips you with all you need in Microsoft Fabric.

  • Data Engineering: Gain expertise in data transformation and management using Microsoft Fabric's powerful data engineering tools.

  • Data Factory: Master the use of Data Factory for efficient data integration and transformation, enabling scalable ETL processes and data pipelines.

  • Data Activator: Learn how to utilize Data Activator to streamline the activation and availability of your data assets for analytics and decision-making.

  • Data Warehousing: Acquire the knowledge to implement and manage robust data warehousing solutions, ensuring data is structured, stored, and ready for analysis.

  • Data Science and Machine Learning: Build and deploy machine learning models, integrating AI into your analytics workflows.

  • Real-Time Analytics: Tackle the fastest-growing data category with confidence, mastering the handling of observational data.

  • Power BI & Business Intelligence: Empower decision-making with Power BI, accessing all the data in Fabric swiftly and effectively.


Who Should Enroll?


  • Aspiring data engineers and architects seeking to lead in the analytics domain.

  • Seasoned professionals aiming to specialize in Microsoft Fabric's analytics & data engineering capabilities.

  • Anyone looking to gain valuable, in-demand skills in the era of AI-powered analytics.

Enrollment Benefits:


  • Complete Coverage: From basics to advanced topics, we provide a structured journey through Microsoft Fabric's capabilities.

  • Real-World Applications: Equip yourself with skills that translate directly to the workplace.

  • Lifetime Access: Enjoy lifelong access to the course materials and updates.

  • Community and Support: Join a community of like-minded learners and receive dedicated support to accelerate your learning journey.


Elevate Your Career with Real Skills

Enroll now to gain the skills that will put you at the forefront of data analytics innovation.

See you inside the course!

See more

FAQ

FAQ area empty

Course curriculum

10 chương 106 bài học 9 giờ 58 phút 7 bài học thử miễn phí
Chương 1 Getting started with Fabric
Chương 2 OneLake & Lakehouses
  • OneLake Học thử 2:32
  • Workspaces 3:09
  • Lakehouses Học thử 2:41
  • Unified Fabric Developer Experience 3:42
  • Exploring workspaces 3:58
  • Create a lakehouse 5:56
  • Load data into lakehouse 3:59
  • Load data into tables 6:42
  • Exploring Delta Tables 4:34
  • Using Dataflow Gen 2 14:23
  • OneLake file explorer 5:19
  • Using SQL analytics endpoint 5:53
  • Build a visual query 7:39
  • Creating shortcuts 7:23
  • Managing access & sharing 5:00
Chương 3 Power BI & Semantic Models
  • Understanding semantic models 7:11
  • Create new semantic model 7:48
  • Creating measures 5:26
  • Connect to Fabric from Power BI Desktop 9:54
  • Using SQL endpoint 4:32
  • Auto Create Reports 7:09
  • Creating Apps 8:38
  • Updating & Deleting Apps 4:47
Chương 4 Data Factory
  • Understanding Pipelines & Data Flow Gen2 2:45
  • Copy Data Activity 11:46
  • Adding DataFlow Gen 2 to Pipeline 12:17
  • Disable Staging for better performance 6:32
  • Schedule Data Pipeline 2:37
  • Troubleshoot & Monitor Data Pipeline 3:10
Chương 5 Data Warehouses
  • What is a warehouse 6:47
  • Creating a data warehouse 3:52
  • Create Table 5:32
  • INSERT & UPDATE data 4:59
  • Alter Table Schema 6:45
  • Calculating colmuns & Schema Updates 5:42
  • COPY INTO command 5:12
  • Copy Data using Pipeline 8:26
  • Referencing SQL endpoints from Lakehouses 5:27
  • Cloning tables 6:29
  • Using Warehouse (via Semantic Model) in Power BI 2:41
Chương 6 Data Engineering
  • Spark in Fabric 7:27
  • Creating a data frame 7:28
  • Exploring the notebooks 6:50
  • Uploading & reading files 4:51
  • Connect a lakehouse 7:34
  • Defining the schema 6:42
  • Filtering Data 4:52
  • Modify Schema 4:05
  • Adding columns 4:05
  • Aggregating & Grouping 5:38
  • Using functions 3:07
  • Joining DataFrames 5:26
  • Writing files to lakehouse 8:03
  • Writing to Delta Tables 4:20
  • SparkSQL queries 5:49
  • Temporary views 4:04
  • Using Python & SQL 6:37
  • Scheduling notebooks 3:19
  • Integrating notebooks in pipelines 3:32
  • Spark settings 5:21
  • Spark job definition 6:38
  • Schedule Spark job definition 3:10
Chương 7 Real-Time Analytics
  • Basics of Real-Time Analytics in Fabric 5:14
  • Main Building Blocks of Real-Time Analtics in Fabric 7:49
  • Creating a KQL database 6:40
  • Basics of KQL 5:04
  • Sorting & Filtering 3:31
  • Aggregating & Grouping 6:19
  • Visulizing Data 4:05
  • Getting data 4:36
  • Joining data 3:32
  • Creating Eventstream 6:08
  • Routing streaming data to into KQL database 6:30
  • Event Processing 11:00
  • Connecting KQL database to Power BI 5:52
  • Ingesting stream into lakehouse 7:45
  • Real-time data in notebooks 3:21
  • Retention policies 2:47
  • Deleting Eventstream 1:05
Chương 8 Data Science
  • Data Science Introduction 7:08
  • Setup of Notebook & Load Data 10:40
  • Creating Pandas Dataframe 3:07
  • Data Cleansing using Data Wrangler 8:46
  • Exploratory Analysis - Distributions 10:54
  • Feature Impact Analysis 3:16
  • Feature Engineering 6:54
  • Connecting the results to Power BI 2:25
  • Setting up experiments & understanding models 6:21
  • Split and Sample Training Data 3:45
  • Train Model 2:38
  • Exploring Experiment & Metrics 7:32
  • Understanding ROC & Precision Recall Curve 6:16
  • Comparing different models 7:38
  • Save run as ML model 1:46
  • Applying the ML model 6:38
Chương 9 Data Activator
  • Fabric Activator Overview 1:53
  • Create Reflex from Power BI data 7:39
  • Add data from Eventstream 7:19
  • Create Triggers from Objects 4:44
Chương 10 Bonus
  • Bonus

Requirment

  • No previous experience is needed. You will learn everythign you need to know

  • Microsoft Fabric trial account

Outcomes

  • Enhance your career with practical, hands-on Microsoft Fabric expertise.

  • Architect secure, scalable solutions across the Microsoft Fabric platform.

  • Navigate Microsoft Fabric's ecosystem for advanced data science applications.

  • Leverage Power BI for dynamic data visualizations.

  • Master real-time analytics for immediate insights from observational data.

  • Develop and deploy machine learning models within Microsoft Fabric.

  • Design and manage comprehensive Data Warehousing solutions for analytics.

  • Utilize Data Activator for effective data asset management and analytics.

  • Implement Data Factory processes for scalable ETL and data integration.

  • Master Microsoft Fabric's data engineering tools for robust data solutions.

Instructor

...
Nikolai Schuler

0.0

  • ... 0 Student
  • ... 1 Course
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all