This page details the « Finance – Controlling» example in our demo solution.
Here is a sample of the data:
You can download the source here: Gsheet
In DataMa Compare
This financial assessment example differs from standard cases because the metric relation does not represent a conversion funnel, but a business equation.
We are comparing the amount of margin, in this case, the margin is the product of :
Margin = Number of Items x (Revenue / Items) x (Margin / Revenue)
This would split the different effects of your business performance: the volume of items sold, the revenue made with these items sold, and the margin earned. This equation could be modified to be much more complicated (integrating, for example, the number of distribution points selling the product, etc.)
To better understand Metric Relation read our article.