Scenario Analysis by Node

Scenario analysis by node helps in further investigation of scenarios along with the node details and its breakdown. It helps you to visualize the trend, variance breakdown and the simulation impact for the desired nodes and its calculation components with the help of charts.

To open the Analysis window, click on any node in the tree view or any cell on the Table View that needs to be analyzed.

For example, clicking on the US node from Scenario 2 of the Simulate window opens the below pop-up where you can see the values, charts, details and notes specific to the US node in Scenario 2.

US node - Scenario Analysis

At the bottom of the window, you have an option (+) to open other nodes and switch between the opened nodes.

The information available on this window is explained below.

We will take up an example with the following simulation summary:

Scenario Name

Scenario 2

Baseline Series

Sum of 2022

Comparison Series

Sum of 2021

Simulated Nodes with change%

Revenue (8%) and Expense (-6%) nodes of US

1. Trend

A line chart along with a clustered column chart is used to quickly compare the simulated value, baseline value and comparison value in a period-wise distribution.

Chart Element
Representation

Blue-green trendline represents the scenario (simulated values)

Column chart in blue represents Baseline Values

Column chart in orange represents Comparison Values

Trend chart for Total Net Profit

Hover the mouse over the chart to get the simulation details for the individual periods on the tooltip.

Hover over to get details of simulation for a specific period

Click on the table icon at the top right corner to switch to the table view.

Find below the table view of the trend of Total Net Profit.

Trend of Total Net Profit - Table view

1.1. Variance Charts

In the Trend chart, you can choose to include variance charts for Simulation Impact, Variance and the original variance to be displayed. Each shows their respective variance. To choose, click on the dropdown menu at the top right corner of the window in the Trend tab.

Variance chart drop-down list when 'None' is selected

The below image shows the trend chart along with the simulation impact variance chart as Sim.Impact option has been chosen from the dropdown list.

Variance chart - 'Simulation Impact' is selected

Hover over the chart to get period-wise details on the tooltip. In table view, the same chart appears as shown below.

Table View of Sim.Impact and Sim Impact%

Similarly, the Variable and Original variance charts can be presented in graph and table views.

Refer to this section to learn the difference between simulation impact, variance and original variance.

2. Variance Breakdown

A Waterfall chart shows the variance breakdown for any chosen node.

For a node with no simulation, the variance between the baseline and the comparison series is shown with a breakdown of all its immediate child nodes/calculation components.

The image below shows the variance breakdown of the baseline series (Sum of 2022) versus the comparison series (Sum of 2021) for the Asia node.

Variance Breakdown of Asia's total net profit - Baseline Series vs Comparison Series

For a simulated node, the variance between the Scenario (simulated values) and the comparison values are shown with a breakdown of all its immediate child nodes/calculation components.

For example, in the below image, the variance breakdown of the Total Net Profit node is shown for Scenario 2 versus the comparison series (Sum of 2021).

Variance Breakdown of Total Net Profit - Scenario 2 vs Comparison Series

3. Simulation Impact

A waterfall chart that visually breaks down the simulation impact is shown for the selected node i.e. it shows all the simulated inputs that add up to create the new scenario value.

In the below image, the simulation impact on Total Net Profit is shown when Revenue and Expense values were simulated for Scenario 2.

Simulation Impact on Total Net Profit

In table view, the chart appears as shown below.

Table View of Simulation Impact on Total Net Profit

4. Calculation Components

This shows the trend and comparison (line and clustered column charts) for the selected node with its calculation component nodes that make up the selected node.

The example below shows the calculation components of Total Net Profit through trellis charts.

Options in the Scenario Analysis window

All the charts of calculation components can be individually downloaded or pinned using the icons available beside each of them. For larger models, the Search option can be used to search for any calculation components. Clicking on the pop-up icon next to each component name opens the node scenario analysis of the selected component node.

5. Node Values and Variances

At the top of the window under the node title, you can view the Scenario value (simulated value), baseline value, comparison value and their simulation impact, variance and original variance.

Variances and Simulation Impact

Original Variance shows the difference between the baseline value and the comparison before simulation.

Simulation Impact shows the difference between the simulated value and the baseline value.

Variance shows the difference between the simulated value and the comparison value.

6. Open Other Nodes

To include other nodes for similar analysis, click on + Add node details icon on the bottom panel.

Add node details

From the pop-up window, select the desired node for which you want to view the trend and analysis charts.

Select the node for analysis

It will be added as a new tab to view and compare the charts.

Europe node added for analysis

7. Table View

Toggle between table view and graph view by clicking on the table/chart icon at the top right corner of the window. Use the variance dropdown menu beside it to view the required data.

Toggle between Table view and Graph View

8. View Node Details

On the right, under the Details section, you can view the node details such as its lineage, type, configuration, time aggregation, simulation method, desired trend, and the node description if added.

Node Details

9. Add Note

On the right, under the Notes section, you can add new notes or view added notes. You can also add notes in the tree or table view which is explained in detail here.

10. Download Chart

The Download option on the chart lets you download the charts in PDF format.

Download Chart

11. Split Screen View

Use the Split screen option in the top right corner to view the tree/table model and simulation analysis window simultaneously.

Click 'Split screen' option

The split screen also offers all the above options available in full-screen mode.

Split Screen

You can switch between full-screen mode and split-screen mode. To close the analysis window click close.

Last updated