Course
Microsoft Fabric Analytics Engineer – Intensive Training («DP600»)
This course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric.
Duration
4 days
Price
3'400.–
Course documents
Official Microsoft Courseware on Microsoft Learn
Alternative learning format available:
Microsoft Fabric Analytics Engineer – Flexible Training («DP600V»)
Course facts
- Planning, implementing, and managing a solution for data analytics
- Preparing and serving data
- Implementing and managing semantic models
- Exploring and analyzing data
Module 1: Ingest Data with Dataflows Gen2 in Microsoft Fabric
- Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.
- Discover how to use Apache Spark and Python for data ingestion into a Microsoft Fabric lakehouse. Fabric notebooks provide a scalable and systematic solution.
- Microsoft Fabric includes Data Factory capabilities, including the ability to create pipelines that orchestrate data ingestion and transformation tasks.
- Lakehouses merge data lake storage flexibility with data warehouse analytics. Microsoft Fabric offers a lakehouse solution for comprehensive analytics on a single SaaS platform.
- Explore the potential of the medallion architecture design in Microsoft Fabric. Organize and transform your data across Bronze, Silver, and Gold layers of a lakehouse for optimized analytics.
- Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data in a Lakehouse at scale.
- Tables in a Microsoft Fabric lakehouse are based on the Delta Lake storage format commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions.
- Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.
- Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
- Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.
- A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
- Scalable data models enable enterprise-scale analytics in Power BI. Implement data modeling best practices, use large dataset storage format, and practice building a star schema to design analytics solutions that can scale.
- Power BI model relationships form the basis of a tabular model. Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.
- Use tools to develop, manage, and optimize Power BI data model and DAX query performance.
- Enforce model security in Power BI using row-level security and object-level security.
This intensive training prepares you for:
- Exam: «DP-600: Implementing Analytics Solutions Using Microsoft Fabric (beta)» for the
- Certification: «Microsoft Certified: Fabric Analytics Engineer Associate»