All courses REMOTE until June 30 | Limited in-class sessions in June - Call Us | From July 1 all courses available in-class and remotely

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.

In this recorded webinar, our Data Scientist Tamara Shatar PhD, 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 identify the benefits and limitations of using R in Power BI. If you are interested in learning about R this is a great introduction. Tamara also delivers our Introduction to R courses both in class around Australia and online.

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

 

  • Visualisation and R
  • 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.)

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 20822 Reviews
Great Explanations, Very Helpful, Highly recommend. -Excel Intermediate Perth
Luke - Excel Intermediate, .
Jagg was really great, good amount of detail and a good pace, made it easy to keep up and really learn everything. Thank you -Excel Intermediate Sydney
Madelene - Excel Intermediate, .
Great communication skills -Excel Intermediate Perth
Anthony - Excel Intermediate, .
. -Office365 Intermediate Sydney
James - Office365 Intermediate, .
Helpful and well explained -Office365 Intermediate Sydney
Monika - Office365 Intermediate, .
John was really good at power BI and some of the concepts were great. I will keep all these details close by and even reach out to John if I have further questions. Thanks for the day! -Power BI Advanced Canberra
Matthew - Power BI Advanced, .
Thanks -Power BI Advanced Canberra
Gabriela - Power BI Advanced, .
The training was really great. Jag kept us engaged for the whole day which is great. I learnt a lot and can't wait o put the tips and tricks in action. Thanks -Excel Intermediate Sydney
Rosalind - Excel Intermediate, .
Jag is so very good! Was very engaging and actually very fun! -Excel Intermediate Sydney
Michelle - Excel Intermediate, .
Good overall -Power BI Advanced Canberra
YuinAi - Power BI Advanced, .
Michael was great - he had a good pace and checked in with us to see if we had any questions. He is clearly very passionate about Power BI which enhanced the whole experience -Power BI Beginner Sydney
Ally - Power BI Beginner, .
It was very informative and Michael was very helpful and detailed. -Power BI Beginner Sydney
Alan - Power BI Beginner, .
Very good introduction to PowerBI. Concepts very well explained. -Power BI Beginner Sydney
Eric - Power BI Beginner, .
Thanks Ken, very informative. -PowerPoint Level 2 Sydney
David - PowerPoint Level 2, .
Thank you was a great session. -PowerPoint Level 2 Sydney
Nikita - PowerPoint Level 2, .
Really useful tips and shortcuts -PowerPoint Level 2 Sydney
Devlin - PowerPoint Level 2, .
Thanks- great course! -PowerPoint Level 2 Sydney
Gabrielle - PowerPoint Level 2, .
Helpful. Thank you very much. -PowerPoint Level 2 Sydney
Guida - PowerPoint Level 2, .
Wonderful course. Enjoyed it very much and learnt many new features -Power BI Beginner Sydney
Victor - Power BI Beginner, .
. -Power BI Beginner Sydney
Steve - Power BI Beginner, .

Trusted by Business

Procured by Government

Map of Australia