Skip to content
Infoveave Help

Execute What-if Analysis

Description

The Execute What-If Analysis activity allows you to simulate multiple business scenarios based on a predefined What-If model. It applies user-defined variables and parameters to evaluate hypothetical changes in inputs—such as costs, revenues, or operational parameters—and calculates their impact using embedded formulas.

This enables data-driven decision-making by forecasting potential outcomes before implementing changes in real-world systems.

Use case:
A sales team uses Execute What-If Analysis to simulate how increased marketing spend could affect revenue across regions. Different scenarios like Base Case, Best Case, and Worst Case are run, and their financial impacts are visualized downstream.

Input

FieldRequiredDescription
What-If AnalysisYesThe analysis definition with scenarios, variables, and formulas to be executed

Output

Output TypeFormatDescription
DataTableSimulated output for each scenario based on the What-If configuration

Configuration Fields

Field NameDescription
What-If AnalysisSelect from predefined What-If analysis models aligned with business or operational objectives
Export FormatChoose the desired output format (e.g., table, CSV, Excel)
ScenarioSelect the scenario to simulate (e.g., Base Case, Best Case, Custom configuration)
QueryUnderlying dataset or query to be used for computation
FiltersDimension-based filters (e.g., Region = North America, Year = 2024) to scope the analysis

Sample Input

Not Applicable

Sample Configuration

FieldValue
What-If AnalysisRevenue Forecast Model
Export FormatTable
ScenarioBase Case
QuerySELECT * FROM SalesMetrics
FiltersRegion = 'North America'

Sample Output

Scenario NameRegionYearRevenue ImpactCost ImpactProfit Margin
Base CaseNorth America20241,500,000500,00030%
Best CaseNorth America20242,000,000450,00040%
Worst CaseNorth America20241,200,000550,00025%