Data and Analytics - from the ground up Training Course

Course CodeCourse Code

danagr

Duration Duration

42 hours (usually 6 days including breaks)

Requirements Requirements

There are no specific requirements needed to attend this course.

Overview Overview

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 OutlineCourse 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

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

TestimonialsTestimonials

I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Kamil was held up helping other people, I could crack on with the next parts.

Luke Pontin - Digital Jersey

learning how to use excel properly

Torin Mitchell - Digital Jersey

The way the trainer made complex subjects easy to understand.

Adam Drewry - Digital Jersey

Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.

Justin Roche - Digital Jersey

Kamil is very knowledgeable and nice person, I have learned from him a lot.

Aleksandra Szubert - Digital Jersey

First session. Very intensive and quick.

Digital Jersey

The patience of Kamil.

Laszlo Maros - Digital Jersey

real life practical examples

Wioleta (Vicky) Celinska-Drozd - Digital Jersey

Bookings, Prices and EnquiriesBookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Private Classroom
 
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
From £6600
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Private Remote
1 £6600
2 £4650
3 £4000
4 £3675
Public Classroom
From £7500
Request
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom
1 £7500
2 £5125
3 £4333
4 £3938
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses

Course Discounts

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.

Some of our clients