Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Common DAX Expressions and Scenarios Power BI Playbook

via Pluralsight

Overview

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.

Syllabus

  • 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

Taught by

Andrew McSwiggan

Reviews

4.6 rating at Pluralsight based on 142 ratings

Start your review of Common DAX Expressions and Scenarios Power BI Playbook

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.