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

Steps

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. Choose Simulation as the scenario.

   6. Create the chart.

   7. Open Configure axes and set:

      Setting	Value
      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.

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.

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 Comparison
   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.

4. Create a table

   1. Click Add chart.

   2. Select Table.

   3. Select Volume, Price, and Revenue

   4. Choose the Simulation scenario and click Create.

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

   6. Open Configure axes and set:

      Setting	Value
      Columns	Remove Scenario, add Year

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

   8. Under Columns click on Create Comparison and set:

      Setting	Value
      Reference value	2025
      Comparison value	2029
      Type	CAGR

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

   10. Click Save.

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

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