What can I use ValQ for?
ValQ is a multi-purpose product that can support use cases across the enterprise. In general, you can leverage ValQ for any decision-making scenario. Specifically, you can use it for dynamic what-if simulations, scenario analysis, variance analysis, business modeling, sales / financial / operations, forecasting, budgeting, intra-period re-forecasting, sensitivity analysis and more.
What is the difference between ValQ Collaborate and ValQ PBI Certified editions?
ValQ Collaborate edition is the all-inclusive edition of the product.
ValQ PBI Certified edition is the Microsoft-certified version of the product.
A pre-requisite for Microsoft certification is that the visuals do not access external resources. Unfortunately, the certification process does not distinguish between ‘good’ and ‘bad’ resource access – due to which even integration with Microsoft Azure is disallowed. Without this, features like collaboration & audit trail are not possible. As a result, we decided to release two editions of ValQ to give our users a choice. You may either go with the full-featured Collaborate edition or with the PBI-Certified edition – based on your comfort & convenience.
Is ValQ customizable?
Does ValQ require any coding knowledge?
No. You do not need to write any single line of code while using ValQ. Everything is configurable in the product.
How can I try out ValQ?
ValQ for Microsoft Power BI is available as a visual from the Power BI marketplace. You can also download it from our website. A best place to get started is here.
When was ValQ first launched?
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 to a next-generation product for Power BI with a lot of additional self-service capabilities.
Does ValQ have a documented User manual?
You can refer to our documentation for ValQ for Microsoft Power BI here.
Can I compare & save scenarios?
Absolutely. You can compare and save the scenarios to your database using one of several options available.
Can I collaborate with other users?
Yes. Several features such as Scenario collaboration, Planning collaboration, Commenting, History Log, etc. are available as part of collaboration.
How fast is the runtime performance of ValQ?
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.
How complex is the installation process?
Installation takes less than a minute. In Microsoft Power BI, it is as simple as adding the custom visual from the Power BI marketplace.
What are the data sources supported by ValQ?
ValQ is a Power BI custom visual hence it supports all the data sources that are supported by Power BI.
Why do I need to login to the visual multiple times?
Login is needed every time you access the visual when you are using a visual imported as Pbiviz file. To avoid this, kindly add the visual from Power BI Marketplace and switch to this new visual. Click here for steps to add ValQ – Collaborate visual from AppSource.
Is there a way to extract data from ValQ and use it to build a dashboard?
Yes, the Export as data source feature in ValQ Collaborate allows you to export series and/or scenarios as a Web URL and establish a live connection with the ValQ model.
Can I apply security on ValQ model to allow/ restrict access?
ValQ Collaborate offers role-based access control to your model, planning series, scenarios, and even the nodes. You can read more about the security roles and level of permissions here.
Can I write back the data from ValQ to my data source?
Yes, Writeback feature in ValQ Collaborate sends the model’s series/scenarios to a configured URL in a JSON format. Applications can process this JSON payload to write it to databases and other applications.
How safe is my data when I use ValQ?
The data used in the ValQ visual is secure, end-to-end encrypted and we can access only the metadata. If you want to retain the data completely within your organisation, we also offer On-Premise installation for ValQ Collaborate that will keep the data in your cloud instead of sending to our public cloud.
Do I need to sign-in to use ValQ?
Yes, you need to sign-in to access the ValQ workspace account which you are a part of to use ValQ Collaborate. Click here to learn more about the Admin Console Portal which is used to manage the ValQ Workspace.
Pricing & Licensing
How does the pricing work for ValQ Collaborate?
ValQ Collaborate has 4 different plans – 1 Basic Freemium and 3 paid plans. Click here to learn more about pricing.
Features & Capabilities
Can all Math (JS) methods be still used in formula like log(x) exp(x) in the Power BI version?
What types of formulae can be used in ValQ?
ValQ supports many traditional user-friendly functions 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,
- Logical functions such as IF, SWITCH, AND, OR
- Math functions such as POW, SQRT, EXP, LOG
- Finance functions 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 Range functions such as RANGE, FOREACH, GET and LastNPeriods.
Can ValQ be used with the onPrem version of Power BI?
Yes. On Prem Power BI is basically Power BI Optimized for Report Server. ValQ works with latest version of Power BI Desktop optimized for Power BI report server (Jan 2019 release).
Do I get to keep the data within my organization?
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 here.
Is there any ongoing support for ValQ?
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.
How to add or change the Microsoft account which is linked to my ValQ Account?
1. After login into the member console of ValQ, please click your profile icon in the top-right menu bar and click profile settings.
2. Then delete the already linked Microsoft account by pressing the delete icon in the Microsoft account section.
3. Now click the sign in with Microsoft button. It will popup the new window which will require one to log in to the Microsoft account and completing that process, your Microsoft account would be linked to your account correctly. After this, you would be able to login with Microsoft or from the Power BI ValQ correctly.
ValQ vs. Other Planning Software
How is ValQ different from commercially available planning software?
ValQ is designed to be self-service planning solution. It helps you model, plan, simulate on the fly. Most of the other commercial planning software usually follow bottom-up planning approach vs ValQ which follows top-down and Value driver planning approach.
- 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
Is ValQ intended to replace commercially available planning software?
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 a 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 faster planning cycle & reduced number of iterations. However, for small and medium business where there are no prior investments with planning software – ValQ can act us an independent planning and simulation software
We have an in-house, advanced software that we use for planning and budgeting. Why would we need ValQ?
With ValQ, you can model scenarios on the fly, and your executives can directly play around & interact with the models with minimal reliance on a IT analyst or consultant.
After a few initial iterations, discussions & feedback, you can subsequently leverage your planning software for a 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.
Try ValQ for Microsoft Power BI today for free
We’ll also share step-by-step instructions that will help you get started