Data and Analytics - from the ground up Training Course

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

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]
Selenium WebDriver in C#: Introduction to Web Testing Automation in C# Sheffield Wed, 2018-09-26 09:30 £2178 / £2578
Introduction to Ansible Automation London, Hatton Garden Mon, 2018-10-08 09:30 £1089 / £1464
Jenkins: Continuous Integration for Agile Development Manchester, King Street Thu, 2018-10-18 09:30 £2574 / £3224
Introduction to Recommendation Systems Swansea- Princess House Thu, 2018-10-18 09:30 £990 / £1140
Impact Evaluation – Quantitative Analysis London, Hatton Garden Wed, 2018-10-24 09:30 £2574 / £3324
CakePHP: Rapid Web Application Development Birmingham Tue, 2018-11-06 09:30 £4356 / £5656

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

is growing fast!

We are looking to expand our presence in your region!

As a Business Development Manager you will:

  • expand business in the region
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

contact us right away!