Advanced Dax For Microsoft Power Bi Desktop (updated 8/2022)

Master the DAX language and build advanced Power BI & data analysis skills with a top business intelligence instructor

What you'll learn
Master Data Analysis Expressions (DAX) for Power BI Desktop
Analyze real-world projects & business intelligence use cases
Learn the same tools used by top analytics & business intelligence professionals
Test your skills with hands-on demos & assignments (with step-by-step solutions)
Requirements
Microsoft Power BI Desktop (free download)
This course is designed for PC/Windows users (currently not available for Mac)
Prior experience with DAX and Power BI is strongly encouraged
Recommend completing our "Up & Running with Power BI Desktop" course before this one
Description
For users looking to take their Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a MUST. In this hands-on, project-based course, you'll put your DAX skills to the test and apply what you learn to some of the toughest real-world business intelligence use cases.You'll be playing the role of Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your goal? Use Power BI and DAX to answer key questions and deliver data-driven insights for the business, by analyzing product inventory, repeat customers, store-level performance, and everything in between.We'll start by quickly reviewing prerequisite topics (evaluation context, filter flow, basic measures, etc.), then dive behind the scenes to explore how the DAX formula and storage engines actually work, including query evaluation, columnar structures, and VertiPaq compression and encoding.From there we'll cover helpful tips and best practices for DAX power users, including variables, comments, query formatting and error handling, then dive deep into scalar functions, iterators, advanced time intelligence, calculated table joins, relationship functions, and much, much more. Last but not least, we'll share a sneak peek into performance tuning and DAX query optimization using DAX Studio and Power BI's Performance Analyzer tool.If you're looking to build expert-level data analysis skills using DAX and Power BI, this is the course for you!__________FULL COURSE OUTLINE:Prerequisite Skills ReviewReview the core DAX concepts you should already know, including evaluation context, filter flow, measures, etc.Course Project IntroIntroduce the Maven Roasters course project, and build the data model that we’ll analyze in Power BI DesktopThe DAX EnginesUnderstand the DAX formula and storage engines, data types, VertiPaq encoding & compression methods, etc.DAX Tips & Best PracticesReview helpful tips for formatting DAX queries, adding comments, handling errors, and using DAX variablesScalar FunctionsExplore common DAX scalar functions, including rounding, information, conversion, and logical functionsAdvanced CALCULATEReview CALCULATE modifiers, context transition, interactions with tables, etc.Table & Filter FunctionsCreate calculated tables, review common DAX filter functions, generate new data, etc.Calculated Table JoinsCreate calculated joins between physical and virtual tables in Power BI (UNION, EXCEPT, INTERSECT, etc.)Relationship FunctionsExplore expanded tables, physical & virtual relationships, common relationship functions, etc.Iterator ("X") FunctionsExplore iterator cardinality, nested iterators, context transition, RANKX, DAX calculation granularity, etc.Advanced Time IntelligenceBuild date tables with DAX, compare custom time periods, manage fiscal calendars, etc.SNEAK PEEK: Performance TuningIntroduce DAX Studio, the Power BI performance analyzer, and common DAX optimization techniques__________Join today and get immediate, lifetime access to the following:150+ page Power BI & DAX ebookDownloadable datasets and Power BI project filesHomework assignments & quizzes1-on-1 expert supportCourse Q&A forum30-day money-back guaranteeSee you in there!-Aaron (Power BI & DAX Instructor, Maven Analytics)__________Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!Hear why our Power BI courses are the TOP-RATED on Udemy:"I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn't want to stop learning – I wanted to keep charging on to the next lesson!"-Ann S."Amazing! 5+ stars if you ask me! Concise, superbly organized and prepared. I have learned a ton about Power BI and DAX and enjoyed the course from start to finish."-Nikola H."Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%!"-Jorge M."Where can I leave a 6 star rating?"-Carlos B.

Overview

Section 1: Getting Started

