Introducing What-If Analysis
Analysis of a What-If Formulae with applied filters is known as What-if Analysis. You will have the ability to adjust or modify the values of the variables used in the What-If Formulae while performing a What-If Analysis. Additionally, it will let you to analyze a wider range of case scenarios by running various analysis conditions. The What-If Analysis will help you to define and manage the parameters for different scenarios along with setting alerts.
Accessing What-If Analysis
- To create and execute a What-If Analysis click on Analysis What-If Analysis .
- To formulate a fresh analysis, click on New Analysis. The What-If dialog box will display.
Selecting the What-If Formulae
Identify and select the configured What-If Formulae, ready to be analyzed over various goal seeking scenarios.
- Enter the analysis Name.
- Select the formula from the drop down.
- To add dimension filter, click on Add filter.
- Click on Save to add the What-If Formulae to Infoveave. View the newly created analysis under My What-If Analysis tab.
Executing What-If Analysis
Initiating the execution process, allows you to perform the What-If Analysis with your chosen parameters and view the outcome in a table format.
- To execute click on Execute icon on the newly created Formulae.
- As you click on Execute, you will need to choose whether to have pagination or proceed without pagination.
- The dialog opens with the Edit analysis, Edit formula, Parameters, Alerts, Add analysis scenario, Load and Export Analysis or Reanalyze when required.
Group
The drag and drop functionality, allows you to easily group data by arranging the column headings within the group section to achieve the desired grouping structure.
To group data, follow these steps
- Locate the column headings that you want to use for grouping.
- Use the drag and drop function to click and hold on a column heading.
- Drag the column heading to the group section.
- Place the column heading in the desired position within the group section.
- Repeat the process for any additional column headings you wish to include in the grouping.
Editing Analysis
Edit Analysis allows you to edit your What-If Analysis to incorporate all the required changes and reanalyze the formula.
To modify a What-If Analysis in Infoveave, follow these steps
- Click on the Edit icon associated with the analysis.
- Modify Analysis components as required
- Edit name Enter a new name that accurately reflects the purpose or updates of the analysis.
- Change formula Select new formula from the list of available formulas previously created.
- Edit/Change filters Edit or change the filters or conditions to focus on specific data subsets.
- Click on the Save button to save your edits.
Editing Formula
Editing the What-If Formulae in Infoveave allows you to bring refinements to the formula logic, expressions, or parameters. It enables you to fine-tune the formula based on changing requirements, data updates, or insights gained from previous analysis.
To modify a What-If Formulae in Infoveave, follow these steps
- Find the specific What-If Formulae that you want to edit.
- Click on the Edit icon associated with the formula.
- After making the necessary modifications to the formula components, click on the Save button to save your edits.
Managing Parameters
Managing parameters in What-If Analysis helps you explore different scenarios outcomes. By defining the key, dimension, and dimension item, you can specify the parameters for analysis. The change type options allow you to determine how the values will be modified, whether by a specific value, percentage, or based on another parameter.
To manage parameters data, follow these steps
- Click on Parameter icon .
- Define Parameters Start by specifying the parameters you want to analyze. Fill in the following fields
- Key Add the key (defined in the What-If Formulae) associated with the parameter.
- Dimension Select the dimension relevant to the selected key parameter.
- Dimension item Choose the specific dimension item for the selected dimension.
- Define Change Type Determine how the values will be modified by selecting one of the following change types
- Value by Modify the value by a specific numeric value.
- Percent by Modify the value by a percentage.
- Value to Set the value to a specific numeric value.
- Keep old value Retain the original value without any changes.
- In relation to Define the change value based on another parameter.
Value by
- Key Enter a unique identifier or key for this parameter. This key helps you distinguish and manage different parameters within your analysis.
- Dimension Select the relevant dimension for this parameter. Dimensions are the aspects of your data that you want to analyze or modify.
- Dimension item Specify the specific item within the selected dimension that you want to focus on. This is the particular element or category you’ll be modifying.
- Value Set the initial value of the parameter. This value represents the starting point for your simulation. You can input a numeric value or use arithmetic operations like addition (+10) to establish the parameter’s baseline.
Percentage by
- Key As with the previous parameter, provide a unique identifier or key to differentiate it from others.
- Dimension Choose the dimension associated with this parameter. Different dimensions may be used to analyze various aspects of your data.
- Dimension item Specify the dimension item. This helps you narrow down the specific element within the chosen dimension that you’re targeting.
- Percentage Define the percentage change for this parameter. It represents the adjustment you want to make, expressed as a percentage. You can input a numeric value (e.g., 10) or use arithmetic operations (e.g., +10%) to indicate the change.
Value to
- Key Assign a unique identifier to this parameter, just like the others.
- Dimension Select the relevant dimension, considering the specific aspect you want to modify.
- Dimension item Specify the dimension item to focus on within the chosen dimension.
- Value Set the final value for the parameter. This value represents the result you want to achieve after applying changes. You can use numeric values or arithmetic operations (e.g., +10) to define the parameter’s outcome.
Keep old value
- Key Define a unique identifier for this parameter.
- Dimension Choose the dimension for this parameter. Dimensions allow you to categorize and organize your data for analysis.
- Dimension item Specify the dimension item. This is the data point within the selected dimension that you intend to maintain without changes.
In relation to
- Key Provide a unique identifier for this parameter.
- Dimension Select the dimension associated with this parameter.
- Dimension item Specify the specific dimension item.
- Based on dimension Choose the base dimension that will influence the parameter you’re defining.
- Based on dimension item Specify the specific item within the base dimension that forms the basis of your parameter.
Alerts
Set alerts on the data table, to easily identify and visualize specific data points that meet certain conditions. This helps in monitoring and analyzing the impact of parameter changes in the What-If Analysis.
To set alerts on the data table in What-If Analysis, follow these steps
- Click on Alerts icon to set alerts.
- Choose the key parameter on which you want to set the alert. This parameter will be used as the basis for evaluating the alert condition.
- Select the operator that defines the condition for the alert. Options may include greater than, less than, equal to, or other comparison operators.
- Enter the value against which the condition will be evaluated. The alert will be triggered when the data meets the specified condition.
- Enable Highlight Entire Row (if required), to highlight the entire row in the data table when the alert condition is met. This helps to visually identify the affected data.
- Click on Add button to add the alert .
Reanalyzing scenarios
Reanalyzing in Infoveave What-If Analysis allows you to rerun the analysis with the original parameters and data. By selecting the Reanalyze option, you can quickly refresh and update the analysis results based on any changes made to the data or parameters.
Add analysis scenario
- Name the new analysis.
- Click on Save, to add the new analysis to Infoveave.
Loading analysis
Loading an analysis in Infoveave What-If Analysis enables you to retrieve and review previously saved analysis scenarios. By selecting the desired analysis from your saved list, you can quickly access and analyze the parameters, data, and insights generated during the previous analysis session.
- To load previously saved analysis, click on Load analysis.
- Select the analysis from the list and click on the icon.
- To remove any analysis from the list of Load analysis, click the Delete icon.
Exporting analysis
Exporting analysis in Infoveave What-If Analysis empowers you to save and share your analysis results in different formats. By exporting the analysis, you can generate reports, create visualizations, or utilize the data for further analysis in external tools.
- Click on Export analysis to export/download the analysis to the local folder as a .xlsx file.
- Download the file by clicking the Download icon.