K2's DAX - The Secret to Better Data Models - On Demand (2 hours)
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.
- 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
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.