Ref Dates Venue Fees CPE Credits Registrations
FI220 16 - 20 Dec 2018 Dubai US$4,750 30 Register
FI220 23 - 27 Jun 2019 Dubai US$4,950 30 Register
FI220 15 - 19 Dec 2019 Dubai US$4,950 30 Register
INTRODUCTION

This EuroMaTech training course provides you with the Advanced Data Analysis skills to enable you to improve the planning, monitoring and performance of your organisation. This will strengthen your ability within the workplace, allowing you to understand, produce and evaluate data to support you in your role for the benefit of yourself and your organisation.

Delegates will work through practical case studies. With the aid of clear explanations, discussions and detailed material in both hard and soft copy it will enable you to transfer advanced skills and knowledge to your workplace. In this EuroMaTech training course, participants will develop the following competencies:

  • Advanced Analytical skills to improve your understanding and decision making
  • Communication skills supported by graphical and statistical analysis
  • Advanced Excel skills to aid presentation and analysis of business data
  • An ability to forecast data
  • Advanced Statistical knowledge and skills
  • An ability to apply Data Analysis Techniques to the workplace
WHO SHOULD ATTEND?
  • Professionals who wish to gain an Advanced knowledge of Data Analysis in order to improve their analytical skills and understanding of data
  • Personnel in roles where they need to produce Advanced data analysis and/or use data to make decisions
PROGRAMME OBJECTIVES
  • Collect, Present, Analyse and Evaluate Data
  • Develop and use Pivot Tables
  • Analyse data using Data Analysis Tools in Excel
  • Perform Linear Regression; Non-linear regression and Multiple Regression using Excel
  • Apply Data Analysis Techniques to improve Project Management
  • Apply Data Analysis Techniques to improve Financial Management
TRAINING METHODOLOGY

This EuroMaTech training course makes extensive use of Excel and the Data Analysis Tools to provide you with Advanced Data Analysis skills. This combined with presentations, explanations, interactive practical exercises, supported by video materials will ensure delegates leave the programme as Advanced analysts.

PROGRAMME SUMMARY

This EuroMaTech training covers the Advanced Data Analysis Techniques in order to make meaningful business decisions, improve efficiency and profits. This will strengthen your ability within the workplace, allowing you to make a significant impact as an advanced analyst, providing, using or evaluating data to improve performance, efficiency and profit.

PROGRAM OUTLINE
Day 1: - Data Collection, Presentation and Analysis
  • Data and Methods of Collecting Data
  • Presentation of Data using Excel
  • Statistical Analysis of Data – Mean; Median and Mode; Variance and Standard Deviation
  • Probability – Binomial; Normal and Poisson Distribution
  • The Limitations of Data and Data Analysis
  • Confidence Iantervals and Hypothesis Testing
Day 2: - Pivot Tables and Data Analysis Tools in Excel
  • Pivot Tables – developing and using Pivot Tables to aid Decision Making
  • Cross Tabulation and Chi-squared
  • Data Analysis Tools in Excel – a detailed understanding
  • ANNOVA; t-tests and Z scores
  • Moving Average and Exponential Smoothing
  • Advanced and Applied Solver and Goal Seek
Day 3: - Advanced Correlation and Regression
  • Co-variance and Correlation
  • Linear Regression
  • Non-linear regression
  • Multiple Regression using Excel
  • Statistically Testing Results
  • Making Decisions – Project Planning, Estimating Costs; Reducing Risk
Day 4: - Project Management and Applied Data Analysis
  • Forecasting Costs and Production levels
  • Estimating Project Duration using Statistical estimates and P.E.R.T
  • Network and Critical Path Analysis
  • Economic Quantity Order Analysis – to optimise inventory levels
  • Linear Programming and Optimisation Techniques to optimise resource allocation e.g. inventory and capital
  • Earned Value Analysis – to identify Project Cost and Schedule Variances
Day 5: - Financial Management and Applied Data Analysis
  • Analysing and Forecasting Volatility in the Market, e.g. Oil Prices
  • Evaluating Suppliers, Competitors and Acquisition Targets using Data Analysis
  • Developing Financial Models
  • Cost, Volume, Profit Analysis
  • Risk Management using Data Analysis
  • Evaluating the impact of decisions on Return on Investment and Return on Equity

Advanced Applied Data Analysis


Upcoming Dates

16 - 20 Dec 2018 in Dubai, $4,750

23 - 27 Jun 2019 in Dubai, $4,950

15 - 19 Dec 2019 in Dubai, $4,950


INTRODUCTION

This EuroMaTech training course provides you with the Advanced Data Analysis skills to enable you to improve the planning, monitoring and performance of your organisation. This will strengthen your ability within the workplace, allowing you to understand, produce and evaluate data to support you in your role for the benefit of yourself and your organisation.

