Part 6: Analyze Results

In this part, you create different chart types to inspect the simulation results .

Analysis in Valsight is using charts, bridges, and tables to compare scenarios, understand changes, and interpret model outcomes.

For detailed reference on any of the concepts here, see Visualizing Data.

Watch the video guide

Step 1: Create a column chart

1. Navigate back to sheet.

2. Click Add chart.

3. Choose Column chart.

4. Select Revenue as the measure.

5. Chose Simulation as the scenario.

6. Create the chart.

7. Open Configure axes

   • X-axis: Year (default)
   • Groups: Remove “Scenario” and add Product instead.

8. Enable Stacked view using the checkbox below the chart type selector.

9. Enable Totals and select Combined sum to show the combined revenue for both products.

10. Under Scaling and Digits, set the scale size to Thousand and decimal places to 0.

11. Click Save.

The bar chart shows Revenue by Year, stacked by Product, with totals displayed.

Step 2: Add the Scenario Manager as a chart

1. Click Add chart again.
2. Select Scenario Manager.
3. Create the chart.

Activate or deactivate assumptions and immediately see the results update in the bar chart.

Step 3: Create a scenario bridge

1. Click Add chart.
2. Select Scenario bridge.
3. Select node: Revenue
4. Choose the two scenarios you want to compare.
5. Choose Assumptions for Comparioson
6. Select the year 2029 for display.
7. Create the bridge.

The bridge now shows how much “Price Adjustment” and “Volume Change” each contribute to the revenue difference between the data baseline and the Simulation scenario in 2029.

Step 4: Create a table

10. Click Add chart.

11. Select Table.

12. Select Volume, Price, and Revenue

13. Choose the Simulation scenario and click Create.

14. Set Aggregation type of Price to Weighted Average in the Model Editor.

15. Open Configure axes:

    • Remove Scenario from the columns
    • Add Year to the columns.

16. Under Rows click on Sort and place Revenue on the latest position.

17. Under Columns click on Create Comparions

    • Reference value: 2025
    • Comparison value: 2029
    • Type: CAGR

18. Under Formatting and Rows, set Revenue as a grand total row and indent Volume and Price.

19. Click Save.

What you have done

• Added the Scenario Manager to the workspace
• Created charts to analyze KPI development

Summary

Congratulations! You have built a complete Valsight project from scratch:

• created a project
• set up dimensions and uploaded data
• built a driver model
• simulated assumptions
• analyzed the results

Key functions used

Next steps

• Add more scenarios in the Scenario Manager and compare them
• Experiment with Line-Item Variants like Best, Realistic, and Worst
• Explore the Function catalog for additional modeling functions
• Learn more about Structure Driver Models in the Valsight documentation