Previously Excel Consulting

R-Script in Power BI

Using R for Beginners

Learn how to use R for data analysis

R is a programming language specifically developed for the statistical analysis of data and for producing graphical output. The functionality of the base R package is greatly extended by user-contributed packages which contain a range of functions. There is often more than one way to achieve an outcome in R. This course provides an overview of the basics and introduces some of the functions and packages that can be used to work with data. The aim of this course is provide a foundational understanding of R, particularly R syntax, data types and objects.

This R training course will involve working through a range of exercises that give you an opportunity to practice writing R code, use a variety of different functions, produce graphical output and view the results. Read the full outline here.

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Brisbane
Date
Course
City
Status
Wed 25-Mar-20
Using R Beginner
Brisbane
Confirmed
Thu 17-Sep-20
Using R Beginner
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Tue 17-Mar-20
Using R Beginner
Sydney
Confirmed
Wed 22-Apr-20
Using R Beginner
Sydney
Confirmed
Mon 18-May-20
Using R Beginner
Sydney
Scheduled
Thu 2-Jul-20
Using R Beginner
Sydney
Scheduled
Wed 19-Aug-20
Using R Beginner
Sydney
Scheduled
Thu 8-Oct-20
Using R Beginner
Sydney
Scheduled
Tue 17-Nov-20
Using R Beginner
Sydney
Scheduled
Thu 17-Dec-20
Using R Beginner
Sydney
Scheduled
Parramatta
We don't have courses scheduled in your city yet. Please see our remote course options or contact us to register your interest.
Melbourne
Date
Course
City
Status
Thu 30-Apr-20
Using R Beginner
Melbourne
Confirmed
Tue 13-Oct-20
Using R Beginner
Melbourne
Scheduled
Canberra
We don't have courses scheduled in your city yet. Please see our remote course options or contact us to register your interest.
Adelaide
We don't have courses scheduled in your city yet. Please see our remote course options or contact us to register your interest.
Perth
We don't have courses scheduled in your city yet. Please see our remote course options or contact us to register your interest.
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.
Frequently Asked Questions

What is R? 

R is an open source and free programming language that was developed for statistical analysis and production of high-quality graphics. It has long been popular with statisticians and academics who make up part of the large active user community behind R. This community has contributed over 15,000 packages that extend the base functionality of R, making it easy to implement a vast range of techniques for data manipulation, analysis and visualisation.  

Is R compatible with Microsoft?

Microsoft have recognized the power of R and offer not only their own enhanced distribution of R, Microsoft R Open, but the ability to use R within Microsoft products and services such as Power BI, SQL Server / SQL Server Machine Learning Services and Visual Studio. Microsoft have also developed several packages, including the Microsoft Machine Learning Package for R. 

Can I run R Scripts in Power BI?
This recorded webinar introduces running R Scripts in Power BI. Its worth investing the time to get comfortable with this topic and understand the possible applications for your workplace. This R Script tutorial is free for a limited time.

 

Using R for Beginners Course Details

Price
$795
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 10, 333 Adelaide St, Brisbane QLD 4000
microsoft_gold

Using R for Beginners Course Details

Price
$795
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 37 Pitt Street, Sydney NSW 2000
microsoft_gold

Using R for Beginners Course Details

Price
$795
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 90 Phillip Street, Parramatta NSW 2150
microsoft_gold

Using R for Beginners Course Details

Price
$795
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 466 Little Lonsdale St, Melbourne VIC 3000
microsoft_gold

Using R for Beginners Course Details

Price
$795
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601
microsoft_gold

Using R for Beginners Course Details

Price
$795
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 97 Pirie Street, Adelaide SA 5000
microsoft_gold

Using R for Beginners Course Details

Price
$795
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 1, 140 St Georges Tce, Perth WA 6000
microsoft_gold

Data Analytics Course Outlines

Other Courses
  • Microsoft Power BI Training Courses
  • Microsoft Office 365 Training Courses
  • Microsoft Excel Training Courses
  • Microsoft Excel Specialist Training Courses
  • Microsoft SharePoint Training Courses
  • Microsoft PowerApps Training Courses
  • Microsoft Project Training Courses
  • Microsoft Visio Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses

Contact Us

What do I need to know to attend?

No specific pre-requisites for the course.

Using R for Beginners Learning Outcomes

You will develop an understanding of and be able to:

  • use R data types and objects
  • write basic syntax
  • create and manipulate objects
  • use functions

  • perform basic exploratory data analysis
  • conduct basic modelling and prediction
  • find functions to perform specific tasks.

