Create advanced analytical models by learning how to harness the power of DAX calculations within Power BI. DAX is the most difficult part of Power BI to learn and put into practice well. This course will take you from a beginner to an advanced user of Power BI by utilizing the powerful DAX language to the fullest.
Participants of this module should have basic knowledge and understanding of how to use Power BI and DAX. It is recommended to have completed the Ultimate Beginners Guide to Power BI and DAX, and the Power BI Super Users Workshop modules. No other advance preparation needed to take this course.
LEARN HOW TO
Utilize the key features Power BI
Use DAX and also what you can achieve with DAX if utilized well
Structure and format DAX formula
Use DAX variables in your formulas effectively
Use calculated columns and measures in your models
Write aggregation, iteration and table DAX functions
Implement DAX functions in combination with each other
Visualize how the DAX calculation engine works via the concept of 'context'
Audit your formulas by understand filter and row context
Use the CALCULATE
Add additional virtual filters to your calculations by using table functionsalysis
Use DAX to solve common analytical scenarios you will face everyday in the real world
Use time intelligence table along with a quality date table
Use advanced table functions in unique calculation requirements
Sam is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organizations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.
Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charterholder, achieving the designation in 2011.
He has a passion for building highly scalable analytical solutions within organizations and wants to see others learn how to do the same.
Frequently Asked Questions
How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.
Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or CoE access to receive support.
What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.