• Home
  • DP-600 Microsoft Certified Fabric Analytics Engineer Associate

DP-600 Microsoft Certified Fabric Analytics Engineer Associate

Course Information

  • Sessions 4 days
  • Duration 30 hrs
  • Level Beginner
  • Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Course Brochure

Download Course Brochure

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.

DP-600 Microsoft Certified Fabric Analytics Engineer Associate

Course Code: C1751

Be the first to review this product

Share

What's This Course About

The DP-600 Microsoft Certified Fabric Analytics Engineer Associate course is designed for data professionals seeking to develop deep expertise in end-to-end analytics using Microsoft Fabric. This course equips learners with practical knowledge on lakehouses, Delta Lake tables, dataflows, real-time intelligence, and Apache Spark integration within the Microsoft Fabric ecosystem. Learners will also explore Fabric’s data warehouse capabilities including data loading, querying, monitoring, and securing analytics environments.

Participants will gain hands-on experience working with scalable semantic models in Power BI, performance optimization, and enterprise-grade data governance using Microsoft Purview. The course also covers essential administration tasks and security best practices, ensuring participants are fully prepared to manage and deliver secure, high-performance analytics solutions. Perfect for those preparing for the DP-600 certification, this course empowers data engineers to lead the future of analytics on Microsoft Fabric.

Bonus: Free Practice Exams

Get exam-ready on our Practice Exam Portal — train in realistic Practice Mode and timed Exam Mode, then retake them as many times as you like before the real exam.

Start Practising →

Funding Options

No funding is available for this course

Course Fee

$1,400.00 (GST-exclusive)
$1,526.00 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

This course prepares you for the DP-600 certification exam, covering all official exam domains and their approximate weightings:

Domain 1 Maintain a data analytics solution (27.5%)

  • Implement workspace-level, item-level, row-level, column-level, object-level, and file-level access controls
  • Apply sensitivity labels to items and endorse items
  • Configure version control for a workspace and manage Power BI Desktop projects (.pbip)
  • Create and configure deployment pipelines
  • Perform impact analysis of downstream dependencies (lakehouses, warehouses, dataflows, semantic models)
  • Deploy/manage semantic models via the XMLA endpoint; create reusable assets (.pbit, .pbids, shared semantic models)

Domain 2 Prepare data (47.5%)

  • Create data connections; discover data via OneLake catalog and Real-Time hub; ingest/access data and choose between data stores
  • Implement OneLake integration for Eventhouse and semantic models
  • Create views, functions, and stored procedures; enrich data with new columns/tables
  • Implement a star schema; denormalize, aggregate, merge/join data
  • Identify and resolve duplicate data, missing data, or null values; convert column data types; filter data
  • Query and analyze data using the Visual Query Editor, SQL, KQL, and DAX

Domain 3 Implement and manage semantic models (27.5%)

  • Choose a storage mode; implement a star schema and relationships (bridge tables, many-to-many)
  • Write DAX calculations using variables and functions (iterators, table filtering, windowing, information functions)
  • Implement calculation groups, dynamic format strings, and field parameters
  • Configure large semantic model storage format; design and build composite models
  • Implement performance improvements in queries/report visuals and improve DAX performance
  • Configure Direct Lake (default fallback, refresh behavior, Direct Lake on OneLake vs SQL analytics endpoint); implement incremental refresh

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

free Microsoft Azure account (https://azure.microsoft.com/en-us/) here 

Hardware: Window or Mac Laptops

Job Roles

Job Roles

  • Microsoft Fabric Analytics Engineer
  • Data Warehouse Engineer
  • Power BI Data Modeler
  • Data Architect (Fabric)
  • Business Intelligence Developer
  • Data Platform Engineer
  • Fabric Solutions Consultant
  • Data Integration Engineer
  • Analytics Consultant
  • Spark Developer (Fabric)
  • Delta Lake Data Engineer
  • Real-Time Analytics Engineer
  • Power BI Optimization Specialist
  • Enterprise Data Analyst
  • DataOps Engineer
  • Semantic Model Developer
  • Fabric Administrator
  • Data Governance Analyst
  • Cloud Data Engineer
  • Analytics Platform Consultant

Trainers

Trainers

Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.

Anil is a ACLP certified trainer. He is an Enterprise Cloud and DevOps Consultant , responsible for helping clients to move Virtual data centre to Private Cloud based on OpenStack and Public Cloud ( AWS, Azure and Google cloud) . Consulting and training experience on Devops tool chain like github , Jenkins, Sonarqube, Docker & kubernetes, Cloud foundry, Openshift, Ansible and SaltStack. Lot of my Role is involved design and implementation of a solution and training.

Ajay is a ACLP certied trainer. Ajay is a vendor neutral cloud consultant and training expert on Cloud , with several Private cloud deployments in India and cloud migration knowledge .He is a Cloud and DevOps enthusiast with consulting, deployment and training expertise on OpenStack, AWS, Google Cloud ,Azure, Jenkins, and Docker Ajay has 18 + years Industry experience as IT entrepreneur and 9 years in Cloud and Devops technical consulting, implementation and training area, currently working in capacity of Vice President – Cloud and Devops services handling singapore and India.

Review

Write Your Own Review

You're reviewing: DP-600 Microsoft Certified Fabric Analytics Engineer Associate

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment