課程資料
報名日期
全年招生
課程級別
學習模式
修業期
7 小時 18 分鐘
教學語言
英語
授課導師
Excel Mojo
評分
2次瀏覽
課程簡介
Advanced DAX in Power BI: Exploring Advanced Techniques, Context & Filter Management, and Performance Optimization
The Advanced DAX in Power BI course is designed for individuals looking to deepen their understanding of Data Analysis Expressions (DAX) within the Power BI environment. This comprehensive course covers a wide range of topics, starting with foundational Power BI concepts such as data tables, lookup tables, and cardinality, before moving into more advanced DAX techniques and functions.
Key concepts explored in this course are filter flow, DAX operators, and the essential functions of the DAX engine, including the formula engine and the storage engine. Participants will gain an in-depth understanding of the VertiPaq engine and DirectQuery and will learn about compression, encoding methodologies, and the relationships between VertiPaq and Power BI models.
The course also covers DAX error handling, scalar functions, logical functions, and table manipulation functions like SELECTCOLUMNS, ADDCOLUMNS, and UNION. Additionally, you will learn about complex DAX functions such as CALCULATE, KEEPFILTERS, and context transitions with practical exercises that enhance real-world understanding.
A strong focus is placed on time intelligence, where you’ll explore date table creation, commonly used time functions like SAMEPERIODLASTYEAR, and patterns for calculating YTD (Year-To-Date) and MTD (Month-To-Date) values. Participants will also become proficient in advanced table functions and relationship management, such as USERELATIONSHIP and CROSSFILTER, which are crucial for building complex models.
By the end of this course, you will have gained the expertise needed to use DAX in Power BI efficiently, optimize reports, and tackle advanced analytical challenges. Whether you're looking to accelerate your decision-making processes or refine your Power BI models, this course will provide the tools and techniques needed to take your skills to the next level.
課程章節
- 1 個章節
- 62 堂課
- 第 1 章 Advanced DAX in Power BI
課程內容
- Master DAX functions, including aggregation, time intelligence, and logical functions for complex calculations in Power BI.
- Understand DAX engine components, including VertiPaq and DirectQuery, and their impact on performance.
- Learn advanced filtering techniques with functions like CALCULATE, KEEPFILTERS, and context transitions.
- Gain expertise in time intelligence functions, including YTD, MTD, and SAMEPERIODLASTYEAR calculations.
- Build and optimize data models using table manipulation and relationship functions such as UNION, RELATED, and USERELATIONSHIP.
此課程所涵蓋的技能
評價
-
GGian Ivo Dall'Agnol
Mancano files di esempio con le istruzioni scritte di cui si parla (le devi inserire a mano)
-
AAnantha K
I have done other 2 courses in this specialization, but honestly this course was far better than those. This course was really well designed. It is more than obvious that the author has put time and effort into it.
-
UUdemy User
Advanced DAX in Power BI is a must for users looking to master complex calculations and optimize data models. It covers advanced topics like time intelligence, custom aggregations, and row-level security, offering hands-on exercises to apply real-world scenarios. Perfect for users already familiar with Power BI who want to take their skills to the next level.
