Time series Series with Power BI- Arima Model-Part 10



In this post, I want to explain the ARIM model (Autoregressive Integrated Moving Average).
Exponential smoothing could not consider the relationship between the values in the different time span. while ARIMA able to handle these data.
ARIMA Model needs three variables.


First, let start with explanation of d value
what is d?
The first step in using ARIMA is to create a stationary time series data. so what is stationary time series?
Stationary time series values fluctuate around one value during the time. for instance, the annual rainfall can be as an example of stationary time series. you could not see any trend in below chart and it fluctuates around value 25. if I calculate the variance of data during the period, it would be zero.
for Arima, we should have a stationary time series like below one. for below chart, the “d” value would be 0 as we do not need to do something about making it stationary.


Now, look at the below time series, it is not a stationary time series. In other words: Yt is not the same as Yt-1. Hence, we need do differentiate data more
so we will have Yt=Yt-Yt-1 so if for each t time we have this formula then d=1. if not maybe we need go further that means Yt=(Yt-Yt-1)-(Yt-1-Yt-2)=Yt-2Yt-1+Yt-2 then d=2.


to do this, we have a function that helps named: “diff” . This function gets a time series object plus the number of differentiation. for above example, we do it for d=1

so the chart will be as


for identify the d parameters, we have to

1- plot the Time series object first

2- if not stationary, then we have to differentiate it to reach a stationary one.

in next post, I will explain the value of p and q which is related to acf and pacf chart.



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="">