Common DAX Expressions and Scenarios Power BI Playbook
Course info



Course info



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.
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.