Advanced Microsoft Fabric Implementation and Governance

Course details

Microsoft Fabric is an integrated cloud data environment that includes data lakehouses, warehousing, data transformation, and machine learning. It can combine data from several sources into one environment, simplifying your various tools into a single solution. If you’ve started on learn some of the broader aspects of Fabric and want to dive deeper, join Microsoft Data Platform MVP and Microsoft Certified Trainer Ginger Grant in this course as she shows you the essential aspects for developing and managing Microsoft Fabric, so you can be prepared to scale your projects to provide organization-wide solutions in Microsoft Fabric. Learn advanced features like governance, source control, pipeline development, and data transformation with Spark.

Learning objectives
Explain what features are possible to implement.
Discuss enterprise governance in Microsoft Fabric, including topics such as security, workspace management, and data organization.
Transforming data using Python and Spark, including not only how to write it but also how to implement it in a pipeline with parameters.
Learn about DevOps for Power BI and Fabric elements, a requirement for enterprise level development and management.
Improve the performance and management of the Data Warehouse in Microsoft Fabric.

Concepts

0. Introduction

01 - Enterprise data with advanced Fabric
02 - Prerequisite course knowledge and resources
03 - Walkthrough of course resources

1. Understanding Fabric Licensing Elements

04 - Licensing features and options
05 - Limitations of Fabric SKU and license
06 - Workspace capacity management
07 - Install and use the Fabric Capacity Metrics app
08 - Tips for decreasing Azure spend

2. Fabric Reporting Source Control

09 - Implementing source control for Fabric content
10 - Power BI project files
11 - Configuration for Power BI, GitHub, and VS Code
12 - Comparing versions
13 - Branching and Git management
14 - Challenge - Adding a report to GitHub
15 - Solution - Review of source control integration in GitHub

3. Fabric DevOps Integration

16 - Overview of Azure DevOps and online source control
17 - Azure DevOps configuration and use
18 - Check-ins and rollbacks
19 - Power BI development pipelines
20 - Challenge - Implementing Azure DevOps
21 - Solution - Implementing Azure DevOps

4. Fabric Governance

22 - OneLake and workspaces
23 - Creating data mesh architecture
24 - Monitoring and management
25 - Tenant admin settings
26 - Data access permissions and workspaces

5. Warehouse and Lakehouse Security and Configuration

27 - Data warehouse or lakehouse
28 - Integrating Azure security and Fabric data security
29 - Implementing database security
30 - Data masking
31 - Improving query performance for lakehouses and warehouses
32 - Challenge - Implement data masking
33 - Solution - Demonstrating data masking

6. Pipeline

34 - Pipeline review and Azure compute
35 - Parameter use in pipelines
36 - Restartable pipeline techniques
37 - Incremental pipeline loading
38 - Scheduling and monitoring

7. Advanced ETL with Spark

39 - Getting started with Spark
40 - Review Fabric specific notebook elements
41 - Copilot in Fabric Spark
42 - Writing Fabric Spark in VS Code
43 - Monitoring Spark jobs

Conclusion

44 - Further your knowledge with Fabric