DAX Tips, Tricks and Techniques

Description

This course is all about learning an assortment of DAX tips, tricks, techniques and best practices in a wide range of areas including:

• The DAX language

• Data models and modeling

• DAX Studio

• Performance Analyzer and the VertiPaq Analyzer

• Time Intelligence

• Best practices

• Common mistakes

• Error handling

• Miscellaneous techniques

• Bidirectional filters

• The need to learn theory first

• A Quiz section to test your knowledge and questions which could be used when interviewing for DAX developers

  
  

What You Will Learn!

• Why you must learn some theory first
• Best practices for naming conventions for your DAX and data model objects
• Why bidirectional filtering is not your friend
• Filtering techniques
• How to find the performance bottleneck in your large Power BI report
• Techniques for creating measures to handle common business related requirements and scenarios
• Time intelligence techniques
• DAX interview questions to test your own knowledge as well as interviewing prospective DAX developers

Who Should Attend!

• DAX and Power Pivot Developers

TAKE THIS COURSE