Key features

• •Understand the ins and outs of DAX expressions and querying functions with the help of easy-to-follow examples
• •Manipulate data of varying complexity and optimize BI workflows to extract key insights
• •Create, monitor, and improve the performance of models by writing clean and robust DAX queries
• •Understand DAX, from the basics through to advanced topics, and learn to build effective data models
• •Write and use DAX functions and expressions with the help of hands-on examples
• •Discover how to handle errors in your DAX code, and avoid unwanted results
• •Load data into a data model using Power BI, Excel Power Pivot, and SSAS Tabular
• •Cover DAX functions such as date, time, and time intelligence using code examples
• •Gain insights into data by using DAX to create new information
• •Understand the DAX VertiPaq engine and how it can help you optimize data models
• •What is DAX?
• •Using DAX Variables and Formatting
• •Building Data Models
• •Working with DAX in Excel, Power BI and SSAS
• •Getting it into Context
• •Progressive DAX Syntax and Functions
• •Table Functions
• •Date, Time and Time Intelligence Functions
• •Filter Functions
• •Statistical Functions
• •Working with DAX Patterns
• •Optimising Your Data Model
• •Optimising Your DAX Queries