DP-600T00: Microsoft Fabric Analytics Engineer Training

The DP-600T00: Microsoft Fabric Analytics Engineer course is a comprehensive, hands-on training program focused on end-to-end data analytics using Microsoft Fabric. This course is designed for data professionals to understand the key components and capabilities of Microsoft Fabric, including Dataflows Gen2, Apache Spark, Delta Lake, Lakehouse architecture, Data Factory pipelines, Power BI, and data security.

Through real-world use cases, participants will learn how to ingest, organize, manage, analyze, and secure data efficiently. Emphasis is placed on Lakehouse and Data Warehouse design, performance optimization, and governance, enabling participants to build scalable and secure analytics solutions within the Microsoft ecosystem.

Understand the architecture and components of Microsoft Fabric for end-to-end analytics.

Administer and configure Microsoft Fabric environments

Ingest data using Dataflows Gen2, Apache Spark, and Data Factory pipelines.

Design and manage Lakehouse environments using Medallion architecture.

Create and manage Delta Lake tables.

Load, query, monitor, and optimize data warehouses.

Model data for analytics and reporting in Power BI.

Secure Lakehouse and Data Warehouse environments.

Understand and implement Power BI scalability, model relationships, performance tuning, and security best practices.

Data Engineers

Data Analysts

Data Architects

Data Scientists

Database Administrators

Business Intelligence (BI) Professionals

IT Managers managing data and analytics teams

Cloud Solutions Architects working on Azure Data Services

Data Security Analysts

Power BI Developers

Professionals exploring Lakehouse and Data Warehouse solutions

Anyone pursuing a specialization in Microsoft’s data analytics services

Overview of Microsoft Fabric and its ecosystem
Introduction to OneLake, Synapse, Power BI, and AI integration

Managing workspaces and capacities
Roles, permissions, and governance
Tenant settings and user access

Creating and managing Dataflows Gen2
Connecting to multiple data sources
Transformation and scheduling

Introduction to Spark in Microsoft Fabric
Creating and running notebooks
Spark for ETL and analytics

Building pipelines using Data Factory
Managing pipeline activities and triggers
Monitoring and troubleshooting pipelines

Lakehouse concepts and creation
Managing data in Lakehouses
Differences between Lakehouse and traditional storage

Understanding Bronze, Silver, and Gold layers
Implementing the Medallion pattern in Fabric
Data transformation strategies

Advanced Spark transformations
Caching, partitioning, and optimization
Use cases in data engineering

Introduction to Delta Lake
Creating, updating, and querying Delta tables
Versioning and schema evolution

Role-based access control
Data masking and encryption
Security best practices (covered in Module 2)

Creating a Data Warehouse
Differences between Lakehouse and Data Warehouse

Methods of data ingestion
Staging and bulk load techniques

Writing SQL queries
Analyzing and joining datasets
Performance considerations

Usage metrics and diagnostics
Indexing and partitioning strategies
Performance tuning techniques

Creating star and snowflake schemas
Implementing relationships
Managing dimensions and facts

Security roles and permissions
Data governance policies
Compliance and auditing

DirectQuery vs Import mode
Managing large datasets
Optimization for performance

Relationships and cardinality
Filtering behaviors and modeling best practices

Performance Analyzer
DAX Studio and VertiPaq Analyzer
Aggregations and query reduction

Row-Level Security (RLS)
Object-Level Security (OLS)
Workspace and app-level permissions

Expert Trainers

Learn from experienced professionals and industry experts with real-world knowledge.

Hands-On Training

Gain practical experience through real-world scenarios, projects, and interactive exercises.

Customizable Corporate Training

Tailored solutions to meet the unique needs of organisations and teams.

Certifications & Assistance

Courses are aligned with international standards and we also help you to prepare for globally recognised certifications.

Global Recognition

Trusted by individuals and enterprises worldwide, with a track record of successful alumni and partnerships.

24 x 7 Expert Support

We have a 24x7 online support team to resolve all your technical queries, through a ticket-based tracking system, for a lifetime.

“The training was thorough, covering Azure Stack deployment, management, and troubleshooting in detail. The faculty’s practical approach helped me apply concepts immediately at work. Iteanz’s post-training support is commendable—great for career advancement!”

Pragya Khaitan

Systems Administrator

“AZ-600T00 course was well-structured with a perfect balance of theory and labs. The trainer’s expertise in Azure Stack operations stood out. Iteanz’s learning resources and responsive support made this a worthwhile investment for my cloud career. A solid choice for Azure Stack professionals.”

Omkar Chaurasia

Cloud Consultant

“The AZ-600T00 training from Iteanz helped me learn deployment, configuration, and lifecycle management in Azure Stack Hub in depth. The technical mentor had great command over modules. The environment was stable, and queries were handled on time.”

Shivam Dubey

Azure Support Analyst

“Well-structured AZ-600T00 sessions with detailed coverage of Azure Stack Hub admin tools and role-based access configuration. Iteanz support promptly resolved lab access issues. Faculty interaction was strong and concepts like ARM templates and diagnostics were taught in depth.”

Jyoti Thakur

DevOps Specialist

Iteanz is providing 100% placement assistance on our key courses. We help you with career counseling, Exams on Key courses, Mock Interviews and Technical Interviews Tips.

Landing an interview proves that you have the job-specific skills for the position, but how do your interview skills stack up? Also, Soft skills are often the most important factor in showing you're the best candidate for the job.

Hence we are conducting FREE TRAINING on Soft-Skills worth Rs-25,000 to all Iteanz students which will help you to attend the interviews with more confidence.

Yes. We arrange a free demo for all the courses either in the Classroom or Live-Online demo. Please fill the demo request form to schedule a free demo.

You will never miss a lecture at myTectra. You can choose either of the two options:

Classroom Training:

If you miss one or a few classes we can give a backup class based on the trainer and your convenient time.
In case you miss many classes, we can reschedule your class with upcoming batches or other running batches based on how many course topics you have completed so far.

Live-Online Training:

View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

Just give us a CALL at +91-80-468-10331 OR email at info@iteanz.com

Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email for both classroom training and Online training.

Visa Debit/Credit Card
American Express and Diners Club Card
Master Card
PayPal
Net Banking/Wire Transfer
UPI Payment such as Google Pay, PhonePe, Paytm
Cash/Cheque/DD ( Not for Online Training )

For Individual:

Classroom Training - Bangalore

Live-Online Training - Globally

For Corporates:

Classroom Training - We deliver classroom training for corporate in more than 20 countries. Send us an Enquiry Now!

Online Training - Globally

* All of the classes are conducted live online. They are interactive sessions that enable you to ask questions and participate in discussions during class time. We do, however, provide recordings of each session you attend for your future reference.

Our Trainer’s are chosen not only for their knowledge and expertise but also for their real-time experience in the respective courses.

Explore Our Enterprise Services

DP-600T00: Microsoft Fabric Analytics Engineer Training

Course Overview

Learning Objectives

Who Can Attend

Curriculum

Get Started with a Demo