To make a booking, call
01-6390050

Data Analytics - 2-day Foundation

2-3 Oct 2017 (€1,395 per seat)
Dublin
Two days
Purpose: 

This course aims to provide sufficient basic knowledge to analyse data in the best way without making any of the common errors.

The main headings we will cover during the course are described below. Each section will first be explained theoretically, followed by practical exercises using example data (or data that is provided by the customer). We will use Minitab data analysis software to practice the various analysis. Each participant will be provided with a free 30 day trial version of Minitab. Some of the topics will also be illustrated using MS EXCEL.

It is advised that each participant has access to a laptop or desktop PC with Windows 7 or 8.1 installed. We assume they can bring their own laptop.

Suitable for: 

This course is recommended for all those in an organisation who want to get a good understanding of Data Analysis, the methodology, the main tools and tests and when to use them and when not.

In addition we will spend some time looking at various common errors you must be aware to avoid wrong results.

What’s good about the course? : 

Summary of Agenda:

Day 1 and Day 2 – All participants

Day 1: Data Types, Distributions, MSA and Graphical Tools

Day 2: Hypothesis testing – Part I

  • At the end of the course participants will know what the data analytics methodology is.
  • At the end of the course participants will have a fundamental understanding of how to use the various tools listed below. Even though we will practice as much as possible, it is advised that the participants keep practicing.
  • The knowledge acquired will provide an understanding of how Data Analysis can be integrated into the company’s reporting and decision structure.

Objectives:

  • At the end of the course participants will know what the data analytics methodology is.
  • At the end of the course participants will have a fundamental understanding of how to use the various tools listed below. Even though we will practice as much as possible, it is advised that the participants keep practicing.
  • The knowledge acquired will provide an understanding of how Data Analysis can be integrated into the company’s reporting and decision structure.

Benefits:

Practical hands-on workshops

Days 1 to 2 for participants new to the topic

Detailed Content:

Day 1

Data Analysis Methodology – CRISP-DM (Cross-Industry Standard Process for Data Mining)

  • Business Understanding
  • Data understanding
  • Data Preparation
  • Modeling
  • Evaluation
  • Deployment

Introduction to Minitab and Excel (History in Minitab & Change settings in Excel)

  1. Distributions
  • Types of data: Continuous, Attribute (Ordinal, Discrete and categorical)
  • Normal Distribution
  • Binomial distribution
  • Poisson distribution

Day 2

Hypothesis testing – Part I

When you want to compare averages or medians of some sample of data to decide if they are statistically different.

When you want to compare the standard deviation of some sample of data to decide if their variation is statistically different.

When you want to compare proportions or percentages that came from different samples of data to decide if they are statistically different.

  • Principles of Hypothesis testing: What is it and why and when do we use hypothesis testing
  • 1 Sample T-Test: for comparing the averages of one sample against a specific target or historical average
  • 2 Sample T-Test: for comparing the averages of two samples against each other.
  • One way ANOVA: for comparing the averages of 3 or more samples against each other
  • Pared T-Test: for comparing the averages of two samples that contain data that is linked in pairs.

Exploratory data analysis via graphical tools

  • Time series
  • Scatter
  • Pareto
  • Box and Whiskers

Advanced Section – Continued for another 2 days