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
Instructor Led Courses
microsoft_gold
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 25024 Reviews
Handy Course! Teacher had great knowledge of the software. -Excel Advanced Perth
Nick - Excel Advanced, .
Awesome! -Excel Advanced Perth
Eva - Excel Advanced, .
I very much enjoyed the course and found Steven to be very helpful. I was very fortunate to be the only student in attendance. I had some knowledge but feel I will leave today with far more knowledge. -Excel Intermediate Brisbane
Shirley - Excel Intermediate, .
Jagg was wonderful. His approach to teaching was very suitable to the needs of the class. He worked at a pace that was easy enough to follow and allowed for questions when necessary. Keep up the good work! -Project Beginner Adelaide
Billie - Project Beginner, .
The course was designed well and eased into some of the more difficult components. Great trainer and able to help articulate learnings into what makes sense to specific projects. -Project Beginner Adelaide
Amanda - Project Beginner, .
A fantastic course. Very helpful and informative -Project Beginner Adelaide
Tanya - Project Beginner, .
good facilitator thx for today -Project Beginner Adelaide
jeff - Project Beginner, .
Excellent beginners course - feel confident to get started! -Project Beginner Adelaide
Kim - Project Beginner, .
Ken was absolutely fantastic! -Excel Beginner Melbourne
Amrita - Excel Beginner, .
Very helpful base level of knowledge across the platform. Looking forward to the intermediate. Super friendly trainer, thanks Domenic. -Office365 Beginner Perth
Lei - Office365 Beginner, .
Very interactive -Office365 Beginner Perth
Mark - Office365 Beginner, .
Great Excel course, will be very useful in improving my work efficiency. Hope to complete the Advanced Excel Course in the future. Thanks Jenny. -Excel Intermediate Perth
Thomas - Excel Intermediate, .
Very very good course. Jenny is amazing and a great teacher!! A great pace / environment to learn in and ask questions. -Excel Intermediate Perth
Morgan - Excel Intermediate, .
Great course - it's going to save me a lot of time at work and make life easier. Jenny was very helpful and clear at explaining the concepts. -Excel Intermediate Perth
Blaine - Excel Intermediate, .
Jenny was incredibly helpful and friendly. She answered whatever questions we had. The functions taught within this class would be very useful for my work within HR as well as projects. -Excel Intermediate Perth
Alison - Excel Intermediate, .
Learned lots, was very easy to follow. -Excel Intermediate Perth
Oliver - Excel Intermediate, .
It was great! -Excel Intermediate Perth
Alessandra - Excel Intermediate, .
Very useful information to convert into both a working and personal environment. -Excel Intermediate Perth
Mia - Excel Intermediate, .
I enjoyed the course. Jenny was very helpful and informative. -Excel Intermediate Perth
Celeste - Excel Intermediate, .
Great, learned even more functions of Excel -Excel Advanced Brisbane
Leonie - Excel Advanced, .

Trusted by Business

Awards and Accreditations

Follow us