Forecasting in R Visual / R Custom Visual / Power Query / Line Chart

Moderator
2000 Views
Highlighted
Moderator
Posts: 64
Registered: ‎08-10-2016

Forecasting in R Visual / R Custom Visual / Power Query / Line Chart

[ Edited ]

Many faces of forecasting ... 

 

Attached sample contains 4 fifferent ways to perform forecasting with exponential smoothing algorithm. 

1) Using R-powered Custom Visual

2) Using R-visual 

3) Using R-in-Power Query (data transform with R) 

4) Using new "forecasting" option  in good old Line Chart 

 

Do not forget to install required R packages

The R code inside  Power Query step is also attached (and also accessible in PBIX) 

 

Attachment
Attachment
Member
Posts: 109
Registered: ‎04-13-2017

Re: Forecasting in R Visual / R Custom Visual / Power Query / Line Chart

Thanks very interesting, it demonstrates the potentialities of the product that many people can not understand at the moment

Regular Visitor
Posts: 24
Registered: ‎09-22-2017

Re: Forecasting in R Visual / R Custom Visual / Power Query / Line Chart

Why are the dates in the resultset skewed? Originally they are all first days of each month, as the first one in the screenshot below. 

 

 Dates.png

Moderator
Posts: 64
Registered: ‎08-10-2016

Re: Forecasting in R Visual / R Custom Visual / Power Query / Line Chart

The algorithm only works with equally spaced dates.  Therefore the original dates are resampled to become equally sampled in the range from first to last dates