Power BI has come a long way over the last 7+ years but there are still areas that it lacks in.
Luckily most of these can be done using R directly in Power BI by either the R visual or running an R Script, and one of the best things about this is that in many cases you only need one or few lines of code to get the result you need, and I show you how to in this video.
#rstat #powerbi #rstudio #datavisualizations
▶️ How to download and install R and RStudio
https://youtu.be/GsiTBOyd7ss
🔗 Download R and RTools
https://cran.rstudio.com/
🔗 Download R Studio
https://posit.co/products/open-source/rstudio/
📁 Dataset for Superstore Sales
https://data.world/deanchereden/pbi-r-combined/workspace/file?filename=Superstore+-+Sales.xlsx
📁 Rscript
https://data.world/deanchereden/pbi-r-combined/workspace/file?filename=PBI+%26+R+Combined.R
▶️ How to get more football data using worldfootballr
https://youtu.be/6ZdgEQbn7vo
🔗 R Visual Known Limitations Documentation
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals#known-limitations
🔖c h a p t e r s 🔖
00:00 - Intro
00:47 - Install R & Rstudio
02:39 - Transform data in PBI using R
10:25 - Create R visuals & small multiples
15:25 - Load in R datasets
20:49 - Combine R dataset with R built visual
24:54 - Use R to analyse a data table
26:37 - R visuals limitations
28:56 - Use R script to export PBI data tables
30:29 - Get a report on your exported table
32:34 - Create a R statistical table
My RStudio Appearance Setup
RStudio theme: Modern
Zoom: 100%
Editor font: Lucida Console
Text rendering: (Default)
Editor font size: 16
Editor theme: Tomorrow Night 80s
To learn how to change your appearance in RStudio here: https://youtu.be/GsiTBOyd7ss?t=161
Contact and Socials
💌 My email - dean@deanchereden.com
🌍 My website - https://www.deanchereden.com
🐦 Twitter - https://twitter.com/deanchereden
Music
🎵 Vhsceral - Gimetime https://chll.to/dd82e17f
🎶 Listen to Chillhop Music - https://youtu.be/kpO-nyGEBJ4