Attribution Analysis using ValQ

by | Aug 7, 2020 | Features, Power BI, ValQ

With ValQ, it is now possible to analyse the effect of different key performance indicators and key inputs on the simulated results of an outcome using attribution analysis. In this blog, we cover the steps to perform attribution analysis with an example. 

Consider the profitability of a mining operation that is shown below. Let us say you have performed some simulations which can be seen in the right panel. The effects of these simulated drivers on KPIsuch as Net Profit can be analysed using Attribution Analysis.attribution-analysis-using-valq

1. In the ‘Analyze’ tab, click on ‘Attribution Analysis’.attribution-analysis-using-valq

2. The default screen is shown below. There are three parts in this screen – toolbar, waterfall chart and table.attribution-analysis-using-valq

3. Let us first look at the waterfall chart. You can enter full-screen mode by clicking on the zoom icon at the bottom right. You can see the following:

  • Forecast value is shown in grey
  • Simulated value is shown in blue
  • Simulations with positive and negative impact are shown in green and red respectively to explain the variation
  • On hovering over the bars, additional information such as the simulation impact and variation in percentage is displayed

attribution-analysis-using-valq

4. By clicking on the icons highlighted, you can toggle between horizontal and vertical waterfall charts.attribution-analysis-using-valq

5. Now, let us look at the table. By default, you can see

  • For the outcome KPI – Baseline and Simulated values, Variance and Variance %
  • For the drivers – Baseline and Simulated values, impact on outcome KPI and Attribution %

Attribution % is the contribution of the driver to the variance % of the outcome KPI. For example, a variance of (3,335k) in Net Profit corresponds to -5.9 in % terms. Consider the simulation impact of Grade, which is 15,590k hence its attribution % is 27.4.attribution-analysis-using-valq

6. On the top right, you have the option to show/hide Contribution %. Contribution % is calculated as the contribution of the driver to the variance of the outcome KPI.

For example, Grade contributes 15,590k to Net Profit’s variance of (3,335k) which translates to a Contribution % of -467.4.attribution-analysis-using-valq

7. Similarly, you can perform attribution analysis for different KPIs by making the desired selection in the Outcome KPI field in the toolbar.attribution-analysis-using-valq

8. Scenarios created in the Simulate tab can be selected in the dropdown as shown.attribution-analysis-using-valq

To know more about the exciting features in ValQ 1.8, visit the summary blog here.

Download the latest version here and get started with ValQ today.

ValQ is now PBI Certified

Related Posts

Get Started with ValQ today!

Try ValQ to instantly visualize the power of business optimization.

Share This