DP-600: Implement Analytics Solutions using Microsoft Fabric
DP-600: Implement Analytics Solutions using Microsoft Fabric
Build on your existing PL-300 skills, learn advanced DAX skills, and use lakehouses, warehouses, notebooks and pipelines
Product Brand: Udemy
4.6
Udemy Coupon Code for DP-600: Implement Analytics Solutions using Microsoft Fabric Course. Build on your existing PL-300 skills, learn advanced DAX skills, and use lakehouses, warehouses, notebooks and pipelines
Created by Phillip Burton, I Do Data Limited | 10.5 hours on-demand video course | 10 downloadable resources
Microsoft Fabric Course Overview
DP-600: Implement Analytics Solutions using Microsoft Fabric
This DP-600: Implement Analytics Solutions using Microsoft Fabric course covers the additional content required for the DP-600 certification exam, building on your existing knowledge gained for the PL-300 exam.
It comes in two parts – additional Power BI knowledge, and Fabric.
In Part 1 of this course, we’ll start with Power BI. We’ll look at:
- Developing our design of semantic models, including calculation groups/items and field parameters.
- Expanding our DAX knowledge, with DAX variables and windowing functions.
- Using external apps, such as Tableau Editor 2 and DAX Studio,
- Implementing many-to-many relationships, implementing dynamic strings, and using the Optimize menu.
- The analytics development lifecycle, focusing on version control and deployment solutions,
- Other Analytics topics, such as creating aggregation tables and using the XMLA endpoint.
In Part 2 of this course, we’ll look at other Fabric apps which can be used by data analytics in conjunction with Fabric.
- After a brief look around Fabric, we’ll start by ingesting data by using data pipelines and dataflows.
- We’ll then create a lakehouse and use notebooks to load data, manipulate it in both SQL and PySpark, and save the resulting dataframes in PySpark. We’ll then use our SQL knowledge in a data warehouse.
- Finally, we’ll create additional objects such as shortcuts and partitions, and optimize performance, implement Slowly Changing Dimensions, and manage our Fabric capacity.
Prior knowledge of all of the topics in the PL-300 exam is assumed, especially with regards to DAX functions. This content is available in “PL-300 certification: Microsoft Power BI Data Analyst”, which is available on Udemy.
Prior knowledge of SQL Server would be helpful, but is not essential.
Once you have completed the course, you will have a good knowledge of implementing a solution for data analytics, preparing and serving data, implementing and managing semantic models, and exploring and analyzing data. And with some practice, you could even go for the official Microsoft certification DP-600 – wouldn’t that look good on your CV or resume?
What you’ll learn
- Plan, implement, and manage a solution for data analytics
- Prepare and serve data
- Implement and manage semantic models
- Explore and analyze data
Recommended Microsoft Fabric Course
Microsoft Fabric
Microsoft Fabric Complete Guide – Future of Data with Fabric
Who this course is for
- This course is for you if you want to implement or manage advanced Power BI skills, and load data into and manipulate data in Fabric lakehouses and warehouseslakehouses
- You could be a data analyst, and want to expand your skills to become a Fabric analytics engineer.
- By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft’s official DP-600 exam.
- Wouldn’t the “Implementing Analytics Solutions Using Microsoft Fabric” certification look good on your CV or resume?
Instructor
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications – so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange’s 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
