Common DAX Expressions and Scenarios Power BI Playbook

In this course we'll build an intelligent data model to facilitate sales analysis for an online clothing retailer with the DAX Language in Power BI Desktop. Completing this course will grant you the knowledge needed to create data objects with DAX.

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.

• 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