Define core calculations with metrics

Data Modeling in Sigma

Ben Harris

Technical Instructional Designer at Sigma

Scenario setup

 

Scenario setup

Problem statement:

• Analysts are seeing different results in summary calcuations

Scenario setup

 

What are metrics?

Solution

• Metrics = reusable calculations

What are metrics?

• Metrics keep calculations consistent
• Prevent small mistakes when making manual calculations

What are metrics?

Revenue example:

• Company wide consistency

Demo

Demo

Demo

Demo

Demo

Demo

Demo

Metrics vs calculated columns

 

Metrics vs calculated columns

• Metrics are calculated across the entire element
• Update based on changes in the data source

Metrics vs calculated columns

• Metrics use an aggregate function: SUM(), AVG(), COUNT(), etc
• Metrics cannot use window functions

Metrics vs calculated columns

• Use metrics for calculations across users
• Use metrics for KPI consistency across users

Let's practice!

Data Modeling in Sigma