Training Course Details

Rapid reporting for analysts: An Introduction to R programming through to reporting in three days

Course Level: Foundation, Intermediate
Jane produces reports both weekly progress, monthly, quarterly and annual overviews for management and the board. She uses a variety of licenced software/tools because each one has limitations. She copies and places them in a document to compile a report. She is overwhelmed with the gradual increase in volume of data to be processed. Needing to wrangle complicated data from multiple sources takes time. Introducing R programming could seem overwhelming to Jane if done in formal modules. This course aims to take each individual through the fundamental approach to using R programming in her current role. Ensuring that the attendees build confidence on where and how to start when they get back to their desks. By the end of the course the individual should have already introduced some automation and will be working towards automating all of their reports. Our experience shows analysts who set up a reproducible report save between 20-80% time on their task

Newcastle upon Tyne, UK | December 2, 2019

Price:
£750.00 ex VAT per person
Venue Details:
Date:
December 2, 2019
Time:
9.00 am - 5.00 pm
Duration:
3 day
Select if you qualify for a discount

Course Details

Course Outline

Day 1: Introduction to R

  • Introduction to R: A brief overview of the R environment including the R working
  • directory, creating/using scripts, saving data and results.
  • Data entry: A description of how to import and export data from R.
  • Data analysis: Learn quick efficient methods to gain insights from data using dplyr.
  • Summary statistics: Calculating means, variance and other useful data summaries.

Day 2: Graphics

  • Introduction to a versatile approach to achieve impressive graphics in R with ggplot.
  • Creation of different plot types: histograms, scatter, density, box plots.
  • Working examples of how alter the design, including scales, axes and legends.
  • Adding the finishing touches with colours, themes, additional information.

Day 3: Automated Reporting

  • Rmarkdown: Creating documents using Markdown
  • knitr: Running dynamic R code
  • Automate: Automate documents and apps
  • LaTeX: A brief introduction to latex for additional styling

View course PDF

Learning Outcomes

By the end of the course participants will be able to…
  • Import and export their own data from spreadsheets and other data storages to R.
  • Manipulate data in ways such that they can efficiently analyse data.
  • Be able to efficiently plot their own data in eye catching ways within seconds.
  • Be able to customise their graphs with colour schemes, themes, fonts and grid layouts.
  • Learn to build automated reports including data, text and graphics using Rmarkdown.

Prior Knowledge

No prior programming knowledge of any kind is assumed. This course is suitable for all fields of work. Previous attendees include biologists, statisticians, accountants, engineers & students, i.e., anyone who uses a spreadsheet! Participants should bring a laptop.