Exam Prep DP-600: Microsoft Fabric Analytics Engineer

Instructor: Whizlabs Instructor

3,272 already enrolled

Included with

Learn more

3 modules

Gain insight into a topic and learn the fundamentals.

17 reviews

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

17 reviews

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

10 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 3 modules in this course

The DP-600 certification course is designed for data professionals, analysts, and developers who want to master Microsoft Fabric for implementing robust analytics solutions. This course covers key concepts such as data ingestion, transformation, modeling, and visualization, enabling learners to design and deploy scalable end-to-end analytics solutions within the Microsoft ecosystem.

Key Learning Objectives: Understand the Microsoft Fabric architecture and its core components. Implement data ingestion from various sources using Data Factory and Synapse Data Engineering. Develop and optimize lakehouses, data warehouses, and real-time analytics solutions. Build data models with Direct Lake, Power BI, and DAX for insightful reporting. Automate and orchestrate data workflows to enhance efficiency. Ensure data governance, security, and compliance within Microsoft Fabric.

Welcome to Week 1 of the Exam Prep DP-600: Microsoft Fabric Analytics Engineer Associate course. In this week, you will understand the core concepts and terminology of data analytics, how to design a robust and scalable data analytics environment, and Build and administer a functional data analytics environment. By the end of this week, you will be able to understand how to effectively manage the lifecycle of data analytics solutions.

What's included

17 videos3 readings3 assignments1 discussion prompt

17 videos Total 119 minutes

Course Overview 7 minutes
Course Objectives 4 minutes
Exam Overview 8 minutes
What is Microsoft Fabric? 7 minutes
Data Analytics Requirements 7 minutes
Configuring the Fabric Admin Portal - Demo 4 minutes
Data Gateway Types - Overview 9 minutes
Create a Custom Power BI Report Theme - Demo 8 minutes
Fabric-enabled workspace settings and access controls - Demo 6 minutes
Data Sharing - Demo 6 minutes
Sensitivity labels 8 minutes
Managing Fabric capacity 9 minutes
OneLake security overview - Microsoft Fabric 8 minutes
Workspace Version Control - Demo 4 minutes
Create and manage a Power BI Desktop Project - Demo 7 minutes
Plan and implement deployment solutions - Demo 10 minutes
Impact analysis of downstream dependencies - Demo 7 minutes

3 readings Total 65 minutes

Course Outline 30 minutes
Welcome to the Course 20 minutes
Overview of Maintain a data analytics solution 15 minutes

3 assignments Total 110 minutes

Plan a Data Analytics Environment - Practice Assignment 30 minutes
Implement and Manage a Data Analytics Environment & Development Lifecycle - Practice Assignment 30 minutes
Maintain a data analytics solution - Graded Assignment 50 minutes

1 discussion prompt Total 10 minutes

Meet and Greet 10 minutes

Welcome to Week 2 of the Exam Prep DP-600: Microsoft Fabric Analytics Engineer Associate course. This week, you will understand how to develop and manage tables, views, and other database objects within a Lakehouse or Warehouse and build and manage data pipelines in Fabric for efficient data movement and transformation. By the end of this week, you will be able to understand how to prepare and transform Lakehouse data using Spark, Data Factory, or SQL for analysis.

What's included

17 videos1 reading3 assignments

17 videos Total 116 minutes

Data Ingestion - Demo 6 minutes
Create and manage shortcuts - Demo 5 minutes
File partitioning for analytics workloads - Demo 8 minutes
Functions, and stored procedures - Overview 8 minutes
Enrich data by adding new columns or tables - Demo 8 minutes
Data Copying 7 minutes
Adding stored procedures, notebooks, and dataflows to a data pipeline 9 minutes
Schedule data pipelines - Demo 6 minutes
Schedule dataflows and notebooks - Demo 4 minutes
Data Cleansing - Demo 10 minutes
Denormalize data - Overview 8 minutes
Aggregate or de-aggregate data - Demo 8 minutes
Merge or join data - Overview 6 minutes
Data types Conversion - Demo 3 minutes
Data Filtering - Demo 8 minutes
Identify Performance Bottlenecks - SQL Server 4 minutes
Resolve issues with Delta table file sizes 9 minutes

1 reading Total 15 minutes

Overview of Prepare Data [Get, Transform, Query and Analyze data] 15 minutes

3 assignments Total 70 minutes

Create Objects, Copy and Transform Data in Microsoft Fabric - Practice Assignment 20 minutes
Prepare and Transform Data in the Lakehouse - Practice Assignment 20 minutes
Prepare Data [Get, Transform, Query and Analyze data] - Graded Assignment 30 minutes

Welcome to Week 3 of the Exam Prep DP-600: Microsoft Fabric Analytics Engineer Associate course. This week, you will understand how to develop and implement robust semantic models that meet business requirements, Optimize semantic models for performance, scalability, and maintainability in enterprise environments, and analyze data using appropriate tools, and techniques to derive insights. By the end of this week, you will get a conclusion of how to summarize key concepts and apply learned skills to real-world data analytics scenarios.

What's included

19 videos2 readings4 assignments

19 videos Total 118 minutes

Choose a storage mode 7 minutes
Use cases for DAX Studio and Tabular Editor 2 - Overview 6 minutes
Star schema for a semantic model - Demo 5 minutes
Implement relationships - Demo 6 minutes
DAX Calculations and Functions - Demo 5 minutes
Calculation groups, dynamic strings, and field parameters - Demo 8 minutes
Large Format Dataset Design and Building - Demo 6 minutes
Composite Models and Aggregations - Overview 6 minutes
Row-level security and object-level security - Demo 4 minutes
Query Performance Improvements - Demo 6 minutes
DAX Performance Optimization - Demo 9 minutes
Semantic Model Optimization Tools - Demo 7 minutes
Incremental Refresh - Demo 9 minutes
Descriptive and diagnostic analytics - Overview 7 minutes
Data Profiling - Demo 7 minutes
SQL Querying - Demo 8 minutes
Datasets querying using the XMLA - Demo 6 minutes
What's Next 4 minutes
Summary of DP-600 3 minutes

2 readings Total 45 minutes

Overview of Implement and manage semantic models 15 minutes
Key Takeaways and Best Practices of the course 30 minutes

4 assignments Total 120 minutes

Design and Build Semantic Models - Practice Assignment 20 minutes
Optimize enterprise-scale semantic models - Practice Assignment 20 minutes
Implement and manage semantic models - Graded Assignment 30 minutes
DP-600: Final Assessment 50 minutes

Instructor

Instructor ratings

(6 ratings)

Whizlabs Instructor

Whizlabs

145 Courses 112,491 learners

Offered by

Whizlabs

Explore more from Data Analysis

Edureka
Microsoft Fabric Analytics Engineer: DP-600 Exam Prep
Course
Whizlabs
Microsoft Fabric: Implement and Manage Analytics Solutions
Course
Edureka
Microsoft Fabric Data Engineer: DP-700 Exam Prep
Course
Whizlabs
Exam Prep DP-700: Microsoft Fabric Data Engineer Associate
Specialization

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.