Power BI and R- Timeseries series Part 9- Decompose None seasonal Data



In the last posts, I have explained about some main concepts of Time series. How to decompose time series that has irregular, trend and seasonality components have been explained in: seasonality component decompose).

now image we have a dataset that does not have any seasonality also does not show a clear trend.

This data is about the age of death of kings from https://robjhyndman.com/tsdldata/misc/kings.dat

We have to read the data using scan function :

now, I am going to convert the data into a time series object using “TS” function. Then I am using plot.ts() to show the  data

The result of running the code will be below image:


as you can see, there is no seasonality in data, just a none clear trend, and irregular components.
Normally, to have a clear image of “trend” of data, we use”Smoothing approach”, Smoothing usually use to better see the trend of data. We use this approach to smooth the irregular components to remove the irregular components.


Simple moving average

SMA, is about calculating the average of data for specific time span,

let explain the concept by below example” we have a data as:

Daily Closing Prices: 11,12,13,14,15,16,17

so for each day we calculate the average of last 5 recent days

First day of 5-day SMA: (11 + 12 + 13 + 14 + 15) / 5 = 13

Second day of 5-day SMA: (12 + 13 + 14 + 15 + 16) / 5 = 14

Third day of 5-day SMA: (13 + 14 + 15 + 16 + 17) / 5 = 15

in R there is a package that helps us to smooth the data


I am going to smooth the data with 3 past data point we have as below

However after running the code, you will see the chart is not that much smoother, so we need to consider more data span, entries 5 and 6. but finally 8 spans make the chart more smooth


so know we able to see the obvious increasing trend in data without any irregular components



reference: http://radacad.com/new-series-of-time-series-part-1



Leila Etaati
Dr. Leila Etaati is Principal Data Scientist, BI Consultant, and Speaker. She has over 10 years’ experience working with databases and software systems. She was involved in many large-scale projects for big sized companies. Leila has PhD of Information System department, University of Auckland, MS and BS in computer science. Leila is Microsoft Data Platform MVP.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">