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

Moderator
3554 Views
Highlighted
Moderator boefraty
Moderator

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

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) 

 

perpor Member
Member

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

Cognosben Regular Visitor
Regular Visitor

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 boefraty
Moderator

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