As a data professional, have you ever wanted to produce an array of data objects using the DAX language? In this course, Common DAX Expressions and Scenarios Power BI Playbook, you will learn foundation skills in dimensional modelling and programming with the DAX Language in Power BI Desktop. First, you will learn the basic design principles. Next, you will discover how to write DAX code to implement the basic model framework. Finally, you will explore the DAX language and use it to extend and enhance the model. When you have completed this course, you will have the skills and knowledge needed to make your data available via a robust and flexible self service analytical interface. Software required: Power BI Desktop.
Author Name: Andrew McSwiggan
Author Description:
Passionate about Business Intelligence and delivering knowledge and insight to support better decisions. An advocate of Self-Service Reporting and Analytics and a Data Visualisation evangelist. Andi has delivered face to face Business Intelligence training to many industries, covering topics such as Report Design, Semantic Layer, Dimensional modeling and Data Visualisation. Andi has led many Data Warehouse and Business Intelligence development projects and is well versed in taking complex an… more

Table of Contents

• Course Overview
  1min
• A Structured Approach to Power Bi Design
  47mins
• Creating Text Columns for Data Analysis
  42mins
• Creating Calendar Columns for Data Analysis
  43mins
• Creating Measures with Aggregation Functions
  31mins
• Creating Groups Bands and Hierarchies with Conditional Values
  36mins
• Creating Intelligent Measures with Iterating X Functions
  37mins
• Taking Control of the Evaluation Context with CALCULATE
  24mins
• Filtering Measures with Time Intelligence Functions
  32mins
• Create Complex Measures for RFM Analysis with CALCULATE
  25mins