Data and Analytics - from the ground up Training Course

Course Code



42 hours (usually 6 days including breaks)


There are no specific requirements needed to attend this course.


Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions: 

What has happened?

  • processing and analyzing data
  • producing informative data visualizations

What will happen?

  • forecasting future performance
  • evaluating forecasts

What should happen?

  • turning data into evidence-based business decisions
  • optimizing processes

The course itself can be delivered either as a 6 day classroom course or remotely over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.

Course Outline

Basic Excel

  • Navigation
  • Manipulating data
  • Working with formulas and addresses
  • Charts

Advanced Excel 

  • Logical functions
  • Scenario analysis
  • Solver
  • Macros
  • First glimpse of code: VBA


  • Data types
  • Writing a function
  • Controlling a program: conditional evaluation and loops
  • Debugging techniques

Data Analytics with R

  • Introducing R
  • Variables and types
  • Data manipulation in R
  • Writing functions
  • Data visualization using ggplot
  • Data wrangling with Dplyr

Introduction to Machine Learning with R

  • Linear Regression
  • Classification and regression trees
  • Classification using Support Vector Machines and Random Forests
  • Clustering techniques


Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From £7500

Private Remote

From £6600

Public Classroom

Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Related Courses

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.