You have no items in your shopping cart.
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, and row/column/object/file-level access controls
- Apply sensitivity labels to items and endorse items
- Configure version control (Git integration) for a workspace
- Create and manage Power BI Desktop projects (.pbip) and configure deployment pipelines
- Perform impact analysis of downstream dependencies across lakehouses, warehouses, dataflows, and semantic models
- Deploy/manage semantic models via the XMLA endpoint and build 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; choose between data stores
- Ingest/access data and implement OneLake integration for Eventhouse and semantic models
- Create views, functions, and stored procedures; implement a star schema; denormalize, aggregate, and merge/join data
- Enrich data with new columns/tables; resolve duplicate, missing, or null data; convert data types; filter data
- Select, filter, and aggregate data using the Visual Query Editor
- Select, filter, and aggregate data using SQL, KQL, and DAX
Domain 3 Implement and manage semantic models (27.5%)
- Choose a storage mode and implement a star schema for a semantic model
- Implement relationships, including bridge tables and many-to-many relationships
- Write DAX calculations using variables and functions (iterators, table filtering, windowing, information functions)
- Implement calculation groups, dynamic format strings, field parameters, and design composite models
- Configure Direct Lake, including default fallback/refresh behavior, and choose Direct Lake on OneLake vs. SQL analytics endpoint
- Improve query, report-visual, and DAX performance; implement incremental refresh for semantic models
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:
TBD
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Data Analyst
- Business Intelligence Analyst
- Database Administrator
- Data Scientist
- Data Engineer
- Azure Solution Architect
- Cloud Engineer
- Data Architect
- Machine Learning Engineer
- AI Developer
- Business Analyst
- Data Consultant
- Big Data Engineer
- SQL Developer
- Data Manager
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)
- Well structured course Review by Course Participant/Trainee
-
The course materials were detailed and easy to reference afterwards. Great value for money. (Posted on 6/5/2026)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 - Very useful course Review by Course Participant/Trainee
-
Good hands-on training with plenty of examples. I feel much more confident applying these skills now. (Posted on 6/3/2026)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 - Learned a lot Review by Course Participant/Trainee
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 4/13/2026)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 - Learned a lot Review by Course Participant/Trainee
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 2/9/2026)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 - Exceeded my expectations Review by Course Participant/Trainee
-
I found the course extremely useful and relevant to my job. Highly recommend it to others. (Posted on 2/6/2026)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
Write Your Own Review
- Recommended Courses
