Three ways of building a model in ValQ

by | May 24, 2019 | ValQ

ValQ helps executives visualize their business models in an intuitive & engaging manner. It achieves this by capturing the relationship between several key business drivers (something that can be adjusted or controlled, e.g. production downtime) and the business outcome (something that the stakeholders or management cares about, e.g. Net Profit).

This blog features three ways (Image 1) to build such a model in ValQ.

Three ways of building a model in ValQ

Image 1: Three ways of building a model in ValQ

1. Simple Dynamic Model: The first and easiest way is to use the option ‘Create a simple dynamic model’, which can help you build your model in less than five (5) minutes. In this method, you bring your own data and start assigning them to ValQ, and you can observe the model being created simultaneously. The model assumes that all calculations are additive (e.g. add all the values of the children to arrive at the value of the parent) – so it can be applied typically to sales scenarios where the sum of sales from one entity (product) simply equals sales for its parent entity (product category).

View the following quick video for creating a simple dynamic model using ValQ.


Image 2: Create a simple dynamic tree

2. Building an Advanced Model from Scratch: Unlike the previous option, this method would require you to define the relationships between KPIs (e.g. Revenue = Sales * Unit Price).  You will also have to define additional properties like aggregation methods over time periods (e.g. Total for ‘Sales’, Weighted Average for ‘Unit Price’). There are some additional properties to be configured as well. View the 12-minute video enclosed below that showcases how to build an advanced model from scratch.

Video: Building an advanced model from scratch

3. Importing an Advanced Model: The third option is the ‘Import an advanced model’, in which you can first define a model using an excel template and import the entire configuration in one shot. This is helpful when you are building extra-large models (e.g. 500+ nodes). The template file also doubles as a requirements document – something that can be reviewed when needed to.

To learn more, tune into one of our ValQ Webinars or try our product for free here.

ValQ is now PBI Certified

Related Posts

Get Started with ValQ today!

Try ValQ, Modern Visual Planning for Microsoft Power BI to instantly visualize the power of business optimization.

Share This