Delegates will work through practical case studies. With the aid of clear explanations, discussions and detailed material in both hard and soft copy it will enable you to transfer advanced skills and knowledge to your workplace. In this EuroMaTech training course, participants will develop the following competencies:

  • Advanced Analytical skills to improve your understanding and decision making
  • Communication skills supported by graphical and statistical analysis
  • Advanced Excel skills to aid presentation and analysis of business data
  • An ability to forecast data
  • Advanced Statistical knowledge and skills
  • An ability to apply Data Analysis Techniques to the workplace


WHO SHOULD ATTEND?
  • Professionals who wish to gain an Advanced knowledge of Data Analysis in order to improve their analytical skills and understanding of data
  • Personnel in roles where they need to produce Advanced data analysis and/or use data to make decisions

PROGRAMME OBJECTIVES
  • Collect, Present, Analyse and Evaluate Data
  • Develop and use Pivot Tables
  • Analyse data using Data Analysis Tools in Excel
  • Perform Linear Regression; Non-linear regression and Multiple Regression using Excel
  • Apply Data Analysis Techniques to improve Project Management
  • Apply Data Analysis Techniques to improve Financial Management

TRAINING METHODOLOGY

This EuroMaTech training course makes extensive use of Excel and the Data Analysis Tools to provide you with Advanced Data Analysis skills. This combined with presentations, explanations, interactive practical exercises, supported by video materials will ensure delegates leave the programme as Advanced analysts.


PROGRAMME SUMMARY

This EuroMaTech training covers the Advanced Data Analysis Techniques in order to make meaningful business decisions, improve efficiency and profits. This will strengthen your ability within the workplace, allowing you to make a significant impact as an advanced analyst, providing, using or evaluating data to improve performance, efficiency and profit.


PROGRAM OUTLINE
Day 1: - Data Collection, Presentation and Analysis
  • Data and Methods of Collecting Data
  • Presentation of Data using Excel
  • Statistical Analysis of Data – Mean; Median and Mode; Variance and Standard Deviation
  • Probability – Binomial; Normal and Poisson Distribution
  • The Limitations of Data and Data Analysis
  • Confidence Iantervals and Hypothesis Testing
Day 2: - Pivot Tables and Data Analysis Tools in Excel
  • Pivot Tables – developing and using Pivot Tables to aid Decision Making
  • Cross Tabulation and Chi-squared
  • Data Analysis Tools in Excel – a detailed understanding
  • ANNOVA; t-tests and Z scores
  • Moving Average and Exponential Smoothing
  • Advanced and Applied Solver and Goal Seek
Day 3: - Advanced Correlation and Regression
  • Co-variance and Correlation
  • Linear Regression
  • Non-linear regression
  • Multiple Regression using Excel
  • Statistically Testing Results
  • Making Decisions – Project Planning, Estimating Costs; Reducing Risk
Day 4: - Project Management and Applied Data Analysis
  • Forecasting Costs and Production levels
  • Estimating Project Duration using Statistical estimates and P.E.R.T
  • Network and Critical Path Analysis
  • Economic Quantity Order Analysis – to optimise inventory levels
  • Linear Programming and Optimisation Techniques to optimise resource allocation e.g. inventory and capital
  • Earned Value Analysis – to identify Project Cost and Schedule Variances
Day 5: - Financial Management and Applied Data Analysis
  • Analysing and Forecasting Volatility in the Market, e.g. Oil Prices
  • Evaluating Suppliers, Competitors and Acquisition Targets using Data Analysis
  • Developing Financial Models
  • Cost, Volume, Profit Analysis
  • Risk Management using Data Analysis
  • Evaluating the impact of decisions on Return on Investment and Return on Equity


© 2018. Material published by Euromatech shown here is copyrighted. All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.

Print Page

© 2018. Material published by Euromatech shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.




Sending your message. Please wait...

Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

VAT Announcement: The Government of UAE have introduced Value Added Tax (VAT) on goods and services from 01-January-2018. In compliance with the legislation issued by the UAE Government, we will be applying a 5% VAT on the fees for all our programs and services offered from January 2018 as applicable and stipulated in the FTA circulars.

Download EuroMaTech’s Complete 2018
Training Schedules.

Download EuroMaTech Training Plan

Download PDF

© 2018. Material published by Euromatech shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.

Sending your message. Please wait...

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Quality Certifications & Accreditations

EuroMaTech is recognised and accredited by some of the worlds top accreditation bodies:

Get In Touch

What’s happening at EuroMaTech?
Follow us on Social Media or Join our mailing list to know more about our latest schedules, seminars, courses and venues.

Copyright © EuroMaTech. All rights reserved.