How to Find Signals in Your Seasonal KPIs

November 20, 2012 by Stacey Barr

One of the trickiest KPIs to analyse, interpret and use are those that have a seasonal or cyclical pattern. Can you make these KPIs reveal their insights about how to improve performance, without getting drowned out in the seasonal variation? Yes you can!

Most problem KPIs just need a bit of transformation before they can reveal their insights about changes due to factors other than the ‘change of the season’.

KPIs with seasonal or cyclical patterns…

It might be Retail Sales with an annual seasonal pattern driven by consumer behaviour. Or Staff Turnover with a quarterly cyclical pattern driven by employing temporary staff. It might be a daily cycle of traffic congestion.

It’s any performance measure that shows a repeating pattern of variation over consistent timeframes.

chart showing seasonal retail salesAny cyclical or seasonal measure can be “deseasonalised”…

The simplest method I know of to deseasonalise a time series of performance measure values is the method that Donald Wheeler outlines in Chapter 18 of his great book “Making Sense of Data”.

You calculate the average measure value over the period of seasonality, which might be a year. Let’s call that the ‘Seasonal Average’. For example, the monthly average value of Retail Sales over the first year in the time series might be $24,593.

You then calculate ‘Seasonal Relatives’ by dividing your measure values by their corresponding ‘Seasonal Average’. If the Retail Sales for January in the first year was $21,860, then the ‘Seasonal Relative’ for January in that year would be 0.889.

From these ‘Seasonal Relatives’, a ‘Seasonal Factor’ for each month of the year is computed by taking the average of all the Seasonal Relatives for that particular month of the year. Let’s say that over all 3 years in our time series of Retail Sales, the ‘Seasonal Relatives’ for January are 0.889, 0.908 and 0.941 respectively. Their average is 0.912. That’s the ‘Seasonal Factor’ for January in general.

Finally, to remove the seasonal effect from your actual performance measure values, you divide each measure value by the ‘Seasonal Factor’ that corresponds to its month of the year. For January in the first year, it’s deseasonalised value would be $21,860 divided by 0.912 which is $23,959.

The best way to analyse your deseasonalised KPI…

The best way to then search for real signals of change in your KPI is to construct a Smart Chart for the deseasonalised measure values. (Until November 30, 2012 you can view a free webinar replay introducing what a Smart Chart is.)

chart showing deseasonalised retail salesTAKE ACTION:

Got a seasonal KPI? Try this method and see if you can reveal any insights that have been hiding in the seasonal variation. Trust me – it’s easy, it’s fun and it’s a very productive use of your time!

Facebooktwittergoogle_pluslinkedinmailby feather

Speak Your Mind

Your email address will not be published. Required fields are marked *

  1. K.S.Subramanian says:

    Dear Ms Stacey
    Thanks for permitting to view the Replay of the Webinar on signals in KPI . Every moment was interesting & the lucid way in which the presentation was made , is appreciated . Hope more such opportunities will be provided to people like me after each webinar .
    I have one question , & will be thankful to get an answer. What is the Difference between a KPI & KRA. Sometimes they are used interchangeably & hence is confusing . To me , I feel they are distinctly different Terminologies

    If you could explain with a simple example, say a Production or Service Process as an example , I will be obliged

  2. Stacey Barr says:

    K.S, terminology in the performance management field is problematic.

    Different people define each term differently, and even the acronyms like KRA can stand for different terms!

    I have always used KRA to stand for Key Result Area. To me, a KRA is a verbal label given to a specific area of performance that is a strategic priority for a company. For example, ‘customer loyalty’ might be a KRA.

    KPI stands for Key Performance Indicator. KPIs are performance measures that are the highest priority measures for the company, given its current strategy or current set of KRAs. For example, ‘Customer Lifetime Value’ is the name of a KPI that measures customer loyalty. (Just google it if you want more detail.)

    Smiles, Stacey.

  3. Mike says:

    Why not use statistics to adjust time series data? Seasonality isn’t just a yearly phenomenon.
    Box-Jenkins (en.wikipedia.org/wiki/Box_jenkins) allows both seasonality adjustments and forecasting, and is widely available in stat packages. (note Box-Jenkins forecasting has somewhat fallen out of style to newer state space methods).
    Demetra+ might be an alternative, is free http://www.cros-portal.eu/content/demetra and reportedly works with Office 2010.

Reprinting Articles


You are welcome to use articles from the Measure Up blog, with these requirements

Connect with Stacey


Haven’t found what you’re looking for? Want more information? Fill out the form below and I’ll get in touch with you as soon as possible.



*We respect your email privacy.
PO Box 422
Samford, Qld, 4520
Australia
Stacey Barr Pty Ltd
ACN: 129953635
Director: Stacey Barr
Simple Share Buttons