POWER BI: R-Visuals

The Basics: R-Visuals

Power BI also lets you make power visualization in R. R is a widely used statistical computing language which can be downloaded here A common type of plot used in R is a graphical display of a correlation matrix. A correlation matrix is a visual representation of how each variable is linearly related. Essentially you have a matrix ( a table of values with rows and columns) where each cell corresponds to how well each of the variables correlate.The graph below illustrates this concept using NHL hockey data:


Fig 1-a: Correlation matrix for all players in NHL 2015/2016 Season

This correlation matrix shows how well player points, age, misses, major penalties, assists, goals and salary are linearly related to each other. The diagonal on the matrix will always be a perfect 1-1 linear correlation since points will be perfectly correlated with points, age will be perfectly correlated with age and so on. The darker the shade of blue the stronger the positive correlation. We can see (not suprisingly), that points have a strong positive correlation with assists and with goals. That is if points go up and so do goals! Goals scored and salary have a roughly moderate correlation while salary and major penalties have no correlation whatsoever.


How to make the r visual above:

In Power BI in your R script visual enter the following lines of code:

                      
                    require (" corrplot" ) 
                    library (corrplot)   
                    M <–cor(dataset)  
                    corrplot (M, method = " color" , tl.cex = 1.5, tl.srt = 100, tl.col= "black")  
                    #corrplot (M, method = " circle" , type = "upper", tl.cex = 1.5, tl.srt =100, t.col = " black" )  
                    #corrplot (M, method = " circle" , tl.cex = 1.5, tl.srt =100, tl.col =" black" , type = " upper" , order =" hclust" ) 
                    
	               

Download the data set


Dash-Intel is a Power BI and Tableau resource site for data visualization and building BI dashboards.

Data Analyst & Consultant

Copyright 2015-2023 Dash-Intel.com Terms