If you work as an Analyst, you probably already know how crucial it is to create a scenario analysis for your teammates. It allows them to manipulate historical data and set up different business cases based on different criteria.

While Power BI is a data visualization tool, it provides a builtin option to quickly pick up user's input and use that value in a forecast measure.

In this video, we are going to cover the basics, see what is generated when you add a What If a parameter, talk about usage, and finally explore two reallife examples.

If you have any questions about these, let me know down in the comments section.

Have a good one,
Roland

New videos coming every Tuesday ‍♂‍

BLOG POST: https://bilingualanalytics.com.au/wha...

MORE VIDEOS:
How to prepare for the DA100 Exam My journey, learning materials & what to expect Power BI Tips    • How to prepare for the DA100 / PL30...  

Facebook Data Visualization in Power BI    • Facebook Data Visualization in Power ...  

Power BI & Power Automate How to automate reporting process    • Power BI & Power Automate  How to au...  

Chapters:
00:00 00:44 Intro
00:44 Word from BILingual
01:00 What is a What If Parameter
02:24 XMLA Endpoint Not Covered
03:09 How to add What If Parameter
04:40 What's generated
05:28 Finetune Parameter
06:20 Design options / Formatting
07:38 How to use it Sales Forecast
09:30 Gelato Shop Milk Estimation
10:40 Holiday Resort Capacity planning
12:17 Summary
13:15 End

▼▼▼▼▼▼▼▼▼

Make sure to hit the button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below or send us an email .

▲▲▲▲▲▲▲▲▲

HOW TO CONNECT
LinkedIn   / bilingualanalytics  
Twitter   / bilanalytics  
Subscribe    / @bilingualanalytics  
ABOUT ME: https://bilingualanalytics.com.au/abo...
– Sydney, Australia


GEAR:
– Canon EOS 200D
– Audio Technica AT2020
– Neewer 18” Ring Light
– BOSE QC35
– 2x ASUS VC279H
– AMD Ryzen 3600, Gigabyte X570, GTX1650, G.Skill 32GB RAM


Music: www.bensound.com

#PowerBI #BILingualAnalytics #WhatIfParameter #ScenarioAnalysis #BusinessCase #Analyst