Machine Learning in Power BI - ARIMA Forecasting - DIY -43-of-50

Microsoft Power BI - Do it Yourself(DIY) Tutorial - ARIMA Forecasting in Power BI - DIY -43-of-50
by
Bharati DW Consultancy
cell: +1-562-646-6746 (Cell & Whatsapp)
email: bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/

Power BI - Do it Yourself Tutorial - ARIMA Forecasting in Power BI - DIY -43-of-50

In this video, we will talk about ARIMA Forecasting in Power BI.

1- Use the same PBIX file, as used in the previous video - Power BI & R Visuals
2- Let's visualize the data, on the right hand side Fields Menu, select SalesDate, Sales_Amt columns.
3- Click on the small arrow next to SalesDate in the Visualizations section. Select the SalesDate instead of Date Hierarchy.
4- Click on the Line Chart from the Visualizations section.
5- Create a slicer for Item Names. Adjust the text size of the ItemName Slicer, if necessary.
6- Select Think Pad 450s from the Slicer, and see the trend against time.
7- Select the Line Chart, and then select the Sales_Cost from the Fields.
8- Click on the R script visual, then click on the Enable button, as shown below.

9- Then write the following piece of code, in the R script area; then click on Run Script.
Please install forecast and tseries R-packages if not already installed.

library(forecast)
library(tseries)
ARIMA_Sales LTsymbol-ts(dataset$Sales_Amt,start=c(1))
Sales_Forecast LTsymbol-auto.arima(ARIMA_Sales, seasonal=TRUE)
Predicted_Sales LTsymbol- forecast(Sales_Forecast, h=10)
plot(Predicted_Sales)
Hands on - DIY #57
1- Use the same PBIX file, which was used for F_SALES in the previous set of videos.
2- Create ARIMA time series forecasting for Amt and Sales Date
Use these video series for R - Machine Learning:
https://www.youtube.com/watch?v=sc4WxfJFvh4&list=PLyD1XCIRA3gTfulK7bZnqSkPLeSVffKpQ

Google Drive Link: https://tinyurl.com/powerbione
Power BI, Do it Yourself Tutorial, Getting Started, Microsoft Power BI, Maps, Clustered & Stacked Visualization,
Interactive Visualizations - Slicers, R Integration, Custom calendar using DAX, Introduction to DAX, DAX Calculated Columns,
DAX Calculated Measure

Видео Machine Learning in Power BI - ARIMA Forecasting - DIY -43-of-50 канала BharatiDWConsultancy