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

🔗 Download R and RTools

🔗 Download R Studio

📁 Dataset for Superstore Sales

📁 Rscript

▶️ How to get more football data using worldfootballr

🔗 R Visual Known Limitations Documentation

🔖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

Contact and Socials

Music

[gekonomicus]

Super great video!!
What about Forecasting in R and showing it in PowerBI?
But with automatic connectors? So the forecasting is automated?