Data and Analytics - from the ground up

Course Code

danagr

Duration

42 hours (usually 6 days including breaks)

Requirements

There are no specific requirements needed to attend this course.

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

Client Testimonials

★★★★★
★★★★★

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

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Javascript And Ajax St Helier, Jersey, Channel Isles Mon, 2018-07-02 09:30 £4950 / £7325
PostgreSQL for Administrators Swansea- Princess House Mon, 2018-07-02 09:30 £2178 / £2478
OCUP2 UML 2.5 Certification - Advanced Exam Preparation St Helier, Jersey, Channel Isles Mon, 2018-07-23 09:30 £1980 / £2930
Introduction to R Glasgow Wed, 2018-08-01 09:30 £3861 / £4911
Subversion for Users Newcastle Fri, 2018-08-03 09:30 £1089 / £1289
OCUP2 UML 2.5 Certification - Intermediate Exam Preparation St Helier, Jersey, Channel Isles Tue, 2018-08-07 09:30 £2340 / £3290
jQuery Swansea- Princess House Wed, 2018-08-15 09:30 £1980 / £2280
AWS: A Hands-on Introduction to Cloud Computing Edinburgh Training and Conference Venue Tue, 2018-09-11 09:30 £1287 / £1487
Test Automation with Selenium St Helier, Jersey, Channel Isles Tue, 2018-09-18 09:30 £2970 / £4395

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.