Sales Forecast using R in Power BI

[Qianru221]

Hi all,

I am doing a forecast on future sales quantity and here are the details of the problem.

- The history of the Quantity sold is loaded into Power BI.

- The history of the Holidays and Employee absence are also loaded into Power BI

- Both data are connected with TimeID Query.

- It is believed that part of the Sales variation can be explained by Holidays and employee(sales) absence.

Therefore now I would like to forecast future sales Quantity against time in the future, taking into factors of holidays and employee absence using R. Would it be possible to provide me with a sample code or sth so that I can implement into the Power BI?

I tried to use existing visuals to do the forecast but most of them yielded a straight line into the future....which is not really what I wished for....

Thanks in advance!

Best,

Qianru.

[VCQ · Accepted solution]

This is a really open ended question. There are a lot of different ways to forecast this particular point(Regressions, time series analysis, etc....) If I were you I would check R stack or math forums. 

[Anonymous · Accepted solution]

Hi @Qianru221,

Maybe you can try to use R forecast pack, below is the sample:

Forecast Table - R script

Forecasting Time Series With R

Regards,

Xiaoxin Sheng

[VCQ · Accepted solution]

This is a really open ended question. There are a lot of different ways to forecast this particular point(Regressions, time series analysis, etc....) If I were you I would check R stack or math forums.