DP-600T00: Microsoft Fabric Analytics Engineer
Microsoft Fabric Analytics Engineer
DP-600T00: Microsoft Fabric Analytics Engineer


- Understand the fundamentals of end-to-end analytics using Microsoft Fabric, enabling a holistic view of data analytics processes.
- Learn to administer and manage Microsoft Fabric environments effectively, ensuring smooth operation and maintenance.
- Master Dataflows Gen2 in Microsoft Fabric for efficient data ingestion and processing.
- Gain proficiency in using Spark and Microsoft Fabric notebooks for data ingestion and exploratory data analysis.
- Develop skills to create and manage Data Factory pipelines, enhancing data integration and workflow automation in Microsoft Fabric.

What to train your team? Get a quote
Fundamental Learnings
Training by Top Microsoft-Certified Trainers
1 Day of Live, Instructor-Led Sessions
Latest, Up-to-date Curriculum, Approved by Industry Experts
Access to a Digital Library of Learning Resources
Comprehensive Knowledge of Core Learnings
Blend of classroom sessions and hands-on training
Prerequisites for this Courese
Prerequisites and Eligibility
- Experience in Data Analytics – Knowledge of data modeling, transformation, and visualization (Power BI experience is helpful).
- Basic Understanding of Microsoft Fabric – Familiarity with components like Dataflows, Pipelines, Notebooks, Semantic Models, Data Warehouses, and Lakehouses.
- Programming Knowledge – Experience with SQL, KQL (Kusto Query Language), or DAX (Data Analysis Expressions).
- Cloud & Microsoft Services Awareness – Basic understanding of cloud computing and Microsoft Azure services.
- Recommended Prior Certification – PL-300: Power BI Data Analyst (optional but beneficial for understanding data analysis and visualization).

Things Included in the course learning
Course Curriculum
1. Introduction to end-to-end analytics using Microsoft Fabric
2. Administer Microsoft Fabric
3. Ingest Data with Dataflows Gen2 in Microsoft Fabric
4. Ingest Data with Spark and Microsoft Fabric Notebooks
5. Use Data Factory Pipelines in Microsoft Fabric
6. Get Started with Lakehouse’s in Microsoft Fabric
7. Organize a Fabric Lakehouse Using Medallion Architecture Design
8. Use Apache Spark in Microsoft Fabric
9. Work with Delta Lake Tables in Microsoft Fabric
10. Secure Your Lakehouse (Content is in Admin Module)
11. Get Started with Data Warehouses in Microsoft Fabric
12. Load Data into a Fabric Data Warehouse
13. Query a Data Warehouse in Microsoft Fabric
14. Monitor and optimize a Microsoft Fabric Data Warehouse
15. Model a Data Warehouse in Microsoft Fabric
16. Secure Your Warehouse
17. Understand Scalability in Power BI
18. Create Power BI Model Relationships
19. Use Tools to Optimize Power BI Performance
20. Enforce Power BI Model Security
Things Included in the course learning
Our Learners Love Us

Recently attended the Scrum Master course. The instructor demonstrated profound knowledge of Agile methodologies and Scrum in particular. Comprehensive course materials, including slides, workbooks, and supplementary readings, have become invaluable resources that I frequently reference in my daily role.

This is an amazing training ecosystem. They had assigned individual relationship managers who not only did the tactical things of reminding of sessions etc, but they also connected me with people who were experts for career guidance. This is the best example of customer delight - you not just engage clients but delight them! Highly recommended for Agile related courses.

I did a PSM-1course from One iTech and it was truly an enriching experience. The trainer was very good and has full expertise on the subject. He was quite interactive and engaging, always ensured everyone understood the concepts and fundamentals of Scrum Agile. He kept revising and recapping all important concepts throughout the session during these two days.

One iTech is very professional in handling entire process. They make sure all the support is provided during training and afterwards. I have done 2 courses with them and both times it was a great experience. The workshop was a well-organized event. The trainer was an expert which made it a valuable training.

What will I learn in this course
Output of this Course
- Understand the fundamentals of end-to-end analytics using Microsoft Fabric, enabling a holistic view of data analytics processes.
- Learn to administer and manage Microsoft Fabric environments effectively, ensuring smooth operation and maintenance.
- Master Dataflows Gen2 in Microsoft Fabric for efficient data ingestion and processing.
- Gain proficiency in using Spark and Microsoft Fabric notebooks for data ingestion and exploratory data analysis.
- Develop skills to create and manage Data Factory pipelines, enhancing data integration and workflow automation in Microsoft Fabric.
- Get started with lakehouses in Microsoft Fabric, learning how to leverage them for combining the best elements of data lakes and data warehouses.
- Organize a Fabric lakehouse using the medallion architecture design to optimize data storage and access patterns.
- Employ Apache Spark within Microsoft Fabric for large-scale data processing.
- Work with Delta Lake tables in Microsoft Fabric to ensure data reliability and improve performance for batch and streaming workloads.
- Learn to secure your lakehouse and data warehouses within Microsoft Fabric, emphasizing data governance and compliance.
- Understand scalability considerations in Power BI to manage growing data and user demands.
- Create and manage Power BI model relationships to facilitate complex data analysis and reporting.
- Utilize tools and techniques to optimize Power BI performance, ensuring efficient data visualization experiences.
- Enforce Power BI model security to protect sensitive data and maintain integrity across reports and dashboards.
Who is this course for
- Data Engineers
- Data Analysts
- Data Architects
- Data Scientists
- Database Administrators
- Business Intelligence Professionals
- IT Managers overseeing data management teams
- Cloud Solutions Architects focusing on data services
- Data Security Analysts
- Professionals aiming to learn about data warehousing and lakehouse architecture
- Power BI Developers
- Anyone seeking to specialize in Microsoft's data analytics tools and services

No Post Found