Metric Drivers

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.
   
2. Scroll to the toggle for Description and Misc Info. Choose Misc Info.
   
   
3. Here is where you will insert your Python code building out your hierarchy. (Example below).
   

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

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?

Updated April 10, 2024 16:03