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.

Book Now

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

Try our skills test

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

Skills Test Nexacu

Choose a Quiz

How do Self-Paced 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.)

Contact Us

phone

enquiry

What is Remote Training?

Login from your desk
Instructor-led Training
Your Questions Answered
Innovative Content
Microsoft Certified Trainers

Thanks -Power BI Intermediate Canberra

Mal - Power BI Intermediate, 21 Jan 2021.

Jason did an amazing job, very attentive, personable, and approachable. Always willing to slow down and make sure everyone is on the same page and answer questions. -Power BI Intermediate Canberra

Logan - Power BI Intermediate, 21 Jan 2021.

John was great. Great handbook for reference. Could potentially look at adding more to the course. Calendar's aren't really needed with everything else available. But I would be curious to see what else Visio can do. Thanks again! -Visio Essentials Melbourne

Amber - Visio Essentials, 21 Jan 2021.

John was great and patient! -Visio Essentials Melbourne

Rebecca - Visio Essentials, 21 Jan 2021.

Excellent trainer, concise, explained material very well and was very patient. -Excel Customised Adelaide

Mirella - Excel Customised, 21 Jan 2021.

Totally enjoyed it -Excel Customised Adelaide

Bronwyn - Excel Customised, 21 Jan 2021.

very knowledgeable -Excel Customised Adelaide

Beth - Excel Customised, 21 Jan 2021.

Useful! Wowed me. -Excel Customised Adelaide

Ann - Excel Customised, 21 Jan 2021.

Great session with some insightful tips and tricks! -Power Point Level 1 & 2 Remote Online

Kellie - Power Point Level 1 & 2, 21 Jan 2021.

Danny is an excellent instructor - very informative session with lots of helpful tips! -Power Point Level 1 & 2 Remote Online

Stephie - Power Point Level 1 & 2, 21 Jan 2021.

I have attended from Beginner to Advance course in consecutive days. Having done almost 2 yrs of self learning, these courses has solidified my learning and has given me tips on how to do other things. Dom was great in all 3 courses. -Power BI Advanced Perth

Dion - Power BI Advanced, 20 Jan 2021.

Dom is a great teacher. So knowledgable. -Power BI Advanced Perth

Kristal - Power BI Advanced, 20 Jan 2021.

Excellent course for gaining a greater understanding of Power BI Advanced workings. Trainer is very thorough. -Power BI Advanced Perth

Siobhán - Power BI Advanced, 20 Jan 2021.

Was a great session downloading the office 365 capabilities! -Office365 Intermediate Brisbane

Selvin - Office365 Intermediate, 20 Jan 2021.

Great course with some really helpful and insightful tips and tricks which I can use in the work place and beyond. Steven was an amazing trainer who explained each of the processes clearly and easily to understand. Thank you so much! -Office365 Intermediate Remote Online

Kaimani - Office365 Intermediate, 20 Jan 2021.

Great Course. Steven was a great instructor, was very clear in his instruction and kind whenever he had to re-address any content. He was also good at trying to cover the topics we were wanting to focus on. -Office365 Intermediate Brisbane

Emma - Office365 Intermediate, 20 Jan 2021.

This was a great opportunity to fill in so many gaps I had in my day to day use of Power BI. Very user friendly and easy to follow. -Power BI Advanced Brisbane

John - Power BI Advanced, 20 Jan 2021.

Jason was great and the course was extremely informative. -Power BI Beginner Canberra

Mark - Power BI Beginner, 20 Jan 2021.

Examples were useful, good spread of key functionality and handy tips -Power BI Beginner Canberra

Ben - Power BI Beginner, 20 Jan 2021.

It is a great course and Jason has done it very interestingly throughout the day. Thank you. -Power BI Beginner Canberra

Hemamali - Power BI Beginner, 20 Jan 2021.

View More Reviews