Previously Excel Consulting

power bi courses nexacu

Using R scripts in Power BI

Learn how to create predictive models, use data mining tools or create visuals not available in native PBI.

Do you need to perform statistical analyses on your data? Do you want to present the results in Power BI? Learn how you can use the R statistical programming language within Power BI to harness the strengths of both of these tools.

This webinar, our instructor Tamara, will show you how to get started using R within Power BI. We'll work through examples of how to use R scripts to import, create, modify or analyse your data and visualise the results. We'll discuss data frames - what they are and how they are used to save your results or refer to your data in your R Scripts. And we'll discuss the benefits and limitations of using R in Power BI.

Course Details
Price
$99
Duration
80 mins
Instructor Led
yes
CPD Hours
1.33 Hrs
Access
12 month
Skill Level
Intermediate/Advanced
Course Prerequisites

Skills and software requirements for this webinar. To get the most out of this webinar, make sure you have the software ready to go.

Skill Requirements:

  • Power BI Intermediate/Advanced Users

Software Requirements:

  • Power BI Desktop - current version
  • R  - downloaded free from https://cran.r-project.org/

Learn how to use R scripts in Power BI

  • Our Instructor
  • Tamara is a Data Scientist
  • She holds a PhD in Machine Learning 
  • Has many years of experience including at the CSIRO, where she worked at a data scientist and trained colleagues
  • Tamara has been a trainer with us for some time and continues to receive outstanding reviews from students 

 

  • Background - what is R?
  • Why use R scripts in Power BI?
  • Setting up
  • Using the R Connector to import or create a dataset
  • Preprocess and import data

 

  • Case study - RFM analysis
  • Using R Scripts in Power Query Editor - working on data already imported in Power Query
  • Saving results of R Scripts
  • Use an R Script to create a calendar / date dimension table
  • Use R Scripts to perform Cluster Analysis
  • Modifying your R Scripts in Power Query Editor
  • Create visualisations using R Script visuals
  • Create and visualise Classification and Regression Trees
  • Limitations of R Script visuals in Power BI
Face to Face Courses
microsoft_gold
Try our skills test

Test your skills and find out which course is right for you.

Choose a Quiz

 

Contact Us

How do Online Courses work?



Book

Find the online course or webinar you

would like to sit and hit book now.



Login

Receive your login details and follow the instructions

to log on to the Nexacu learning portal.




Learn

Complete your online course or view

your webinar at your own pace.

System Requirements

Browser

  • Internet Explorer: Version 9 to 11
  • Firefox or Google Chrome: Latest Version

Software requirements

  • Microsoft Windows 7/8/10
  • Apple Mac OS X 10.5.x, 10.6.x *(Online self-paced courses courseware works with Mac OS, diagnostic tests do not.)

Why choose Nexacu?

Valued by Individuals

 

4.8/5
Over 18419 Reviews
Excellent Course well presented by Steven. Excited to expand the horizons another step to power BI heaven -Power BI Advanced Brisbane
Terry - Power BI Advanced, .
Great content, Steve kept things going as slower users tend to slow things down but parked questions well and kept things going. Well explained -Power BI Advanced Brisbane
Matthew - Power BI Advanced, .
Great Course, Thanks Steven -Power BI Advanced Brisbane
Savindren - Power BI Advanced, .
Good presentation and hand on the task. -Power BI Advanced Brisbane
Yuejing - Power BI Advanced, .
Well presented and informative. -Power BI Advanced Brisbane
Brent - Power BI Advanced, .
Good training. -Power BI Advanced Brisbane
Shergeoh - Power BI Advanced, .
It was a good course, good speed and trainer explained tasked very well. Exercises were good and training material very helpful. -Excel Advanced Sydney
Stephanie - Excel Advanced, .
Very knowledgeable trainer and was able to adapt to circumstance that could be beneficial and understood by the group -Excel Advanced Sydney
Danielle - Excel Advanced, .
Good content, and explained in a calm and efficient manner -Excel Advanced Sydney
SonyParimi - Excel Advanced, .
Great documentation and files for the training sessions. Rajashree is really good at keeping the class on track and is quick to identify issues when a user is having problems. -Excel Advanced Sydney
Libby - Excel Advanced, .
Very useful and speed of session was good. Good mix of exercises. More detail on macros would be great. -Excel Advanced Sydney
Jessica - Excel Advanced, .
Michael was fantastic he really made this course informative and enjoyable. I got a lot out of this course. -Office365 Beginner Parramatta
Renee - Office365 Beginner, .
Instructor didn't take a linear path through the workbook, but did manage to cover all area, it was good to see pragmatic approach to student learning -Power BI Advanced Sydney
Stuart - Power BI Advanced, .
Very well explained. -Office365 Beginner Parramatta
Felicity - Office365 Beginner, .
Thoroughly enjoyable. John moved quickly through examples, but not too quick for people to get lost. Very happy that the group was very capable. -Excel Advanced Melbourne
Matthew - Excel Advanced, .
Thank you John for the very informative and interesting course! I learn a lot of useful tricks on how to improve my excel skills on a day to day basis. -Excel Advanced Melbourne
Maria - Excel Advanced, .
Great course -Office365 Beginner Parramatta
Courtney - Office365 Beginner, .
John was really good, going through the content clearly and in a way for us novices to understand the steps involved in different processes. -Excel Advanced Melbourne
Benji - Excel Advanced, .
Helpful and interactive, but intensive -Excel Advanced Melbourne
Oussama - Excel Advanced, .
Nice presentation Covered interested topics -Excel Advanced Melbourne
gunjan - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia