Microsoft Fabric: Advanced DAX Queries and Tools to Manage Semantic Models

Microsoft Fabric    |    Intermediate
  • 18 videos | 1h 50m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 2 users Rating 4.5 of 2 users (2)
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 course
    Identify how to apply iterators for row-by-row calculations
    Perform row-wise computation and aggregation on multiple columns using iterators
    Recognize how variables can simplify calculations and improve performance
    Use variables to perform reusable computations
    Describe how to use information functions to manage data quality
    Validate data and handle errors using information functions
    Outline the use cases of time intelligence and table filtering functions
    Identify the different types of dax windowing functions
  • Compute moving averages and cumulative sums using window functions
    List use cases of calculation groups, dynamic format strings, and field parameters
    Recognize the role of the tabular editor in working with tabular semantic models
    Describe how to manage semantic models using the performance analyzer
    Identify how to apply model best practices using the best practice analyzer (bpa)
    Outline how to use the vertipaq analyzer to diagnose memory and storage issues
    List the uses of the alm toolkit
    Recognize how sql server management studio (ssms) can be used to manage semantic models
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 29s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 6m 54s
    Upon completion of this video, you will be able to identify how to apply iterators for row-by-row calculations. FREE ACCESS
  • Locked
    3.  Performing Multi-Column Operations Using Iterators
    7m 11s
    Learn how to perform row-wise computation and aggregation on multiple columns using iterators. FREE ACCESS
  • Locked
    4.  DAX Variables
    5m 34s
    Through this video, you will be able to recognize how variables can simplify calculations and improve performance. FREE ACCESS
  • Locked
    5.  Reusing Computations with Variables
    4m 19s
    In this video, find out how to use variables to perform reusable computations. FREE ACCESS
  • Locked
    6.  Information Functions in DAX
    4m 32s
    After completing this video, you will be able to describe how to use information functions to manage data quality. FREE ACCESS
  • Locked
    7.  Using Information Functions for Data Validation and Error Handling
    5m 54s
    Discover how to validate data and handle errors using information functions. FREE ACCESS
  • Locked
    8.  DAX Time Intelligence and Table Filter Functions
    6m 4s
    In this video, we will outline the use cases of time intelligence and table filtering functions. FREE ACCESS
  • Locked
    9.  Window Functions in DAX
    9m 17s
    Upon completion of this video, you will be able to identify the different types of DAX windowing functions. FREE ACCESS
  • Locked
    10.  Applying Window Functions
    11m
    Find out how to compute moving averages and cumulative sums using window functions. FREE ACCESS
  • Locked
    11.  DAX Modeling Time-Savers
    12m 34s
    After completing this video, you will be able to list use cases of calculation groups, dynamic format strings, and field parameters. FREE ACCESS
  • Locked
    12.  Tabular Editor
    9m 10s
    Through this video, you will be able to recognize the role of the Tabular Editor in working with tabular semantic models. FREE ACCESS
  • Locked
    13.  Performance Analyzer
    7m 6s
    Upon completion of this video, you will be able to describe how to manage semantic models using the Performance Analyzer. FREE ACCESS
  • Locked
    14.  Best Practice Analyzer (BPA)
    3m 53s
    In this video, we will identify how to apply model best practices using the Best Practice Analyzer (BPA). FREE ACCESS
  • Locked
    15.  VertiPaq Analyzer
    5m 51s
    After completing this video, you will be able to outline how to use the Vertipaq Analyzer to diagnose memory and storage issues. FREE ACCESS
  • Locked
    16.  ALM Toolkit
    3m 50s
    Upon completion of this video, you will be able to list the uses of the ALM Toolkit. FREE ACCESS
  • Locked
    17.  SQL Server Management Studio (SSMS)
    3m 51s
    Through this video, you will be able to recognize how SQL Server Management Studio (SSMS) can be used to manage semantic models. FREE ACCESS
  • Locked
    18.  Course Summary
    2m 16s
    In 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.

YOU MIGHT ALSO LIKE

Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 4.8 of 5 users Rating 4.8 of 5 users (5)
Rating 4.3 of 14 users Rating 4.3 of 14 users (14)