R Visuals in Power BI- DIY -41-of-50
Microsoft Power BI - Do it Yourself(DIY) Tutorial - Power BI & R Visuals - DIY -41-of-50
by
Bharati DW Consultancy
cell: +1-562-646-6746 (Cell & Whatsapp)
email: [email protected]
website: http://bharaticonsultancy.in/
Power BI - Do it Yourself Tutorial - Power BI & R Visuals - DIY -41-of-50
In this video, we will talk about creating R visuals in Power BI.
1- Download the csv data from the following location, save it on your C: drive.
Google Drive Link: https://tinyurl.com/powerbione
2- Create a folder C:\R\, The csv file should be available at this location – C:\R\Retail_Sales_Data.csv
3- Import the data in Power BI by clicking Get Data option on the under the Home Menu, and then select More.
4- Click on Text/CSV, Click on Connect. Navigate to C:\R\Retail_Sales_Data.csv & Click on Load.
5- From the Visualization section, Click on the R script visual, then click on the Enable button.
Please note that if you don’t have R installed on your system, then download and install R from the following location:
https://mran.revolutionanalytics.com/...
6- Select columns - ItemName, Sales_Qty and Discount.
7- Write the following piece of code, in the R script area; then click on Run Script.
boxplot(dataset$Sales_Qty, main="Boxplot", ylab="Sales_Qty")
8- Select Think Pad 450s from the slicer option.
9- To find a correlation between Sales_Qty and Discount, use # symbol to comment out the first line of code, then add the following piece of code, in the R script area; click on Run Script. Observe that the correlation between Discount and Sales_Qty
boxplot(Discount~Sales_Qty,data=dataset, main="Boxplot", ylab="Sales_Qty")
Hands on - DIY #55
1- Use the same PBIX file, which was used for F_SALES in the previous set of videos.
2- Create R visuals - use Histogram, BoxPlot.
Use these video series for R - Machine Learning:
• Data Science & Machine Learning - Getting ...
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