Consulting analysis and scenario modelling tool

The consultant compares the client's operating alternatives, costs and potential results. The saved assumptions and calculations help explain the recommendation and update it when data changes.

Questionnaires, interviews, rating scales, calculations and conclusion logic depend on the specific consultant or project. It is difficult to compare customers, ensure quality and reuse knowledge of previous projects.

How the solution works

  1. A consultant with a client reconciles the issue of analysis and comparative choices.
  2. The team collects data and finds out the missing information.
  3. Calculations are prepared with clearly written assumptions.
  4. Comparison of options and verification of what would change in the absence of assumptions.
  5. The specialist reviews the analysis and explains the recommendation to the client.

Key challenges

  • Diagnostic methodologies are applied unevenly
  • Analysis assumptions, data versions, and rationale for findings are difficult to trace

Solution capabilities

Client Data and Sources

The consultant collects used documents and data to the analysis. Their period, corrections and missing information are visible.

Computational Methods

The command chooses the method appropriate for the question and records how it is applied. This allows colleagues to check the calculation and understand the conditions of the comparison.

Alternative Calculations

For each variant, costs, formulas and assumptions are saved. Changing them allows you to compare a new result with the previous one.

Comparison of actions

The consultant compares several real actions, such as changing the order of work, expanding the existing system or investing in a new one. See the conditions and expected benefits of each option.

Review of Recommendation

Another specialist can check sources, calculations and conclusion. When new data is received, it is seen which part of the recommendation needs updating.

Business context

Diagnostic methodologies are applied unevenly
Questionnaires, interviews, rating scales, calculations and conclusion logic depend on the specific consultant or project. It is difficult to compare customers, ensure quality and reuse knowledge of previous projects.
Analysis assumptions, data versions, and rationale for findings are difficult to trace
Calculations and scenarios are created in different tables, and in the final slides it is not always clear what data and assumptions are used. The client has difficulty checking the conclusion, and when the data changes, the analysis has to be restored manually.
The recommendation allows the client to compare the consequences of decisions
The client of the consultation needs to understand what the proposed action is based on and under what conditions it is useful. Saved calculations and assumptions allow comparison of alternatives. Changing the data allows you to update the evaluation instead of creating a new recommendation without a history of the previous decision.

Core features

  • Client Data and Sources
  • Computational Methods
  • Alternative Calculations
  • Comparison of actions
  • Review of Recommendation

Key integrations

Client Data Sources
Translated facts, periods and agreed rights of use.
The Knowledge Base of Methods
The methodologies, assumptions and past case limits to be applied.

Potential impact (%)

The ranges indicate an illustrative relative change in the metric under the stated assumptions. Results depend on the starting position and actual use of the solution. Percentages for different metrics must not be added together.

Findings recovery work

16–42%Decreasing

This illustrative scenario assumes that 40-70% of information searches and repeated cross-checks can be addressed. That share is assumed to fall by 40-60%. Company data is needed to verify both the addressable workload and the resulting change.

Measure minutes to restore the selected conclusion to its original sources.

An analysis error has led to a strange recommendation

5–25%Decreasing

This illustrative scenario assumes that 20-50% of missed actions can be identified through task and deadline tracking. That share is assumed to fall by 25-50%. Company data is needed to verify both the addressable share and the resulting change.

Compute for incorrect source, formula or assumption after transmission of corrected conclusions.

Part of negative feedback on the applicability of analysis findings

3–12%Decreasing

Indicative assumption: 15-30% of negative reviews relate to unexplained performance alternatives and their assumptions. The solution could reduce this proportion by 20-40%. This is a scenario of potential; the assumptions need to be verified by feedback collected by the company.

When a company starts collecting feedback, negative reviews about the applicability of analysis findings are calculated from all evaluations received on the topic. The same method of evaluation is applied before and after installation and similar customer groups are compared. Without initial data, the actual change is not determined.

Conditional calculation scenarios. The assumptions have not been validated against client measurements.

When this solution is relevant

  • The client's question has to be answered by searching for several spreadsheets and previous versions of them.
  • As the data changes, it is difficult for the team to determine which calculations and recommendations need to be updated.

Implementation requirements

The calculations, data sources and document storage used are compatible with the team. Determine who checks the analysis and how changes to the assumptions are captured. Not only amounts but formulas are checked when transferred from spreadsheets.

Further development options

  • Adding additional computational methods used by the team
  • Updating the analysis to new customer activity data

Frequently asked questions

Adapting the solution to your business