Variance Analysis || DAX || VSTACK || Data Analysis || Financial Analysis

In this tutorial, you will learn the meaning and types of variance and how to create a variance report using Excel and DAX formulas.
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!

Content
00:02 Intro
00:27 What is variance analysis
01:06 Types of variance analysis
01:41 Favorable and unfavorable variances
02:32 Variance formulas
03:00 The data
03:51 VSTACK
04:45 Unpivot in power query
05:50 The data model
05:59 Connect fact tables
06:35 Create dimension tables
07:09 VSTACK and Unique
07:47 Transpose
08:05 Connect dimension tables to fact tables
08:24 Variance measures
10:10 Date table
11:26 Prior Year and Year-Over-Year measures
12:25 Pivot table report
13:53 Slicers
14:16 Create index number in power query
14:43 Sort by Column
15:00 Key questions
Thank you!

Connect with me on:
👉Instagram Instagram: youexceltutorials
👉Facebook Facebook: youexceltutorials
👉Twitter Twitter: youexceltutor
👉 TikTok TikTok: youexceltutorials
👉LinkedIn LinkedIn: bunmi-sanusi

🎬Check this list:
Power Pivot playlist Power Pivot and Power Query
Create relationships Define and create relationships in Po...
Date table Date Table || Hierarchies || KPIs in ...

⬇️Download the file here https://docs.google.com/spreadsheets/...

📢” Oh, magnify the Lord with me, and let us exalt His name together” (Psalm 34:3) NKJV

#msexcel, #dax, #youexceltutorials,

• #education
• #youexceltutorials