Select your country to view prices and course dates.

x

January Sale - 20% of all courses - Book Today

Using R scripts in Power BI - Webinar

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 suite of R programming courses live online.

Course Details
Price
$49
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
  • Highly proficient in English

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 Agricultural Data Analytics 
  • Has many years of experience including at the Australian 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 visualizations using R Script visuals
  • Create and visualize Classification and Regression Trees
  • Limitations of R Script visuals in Power BI
Try our skills test

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

Skills Test Nexacu

Choose a Quiz

 

Contact Us


How do Self-Paced Online Courses work?

online training support

Book

Find the online course or webinar you

would like to sit and hit book now.

average size class

Login

Receive your login details and follow the instructions

to log on to the Nexacu learning portal.

certified trainers



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

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 25129 Reviews
Some very helpful tips, definitely things I can use in the future -Word Advanced Brisbane
Millie - Word Advanced, .
Very informative and engaging. Good teacher -Excel Intermediate Brisbane
Alisha - Excel Intermediate, .
was informative and well done -Excel Intermediate Brisbane
Sola - Excel Intermediate, .
thank you great course and facilitator was great -Excel Intermediate Brisbane
Luke - Excel Intermediate, .
very useful. -Excel Intermediate Brisbane
Jennifer - Excel Intermediate, .
Very clear and helpful. Good pace also. Well structured. -Excel Intermediate Brisbane
Aria - Excel Intermediate, .
This course was great. I knew very little about VBA prior to attending and Michael was clear and built knowledge so well that I feel confident attempting to apply this in real work situations. A highly recommended course. -Excel Macros/VBA 2 Day Parramatta
Mary - Excel Macros/VBA 2 Day, .
This course was amazing. Michael was such an engaging teacher and kept the class so informative and so easy to follow. We had a great time learning the content of this course and we loved the small class we were in. We could ask a lot of questions and enjoy the whole course at the same time. This was one of many courses I have attended with Nexacu and all the teachers are great. Michael is my favourite. 5 Stars from me from all perspectives !!! -Excel Macros/VBA 2 Day Parramatta
Jacqueline - Excel Macros/VBA 2 Day, .
Moved a bit quicker than the beginner but showed good examples of what you can do. I certainly need to go away and practice with some real data to apply what I have learned today. Many thanks -Power BI Intermediate Adelaide
Merrin - Power BI Intermediate, .
Thanks for the help! -Power BI Intermediate Adelaide
Bradley - Power BI Intermediate, .
Brilliant - learnt so much. Many thanks Jagg -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
was able to learn new formulas and functions that will help me in the future. -Power BI Intermediate Adelaide
Estelle - Power BI Intermediate, .
Learnt a lot on how to manipulate and clean up data. Learnt to better manage permissions to data. Learnt more on the date functions, though still don't know how to calculate current week/previous week comparisons. -Power BI Intermediate Melbourne
Kristina - Power BI Intermediate, .
Learnt many items with Power Query and DAX, along with row level security which is of particular interest with the types of personnel reports I will need to build. -Power BI Intermediate Melbourne
Kylie - Power BI Intermediate, .
Excellent content, great teacher. Thank you! -Excel Intermediate Melbourne
Linda - Excel Intermediate, .
Steven was incredibly helpful in training us. He took the time to understand our professional roles and relate what we were learning to our day to day tasks. He was patient and professional. Thank you! -Word Intermediate Brisbane
Alison - Word Intermediate, .
I have enjoyed it and learned many tips. -Word Intermediate Brisbane
Kristian - Word Intermediate, .
This was great! -Word Intermediate Brisbane
Courteney - Word Intermediate, .
Well-paced and very informative training. Trainer is very knowledgeable and helpful with any questions. -Power BI Intermediate Brisbane
Emily - Power BI Intermediate, .
Great course. Jason was very clear and easy to understand. Learnt a lot in one day. Thanks! -Power BI Intermediate Brisbane
Ben - Power BI Intermediate, .

Trusted by Business

Awards and Accreditations

Follow us