Enrich a data model by adding a metric

Data Modeling in Sigma

Ben Harris

Technical Instructional Designer at Sigma

Scenario setup

  • Analysts are analyzing total savings
  • Inconsistent results across analysts

oakmark bank

Data Modeling in Sigma

Scenario setup

  • Leadership: raw data is correct
  • Mismatch from different calculations

oakmark bank

Data Modeling in Sigma

Scenario setup

Solution:

  • All analyst should use Oakmark's standard method

recraft: half: Analysts with different total amounts on screens

Data Modeling in Sigma

Scenario setup

Solution:

  • Codify this logic in a metric

recraft: half: Analysts with different total amounts on screens

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Demo steps

Data Modeling in Sigma

Let's practice!

Data Modeling in Sigma

Preparing Video For Download...