You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
This course prepares you for the DP-700 certification exam, covering all official exam domains and their approximate weightings:
Domain 1 Implement and manage an analytics solution (32.5%)
- Configure Microsoft Fabric workspace settings (Spark, domain, OneLake, Apache Airflow)
- Implement lifecycle management: version control, database projects, deployment pipelines
- Configure security and governance: workspace/item-level access controls, row/column/object/file-level security, dynamic data masking, sensitivity labels, item endorsement, audit logs, OneLake security
- Orchestrate processes: choose between Dataflow Gen2, pipeline, and notebook; design schedules and event-based triggers; implement orchestration patterns with parameters and dynamic expressions
Domain 2 Ingest and transform data (32.5%)
- Design and implement full and incremental data loading patterns, including for dimensional models and streaming data
- Ingest and transform batch data: choose appropriate data store and transformation tool (Dataflows Gen2, notebooks, KQL, T-SQL), create OneLake shortcuts, implement mirroring, ingest via pipelines
- Transform data using PySpark, SQL, and KQL; denormalize, group/aggregate data; handle duplicate, missing, and late-arriving data
- Ingest and transform streaming data: choose streaming engine, process data via Eventstreams, Spark structured streaming, and KQL; create windowing functions
Domain 3 Monitor and optimize an analytics solution (32.5%)
- Monitor Fabric items: data ingestion, data transformation, semantic model refresh, and configure alerts
- Identify and resolve errors in pipelines, Dataflow Gen2, notebooks, Eventhouse, Eventstream, T-SQL, and OneLake shortcuts
- Optimize performance of Lakehouse tables, pipelines, data warehouses, Eventstreams/Eventhouses, Spark jobs, and queries
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:
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Data Engineer
- Azure Data Engineer
- Cloud Data Engineer
- Business Intelligence Developer
- Data Architect
- Data Scientist
- Machine Learning Engineer
- Big Data Engineer
- Data Analyst
- Database Administrator
- Cloud Solutions Architect
- DevOps Engineer
- Software Developer
- IT Professional
- Systems Analyst
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)
- Learned a lot Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 5/8/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 - Practical and relevant Review by Course Participant/Trainee
-
The trainer is an expert in the subject and shared many practical insights from real projects. (Posted on 4/12/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 - Excellent course Review by Course Participant/Trainee
-
Really enjoyed the training. The examples were relevant and the pace was just right. (Posted on 3/25/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 - Clear and easy to follow Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 12/11/2025)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 - Worth every cent Review by Course Participant/Trainee
-
The course content was comprehensive and up to date. The practical exercises were the best part. (Posted on 8/17/2025)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
