Metric relation describes the equation between metrics of your source, in order to compute the KPI you want to observe.
At DataMa, we call it the « Market Equation ». Find more information on how to create a metric relation in our article
Building it can be a little bit tricky, but generally you have it behind your business KPIs. All you need to do is come back to basics and try to write down how your metrics are related.
A simplistic retail example: As a retailer I want to understand my Revenue. So my main KPI is
Now, I can easily split Revenue that way:
Revenue = Volume * Revenue / Volume. That makes a lot of sense, because then I have two underlying performance indicators (PI) that actually helps me split the different effect behind what I observe on my main KPI
Revenue. First underlying PI is
Volume (the number of products I sell), and the other is
Revenue/ Volume, which is basically my unit price.
Why do I want to split those? Well basically because it’s not the same team in charge of volumes and the one in charge of pricing. So, in order to be able to identify where I need to improve, I need to split those two effects
Within DataMa PIVOT, we call each underlying PI a « Step », because it will be steps of the waterfall you’re building. Number of steps can be theoretically unlimited, but for obvious visual and business reasons, you probably want to limit to no more than 10 steps.
One « Step » is a ratio between two metrics of your source. You have a numerator and a denominator. When no denominator exists (e.g.
Volume) we just say that Denominator is 1.
Steps gets multiplied together in order to get your KPIs. So, if your file has 5 metrics (call it
Metric1, Metric2, ..., Metric5) and your main KPI is Metric5 Metric Relation would typically look like this:
Metric5 = Metric1 * Metric2/Metric1 * Metric3/Metric2 * Metric4/Metric3 * Metric5/Metric4
Don’t be afraid of putting too many PIs in that equation: with DataMa PIVOT, you can always zoom in to part of the equation, or aggregate some components using the « Skip steps » functionality.
DataMa Demo can help you get idea of Metric Relation you may want to build.