194
LESSONS
ALL
SKILL LEVEL
17:40
DURATION
ENGLISH
AUDIO
ENG
SUBTITLES
OVERVIEW
The ability to use Power BI is one of the most desired skills in business, and Microsoft Fabric completements your Power BI skills. Completing this course will give you advanced Power BI skills, as well as the ability to load and manipulate data in lakehouses and warehouses using SQL, and Eventhouses using KQL.
.
WHO IS THE COURSE FOR?
This course is for you if you want to develop your Power BI skills to develop more complicated semantic models, as well as to prepare and serve data online.
You don’t need any prior knowledge. However, if you have already studied for the PL-300 Microsoft Power BI Data Analyst exam, then you can skip Part 1 of this course. It is useful if you have existing SQL or KQL skills, though this is not required.
.
LEARNING PATH
PART 1 – POWER BI FROM PL-300 EXAM
- Installing and using Power BI Desktop and Service
- Creating calculated columns, including Logical functions
- Creating Measures, including aggregations, and iterator, information, filter functions, date, time and time intelligence functions
PART 2 – ADVANCED POWER BI
- Design and build semantic models.
- DAX Variables and Windowing functions.
- External Apps, including Tableau Editor 2 and DAX Studio
- Relationships and performance improvements
- Manage the analytics development lifecycle
- Other Power BI Analytics topics
PART 3 – LAKEHOUSES, WAREHOUSES AND SQL
- A look around Fabric
- Using data pipelines and Dataflow Gen2
- Querying data in SQL in a lakehouse and using a notebook
- Transforming data in a data warehouse
- Improving performance in SQL
PART 4 – EVENTHOUSES AND KQL
- Creating an Eventhouse.
- Selecting, filtering and aggregating data using KQL
- Using KQL functions
- Transforming data using KQL
- Configure security and governance, and deployment pipelines
REVIEWS
“It includes all the topics of the DP-600 exam” (December 2024)
“Hands down, this is one of the best courses for DP-600 available on Udemy. I’ve purchased several other courses, but none compare to this one. It’s clear, concise, and focused, with no unnecessary content. I’ve received my certification, thanks to this excellent course. Highly recommend!”
“I enjoyed this course, and I learned some really useful things. The Calculation Group clarified this relatively new feature for me, so I will use it in the future. I’m taking my DP-600 exam soon. This course has filled in my knowledge of Fabric. I’ve even activated my Fabric 60 Day Trial because of this course, so I can actually go through the steps of creating items and manipulating data first-hand. The corse was presented in clear and logical manner.”
.
