What is Period-over-Period analysis?

Calculations in Sigma

Mandy Gray

Solutions and Enablement Lead, Aimpoint Digital

What is period-over-period (PoP) analysis?

  • Period-over-period analysis compares values across different timeframes

One_month_comparison.png

Calculations in Sigma

What is period-over-period (PoP) analysis?

  • Period-over-period analysis compares values across different timeframes

Two_month_comparisons.png

Calculations in Sigma

Defining comparison periods with Oakmark

  • Initial challenge is to define which time periods to compare

Calculations in Sigma

Choosing the best timeframe for comparison

  • Compare January transactions to December transactions

Calculations in Sigma

Choosing the best timeframe for comparison

  • Compare January transactions to December transactions

  • Compare January this year to January last year

Calculations in Sigma

Comparing short-term and long-term data

  • January to December comparison shows short-term volatility but not long-term trends

  • Better to compare January this year to January last year

Calculations in Sigma

Aligning timeframes with analysis goals

  • Many options for comparing time periods
  • Always compare apples to apples (same time periods)
  • Sigma makes selecting timeframes intuitive

Calendar comparison showing month vs quarter mismatch

Calculations in Sigma

DEMO

Calculations in Sigma

Let's practice!

Calculations in Sigma

Preparing Video For Download...