• 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

Course Brochure

Download Course Brochure

Certification

By end of the course, learners should be able to:

  • LO1: Input required data into accounting systems accurately and ensure transactions follow regulatory frameworks.

  • LO2: Maintain awareness of changes in managerial accounting standards.
  • LO3: Identify significant accounting and income tax issues.

DP-600 Microsoft Certified Fabric Analytics Engineer Associate

Course Code: C1751

8 Review(s) | Add Your Review

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 →

Microsoft Learning Partner

We are an Authorised Microsoft Learning Partner (Org ID: 5238476). To get the official Microsoft certification, please register your certification exam at a Pearson VUE test center.

WSQ Funding

Full Fee ₵5,500.00 Before GST
GST ₵495.00 9% of fee
Baseline Nett ₵3,245.00 SG/PR age 21+ · 50% funded
MCES / SME Nett ₵2,145.00 SG age 40+ · 70% funded
Funding and Grant Applications

No funding is available for this course

Course Fee

₵5,500.00

Course Date

Course Time

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 info@tertiarycourses.com.gh and we will forward your queries to the subject matter experts and get back to you as soon as possible.

Cancellation & Reschedule Policy

  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
  • Note: the venue of the training is subject to changes due to class size and availability of the classroom. The minimum class size to start a class is 3 Pax.

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

is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies

Review

Customer Reviews (8)

Hands-on and practical Review by Course Participant/Trainee
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
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 1/9/2025)
Practical and relevant Review by Course Participant/Trainee
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
Really enjoyed the training. The examples were relevant and the pace was just right. (Posted on 10/19/2024)
Highly recommended Review by Course Participant/Trainee
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
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 3/1/2024)

Items 6 to 8 of 8 total

per page
Page:
  1. 1
  2. 2

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