Power BI Advanced Analytics with R Training

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 be 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.

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