TRN802 Advanced Analytics with Oracle’s R Technologies, 2 days

TRN802 Advanced Analytics with Oracle’s R Technologies, 2 days

Actions and Detail Panel


Date and time


Online event

Refund policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Advanced Analytics with Oracle’s R Technologies, 2 day course aimed at BI Developers, Report Authors and DBAs.

About this event

TRN802: Advanced Analytics with Oracle’s R Technologies, 2 days

Course Dates:

23,24,25, 26 August 2022 (4 half days = 2 day course duration)

Training Delivery Timezone:

* GMT-4 / USA New York 9.00am - 13.00pm

* GMT+1 UK BST 14.00 - 18.00pm daily

Purchase Process & Price

USA, EU and Global GBP £1,000 + no VAT. Purchase tickets via this USA / EU EventBrite item.

UK Customers can use this UK EventBrite item to pay GBP £1,000 + 20% VAT = £1,200 total.

Course Overview:

R has become the default data science and statistical modelling tool across all shapes and sizes of organisation. R is open source, and its functionality can be extended by community written packages, significantly increasing its power and flexibility. R can be used standalone, in a notebook environment like R Studio or Juptyer, or embedded in enterprise reporting tools such as Oracle’s OBIEE and Data Visualisation tools.

This course aims to teach people with a background in enterprise reporting, data visualisation, data, or business analysis the fundamentals of R and how to use it in an enterprise context. The lessons and labs use both local datasets and outputs, and Oracle's database and reporting tools to teach students how to perform simple data manipulation build models and visualise the results.

Previous Knowledge

Some Experience with Oracle's Data and Business Intelligence Tools, SQL or modelling.

Delivery Format

The training course is delivered via Zoom and Rittman Mead provide delegates with our hosted virtual machine online training environment which includes R-Studio.


The topics we’ll be covering in this course are:

Agenda (Day 1)

A Brief Tour of R

- History

- Examples

The R Environment

- RStudio

Data Types in R

- Vectors, matrices, lists, and data frames

Conditions and Loops

- If - Else If – Else

- Vectorized conditionals – ifelse

- While Loops & For Loops

Functions and the Apply Family

- Writing Functions

- lapply, sapply and mclapply

Agenda (Day 2)

Acquire Data

- From Flat Files (readr)

- From Oracle (ROracle)

- From APIs (twitterR)

Tidy Data

- Theory of Tidy Data

- Tidy Data and Star Schemas

- The TidyR Package and its Functions

Transform Data

- Single-Table Transformations

- Multi-Table Transformations

- DPLYR vs SQL - Syntax Showdown

Visualize Data

- The Grammar of Graphics

- ggplot2 - Static Graphics with R


Hands on practical activities for delegates

Lab 01 – The R Environment

Lab 02 - Data structures in R and Oracle

Lab 03 - Conditions and Loops

Lab 04 - Functions and the Apply Family

Lab 05 - Acquire and Tidy Data

Lab 06 - Transform Data

Lab 07 - Visualize Data

Online Training Environment

"Advanced Oracle Analytics R Bootcamp Training is a hands-on course that consists of trainer presentations and demonstrations plus delegate lab activities. Rittman Mead provides the training environment which is virtual machine for each delegate To participate in this course, all you need is a computer with a web browser such as Chrome and the latest desktop version of Zoom. We will share courseware, consisting of Slides and Lab activities in the form of PDF files via a Onedrive shared link for download.

Training Needs Analysis

With new clients, we typically set up a short TNA Zoom call in which we identify your specific training needs and skills development goals. This helps us offer you the right Learning Pathways. Feel free to let me know your availability for such a call if it helps you at this stage.

Please email us to find out more about this course.

Paul Murphy | Training Lead | Rittman Mead (UK)

Rittman Mead Training Catalogue:

Take a look at the other courses we offer.

Rittman Mead Blog: Find enlightening articles on Oracle Analytics and more...

Rittman Mead Consulting is a data and analytics company who specialise in data visualisation, predictive analytics, enterprise reporting and data engineering. This makes our Training Courses very practical since they are delivered by experienced consultants that have real world experience with the OA tools.

Share with friends