Scenario Analysis in Power BI - Using What If Parameters

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 built-in 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 real-life 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: bilingualanalytics.com.au/wha...
🎬 MORE VIDEOS:
How to prepare for the DA-100 Exam - My journey, learning materials & what to expect - Power BI Tips - • How to prepare for the...
Facebook Data Visualization in Power BI 👀 - • Facebook Data Visualiz...
Power BI & Power Automate - How to automate reporting process - • Power BI & Power Autom...
Chapters:
00:00 - 00:44 Intro
00:44 Word from BI-Lingual
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 e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: 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

[@NirRobinson]

thanks. good explanation

[@BILingualAnalytics]

Glad you liked it! :)