Ref Dates Venue Fees CPE Credits Registrations
FI219 01 - 05 Sep 2019 Dubai US$4,950 30 Register
INTRODUCTION

This highly participative EuroMaTech training course provides you with the essential skills to enable you to analyse financial data effectively for your personal and organisational benefit – very quickly moving you from a beginner to a trained and highly effective data analyst, capable of evaluating stock prices, sales, exchange rate and oil prices.  It will improve every aspect of your role from your ability to collect data to data presentation and analysis.

Delegates will work through practical case studies, analysing movement in share prices, sales, costs as well as exchange rates and oil prices. You will learn how to manipulate data, assess profitability and make sound investment decisions. 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 for your personal and organisational benefit.

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
WHO SHOULD ATTEND?
  • 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
  • Individuals interested in investment analysis and  stock price performance
PROGRAMME OBJECTIVES
  • 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 & investment decisions
TRAINING METHODOLOGY

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.

PROGRAMME SUMMARY

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

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

Print Page

© 2019. 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.



Data Analysis Fundamentals
Analysing Financial Data for Personal & Organisational Benefit



Upcoming Dates

01 - 05 Sep 2019 in Dubai, $4,950



INTRODUCTION

This highly participative EuroMaTech training course provides you with the essential skills to enable you to analyse financial data effectively for your personal and organisational benefit – very quickly moving you from a beginner to a trained and highly effective data analyst, capable of evaluating stock prices, sales, exchange rate and oil prices.  It will improve every aspect of your role from your ability to collect data to data presentation and analysis.

Delegates will work through practical case studies, analysing movement in share prices, sales, costs as well as exchange rates and oil prices. You will learn how to manipulate data, assess profitability and make sound investment decisions. 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 for your personal and organisational benefit.

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
WHO SHOULD ATTEND?
  • 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
  • Individuals interested in investment analysis and  stock price performance
PROGRAMME OBJECTIVES
  • 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 & investment decisions
TRAINING METHODOLOGY

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.

PROGRAMME SUMMARY

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

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

© 2019. 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.

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 Brochure

thumbnail of FI219Data Analysis Fundamentals

Want this Seminar for your Organisation

Please let us know if you wish to conduct this seminar on an in-house basis

Find a course

Other Popular Seminars

Tools

Download our All-New
Training Calendar 2019

Download EuroMaTech Training Plan

Download PDF

© 2019. 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.

Contact Us

EuroMaTech
Training and Management Consultancy
Business Central Towers
Media City Dubai, UAE
Phone U.A.E : +971 4 457 1800
Phone U.K: +44 151 709 7100
E-mail: info@euromatech.ae
Tax Registration Number: 100221936600003

Connect with Us


[recaptcha]

Copyright © EuroMaTech. All rights reserved.