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.
Course info
Rating
(14)
Level
Beginner
Updated
May 23, 2019
Duration
4h 10m
Table of contents
Course Overview
A Structured Approach to Power BI Design
Creating New Text Attributes Product and Channel Dimensions
Creating New Date Attributes Calendar and Customer Dimensions
Creating Metrics from Aggregate Functions
Including Calculated Metrics in a Chart or Table
Filtering Metrics with Time Intelligent Functions
Creating Attributes with Conditional Values
Filtering Metrics with Conditional Values
Applying Filter Functions
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
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.