← Back to courses
Data Science and AI
Microsoft Fabric Analytics Engineer (DP-600)
Three months from raw data to enterprise semantic models
A three-month classroom course that follows Microsoft's study guide for Exam DP-600, Implementing Analytics Solutions Using Microsoft Fabric: planning and managing an analytics solution, preparing and serving data, semantic models, and exploring and analysing data. The exam fee and the Fabric capacity used after the course are not included.
10Modules
AdvancedLevel
3 monthsDuration
COURSE THUMBNAIL
What you will be able to do
Ingest and transform data in a Fabric lakehouse
Build a star-schema semantic model with DAX
Apply row-level security and version control
Sit Exam DP-600 with every skill area covered
Course outline
01
Planning a data analytics environment
02
Implementing and managing the environment: access, sharing and capacity
03
Managing the analytics development lifecycle
04
Creating objects in a lakehouse or warehouse
05
Copying data with pipelines, dataflows and notebooks
06
Transforming data: cleansing, star schemas and joins
07
Optimising performance
08
Designing and building semantic models
09
Optimising enterprise-scale semantic models
10
Exploratory analytics and querying data with SQL
Tools you will use
Microsoft FabricPower BIDAXSQLPySpark
What you need
Working knowledge of SQL
Experience building Power BI reports
