Metric Drivers

Maegan Morrison
Maegan Morrison
  • Updated

Metric Drivers Managed Skill Icon.jpg

Skill Setup

Ensure a metric hierarchy is properly setup within your dataset. 

 

To set up your hierarchies:

  1. From Skill Studio, choose your Metric Drivers skill. Select the data icon from the toolbar.
    Set up hierarchy 1.jpg
  2. Scroll to the toggle for Description and Misc Info. Choose Misc Info.
    Misc Info.jpg
  3. Here is where you will insert your Python code building out your hierarchy. (Example below).
    Put in Hierarchy.jpg

 

Dimension & Metric Hierarchy Example:

{
  "metric_hierarchy": [
    {
      "metric": "sales",
      "parent_metric": "value_share"
    },
    {
      "metric": "volume",
      "parent_metric": "sales"
    },
    {
      "metric": "price",
      "parent_metric": "sales"
    },
    {
      "metric": "TDP",
      "parent_metric": "volume"
    }
  ],
  "dimension_hierarchy": [
    {
      "col": "market",
      "children": [
        {
          "col": "category",
        "children": []
        }
      ]
    },
    {
     "col": "manufacturer",
      "exclude_in_mkt_size": true,
      "children": [
        {
          "col": "brand",
          "children": []
        }
      ]
    }
  ]
}

Notes on metric hierarchy:

[{
      "metric": "sales",
      "parent_metric": "value_share"
    }]

Notes on dimension hierarchy: 

{
      "col": "market",
      "children": [
        {
          "col": "category",
          "children": []
        }
      ]
    }

 

Use this skill to

Identify the key drivers of a metric.

 

This skill is good for

Metric Drivers provides users with an understanding of the drivers of change for a specific KPI. The provided answer will include an explanation of the driving metrics, as well as different dimensional drivers. Users will be able to view the ranking of each dimension, the impact on change, and the ranking change of each dimension value to understand which are contributing to growth/decline of the metric.

 

Default Visualization

Multiple Pivot Tables

Metric Drivers.jpg

 

Example Questions

  • Can you explain the sales decline for Barilla in March of 2023?
  • How is rice performing in terms of sales growth?
  • Why is whole grain pasta experience a decline in volume?

Was this article helpful?

Comments

0 comments

Article is closed for comments.