New Series of Time Series: Power BI Custom Visual (Part 4)

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

tsdecompose4

In this post, I am going to show how we can do time series inside Power BI using custom visual from Office store.

First you need to download custom visual from office store,

to download R custom visual please follow the below link

https://store.office.com/en-001/appshome.aspx?ui=en-US&rs=en-001&ad=US&clickedfilter=OfficeProductFilter%3aPowerBI&productgroup=PowerBI

officestore

 

now we are going to download some timeseries custom visuals from this website.

ts-powerbiin the text area type “time series” word (number 1 in the above picture). then in the right side you will see some charts.

I am going to show how we can import them into power bi and use them to show charts.

the first chart that I am going to show is a “Decomposit chart”, so what is decomposit chart?

Time series decomposition chart

As I have explained in the post one, each timeseries chart able to show 3 main concepts:

1- Trend

2- Seasonality

3-Irregular component

Trend

trend is about long-term increase or decrease in the data . for instance in the milk production we can see there is increase trend in production.

Seasonality

A seasonal pattern when data is influence by seasonal or any order. for instance, in above picture, you see in all years in the second quarter  milk production is high and then in the third quarter is the lowest one (see below ), and this trend is same in all years

see as below chart, the below chart shows a timeseries object with seasonality and trend. (the chart  is going up and also there is a trend in all intervals)

 

birth

sometimes we want to see each of these component separatley to analysis them.

To do see, we able to decompose them to show them in separate charts.

I am going to show you how to decompose them in power bi.

imagin that we have birth rate from 1961 to 1972.

We imported data into the Power BI as below:

datats

I have two columns, one for date and the other for value that is birth rate.

In the second step, I am going to import the custom visual chart by following the below steps.

just click on the 3 dots (see below picture), then select the “import from file”

tsdecompose3

then, just import the chart into visual, and we add two values: Time and Data for the chart.

tsdecompose4

as you see in the above picture, we have four main chart, the first chart is the original time series that show the birth rate which is increasing or decreasing that we call it as  trend.

In the second one, we able to see seasonality separatley, the third chart shows the trend of birth rate that is increasing. and the last on shows the irregular component of birth rate.

in the next post, I will talk about the two other custom visual chart we have inside power bi for doing the forecasting using “exponential smoothing” or “Arima”

 

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Leila Etaati on LinkedinLeila Etaati on TwitterLeila Etaati on Youtube
Leila Etaati
Trainer, Consultant, Mentor
Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

Leave a Reply

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