Lecture 1 Course Structure & Outline

Lecture 2 READ ME: Important Notes for New Students

Lecture 3 DOWNLOAD: Course Resources

Lecture 4 Setting Expectations

Lecture 5 Helpful Resources

Section 2: Prerequisite Skills Review

Lecture 6 Introduction

Lecture 7 Data Modeling Fundamentals

Lecture 8 Basic DAX Review

Section 3: Introducing the Course Project

Lecture 9 Introducing the Course Project

Lecture 10 NOTE: Power BI Options & Settings

Lecture 11 Maven Roasters Data Model Setup

Lecture 12 ASSIGNMENT: Getting Familiar with the Data Model

Section 4: The DAX Engines

Lecture 13 Introduction

Lecture 14 DAX Formula & Storage Engines

Lecture 15 DAX Query Evaluation In Depth

Lecture 16 Data & Storage Types

Lecture 17 VertiPaq Columnar Data Structure

Lecture 18 VertiPaq Compression & Encoding

Lecture 19 Value Encoding

Lecture 20 Hash Encoding

Lecture 21 Run Length Encoding

Lecture 22 VertiPaq Relationships

Lecture 23 Summary: DAX Engines

Section 5: Tips & Best Practices

Lecture 24 Introduction

Lecture 25 DAX Shortcuts

Lecture 26 Formatting Best Practices

Lecture 27 DAX Evaluation Order

Lecture 28 Commenting Your Code

Lecture 29 PRO TIP: Dedicated Measure Table

Lecture 30 Error Handling

Lecture 31 Creating & Using DAX Variables

Lecture 32 Variable Evaluation Order

Lecture 33 PRO TIP: Using Variables to Test & Debug DAX

Section 6: Scalar Functions

Lecture 34 Introduction

Lecture 35 Common Scalar Functions

Lecture 36 Aggregation Functions

Lecture 37 PRO TIP: SUM & SUMX

Lecture 38 Rounding Functions

Lecture 39 ASSIGNMENT: Rounding Functions

Lecture 40 SOLUTION: Rounding Functions

Lecture 41 Information Functions

Lecture 42 Conversion Functions

Lecture 43 ASSIGNMENT: Conversion Functions

Lecture 44 SOLUTION: Conversion Functions

Lecture 45 Logical Functions: SWITCH

Lecture 46 Logical Functions: COALESCE

Lecture 47 ASSIGNMENT: Logical Functions

Lecture 48 SOLUTION: Logical Functions

Section 7: Advanced CALCULATE

Lecture 49 Introduction

Lecture 50 Expanded Tables

Lecture 51 Context Transition

Lecture 52 Evaluation Order

Lecture 53 CALCULATE Modifiers

Lecture 54 REMOVEFILTERS

Lecture 55 KEEPFILTERS

Lecture 56 ASSIGNMENT: Advanced CALCULATE

Lecture 57 SOLUTION: Advanced CALCULATE

Lecture 58 PRO TIP: Common CALCULATE Patterns

Section 8: Table & Filter Functions

Lecture 59 Introduction

Lecture 60 Common Table & Filter Functions

Lecture 61 Review: Calculated Tables

Lecture 62 DISTINCT

Lecture 63 VALUES

Lecture 64 ASSIGNMENT: VALUES & DISTINCT

Lecture 65 SOLUTION: VALUES & DISTINCT

Lecture 66 SELECTEDVALUE

Lecture 67 ALLEXCEPT

Lecture 68 ASSIGNMENT: ALLEXCEPT

Lecture 69 SOLUTION: ALLEXCEPT

Lecture 70 ALLSELECTED

Lecture 71 ASSIGNMENT: ALLSELECTED

Lecture 72 SOLUTION: ALLSELECTED

Lecture 73 SELECTCOLUMNS

Lecture 74 ADDCOLUMNS

Lecture 75 SUMMARIZE

