CPE Credits
FI 219
04 - 08 Mar 2018
US$ 4750
FI 219
02 - 06 Sep 2018
US$ 4750

This highly participative EuroMaTech training course provides you with an introduction to the essential skills required to enable you to collect, present and analyse data. Very quickly you will go from a beginner to a highly effective data analyst using Excel to present and evaluate business data.

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 skills and knowledge to your workplace. In this Data Analysis Fundamentals training course, participants will develop the following competencies:

  • Analytical skills to improve your understanding and decision making
  • Communication skills supported by graphical and statistical analysis
  • Excel skills to aid presentation and analysis of business data
  • An ability to forecast data
  • Basic Statistical knowledge and skills
  • Professionals who wish to gain an introduction to Data Analysis in order to improve their analytical skills and understanding of data
  • Personnel moving into roles where they will need to produce data and/or use data to make decisions
  • Select the most appropriate Methods of Data Collection
  • Present Data in an interesting and meaningful manner
  • Analyse data using statistical methods
  • Use Probability to estimate data
  • Understand the Limitations of Data and Data Analysis and undertake Hypothesis Testing
  • Use Data Analysis and Forecasting Techniques to make business decisions

Delegates will be provided practical work to enable them to actively participate and develop their skills in the evaluation of practical case studies relevant to their workplace. This EuroMaTech training course will also use clear explanations, discussions and video material to aid understanding and development, moving delegates from beginners to proficient analysts.


This EuroMaTech training course covers the essential skills to enable you to collect, present, analyse data. It will enable delegates to make a significant impact within their organisation, capable of understanding data provided or to use data to make meaningful business decisions.

Day 1 - Data and Methods of data collection
  • Types of Data – Primary and Secondary Data; Quantitative and Qualitative Data
  • The Role of Data Analysis in Business
  • Methods of Collecting Data – Surveys, Interviews, Focus Groups etc
  • Sample Design – Random, Systematic, Stratified etc
  • Planning a Sampling Survey
  • Organising the Data Received and Information Management
Day 2 - Presentation of data
  • Methods of Presentation
  • Using Excel to aid Presentation
  • Simple Bar Charts; Line Graphs; Pictogram; Pie Charts etc
  • Time Series Analysis
  • Interpolating and Extrapolating
  • The Interpretation of Data Presentation
Day 3 - Statistical Analysis of Data
  • Random Variables – Discrete and Continuous
  • Using Excel to aid Analysis
  • Mean; Median and Mode
  • Variance and Standard Deviation
  • Co-variance and Correlation
  • Probability – Binomial; Normal and Poisson Distribution
Day 4 - Evaluating Data and Decision Making
  • The Limitations of Data and Data Analysis
  • Populations and Samples
  • Confidence Intervals
  • Hypothesis Testing
  • Testing 2 Means – Independent and Paired Samples
  • Decision Making using Decision Trees
Day 5 - Data Analysis and Forecasting Techniques
  • Forecasting, Sales; Costs; Budgets, Production etc
  • An Introduction to the Data Analysis Tools in Excel
  • What-If Analysis and Scenario Manager using Excel
  • Linear Regression
  • Basic Solver and Goal Seek
  • Variance Analysis – comparing Forecast to Budgets
Download EuroMaTech's Complete 2017 Training Schedules
Download EuroMaTech 2017 Training Plan
Download EuroMaTech 2017 Training Plan