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