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 in Fabric: version control, database projects, deployment pipelines
- Configure security and governance: workspace/item-level access, row/column/object/folder-file-level access, 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 notebooks and pipelines (parameters, dynamic expressions)
Domain 2 Ingest and transform data (32.5%)
- Design and implement full and incremental data loads; prepare data for a dimensional model; design a loading pattern for streaming data
- Ingest and transform batch data: choose 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, use Eventstreams/Spark structured streaming/KQL, choose native tables vs OneLake shortcuts, create windowing functions
Domain 3 Monitor and optimize an analytics solution (32.5%)
- Monitor Fabric items: data ingestion, data transformation, semantic model refresh, 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 warehouse, Eventstreams/Eventhouses, Spark, and query performance
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/) hereHardware: Window or Mac Laptops
Job Roles
Job Roles
- Microsoft Fabric Data Engineer
- Data Ingestion Specialist
- Real-Time Analytics Engineer
- Lakehouse Developer
- Apache Spark Engineer (Fabric)
- Eventstream Data Engineer
- Delta Lake Engineer
- Fabric Lakehouse Architect
- Data Platform Engineer
- Data Pipeline Developer
- Data Warehouse Developer
- Fabric Eventhouse Engineer
- Cloud Data Engineer
- Analytics Operations Engineer
- Data Transformation Engineer
- Business Intelligence Data Engineer
- CI/CD Data Platform Engineer
- Fabric Environment Administrator
- Enterprise Data Engineer
- Data Automation Specialist
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 (9)
- Knowledgeable trainer Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 7/28/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 - Knowledgeable trainer Review by Course Participant/Trainee
-
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 12/11/2024)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
-
Great course materials and well-paced lessons. The exercises really helped me understand the topic. (Posted on 11/19/2024)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 1/20/2024)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
