Exponential Smoothing Forecast in Query Editor using R

[Mohamed-Ashraf]

I need help with implementing Forecasting models using R in Query Editor with the below dataset

Date	SKU	Value1	Value2	Value3
01-Jan-18	A	28	16	25
01-Feb-18	A	22	18	16
01-Mar-18	A	16	23	15
01-Apr-18	A	19	12	26
01-May-18	A	10	25	30
01-Jun-18	A	24	19	28
01-Jul-18	A	22	20	28
01-Aug-18	A	25	22	12
01-Sep-18	A	23	11	15
01-Oct-18	A	13	24	15
01-Nov-18	A	19	27	21
01-Jan-18	B	30	18	15
01-Feb-18	B	11	14	30
01-Mar-18	B	26	12	20
01-Apr-18	B	24	25	19
01-May-18	B	18	26	29
01-Jun-18	B	13	28	11
01-Jul-18	B	24	28	21
01-Aug-18	B	20	15	23
01-Sep-18	B	27	10	13
01-Oct-18	B	29	22	17
01-Nov-18	B	13	17	12
01-Jan-18	C	11	20	18
01-Feb-18	C	21	21	17
01-Mar-18	C	15	21	25
01-Apr-18	C	14	12	15
01-May-18	C	13	22	17
01-Jun-18	C	20	24	18
01-Jul-18	C	27	14	30
01-Aug-18	C	22	12	25
01-Sep-18	C	27	14	24
01-Oct-18	C	20	19	30
01-Nov-18	C	21	25	16

Please I want to implement reusable R Code with clarification of parameters or variables for (Date, Value1, Value2, Value3), the required packages for R?

Thanks in advance

[Fowmy]

@Mohamed-Ashraf 

Please check out these links if they will be useful to you.

https://community.powerbi.com/t5/Desktop/Forecast-Table-R-script/m-p/197834
https://academy.dataiku.com/time-series-with-code-open
https://pawarbi.github.io/blog/forecasting/python/powerbi/forecasting_in_powerbi/2020/04/24/timeseri...

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn