LEVEL UP your Power BI reporting with R

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
   • How to Download R & R Studio, Run R Studio...  


🔗 Download R and RTools
https://cran.rstudio.com/

🔗 Download R Studio
https://posit.co/products/open-source...

📁 Dataset for Superstore Sales
https://data.world/deanchereden/pbi-r...

📁 Rscript
https://data.world/deanchereden/pbi-r...

▶️ How to get more football data using worldfootballr
   • How to get football data for FREE - worldf...  

🔗 R Visual Known Limitations Documentation
https://learn.microsoft.com/en-us/pow...


🔖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:    • How to Download R & R Studio, Run R Studio...  


Contact and Socials

💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter -   / deanchereden  


Music

🎵 Vhsceral - Gimetime https://chll.to/dd82e17f

🎶 Listen to Chillhop Music -    • Misha & Jussi Halme - Bliss (A Felicidade)...