Cart 0

Microsoft Fabric Analytics Engineer (DP-600)

Course Outline

This Microsoft Fabric Analytics Engineer (DP-600) course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will build on existing analytics experience and will learn how to use Microsoft Fabric components, including lakehouses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytics assets.

Microsoft Fabric Analytics Engineer (DP-600) Benefits

  • In this course, you will learn how to:

    • Plan, implement, and manage a solution for data analytics. 
    • Prepare and serve data. 
    • Implement and manage semantic models. 
    • Explore and analyze data. 
    • Prepare for the Implementing Analytics Solutions Using Microsoft Fabric certification exam. 

  • Training Prerequisites

    While there are no required prerequisites for taking this course, it is recommended that students have: 

    • A foundational knowledge of core data concepts and how they’re implemented using Microsoft data services (see: Microsoft Azure AI Fundamentals Training (AI-900)) 
    • Experience designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI (see: Power BI Data Analyst Training Course (PL-300)) 

  • Certification Information

    This course maps directly to and is intended to prepare students for the DP-600: Implementing Analytics Solutions Using Microsoft Fabric exam 

Microsoft Fabric Analytics Engineer (DP-600) Training Outline

Course Introduction 

  • Explore end-to-end analytics with Microsoft Fabric 
  • Administer Microsoft Fabric 

    Data Ingestion 

    • Ingest data with Dataflows (Gen2) in Microsoft Fabric 
    • Ingest data Spark and Microsoft Fabric notebooks 
    • Use Data Factory pipelines in Microsoft Fabric 

      Lakehouses in Microsoft Fabric 

      • Get started with lakehouses in Microsoft Fabric 
      • Organize a Fabric lakehouse using medallion architecture 

        Apache Spark in Microsoft Fabric 

        • Use Apache Spark in Microsoft Fabric 
        • Work with Delta Lake tables in Microsoft Fabric 
        • Secure your Fabric lakehouse 

          Data Warehouses in Microsoft Fabric 

          • Get started with data warehouses in Microsoft Fabric 
          • Load data into a Microsoft Fabric data warehouse 

            Query and Optimization 

            • Query a data warehouse in Microsoft Fabric 
            • Monitor and optimize a Microsoft Fabric data warehouse 

              Power BI Scalability 

              • Understand scalability in Power BI 
              • Create Power BI model relationships 
              • Use tools to optimize Power BI performance 

                Power BI Security and Conclusion 

                • Enforce Power BI model security 
                • Course conclusion 
                Course Dates - North America
                Course Dates - Europe
                Attendance Method
                Additional Details (optional)