DP-600T00: Implement analytics solutions using Microsoft Fabric

About this course

This course covers how to prepare, enrich, and serve data for analysis by consumers such as data analysts, report developers, and AI agents. The course focuses on designing dimensional models and transforming data by using dataflows, notebooks, and T-SQL across lakehouses, warehouses, and eventhouses in Microsoft Fabric. The course also covers building and optimizing semantic models, managing the analytics development lifecycle, and enforcing security and governance across data assets. Audience Profile This course is intended for data professionals with experience in data modeling, transformation, and analytics. Learners should have prior experience translating business requirements into analytical measures by using Structured Query Language (SQL) or Data Analysis Expressions (DAX). Experience building semantic models and reports in Power BI is recommended. Familiarity with Kusto Query Language (KQL) and Python is also helpful but not required.

Instructor-led training for professionals and companies in Chile. Request dates, schedules, seats and commercial terms. Training hours and daily scheduling follow Netsolutions planning and are confirmed in the commercial proposal.

Course syllabus

1. Explore analytics data stores in Microsoft Fabric
2. Introduction to end-to-end analytics using Microsoft Fabric
3. Discover and connect to data in OneLake
4. Get started with lakehouses in Microsoft Fabric
5. Get started with data warehouses in Microsoft Fabric
6. Get started with Real-Time Intelligence in Microsoft Fabric
7. Design and transform analytics data in Microsoft Fabric
8. Choose data stores in Microsoft Fabric
9. Design dimensional models for analytics in Microsoft Fabric
10. Transform data using Dataflows Gen2 in Microsoft Fabric
11. Transform data using notebooks in Microsoft Fabric
12. Transform data using T-SQL in Microsoft Fabric
13. Design and manage semantic models in Microsoft Fabric
14. Create DAX calculations in semantic models
15. Design semantic models for scale in Microsoft Fabric
16. Optimize semantic model performance
17. Enforce semantic model security
18. Manage the semantic model development lifecycle
19. Prepare AI-ready analytics data in Microsoft Fabric
20. Prepare semantic models for AI in Power BI and Microsoft Fabric
21. Understand Microsoft Fabric IQ fundamentals
22. Create an ontology with Fabric IQ
23. Secure and govern analytics data in Microsoft Fabric
24. Secure data access in Microsoft Fabric
25. Secure a Microsoft Fabric data warehouse
26. Govern analytics data in Microsoft Fabric