Overview
Moving from data visualization into deeper, 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.

Together, Power BI and R offer accessible analytics by allowing a combination of easy-to-use data visualization along with industry-standard, robust statistical computation. Participants  will review a wide range of machine learning algorithms and learn how descriptive, prescriptive, predictive, and visually appealing analytical solutions can be designed with R and Power BI.

Audience
This class is for Power BI users who are comfortable with the product and are ready to transition to from being a data-savvy user to being a data analyst using sound statistical tools to perform advanced analytics.

Prerequisites
Before attending this course, students should have taken or be familiar with the contents presented in the Data analysis and visualization with Power BI.

Duration

3 Days

Objectives

What You Will Learn

To install and configure R in Power BI.

Use the Query Editor and Run Scripts. Use an external integrated development environment

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.

Course Outline

Module 1: Configure R in Power BI
Installing R
Using R in Query Editor
Running R Scripts

Module 2 : Using an External R IDE
Enable the External IDE
Launching an R IDE from Power BI

Module 3: R Packages in the Power BI Service
R Package Requirements and Limitations
Supported R Packages

Module 4: Creating Visuals from R Script Data
Advantages/Disadvantages
Using R Script to Import/Modify Data

Module 5 : Creating R Visuals
Advantages/Disadvantages
R Script Security
R Script Error Experience
Known Limitations
Using R Visuals in Power BI

Module 6 : Creating R-Powered Custom Visuals
Advantages/Disadvantages of R-Powered Visuals
Acquiring R-Powered Visuals
Using R-Powered Visuals
Building R-Powered Visuals