Power BI and R offer accessible analytics by allowing a combination of easy-to-use data visualization along with industry-standard, robust statistical computation.
Delegates will learn how descriptive, prescriptive, predictive, and visually appealing analytical solutions can be designed with R and Power BI.
Moving from data visualization into deeper and more advanced statistical analytics in Power BI? This course will improve analytical skills for data visualization-savvy Power BI users who want to harness the analytical power of R from within Power BI.
Learning Objectives
Participants will learn:
- How to do data transformation in Power BI with R functions
- How to create interactive R reports in Power BI
- How to install and configure R in Power BI.
- How to use the Query Editor and Run Scripts
- How to use an external integrated development environment
- How to use R Packages in the Power BI Service.
- The 3 ways of using R in Power BI: R-powered Custom Visuals, R Visuals, and R Scripts.
Program Outline
- Configure R in Power BI
- Installing R
- Using R in Query Editor
- Running R Scripts
- Using an External R IDE
- Enable the External IDE
- Launching an R IDE from Power BI
- R Packages in the Power BI Service
- R Package Requirements and Limitations
- Supported R Packages
- Creating Visuals from R Script Data
- Using R Script to Import/Modify Data
- Creating R Visuals
- R Script Security
- R Script Error Experience
- Known Limitations
- Using R Visuals in Power BI
- Creating R-Powered Custom Visuals
- Acquiring R-Powered Visuals
- Using R-Powered Visuals
- Building R-Powered Visuals
Target Audience
This course is for Power BI users who are ready to transition from being a data-savvy user to being a data analyst using sound statistical tools to perform advanced analytics.
Prerequisites
Before attending this course, delegates should have taken or be familiar with Microsoft Power BI.

