Cart 0
K2's DAX - The Secret to Better Data Models - On Demand (2 hours)

K2's DAX - The Secret to Better Data Models - On Demand (2 hours)

Course Description

PowerPivot and the Excel Data Model provide over 300 data access expression (DAX) functions. DAX functions are routinely used for creating measures and calculated columns that facilitate sophisticated data analysis and reporting. From simple functions, such as FORMAT (for reformatting data) to advanced functions, such as RELATED (for denormalizing data), DAX has a function for nearly every data analysis task. The super functions, SUMX (to aggregate calculations over all records) and CALCULATE (to modify the filter context), provide incredible power and flexibility for data analysis. Combine those with the thirty-five time intelligence functions and users have a broad range of functionality for creating any necessary calculation. Don't miss this opportunity to see the power of DAX for building better Data Models.

Major Topics

  • Using FORMAT to create calculated date columns
  • Make calculations on data stored in another table using RELATED
  • Create aggregate measures from multiple columns with SUMX
  • Explore the power of CALCULATE to alter the filter context of a measure
  • Understand how time intelligence functions facilitate financial reporting

    Learning Objectives

    Upon completing this course, you should be able to:

    • Use FORMAT and RELATED to calculate columns and measures
    • Describe how SUMX calculates aggregate measures
    • Differentiate calculated columns from measures
    • Explain how CALCULATE can alter the filter context of a measure
    • Identify three time intelligence functions

      Who Should Attend: Accountants and finance professionals who want to enhance the power and functionality of PowerPivot and the Data Model using DAX formulas.

      Course Level: Advanced

      CPE Credits: 2 Hours Information Technology  

      Prerequisites: Good working knowledge of Excel, the Data Model, and PowerPivot

      Advance Preparation: None

      Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.