Using R for Beginners Course Content

  • Introduction
  • Introduction to R
  • Base R and contributed packages
  • Download and installation of base R
  • Installing R packages
  • The RStudio IDE
  • Download and installation
  • Overview of the RStudio environment
  • The main panes
  • Working directory
  • Workspace
  • Projects
  • Create a project
  • Using R as a Calculator
  • Executing commands from the command line and from the source pane
  • Arithmetic operators
  • Relational operators
  • Logical operators
  • Creating Objects
  • Objects in R
  • Assignment operators
  • Naming rules
  • Basics of R Syntax
  • Creating objects
  • Viewing objects in RStudio
  • Viewing objects in the console
  • Data Types and Classes
  • Basic data types
  • Data structures in R
  • Vectors
  • Factors
  • Matrices
  • Data Types and Classes cont'd
  • Arrays
  • Lists
  • Data frames
  • Tibbles
  • Which data structure should I use?
  • Changing data types
  • Implicit coercion
  • Explicit coercion
  • Naming parts of data objects
  • Column names
  • Row names
  • Dimension names
  • Names
  • Accessing Data within Data Structures
  • Referring to data by position
  • Referring to data by name
  • Replace parts of an object
  • Replace names
  • Replace values
  • Add to a data object
  • Add elements to vectors
  • Add rows or columns
  • Add by position
  • Add by name
  • Remove data from an object
  • Evaluation in R
  • Vector arithmetic
  • Order of operations
  • Vector recycling
  • Vectorised operations
  • Applying functions to elements of data structures
  • Using Functions
  • What is a function?
  • Syntax for using functions in R
  • Basic statistical summary functions
  • Masking of functions
  • Package: conflicted
  • Explicitly specifying the package name when calling a function
  • Getting help with a function
  • Importing Data
  • Importing data in RStudio
  • Using code to import data
  • Importing data from text files (csv)
  • Importing data from Excel
  • Manipulating Data
  • Renaming columns and rows
  • Add new columns to a data frame
  • Add new rows to a data frame
  • Ordering data
  • Subsetting data
  • Grouping data
  • Summarising data
  • Manipulating Data cont’d
  • Extract years from dates
  • Extract months from dates
  • Extract days from dates
  • Extract days of the week from dates
  • Identifying blank values
  • Dealing with blank values
  • Removing blank values
  • Manipulating Data cont’d
  • Concatenate data into a single column
  • Split data from a column in to multiple columns
  • Replacing values
  • Working with strings
  • Abbreviating text
  • Remove duplicate rows
  • Bin continuous variables into categories
  • Working with Relational Data
  • Add new variables to a data frame from another
  • Mutating joins
  • Filtering joins
  • Exporting data to a file
  • Basic Exploratory Data Analysis
  • Choosing the right chart for your goal
  • Choosing the right chart for your data
  • Univariate Analysis
  • Exploring the data distribution
  • Mean
  • Standard deviation
  • Quartiles
  • Visual Representation of Distributions
  • Histograms
  • Boxplots
  • Dot charts
  • Multivariate Analysis
  • Create a bar chart
  • Create a column chart
  • Customising plots
  • Correlations
  • Basic Modelling
  • Modelling for prediction
  • Create a linear model
  • Assumptions
  • Evaluating the model
  • Is my model valid?
  • Basic Modelling cont'd
  • How good is my model?
  • Add a trend line to a graph
  • Making predictions from the model
  • Exporting results to a file

Why choose Nexacu?

Valued by Individuals

 

4.8/5
Over 18890 Reviews
WELL SPOKEN -Excel Advanced Perth
RENAE - Excel Advanced, .
Course was very easy to follow and well paced. Steven was excellent at explaining everything and answering questions etc. -SharePoint Site Owner Brisbane
Louise - SharePoint Site Owner, .
Thank you for a very engaging training course Steven. Much appreciate all you knowledge and sharing you experience. -SharePoint Site Owner Brisbane
Ruth - SharePoint Site Owner, .
Great course highly recommended. -SharePoint Site Owner Brisbane
Andrew - SharePoint Site Owner, .
Great Course. Need better Coffee! :) -SharePoint Site Owner Brisbane
Rod - SharePoint Site Owner, .
Michael has offered a comprehensive training session with some real life suggestions. He was easy to understand and always happy to help. -SharePoint Site Owner Sydney
Claudio - SharePoint Site Owner, .
I thought the course was very informative. So much information and such little time. Could easily be a 3 day course. Thankyou Michael! -SharePoint Site Owner Sydney
Ben - SharePoint Site Owner, .
Very informative and interactive -SharePoint Site Owner Sydney
Arlene - SharePoint Site Owner, .
Great course with real life applications in mind. Course Instructor was clear and easy to understand while working at a pace which was comfortable. -Excel Macros/VBA 2 Day Brisbane
MIchael - Excel Macros/VBA 2 Day, .
Great energy by the instructor Ken. Material is great and up to date. Learned lots of new thing, tips, tricks. I would be interested if there will be any advanced training in the near future. -Power Apps Intermediate Melbourne
Ray - Power Apps Intermediate, .
John was a great instructor, the course was easy to understand and follow. John was also a entertaining instructor. I also learnt skills that i believe i can use straight away into my day to day job and enhance my projects. -Excel Macros/VBA 2 Day Melbourne
Katie - Excel Macros/VBA 2 Day, .
John is great! -Excel Macros/VBA 2 Day Melbourne
Peter - Excel Macros/VBA 2 Day, .
Great cousre -Project Advanced Canberra
matt - Project Advanced, .
Great course -Project Advanced Canberra
VI - Project Advanced, .
Greg was very knowledgeable in the course work, and answered all questions with various options relevant to my feild. Would recommend course to others. -Project Advanced Canberra
Brendan - Project Advanced, .
Danny was excellent. He was clear and thorough in his explanation. The course was very beneficial to our group. -Excel Advanced Sydney
Tanya - Excel Advanced, .
Thank you for guiding us through difficult concepts and customizing the course to our needs. We had a great time and really found the course to be very beneficial. Danny is an excellent trainer. -Excel Advanced Sydney
Marieke - Excel Advanced, .
lot of information -Excel Intermediate Perth
Heather - Excel Intermediate, .
excellent course, easy to understand and having the book to take home is useful in practice -Excel Intermediate Perth
Julie - Excel Intermediate, .
great teaching -Excel Intermediate Perth
Lisa - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia