PowerBI Advanced Course 2024, Designed by Artifica Lab Co., Ltd

 

Section 1: Intro to Advanced PowerBI

* DAX Engine Concepts

* Formula Engine & Storage Engine Key Concepts

 

Section 2: Review Lectures on DAX

* Measures, Calculated Columns, Calculated Tables and RLS in PowerBI

* Shortcut Codes

* DAX Error handling: IFERROR( ), ISBLANK( )

* Using DAX Variables

 

Section 3: Dolphin Cake & Coffee Project

* Case Study & Datasets Introduction

* Sales Performance Analysis using DAX Functions

* Retail Stores Analysis and Insights with DAX

* Selling Products

* Other DAX functions applied in the project

 

Section 4: DAX Functions Categories: Aggregation, Math & Trig, Information, Logical

* Recall subject on above stated DAX functions

 

Section 5: Advanced DAX Filter Functions

* CALCULATE ( ) function in DAX

* Introduction to Filter Modifier Functions

* ALL( ) function to ignore any filters + Exercises

* ALLSELECTED( ) function to only remove specific filters + Exercises

* ALLNOBLANKROW( ) function

* ALLEXCEPT( ) to remove all context filters except specific columns + Excercises

* KEEPFILTERS( ) function + Exercises

* REMOVEFILTERS( ) + Exercises

 

Section 6: A Mix of Advanced DAX Table + Filter Functions

* Data Adding Functions: SELECTCOLUMNS( ), ADDCOLUMNS( ), SUMMARIZE( )

* SELECTCOLUMNS( ) to create a table from selected columns + Exercises

* ADDCOLUMNS( ) to add additional columns+ Exercises

* SUMMARIZE( ) function Usage

* Data Filtering Functions: ALLEXCEPT( ), ALLSELECTED( )

* Data Creation Functions: ROW( ), DATATABLE( ), GENERATESERIES( ), { } Table Constructor

 

Section 7: Table Joins DAX Functions

* Alternative to Merge Queries: Using Joins Functions

* CROSSJOIN( ), UNION( ), EXCEPT( ), INTERSECT( )

 

Section 8: DAX Relationship Functions

* Physical and Virtual Relationships

* RELATED( ) DAX Functions

* RELATEDTABLE( ) DAX Functions

* USERELATIONSHIP( ) DAX Functions

* CROSSFILTER( )

* TREATAS( )

 

Section 9: DAX Iterator Functions

* What are Iterator Functions

* SUMX( ) , CONCATENATEX( ) + Dynamic Labels

* AVERAGEX( ), RANKX( )

 

Section 10: Time Intelligence Functions

* Understanding Date Table

* Summarization: DATESYTD( ), TOTALYTD( ), DATESBETWEEN( ), DATESINPERIOD( )

* Comparison: DATEADD( ), PARALLELPERIOD( ), SAMEPERIODLASTYEAR( )

* CALENDAR( ), CALENDARAUTO( ), FORMAT( )

* Results to Date: CALCULATE ( ) + DATESYTD( )

* Previous Period: CALCULATE ( ) + DATEADD( )

* Running Total: CALCULATE ( ) + DATESINPERIOD( )

* Week-Based DAX Calculations: 4-4-5 and 4-5-4 Calendars

 

Section 11: NorthWind Traders Project

* Sales Performance Analytics

* Shipping Cost Analysis & Insights

* Selling Products Analysis

* Customers Analysis & Insights

* Additional Recommendations

* Advanced Visuals + Complete Dashboard

 

Section 12: Zebra Marketing Analytics Project

* Demographics Analysis

* Geographic Distribution

* Campaign Performance

* Products Performance

* Customer Registration

* Advanced Visuals + Complete Dashboard

 

Section 13: Future of PowerBI Evolution: Microsoft Fabrics

* How Microsoft Fabrics Works

* The Solution of End-to-End Data Analytics Enterprise Ready System

* Introduction to OneLake

* Introduction to Data Factory

* Introduction to Data Engineering

* Introduction to Data Science

* Introduction to Data Warehouse

* Introduction to Real-Time Analytics

* Introduction to PowerBI in Microsoft Fabrics

* Further Study Step in Next Level Classs