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

  • SEO
  • Online Advertising
  • Online Ordering For Restaurants
  • Data Analytics

  • External Resources 4 Developers
  • CSS Tricks
  • MDN

  • Dash-Intel.com is a Power BI and Tableau resource site around data visualizations and building business dashboards.

    Data Analytics consultants in Edmonton, Alberta specializing in Tableau and marketing analytics

    Copyright 2020 Dash-Intel.com Terms / All rights reserved.