ValQ Premium FAQs
Last updated
Last updated
ValQ is a multi-purpose product that can support use cases across the enterprise. In general, you can leverage ValQ for decision-making by way of dynamic what-if simulations, scenario analysis, variance analysis, business modeling, sales/ finance/ operations, forecasting, budgeting, rolling forecast and more. Specifically, for the finance domain, ValQ supports advanced use cases such as financial planning & analysis and the three-statement model.
ValQ for Microsoft Power BI is available as a custom visual in the .
No. You do not need to write even a single line of code while using ValQ. Everything is configurable in the product.
Installation takes less than a minute. It is nothing but adding a custom visual in Microsoft Power BI from the Microsoft AppSource.
ValQ is a Power BI custom visual hence it supports all the data sources that are supported by Power BI.
ValQ Premium is a certified Power BI visual. A certified PBI visual meets the Microsoft PBI code standards and guidelines. Therefore, it is secure.
ValQ comes with an embedded calculation engine that handles all calculations locally (front-end) on the fly. Once data is loaded into the tree for the first time, all further interactions & what-if analyses are handled locally without any requests going back to the server or the data source. As a result, any changes due to simulations are updated in a fraction of a second.
ValQ is a mature product that has been in existence for 4+ years. Earlier known as ‘Value Driver Tree’ for SAP Lumira designer, the product was adopted by several enterprise customers to build value driver planning with 1400+ KPIs. Since then, ValQ has evolved into a next-generation product for Power BI with a lot of additional self-service capabilities.
ValQ allows a high degree of customization, without the need to write code. The tree structure of KPIs, the hierarchy, and calculations involved at each level that define the relationship between KPIs, reports, dashboards, presentation slides, conditional formatting, number formatting, scaling, etc. – all are customizable.
Absolutely. You can compare and save the scenarios to your database using one of several options available.
Yes. Several features such as Scenario collaboration, Planning collaboration, Commenting, History Log, Model Merge, Writeback, etc. are available as part of the collaboration.
However, all these collaboration options are available only with the ValQ Enterprise edition.
The Plan tab does both bottom-up as well as top-down allocations. E.g. Changes to sales projections for a product can be proportionally allocated to geographies or SKUs using several distribution methods. You can also view how it impacts the overall KPIs like net profit. You can modify the baseline series(after creating a copy of it) and use the updated one as a reference on which you can develop multiple scenarios.
Simulate tab does only bottom-to-top allocations. Any changes you simulate at a particular node roll up to the top. It does not ‘allocate’ the impact of such simulation to its children. Every scenario is created with the baseline data series as a reference. Hence, there is a logical separation between baseline series vs. scenario data.
ValQ is designed to be a self-service planning solution. It helps you model, plan, simulate, analyze, report and visualize on the fly. Most of the other commercial planning software usually follows a bottom-up planning approach, but ValQ uses both top-down and value-driver planning approaches.
You can model business scenarios on the fly – in a matter of few hours to a few days – something that would take weeks or months with best-in-class bottom-up planning software.
Highly visual and intuitive user experience means executive and operational management alike can analyze and simulate on their own completely changing the use of models
You have a high-performance experience as ALL calculations happen on the front end.
Yes and No. It depends on the size of your business and whether you have prior investments with other planning software or not. For large enterprises that already have planning software in place, ValQ can complement existing bottom-up planning processes by helping you build interactive & dynamic top-down planning models. This delivers time & cost savings through a faster planning cycle & reduced number of iterations. However, for small and medium businesses where there are no prior investments in planning software – ValQ can act as an independent planning and simulation software.
With ValQ, you can model scenarios on the fly, and your executives can directly play around & interact with the models with minimal reliance on an IT analyst or consultant.
After a few initial iterations, discussions & feedback, you can subsequently leverage your planning software for more detailed fine-tuning, configuration and validation. This saves a lot of time & effort. Your business meetings would also be more effective using ValQ as executives can receive instantaneous feedback on changes to scenarios.
Yes. On-prem Power BI is basically Power BI Optimized for Report Server. ValQ works with the latest version of Power BI Desktop optimized for the Power BI report server.
Yes. ValQ offers global enterprise-class support for customers supported by a valid support and maintenance agreement. There is a dedicated helpdesk with a support portal that customers can access.
All mathematical JS methods will work in ValQ .
ValQ supports many traditional user-friendly that allow you to create complex models. You may recognize many of these from your experience with Microsoft Excel. Listed below are a few examples,
such as IF, SWITCH, AND, OR
such as POW, SQRT, EXP, LOG
such as IRR, NPV, PMT, RATE
An ability to refer to individual or combination of period values of nodes has also been introduced with the such as RANGE, FOREACH, GET and LastNPeriods.
Yes, we offer On-Premise installation of ValQ for Power BI which allows you to keep the data completely within your organisation. If you want to talk to us about On-Premise, kindly drop your questions .