Common DAX Expressions and Scenarios Power BI Playbook

By Andrew McSwiggan
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.
Play course overview
Course info
Rating
(14)
Level
Beginner
Updated
May 23, 2019
Duration
4h 10m
Table of contents
Course Overview
Course Overview 2m
A Structured Approach to Power BI Design
What Is a Dimensional Model? 7m The Dimensional Modelling Process 5m Designing the Data Model 4m Creating Dimensions and Fact Tables 9m
Creating New Text Attributes Product and Channel Dimensions
Handling Blanks and Creating the Product Dimension 8m Locate the Product Elements 9m Create the Product Attributes 9m Fixing Messy Text 5m Combine and Lookup Text Strings 3m Lookup Values and Module Summary 8m
Creating New Date Attributes Calendar and Customer Dimensions
Analysis Over Time 8m New Sales Calendar Date Dimensions 5m First Day of the Month 6m Calculate Week Numbers 6m Last and First Days of the Week 6m Customers Last Sales Date 4m
Creating Metrics from Aggregate Functions
Intro and Overview 2m Demo: How do Aggregates Work? 4m Measures in Action 5m X Aggregates 5m Customer Purchases 3m Module Summary 1m
Including Calculated Metrics in a Chart or Table
Review the Data Model 2m The Expression Context 3m Demo: Applying Filters and Seeing the Results 7m The Row Context 2m Working with Contexts 7m RANK and Module Summary 10m
Filtering Metrics with Time Intelligent Functions
Module Overview and Data Review 4m Cumulative Period Comparisons 4m Promotion Analysis 5m Monthly Percentage Change 2m Moving Annual Totals 6m Key Performance Indicators 4m Module Summary 1m
Creating Attributes with Conditional Values
Introduction and Power BI Groups 5m Create Product Categories with Conditional Values 6m Create Product Gender with Conditional Logic 3m Demo: Conditional Logic with SWITCH 8m Calculating Seniority with DATEDIFF and VAR 6m Module Summary 1m
Filtering Metrics with Conditional Values
Introduction and Creating Filtered Measures with Calculate 8m Demo: Creating Product Category Measures 4m Demo: Creating Percentage Measures 9m Module Summary 0m
Applying Filter Functions
Introduction to Applying Filter Functions 0m Recent Customer Activity 4m Demo: Active Customer Days 2m Demo: Calendar Recent Period 4m Demo: Time Filtered Measures 1m Demo: Recency, Activity, and Sales Value 3m Customer Activity Measures 5m Module and Course Summary 1m
Description
Course info
Rating
(14)
Level
Beginner
Updated
May 23, 2019
Duration
4h 10m
Description

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.

About the author
Andrew McSwiggan
About the author

Passionate about Business Intelligence and delivering knowledge and insight to support better decisions. An advocate of Self-Service Reporting, Analytics Data Visualisation. Andi has delivered face to face Business Intelligence training covering topics such as Report Design, Dimensional modeling, and Data Visualisation. Andi is a keen cyclist and amateur cook and lives with his wife in Southern Spain.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
(Music) Hi everyone. My name is Andrew McSwiggan, and welcome to my course, Common DAX Expressions and Scenarios Power BI Playbook. I'm a business intelligence analyst at Playtech, and I work with data every day. The DAX language is very simple in appearance, but very powerful in terms of what you can achieve once you've mastered the basics. I take a simple flat file and take you step by step to transform it. Everything you learn along the way will have real-world context. Every piece of code I show you will be used to extend the model to produce a fully functioning analytical tool inside Power BI. Some of the key topics I cover with DAX are creating a star schema model, creating smart metrics such as MATs and KPIs with time intelligence functions; creating smart data columns by decoding and cutting out text. By the end of this course, you'll know how to create and manage a self-service data model in Power BI Desktop. Before beginning the course, you should be familiar with Power BI basics and basic data analysis. I hope you'll join me on this journey to learn DAX and data modeling in Power BI Desktop with the Common DAX Expressions and Scenarios Power BI Playbook course at Pluralsight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT