Understand the impact of cell changes

Understand the impact of cell changes

Ever wondered what input cells have the greatest impact on a key output so you can analyse them and understand how to reduce your costs, grow your revenues or increase/decrease any important Key Performance Indicator?

You can use auto-analysis to get a comprehensive analysis and report with one click: How to run Autoanalysis in Visyond.

How can I know which input cells have the greatest impact on a certain output?

Tornado Analysis will tell you how much a selected output is sensitive to fixed changes in driver cells. You will be able to answer questions like: ‘By what percentage the Output changes when the drivers, one by one, change by x%?

A Tornado chart is simple to read and understand and can help you present with impact.

tornado

See How to run Tornado Analysis in Visyond

How can I observe the changes of an output cell when one or two input change?

You built your model and the answer is “Profit = USD 100M”. Your manager of client asks “ok, but WHAT-IF this or that changes?”.WHAT-IF questions are very common and with Visyond you can answer them in a few clicks.

Sensitivity analysis helps you understand the relationship between input and output variables in a model.

running sensitivity analysis

Dependencies Analysis

If you want to visualize how cells are connected and how their changes impact their dependencies, you need the Dependency Analysis module.

how to
August 11, 2018

Was that post helpful?

Related Articles