Microtek Learning Logo

DP-600: Microsoft Fabric Analytics Engineer Training

5
(5)

Use Microsoft Fabric to become a data analytics engineer. Your ability to design, create, and implement data analytics solutions utilizing Microsoft Fabric services is enhanced by the DP-600 training. Discover how to use real-time analytics, data warehousing, data transformation, and ingestion to make data-driven decisions.

  • Accredited By : Microsoft Partner Logo
  • Category : Fabric

Course Price : $2199 Per Participant

Course Description

The DP-600T00 Microsoft Fabric Analytics Engineer training explains techniques and procedures for utilizing Microsoft Fabric to develop and oversee enterprise-scale data analytics solutions. Building on their prior knowledge in analytics, students will learn how to create and distribute analytics assets using Microsoft Fabric components, such as lakehouses, data warehouses, notebooks, data pipelines, dataflows, and semantic models.

The DP-600T00: Microsoft Fabric Analytics Engineer training is most appropriate for individuals with the PL-300 certification or a comparable level of experience with Power BI modeling, data transformation, sharing, and visualization. Additionally, students should have previous expertise developing and implementing enterprise-level data analytics solutions.

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick An introduction to Microsoft Fabric end-to-end analytics
  • green-tick Manage Microsoft Fabric Ingest Data in Microsoft Fabric Using Dataflows Gen2 Ingest data using Spark and Microsoft Fabric notebooks
  • green-tick Utilize Microsoft Fabric Data Factory pipelines.
  • green-tick Use Microsoft Fabric's lakehouses to get started.
  • green-tick Organize a lakeside Fabric employing the design of medallion architecture.
  • green-tick Utilize Microsoft Fabric with Apache Spark
  • green-tick Work in Microsoft Fabric using Delta Lake tables.
  • green-tick Use Microsoft Fabric's data warehouses to get started.
  • green-tick Fill a Microsoft Fabric data warehouse with data.
  • green-tick Use Microsoft Fabric to query a data warehouse
  • green-tick Keep an eye on an Azure Fabric data warehouse.
  • green-tick Recognize how to scale Power BI.
  • green-tick Establish associations in the Power BI model.
  • green-tick Utilize tools to enhance Power BI functionality.
  • green-tick Protect the Power BI model.

Who should attend this course?

Data experts with experience in data modeling, extraction, and analytics make up the majority of the course's audience. Professionals that wish to use Microsoft Fabric to develop and implement enterprise-scale data analytics solutions are intended to use the DP-600.

Microsoft Learning PartnerMicrosoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

GTR
  • calendar Jun 17, 2024
  • time 9:00 am - 5:00 pm EST
  • location online
  • calendar Jul 01, 2024
  • time 9:00 am - 5:00 pm EST
  • location online
  • calendar Jul 22, 2024
  • time 9:00 am - 5:00 pm EST
  • location online
  • calendar Aug 12, 2024
  • time 9:00 am - 5:00 pm EST
  • location online

Can’t Find The Batch You’re Looking For?

Request a Batch

Curriculum

  • Describe end-to-end analytics in Microsoft Fabric
  • Describe Fabric admin tasks
  • Navigate the admin center
  • Manage user access
  • Describe Dataflow (Gen2) capabilities in Microsoft Fabric
  • Create Dataflow (Gen2) solutions to ingest and transform data
  • Include a Dataflow (Gen2) in a pipeline
  • Ingest external data to Fabric lakehouses using Spark
  • Configure external source authentication and optimization
  • Load data into lakehouse as files or as Delta tables
  • Describe pipeline capabilities in Microsoft Fabric
  • Use the Copy Data activity in a pipeline
  • Create pipelines based on predefined templates
  • Run and monitor pipelines
  • Describe core features and capabilities of lakehouses in Microsoft Fabric
  • Create a lakehouse
  • Ingest data into files and tables in a lakehouse
  • Query lakehouse tables with SQL
  • Describe the principles of using the medallion architecture in data management.
  • Apply the medallion architecture framework within the Microsoft Fabric environment.
  • Analyze data stored in the lakehouse using DirectLake in Power BI.
  • Describe best practices for ensuring the security and governance of data stored in the medallion architecture.
  • Configure Spark in a Microsoft Fabric workspace
  • Identify suitable scenarios for Spark notebooks and Spark jobs
  • Use Spark dataframes to analyze and transform data
  • Use Spark SQL to query data in tables and views
  • Visualize data in a Spark notebook
  • Understand Delta Lake and delta tables in Microsoft Fabric
  • Create and manage delta tables using Spark
  • Use Spark to query and transform data in delta tables
  • Use delta tables with Spark structured streaming
  • Describe data warehouses in Fabric
  • Understand a data warehouse vs a data Lakehouse
  • Work with data warehouses in Fabric
  • Create and manage datasets within a data warehouse
  • Learn different strategies to load data into a data warehouse in Microsoft Fabric.
  • Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
  • Learn how to load data in a warehouse using T-SQL.
  • Learn how to load and transform data with dataflow (Gen 2).
  • Use SQL query editor to query a data warehouse.
  • Explore how visual query editor works.
  • Learn how to connect and query a data warehouse using SQL Server Management Studio.
  • Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
  • Monitor current activity in the data warehouse with dynamic management views.
  • Monitor querying trends with query insights views.
  • Describe the importance of building scalable data models
  • Implement Power BI data modeling best practices
  • Use the Power BI large dataset storage format
  • Understand how model relationship work.
  • Set up relationships.
  • Use DAX relationship functions.
  • Understand relationship evaluation.
  • Optimize queries using performance analyzer.
  • Troubleshoot DAX performance using DAX Studio.
  • Optimize a data model using Tabular Editor.
  • Restrict access to Power BI model data with RLS.
  • Restrict access to Power BI model objects with OLS.
  • Apply good development practices to enforce Power BI model security.
  • Course Details

    • cert cert-green
      Certification: YES
    • skill skill-green
      Skill Level: Advanced
    • enroll enroll-green
      Enrolled: 1246
    • duration duration green
      Duration: 4 Days

    Talk to Learning Advisor