What-If Analysis
Contents
Overview
Analysis of a What-If formula 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 Formula 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.
Create What-If Analysis
The process of creating What-If analysis
- To create and execute a What-If analysis click on click on Analysis What-If Analysis .
- All What-If formula, those created by you or shared with you will be displayed.
- To formulate a fresh analysis, click on New Analysis. The What-If dialog box will display.
- Use the search option to look for any existing What-If Analysis.
- Use the Filter by Datasource/Mode option to filter the What-If analysis based on the datasource.
- To switch the view between Card View and List View, click on the respective icons near to the search bar.
- To create a New Folder in the What-If formula, click on the Folder icon.
- To download the list of all existing What-If analysis, click on the Download icon. It delivers the details on (• Entity Id Name • Description • Content Tags • Created By • Created By User • Created On • Folder • Datasource Id • Datasource Name • Is Folder Public)
- When viewing the assets in What-If Analysis, keep an eye out for the "In Production" tag. This tag indicates that at least one of the elements (Queries, Reports, Tasks) is linked to a Job that is currently in the Production phase.
- Enter the analysis Name .
- Select the formula from the drop down.
- The drop-down list will get the list of all What-If formulas you have.
- To add dimension filter click on Add Filter.
- For the filter to be added, define the dimension, the conditional filter from the drop-down and fix the conditional value.
- Click on Save to add the what-if formula to Infoveave. View the newly created analysis under in My What-If Analysis tab.
Execute What-If Analysis
By initiating the execution process, you can 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.
- The dialog opens up for you define the parameters , Set alerts , save, load and export analysis or reanalyze when required.
- As you click on Execute Analysis, you will need to choose whether to have pagination or proceed without pagination.
- Executing the analysis will deliver the table on the rows processed.
- Infoveave will start processing the raw data inside the analysis engine as per the selected dimensions as filters.
- Executing the what-if analysis will deliver the calculated data based on the what-if formulas created.
- Example
- For the data source "Sales", we created a What-if formula. We also defined the measures as Factory Price (a), Shipping Cost (b), Transit Insurance percentage (c) and the expression Transit Insurance amount (d).
- We formulated the equation; Transit Insurance amount (d)= Factory Price (a) * {Shipping Cost (b) + Transit Insurance percentage (c)} or ( d = a * ( b + c ) ).
- Executing the What-If analysis on the formulas created, will deliver the value for the defined expressions (Transit Insurance amount (d)).
Group-by
By utilizing the drag and drop functionality, you can easily group data by arranging the column headings within the Group-by 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-by section.
- Place the column heading in the desired position within the Group-by section.
- Repeat the process for any additional column headings you wish to include in the grouping.
Manage Parameters
Managing parameters in What-If analysis is a crucial step in exploring different scenarios and understanding the 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. Additionally, you have the option to update the analysis data table before running the analysis. Once all the parameters are configured, you can run the analysis and gain valuable insights into the effects of parameter changes.
To manage parameters data, follow these steps:
- Click on Manage 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 Formula) 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.
- If you select an Expression(defined in the What-If Formula) as the key, an additional field "Effect on" will appear. This allows you to specify the parameter on which the effect will occur.
- If you choose the "In relation to" option, define the key parameter in the "Based on" field. Then, you must select another dimension and dimension item that reflects the change you want to analyze.
- Update Value Copies (Optional): Check the “Update Value Copies” checkbox if you want to update the analysis data table. This ensures that the next analysis is performed using the most up-to-date data (if required).
- Add Parameters: Once you have defined all the necessary fields, click on the “Add Parameters” button to include the configured parameters.
- Run Analysis: To execute the analysis with the defined parameters, click on the “Analysis” button.
- Example: Consider we wanted to see how the "Factory Price (a)" is going to get altered if the we multiply the "Transit Insurance Amount (d)" by 10 times. By analyzing the new parameter will get to know the new value for the "Factory Price (a)".
- Hover the mouse over the altered rows to see the Original, Updated and Change Price.
Set 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.
- Select the desired Key: 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.
- Choose the appropriate Operator: Select the operator that defines the condition for the alert. Options may include greater than, less than, equal to, or other comparison operators.
- Specify the Value: 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 desired): Activate this option to highlight the entire row in the data table when the alert condition is met. This helps to visually identify the affected data.
- Select a Color: Click on icon to add a color to highlight the row when the alert condition is triggered.
Save Analysis
Saving the analysis in Infoveave What-If Analysis allows you to preserve and store your analyzed parameters and processed data. By naming and adding the analysis to Infoveave, you can easily access and manage multiple analysis scenarios. This enables you to revisit and compare your findings, track changes, and make informed decisions based on the insights gained from the What-If Analysis
- To save the freshly analyzed parameters and the processed rows click on Save .
- Name the new analysis.
- Click on Add Analysis Scenario, to add the new analysis to Infoveave.
Load 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 an analysis previously saved, 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.
Export 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 with the icon.
- When exporting the What-If Analysis in Infoveave, the analysis results will be downloaded in the format specified under the "Manage Exports" section of the corresponding What-If formula.
- Make sure to configure the desired export format in order to obtain the analysis output in the desired format during the download process.
Reanalyze
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.