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

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

boefraty — Tue, 20 Dec 2016 13:16:01 GMT

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)

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

perpor — Wed, 31 May 2017 08:32:00 GMT

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

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

Cognosben — Fri, 10 Nov 2017 19:14:59 GMT

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.

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

boefraty — Wed, 13 Dec 2017 07:58:12 GMT

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