K2's Data Transformation with DAX Formulas

K2's Data Transformation with DAX Formulas

  • $79.00

Course Description

PowerPivot and the Excel Data Model provide over 300 data access expression (DAX) functions for transforming data. 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 cleanup 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 easing your data analysis burdens.

Major Topics

  • Using FORMAT to create calculated date columns
  • 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

PLEASE NOTE: Registration cutoff is 2 days prior to the start of the webinar