Microsoft Fabric Analytics Engineer DP600 Training Course - Portugal

Microsoft Fabric Analytics Engineer DP600 Training Course Outline

Module 1: Introduction to End-to-End Analytics Using Microsoft Fabric

• Introduction
• Explore End-to-End Analytics with Microsoft Fabric
• Data Teams and Microsoft Fabric
• Enable and Use Microsoft Fabric

Module 2: Get Started with Lakehouses in Microsoft Fabric

• Introduction
• Explore the Microsoft Fabric Lakehouse
• Work with Microsoft Fabric Lakehouses
• Explore and Transform Data in a Lakehouse

Module 3: Use Apache Spark in Microsoft Fabric

• Introduction
• Prepare to Use Apache Spark
• Run Spark Code
• Work with Data in a Spark Dataframe
• Work with Data Using Spark SQL
• Visualise Data in a Spark Notebook

Module 4: Work with Delta Lake Tables in Microsoft Fabric

• Introduction
• Understand Delta Lake
• Create Delta Tables
• Optimise Delta Tables
• Work with Delta Tables in Spark
• Use Delta Tables with Streaming Data

Module 5: Orchestrate Processes and Data Movement with Microsoft Fabric

• Introduction
• Understand Pipelines
• Use the Copy Data Activity
• Use Pipeline Templates
• Run and Monitor Pipelines

Module 6: Ingest Data with Dataflows Gen2 in Microsoft Fabric

• Introduction
• Understand Dataflows Gen2 in Microsoft Fabric
• Explore Dataflows Gen2 in Microsoft Fabric
• Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric

Module 7: Get Started with Data Warehouses in Microsoft Fabric

• Introduction
• Understand Data Warehouse Fundamentals
• Understand Data Warehouses in Fabric
• Query and Transform Data
• Prepare Data for Analysis and Reporting
• Secure and Monitor Your Data Warehouse

Module 8: Get Started with Real-Time Intelligence in Microsoft Fabric

• Introduction
• What Is Real-Time Data Analytics?
• Real-Time Intelligence in Microsoft Fabric
• Ingest and Transform Real-Time Data
• Store and Query Real-Time Data
• Visualise Real-Time Data
• Automate Actions

Module 9: Get Started with Data Science in Microsoft Fabric

• Introduction
• Understand the Data Science Process
• Explore and Process Data with Microsoft Fabric
• Train and Score Models with Microsoft Fabric

Module 10: Administer a Microsoft Fabric Environment

• Introduction
• Understand the Fabric Architecture
• Understand the Fabric Administrator Role
• Manage Fabric Security
• Govern Data in Fabric

Module 11: Get Started with Data Warehouses in Microsoft Fabric

• Introduction
• Understand Data Warehouse Fundamentals
• Understand Data Warehouses in Fabric
• Query and Transform Data
• Prepare Data for Analysis and Reporting
• Secure and Monitor Your Data Warehouse

Module 12: Load Data into a Microsoft Fabric Data Warehouse

• Introduction
• Explore Data Load Strategies
• Use Data Pipelines to Load a Warehouse
• Load Data Using T-SQL
• Load and Transform Data with Dataflow Gen2

Module 13: Query a Data Warehouse in Microsoft Fabric

• Introduction
• Query Data
• Use the SQL Query Editor
• Explore the Visual Query Editor
• Use Client Tools to Query a Warehouse

Module 14: Monitor a Microsoft Fabric Data Warehouse

• Introduction
• Monitor Capacity Metrics
• Monitor Current Activity
• Monitor Queries

Module 15: Secure a Microsoft Fabric Data Warehouse

• Introduction
• Explore Dynamic Data Masking
• Implement Row-Level Security
• Implement Column-Level Security
• Configure SQL Granular Permissions Using T-SQL

Module 16: Add Measures to Power BI Desktop Models

• Introduction
• Create Simple Measures
• Create Compound Measures
• Create Quick Measures
• Compare Calculated Columns with Measures

Module 17: Design Scalable Semantic Models

• Introduction
• Choose the Best Storage Mode
• Configure Semantic Models for Large Data
• Work with Relationships
• Write DAX for Readability with Complex Calculations
• Create Dynamic Calculation Elements

Module 18: Optimise a Model for Performance in Power BI

• Introduction to Performance Optimisation
• Review Performance of Measures, Relationships, and Visuals
• Use Variables to Improve Performance and Troubleshooting
• Reduce Cardinality
• Optimise DirectQuery Models with Table Level Storage
• Create and Manage Aggregations

Module 19: Create and Manage Power BI Assets

• Introduction
• Create Reusable Power BI Assets
• Manage Development Lifecycle for Power BI Assets
• Use Lineage View and Endorse Data Assets
• Manage a Power BI Semantic Model Using XMLA Endpoint

Module 20: Enforce Power BI Model Security

• Introduction
• Restrict Access to Power BI Model Data
• Restrict Access to Power BI Model Objects
• Apply Good Modeling Practices

Module 21: Administer a Microsoft Fabric Environment

• Introduction
• Understand the Fabric Architecture
• Understand the Fabric Administrator Role
• Manage Fabric Security
• Govern Data in Fabric

Module 22: Secure Data Access in Microsoft Fabric

• Introduction
• Understand the Fabric Security Model
• Configure Workspace and Item Permissions
• Apply Granular Permissions

Module 23: Secure a Microsoft Fabric Data Warehouse

• Introduction
• Explore Dynamic Data Masking
• Implement Row-Level Security
• Implement Column-Level Security
• Configure SQL Granular Permissions Using T-SQL

Module 24: Govern Data in Microsoft Fabric with Purview

• Introduction
• Govern Data in Microsoft Fabric
• Why Use Microsoft Purview with Microsoft Fabric?
• Govern Data in the Microsoft Purview Hub