Microsoft Power Bi Dax Super User - Intermediate - W/Manual

Delve deep into the DAX functional language and learn to build complex DAX formulas to retrieve the answers you need!

What you'll learn
Understand Database Normalization and Relationships
Learn why you need a Rolling Calendar when you have date fields
Learn a multitude of functions in six DAX Category types
Install and create new stunning visuals with unique slicers
Requirements
Prior to enrolling this course, you should have taken my Power BI Data Analysis course offered here on UDEMY, or another equivilent introductory course to Power BI.
Description
Welcome to my intermediate level for Power BI users who want to delve deeper into the DAX functional language. After taking my Power BI Data Analysis Course (for beginners) you now will be ready to take your skills to the next level and really get a grasp on the DAX language that is used in Power BI formulas.In this course we will implement over 30 DAX functions from across nine different categories:Conditional & Logical FunctionsIS FunctionsDate & Time FunctionsConversion FunctionsMath & Stats FunctionsText FunctionsIterator FunctionsTime Intelligence FunctionsTable & Filter FunctionsInfamous CALCUALTE FunctionI will teach you how to problem solve your formulas and how to build them in pieces, so they are easier to understand and use that knowledge to have your measures call other measures. Not to mention learn to build a measures table to hold all the measure you will create for your report to keep them organized and all in one place.You will also learn the need to have a rolling calendar and the benefits it provides for those people who have a multitude of tables with date fields and how the table will auto adjust its dates as new data is added.  All that combined with installing appealing new visuals from the marketplace and using stunning slicers to make your reports more interactive for your user. By the end of this course, you will have the confidence to build out your formulas to get the results you need and the visually appealing new visuals on your reports that show the results of your data analysis for the company!

Overview

Section 1: Introduction

Lecture 1 Course & Instructor Info

Lecture 2 Support Notes for Students

Lecture 3 Download Course Resources & PDF Manual

Lecture 4 Contacting the Instructor

Lecture 5 Let's Set Some Expectations

Lecture 6 PDF Manual & Video Correlation

Section 2: Data Sources & Datasets

Lecture 7 Configuring Data Source Settings

Lecture 8 The Power Query Editor (PQE)

Lecture 9 Combining Queries

Lecture 10 Building Hierarchies

Lecture 11 Dedicated Measures Table

Section 3: Data Modeling & Relationships

Lecture 12 Defining Data Modeling

Lecture 13 Data & Lookup Tables

Lecture 14 Rolling Calendar

Lecture 15 Connect & Review Data Sources

Lecture 16 Section 3 / Chapter 2 Exercise

Section 4: Calculating with DAX Functions

Lecture 17 Conditional & Logical Functions

Lecture 18 IS Functions

Lecture 19 Date & Time Functions

Lecture 20 Conversion Functions

Lecture 21 Math & Stats Functions

Lecture 22 TEXT Functions

Lecture 23 Infamous CALCULATE Function

Lecture 24 Iterator Functions

Lecture 25 Time Intelligence Functions

Lecture 26 Table & Filter Functions

Lecture 27 Section 4 / Chapter 4 Exercises

Section 5: Visualizing your Data Results

Lecture 28 Living in the Matrix

Lecture 29 Trends & Forecasts

Lecture 30 Geo Sync your Data with Maps

Lecture 31 Key Metrics with KPI Visuals

Lecture 32 Designing for Smart Phones

Lecture 33 Interactive Reports

Lecture 34 Section 5 / Chapter 4 Exercises

Section 6: Course Project

Lecture 35 Instructor Thank You!

Lecture 36 Power BI DAX Super User Project

Students who have a solid foundation from using Power BI,Advanced Power BI users with 2-3 years working with functions in general,Someone who wants to upgrade their Power BI Knowledge and take it to the next level