Lecture 76 ASSIGNMENT: SUMMARIZE

Lecture 77 SOLUTION: SUMMARIZE

Lecture 78 Generating New Data

Lecture 79 ROW

Lecture 80 DATATABLE

Lecture 81 GENERATESERIES

Lecture 82 The Table Constructor

Lecture 83 ASSIGNMENT: Generating Data

Lecture 84 SOLUTION: Generating Data

Section 9: Calculated Table Joins

Lecture 85 Introduction

Lecture 86 CROSSJOIN

Lecture 87 UNION

Lecture 88 EXCEPT

Lecture 89 INTERSECT

Lecture 90 ASSIGNMENT: Calculated Table Joins

Lecture 91 SOLUTION: Calculated Table Joins

Section 10: Relationship Functions

Lecture 92 Introduction

Lecture 93 Physical vs. Virtual Relationships

Lecture 94 RELATED

Lecture 95 RELATEDTABLE

Lecture 96 ASSIGNMENT: RELATED & RELATEDTABLE

Lecture 97 SOLUTION: RELATED & RELATEDTABLE

Lecture 98 USERELATIONSHIPS

Lecture 99 CROSSFILTER

Lecture 100 ASSIGNMENT: CROSSFILTER

Lecture 101 SOLUTION: CROSSFILTER

Lecture 102 TREATAS

Lecture 103 ASSIGNMENT: Sales Targets (TREATAS)

Lecture 104 SOLUTION: Sales Targets (TREATAS)

Section 11: Iterator Functions

Lecture 105 Introduction

Lecture 106 Review: Basic Iterators

Lecture 107 Iterator Cardinality

Lecture 108 CONCATENATEX

Lecture 109 PRO TIP: Adding Dynamic Labels

Lecture 110 ASSIGNMENT: CONCATENATEX

Lecture 111 SOLUTION: CONCATENATEX

Lecture 112 AVERAGEX

Lecture 113 PRO TIP: Moving Averages

Lecture 114 ASSIGNMENT: Moving Averages

Lecture 115 SOLUTION: Moving Averages

Lecture 116 RANKX

Lecture 117 ASSIGNMENT: RANKX

Lecture 118 SOLUTION: RANKX

Section 12: Advanced Time Intelligence

Lecture 119 Introduction

Lecture 120 Automatic Date Tables

Lecture 121 Date Table Requirements

Lecture 122 CALENDAR

Lecture 123 CALENDARAUTO

Lecture 124 PRO TIP: Building a Reusable Date Table

Lecture 125 Date Formatting

Lecture 126 ASSIGNMENT: Date Formatting

Lecture 127 SOLUTION: Date Formatting

Lecture 128 Common Time Intelligence Functions

Lecture 129 PARALLELPERIOD

Lecture 130 PREVIOUSQUARTER

Lecture 131 SAMEPERIODLASTYEAR

Lecture 132 ASSIGNMENT: Time Periods

Lecture 133 SOLUTION: Time Periods

Lecture 134 Week-based Calculations

Lecture 135 Previous Fiscal Week

Lecture 136 Fiscal Period to Date

Lecture 137 Fiscal Previous Period

Lecture 138 ASSIGNMENT: 4-5-4 Calendar

Lecture 139 SOLUTION: 4-5-4 Calendar

Section 13: Sneak Peek: Performance Tuning

Lecture 140 Introduction

Lecture 141 Power BI Performance Analyzer

Lecture 142 PRO TIP: Copy Query

Lecture 143 DAX Studio

Lecture 144 DAX Optimization Workflow

Section 14: Wrapping Up

Lecture 145 BONUS LESSON

Aspiring data professionals looking to master the #1 business intelligence tool on the market,Analytics or BI professionals looking to build expert-level DAX + Power BI skills,Power BI users tasked with solving unique and complex analytics use cases,Students looking for a comprehensive, engaging, and highly interactive approach to training