Microsoft Fabric Analytics Engineer DP600 Training in Oxford

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

Who Should Attend this Microsoft Fabric Analytics Engineer DP600 Training?

This course is ideal for professionals who work with large datasets and are involved in managing or developing data analytics solutions in cloud-based environments. The course is suitable for individuals aiming to enhance their skills in Microsoft Fabric and develop a deep understanding of analytics engineering.

• Data Engineers
• Analytics Engineers
• Cloud Solution Architects
• Data Analysts
• Business Intelligence Developers
• Database Administrators
• Solution Architects

Prerequisites for this Microsoft Fabric Analytics Engineer DP600 Training

This course is best suited for those who have the PL-300 certification or similar expertise in using Power BI for data transformation, modeling, visualisation, and sharing. Also, learners should have prior experience in building and deploying data analytics solutions at the enterprise level.

Microsoft Fabric Analytics Engineer DP600 Training Course Overview

Microsoft Fabric is a unified, end-to-end platform for analytics, offering robust tools to manage data pipelines, implement analytics, and provide real-time insights across multiple data environments. The DP600 training focuses on empowering professionals to gain the necessary skills to work with Microsoft Fabric's analytics capabilities, ensuring smooth integration and effective decision-making.

The Knowledge Academy’s 4-day Microsoft Fabric Analytics Engineer DP600 course is designed to provide in-depth knowledge of Microsoft Fabric, focusing on managing and analysing data in cloud-based environments. Throughout the course, you will explore the fundamental concepts of data storage, ingestion, processing, and visualisation within Microsoft Fabric. You will gain hands-on experience with various tools, services, and best practices for building data solutions that scale and deliver real business value.

Microsoft Fabric Analytics Engineer DP600 Course Objectives

• Understand the fundamentals of Microsoft Fabric for analytics
• Learn how to create, manage, and optimise data pipelines
• Implement analytics solutions using Microsoft Fabric services
• Gain insights into managing and analysing big data
• Explore real-time analytics and data visualisation
• Learn how to optimise performance and scalability in analytics solutions

After attending this training, delegates will have the ability to confidently manage Microsoft Fabric environments, build robust data pipelines, implement real-time analytics solutions, and visualise data for informed decision-making. Additionally, they will be equipped to troubleshoot common issues, ensure scalability, and optimise performance in large-scale data environments.

What’s included in this Microsoft Fabric Analytics Engineer DP600 Training Course?

• World-Class Training Sessions from Experienced Instructors
• Microsoft Fabric Analytics Engineer DP600 Training Certificate
• Digital Delegate Pack