An Introduction to R Script Visuals in Data

An Introduction to R Script Visuals in Data Analysis Yang Li Power. BIWorld. Tour. com #PBIWorld. Tour

An Introduction to R Script Visuals in Data Analysis • R • Why to use R • Basic data analysis steps • How to create R visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Session Agenda • What is R • Why to use R in Power BI • Ways of using R in Power BI • How to create R visuals • Basic data analysis steps with R visuals • Current limitations • Questions Power. BIWorld. Tour. com #PBIWorld. Tour

Yang Li AI Sydney • Ph. D Data Scientist • Predictive Modeling • Machine Learning/ Deep Learning Power. BIWorld. Tour. com #PBIWorld. Tour

What is R Power. BIWorld. Tour. com #PBIWorld. Tour

What is R • For statistical computing, data analysis, and data visualization Power. BIWorld. Tour. com #PBIWorld. Tour

What is R • For statistical computing, data analysis, and data visualization • Open Source & Free Power. BIWorld. Tour. com #PBIWorld. Tour

What is R • For statistical computing, data analysis, and data visualization • Open Source & Free • More than 10, 000 add-on packages Power. BIWorld. Tour. com #PBIWorld. Tour

What is R • For statistical computing, data analysis, and data visualization • Open Source & Free • More than 10, 000 add-on packages • Big Community Power. BIWorld. Tour. com #PBIWorld. Tour

Why use R in Power BI Power. BIWorld. Tour. com #PBIWorld. Tour

Why use R in Power BI • Data manipulation • Data cleaning • Data transformations Power. BIWorld. Tour. com #PBIWorld. Tour

Why use R in Power BI • Data manipulation • Advanced analytics • Predictive analysis • Clusterings • Classifications Power. BIWorld. Tour. com #PBIWorld. Tour

Why use R in Power BI • Data manipulation • Advanced analytics • More customized visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Ways of using R in Power BI Power. BIWorld. Tour. com #PBIWorld. Tour

Ways of using R in Power BI • R-powered custom visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Demo: R-powered custom visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Ways of using R in Power BI • R-powered custom visuals • Run R scripts • Import data using R scripts Power. BIWorld. Tour. com #PBIWorld. Tour

Demo: Import data using R scripts Power. BIWorld. Tour. com #PBIWorld. Tour

Ways of using R in Power BI • R-powered custom visuals • Run R scripts • Import data using R scripts • Using R in Query Editor Power. BIWorld. Tour. com #PBIWorld. Tour

Demo: Using R in Query Editor Power. BIWorld. Tour. com #PBIWorld. Tour

Ways of using R in Power BI • R-powered custom visuals • Run R scripts • Import data using R scripts • Using R in Query Editor • Create visuals using R Power. BIWorld. Tour. com #PBIWorld. Tour

How to create R visuals Power. BIWorld. Tour. com #PBIWorld. Tour

How to create R visuals • Install R and R IDE • R/ Microsoft R Open/ R Client/ R Server • RStudio/ Microsoft Visual Studio Power. BIWorld. Tour. com #PBIWorld. Tour

How to create R visuals • Install R and R IDE • Set up Power BI Power. BIWorld. Tour. com #PBIWorld. Tour

How to create R visuals • Install R and R IDE • Set up Power BI • Start coding! Power. BIWorld. Tour. com #PBIWorld. Tour

How to create R visuals • Install R and R IDE • Set up Power BI • Start coding! • Install required packages first install. packages(“<package name>”) # only needs to be called once library(< package name>) # must be called each time you start a new R session Power. BIWorld. Tour. com #PBIWorld. Tour

Demo: create R visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Basic data analysis steps Power. BIWorld. Tour. com #PBIWorld. Tour

Basic data analysis steps • Data overview • • • Missing values Sample size Overall data distribution Non-sense data points Outliers Correlation Power. BIWorld. Tour. com #PBIWorld. Tour

Basic data analysis steps • Data overview • Data cleaning • • Improve data quality Create new features Data normalization resampling Power. BIWorld. Tour. com #PBIWorld. Tour

Basic data analysis steps • Data overview • Data cleaning • Data modeling • Descriptive • Exploratory • Predictive Power. BIWorld. Tour. com #PBIWorld. Tour

Demo: Scatter Plot Matrix Boxplot Correlation Mapping Forecast Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations • Power BI Desktop/ Power BI Service • Not all R packages supported • No show data option • Data size – 150, 000 rows • Calculation time – 5 minutes/ 30 minutes • R visual itself is not interactive • Refreshing is slow Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations • Power BI Desktop/ Power BI Service • Not all R packages supported • No show data option • Data size – 150, 000 rows • Calculation time – 5 minutes/ 30 minutes • R visual itself is not interactive • Refreshing is slow Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations • Power BI Desktop/ Power BI Service • Not all R packages supported • No show data option • Data size – 150, 000 rows • Calculation time – 5 minutes/ 30 minutes • R visual itself is not interactive • Refreshing is slow Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations • Power BI Desktop/ Power BI Service • Not all R packages supported • No show data option • Data size – 150, 000 rows • Calculation time – 5 minutes/ 30 minutes • R visual itself is not interactive • Refreshing is slow Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations • Power BI Desktop/ Power BI Service • Not all R packages supported • No show data option • Data size – 150, 000 rows • Calculation time – 5 minutes/ 30 minutes • R visual itself is not interactive • Refreshing is slow Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations • Power BI Desktop/ Power BI Service • Not all R packages supported • No show data option • Data size – 150, 000 rows • Calculation time – 5 minutes/ 30 minutes • R visual itself is not interactive • Refreshing is slow Power. BIWorld. Tour. com #PBIWorld. Tour

Current limitations • Power BI Desktop/ Power BI Service • Not all R packages supported • No show data option • Data size – 150, 000 rows • Calculation time – 5 minutes/ 30 minutes • R visual itself is not interactive • Refreshing is slow Power. BIWorld. Tour. com #PBIWorld. Tour

Reference Links: Supported R packages- https: //docs. microsoft. com/en-us/power-bi/service-r-packagessupport Access to R visuals in Power BI Service- https: //docs. microsoft. com/en-us/powerbi/service-r-visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Don’t forget to join your local PUG to enjoy year-round networking and learning.