---
title: Execute What-if Analysis
description: Run a predefined What-If analysis using configurable scenarios and filters.
category: Analytics
tags: [what-if, simulation, analysis, planning, forecasting]
---

# 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**

| **Field**        | **Required** | **Description**                                                                |
| ---------------- | ------------ | ------------------------------------------------------------------------------ |
| What-If Analysis | Yes          | The analysis definition with scenarios, variables, and formulas to be executed |

---

## **Output**

| **Output Type** | **Format** | **Description**                                                       |
| --------------- | ---------- | --------------------------------------------------------------------- |
| Data            | Table      | Simulated output for each scenario based on the What-If configuration |

---

## **Configuration Fields**

| **Field Name**       | **Description**                                                                                |
| -------------------- | ---------------------------------------------------------------------------------------------- |
| **What-If Analysis** | Select from predefined What-If analysis models aligned with business or operational objectives |
| **Export Format**    | Choose the desired output format (e.g., table, CSV, Excel)                                     |
| **Scenario**         | Select the scenario to simulate (e.g., Base Case, Best Case, Custom configuration)             |
| **Query**            | Underlying dataset or query to be used for computation                                         |
| **Filters**          | Dimension-based filters (e.g., Region = North America, Year = 2024) to scope the analysis      |

---

## **Sample Input**

_Not Applicable_

---

## **Sample Configuration**

| Field            | Value                        |
| ---------------- | ---------------------------- |
| What-If Analysis | `Revenue Forecast Model`     |
| Export Format    | `Table`                      |
| Scenario         | `Base Case`                  |
| Query            | `SELECT * FROM SalesMetrics` |
| Filters          | `Region = 'North America'`   |

---

## **Sample Output**

| Scenario Name | Region        | Year | Revenue Impact | Cost Impact | Profit Margin |
| ------------- | ------------- | ---- | -------------- | ----------- | ------------- |
| Base Case     | North America | 2024 | 1,500,000      | 500,000     | 30%           |
| Best Case     | North America | 2024 | 2,000,000      | 450,000     | 40%           |
| Worst Case    | North America | 2024 | 1,200,000      | 550,000     | 25%           |

---