Microsoft Fabric: Advanced DAX Queries and Tools to Manage Semantic Models
Microsoft Fabric
| Intermediate
- 18 videos | 1h 50m 46s
- Includes Assessment
- Earns a Badge
Mastering advanced DAX techniques enables organizations to enhance performance, validate data, and manage high-performing semantic models. In this course, learn advanced DAX concepts, starting with iterators for performing row-by-row operations and multi-column calculations, DAX variables, and information functions for data validation and error handling. Next, explore time intelligence, table filter and window functions, and DAX modeling time-savers for optimizing workflows. Finally, examine advanced tools for managing semantic models, including the Tabular Editor, Performance Analyzer, Best Practices Analyzer (BPA), VertiPaq Analyzer, ALM Toolkit, and SQL Server Management Studio (SSMS). This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this courseIdentify how to apply iterators for row-by-row calculationsPerform row-wise computation and aggregation on multiple columns using iteratorsRecognize how variables can simplify calculations and improve performanceUse variables to perform reusable computationsDescribe how to use information functions to manage data qualityValidate data and handle errors using information functionsOutline the use cases of time intelligence and table filtering functionsIdentify the different types of dax windowing functions
-
Compute moving averages and cumulative sums using window functionsList use cases of calculation groups, dynamic format strings, and field parametersRecognize the role of the tabular editor in working with tabular semantic modelsDescribe how to manage semantic models using the performance analyzerIdentify how to apply model best practices using the best practice analyzer (bpa)Outline how to use the vertipaq analyzer to diagnose memory and storage issuesList the uses of the alm toolkitRecognize how sql server management studio (ssms) can be used to manage semantic modelsSummarize the key concepts covered in this course
IN THIS COURSE
-
1m 29sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
6m 54sUpon completion of this video, you will be able to identify how to apply iterators for row-by-row calculations. FREE ACCESS
-
7m 11sLearn how to perform row-wise computation and aggregation on multiple columns using iterators. FREE ACCESS
-
5m 34sThrough this video, you will be able to recognize how variables can simplify calculations and improve performance. FREE ACCESS
-
4m 19sIn this video, find out how to use variables to perform reusable computations. FREE ACCESS
-
4m 32sAfter completing this video, you will be able to describe how to use information functions to manage data quality. FREE ACCESS
-
5m 54sDiscover how to validate data and handle errors using information functions. FREE ACCESS
-
6m 4sIn this video, we will outline the use cases of time intelligence and table filtering functions. FREE ACCESS
-
9m 17sUpon completion of this video, you will be able to identify the different types of DAX windowing functions. FREE ACCESS
-
11mFind out how to compute moving averages and cumulative sums using window functions. FREE ACCESS
-
12m 34sAfter completing this video, you will be able to list use cases of calculation groups, dynamic format strings, and field parameters. FREE ACCESS
-
9m 10sThrough this video, you will be able to recognize the role of the Tabular Editor in working with tabular semantic models. FREE ACCESS
-
7m 6sUpon completion of this video, you will be able to describe how to manage semantic models using the Performance Analyzer. FREE ACCESS
-
3m 53sIn this video, we will identify how to apply model best practices using the Best Practice Analyzer (BPA). FREE ACCESS
-
5m 51sAfter completing this video, you will be able to outline how to use the Vertipaq Analyzer to diagnose memory and storage issues. FREE ACCESS
-
3m 50sUpon completion of this video, you will be able to list the uses of the ALM Toolkit. FREE ACCESS
-
3m 51sThrough this video, you will be able to recognize how SQL Server Management Studio (SSMS) can be used to manage semantic models. FREE ACCESS
-
2m 16sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.