DAX Tips, Tricks and Techniques
What you'll 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
Requirements
- Some working knowledge of DAX
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
Who this course is for:
- DAX and Power Pivot Developers
Course content
- Preview01:55
Instructor
Microsoft Certified Professional:
Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January, 2019)
Seasoned database architect (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence and Power BI. 20 years of software development using a variety of Microsoft technologies, mostly C#.
2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.
StackOverflow reputation of 31,200 (top 1%)