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

To learn how to change your appearance in RStudio here: [ Ссылка ]


Contact and Socials

💌 My email - dean@deanchereden.com
🌍 My website - [ Ссылка ]
🐦 Twitter - [ Ссылка ]


Music

🎵 Vhsceral - Gimetime [ Ссылка ]

🎶 Listen to Chillhop Music - [ Ссылка ]

свернуть