Excel BI Tools: DAX Formulas for Dynamic Tables Training Course
Course Description: The Excel BI Tools: DAX Formulas for Dynamic Tables course will train students on how to DAX language to create reusable formulas that can work across multiple data sources to produce powerful reports. DAX related reporting requirements are covered in the course, and students will also learn how to build models that extend the capabilities of Power BI, Excel, and SQL Server Analysis Services.
Please note: This class is taugh using Excel Software, but user of Power BI and SQL Server Analysis Services will easily be able to follow along.
The course will cover the following topics:
- DAX Functionality Review
- Controlling Content & Values
- Context Control Functions
- Contexts In Relationships
- Advanced Concepts
- Time Intelligence Calculations
- DAX Dashboard Techniques
DAX Functionality Review