Code Date Venue Fees
ME053 21 - 25 Oct 2018 Dubai - UAE $4,750 Register
Home » Seminars » Management & Leadership » Info-Graphics: Data Analysis and Reporting Techniques

Introduction

Corporate ethos which demands continual improvement in work place efficiencies and reduced operating, maintenance, support service and administration costs means that managers, analysts and their advisors are faced with ever-challenging analytical problems and performance targets. To make decisions which result in improved business performance it is vital to base decision making on appropriate analysis and  interpretation of numerical data.

Objectives

This training seminar aims to provide those involved in analysing numerical data with the understanding and practical capabilities needed to convert data into information via appropriate analysis, and then to represent these results in ways  that can  be readily  communicated to others in the organisation.

Objectives include:

  • To provide delegates with both understanding and practical experience of a range more common to analytical techniques and representation methods for numerical data
  • To give delegates the ability to recognize which types of analysis are best suited to particular types of problems
  • To give delegates sufficient background and theoretical knowledge to be able to judge when  an applied technique will likely lead to incorrect conclusions
  • To provide delegates with a working vocabulary of analytical terms that will enable them to converse with people who are experts in the areas of data analysis, statistics and probability, and to be able to read and comprehend common textbooks and journal articles in this field
  • To introduce some basic statistical methods
  • To explore the use of Excel 2010 or 2013 for Data Analysis and the capabilities of the Data Analysis Tool
It should  be noted that the training course does not cover the subjects of data acquisition, databases, data management, data warehousing or the analysis of text-based information.

Training Methodology

The training course adopts a problem-based learning approach, in which delegates are presented with a series of real numerical data analysis problems drawn from the widest possible range of applications – from engineering to finance and from logistics to quality control.

Each problem presents and  exemplifies the  need for a different data analysis approach. For reasons of time constraint it will not be possible to develop solutions during the training course to all of the problems posed. Nevertheless, all delegates will be given comprehensive solutions to all of the problems, to take away with them at the end of the training course, as future learning resources.

The training course is entirely applications-oriented, minimizing the time spent on the mathematics of analysis and maximizing the time spent on the use of practical methods in Excel, along with the understanding why such methods work.

Delegates will spend almost all of the time exploring Excel's data analysis and representation functionality, including the Data Analysis Tool Pack, to investigate the totally realistic data analysis problems.

Organisational Impact

Organisations that are able to make optimum decisions will enhance their ability to compete on the global stage. The participants on this training course, and therefore the teams that they work within will, as a result of their training, be better positioned to influence the organisation with recommendations based on objective data analysis that in turn produce a higher performing business.

Individuals exposed to this training will develop new insights to the usefulness of Excel and the field of data analysis, and they will learn why the best companies in the world see data analysis as being essential to delivering the right quality products and services at the lowest  costs.

Personal Impact

Participants will gain an understanding and  practical experience of a range of the more common analytical techniques and data representation methods, which have direct relevance to a wide range of issues. The ability to recognize which types of analysis are best suited to particular types of issue will be addressed, and delegates will be given sufficient background and theoretical knowledge to be able  to judge when an applied technique will likely lead to incorrect conclusions.

Who Should Attend?

The training course has been designed for professionals whose jobs involve the manipulation, representation, interpretation and/or analysis of data. Familiarity with a PC and in particular with Microsoft Excel (2003, 2007, 2010 or 2013) is assumed.

The training course involves extensive computer-based data analysis using Excel 2010 and therefore delegates will be expected to be numerate and to enjoy working with numerical data on a computer.

Seminar Outline

The Basics

  • Sources of Data, Data Sampling, Data Accuracy, Data Completeness, Simple Representations, Dealing with Practical

Fundamental Statistics

  • Mean, Average, Median, Mode, Rank, Variance, Covariance, Standard Deviation, “lies, more lies and  statistics”, Compensations for small sample sizes,  Descriptive Statistics, Insensitive

Basics of Data Mining and  Representation

  • Single, Two and  Multi-dimensional Data Visualization, Trend Analysis, How to decide what  it is that you want  to see, Box and  Whisker  Charts, Common Pitfalls 

Data Comparison

  • Correlation Analysis, the Autocorrelation Function, Practical considerations of Data Set Dimensionality, Multivariate and Non-linear

Histograms and Frequency of Occurrence

  • Histograms, Pareto Analysis (sorted histogram), Cumulative Percentage Analysis, the Law of Diminishing Return, Percentile Analysis

Frequency Analysis

  • The Fourier Transform, Periodic and  a-periodic data, Inverse Transformation, Practical implications of Sample Rate, Dynamic Range and  Amplitude

Regression Analysis and  Curve  Fitting

  • Linear and Non-linear regression, Order; Best Fit; Minimum Variance, Maximum likelihood, Least Squares Fits, Curve Fitting Theory, Linear, Exponential and  Polynomial Curve Fits, Predictive

Probability and  Confidence

  • Probability Theory, Properties of Distributions, Expected Values, Setting Confidence Limits, Risk and Uncertainty, ANOVA (Analysis Of Variance)

Some more advanced ideas

  • Pivot Tables, the Data  Analysis Tool Pack, Internet-based Analysis Tools,  Macros, Dynamic Spreadsheets, Sensitivity

 

DAY 1

Introduction and Descriptive Statistics                       

  • What is Data Analysis?
  • A Reminder of Elementary Statistics
  • A Quick-start Tutorial for Excel
  • Describing Data Sets using Statistics
  • Representing Data Sets Graphically
  • How to create infographic in Excel?
  • The Normal Distribution
  • Mini-Case Studies

DAY 2                                         

Frequency and Time Series Analysis              

  • Frequency of Occurrence
  • Histograms
  • Pareto Analysis
  • Pivot Tables and Pivot Charts
  • Creating Excel Dashboard
  • Time Series Analysis
  • Trending Data
  • Estimation Theory
  • Mini-Case Studies

DAY 3                            

Scenario Analysis, Confidence and Six Sigma

  • Modeling Scenario
  • Interactive Spreadsheets
  • Confidence Intervals
  • Control Charts
  • An Introduction to Six Sigma
  • Error Bars
  • Mini-Case Studies

DAY 4

Regression Analysis Equations and System Modeling 

  • Simple Regression Analysis
  • Curve Fitting
  • Describing Data using Equations
  • Prediction
  • Modeling Single Input Single Output Systems
  • Modeling Multiple Input Single Output Systems
  • Constraint optimization using Solver
  • Mini-Case Studies

DAY 5                                  

Correlation Analysis and Anova                       

  • Differences between Data Sets
  • Correlation Analysis
  • Analysis Of Variance (ANOVA)
  • Mini-Case Studies
  • Overall Review of Concepts Learned and How they can be applied in Practice

Accreditation

  • Quality Logo

In Association With

Oxford Management Centre

Oxford Management Centre

A GLOMACS - Oxford Management Centre collaboration aimed at providing the best training services and benefits to our valued clients

Visit website

You may also be Interested in...

Home » Seminars » Management & Leadership » Info-Graphics: Data Analysis and Reporting Techniques

© 2017. Material published by GLOMACS 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.

DMCA.com Protection Status

Send to Colleague

© 2017. Material published by GLOMACS 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...

Send Successfully

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

Please complete all the fields in the form before sending.

Print Page

© 2017. Material published by GLOMACS 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.

Download PDF

© 2017. Material published by GLOMACS 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.



Info-Graphics: Data Analysis and Reporting Techniques


Upcoming Dates

Code Date Venue Fees
ME053 21 - 25 Oct 2018 Dubai - UAE $4,750

Introduction

Corporate ethos which demands continual improvement in work place efficiencies and reduced operating, maintenance, support service and administration costs means that managers, analysts and their advisors are faced with ever-challenging analytical problems and performance targets. To make decisions which result in improved business performance it is vital to base decision making on appropriate analysis and  interpretation of numerical data.

Objectives

This training seminar aims to provide those involved in analysing numerical data with the understanding and practical capabilities needed to convert data into information via appropriate analysis, and then to represent these results in ways  that can  be readily  communicated to others in the organisation.

Objectives include:

  • To provide delegates with both understanding and practical experience of a range more common to analytical techniques and representation methods for numerical data
  • To give delegates the ability to recognize which types of analysis are best suited to particular types of problems
  • To give delegates sufficient background and theoretical knowledge to be able to judge when  an applied technique will likely lead to incorrect conclusions
  • To provide delegates with a working vocabulary of analytical terms that will enable them to converse with people who are experts in the areas of data analysis, statistics and probability, and to be able to read and comprehend common textbooks and journal articles in this field
  • To introduce some basic statistical methods
  • To explore the use of Excel 2010 or 2013 for Data Analysis and the capabilities of the Data Analysis Tool
It should  be noted that the training course does not cover the subjects of data acquisition, databases, data management, data warehousing or the analysis of text-based information.

Training Methodology

The training course adopts a problem-based learning approach, in which delegates are presented with a series of real numerical data analysis problems drawn from the widest possible range of applications – from engineering to finance and from logistics to quality control.

Each problem presents and  exemplifies the  need for a different data analysis approach. For reasons of time constraint it will not be possible to develop solutions during the training course to all of the problems posed. Nevertheless, all delegates will be given comprehensive solutions to all of the problems, to take away with them at the end of the training course, as future learning resources.

The training course is entirely applications-oriented, minimizing the time spent on the mathematics of analysis and maximizing the time spent on the use of practical methods in Excel, along with the understanding why such methods work.

Delegates will spend almost all of the time exploring Excel's data analysis and representation functionality, including the Data Analysis Tool Pack, to investigate the totally realistic data analysis problems.

Organisational Impact

Organisations that are able to make optimum decisions will enhance their ability to compete on the global stage. The participants on this training course, and therefore the teams that they work within will, as a result of their training, be better positioned to influence the organisation with recommendations based on objective data analysis that in turn produce a higher performing business.

Individuals exposed to this training will develop new insights to the usefulness of Excel and the field of data analysis, and they will learn why the best companies in the world see data analysis as being essential to delivering the right quality products and services at the lowest  costs.

Personal Impact

Participants will gain an understanding and  practical experience of a range of the more common analytical techniques and data representation methods, which have direct relevance to a wide range of issues. The ability to recognize which types of analysis are best suited to particular types of issue will be addressed, and delegates will be given sufficient background and theoretical knowledge to be able  to judge when an applied technique will likely lead to incorrect conclusions.

Who Should Attend?

The training course has been designed for professionals whose jobs involve the manipulation, representation, interpretation and/or analysis of data. Familiarity with a PC and in particular with Microsoft Excel (2003, 2007, 2010 or 2013) is assumed.

The training course involves extensive computer-based data analysis using Excel 2010 and therefore delegates will be expected to be numerate and to enjoy working with numerical data on a computer.

SEMINAR OUTLINE

The Basics

  • Sources of Data, Data Sampling, Data Accuracy, Data Completeness, Simple Representations, Dealing with Practical

Fundamental Statistics

  • Mean, Average, Median, Mode, Rank, Variance, Covariance, Standard Deviation, “lies, more lies and  statistics”, Compensations for small sample sizes,  Descriptive Statistics, Insensitive

Basics of Data Mining and  Representation

  • Single, Two and  Multi-dimensional Data Visualization, Trend Analysis, How to decide what  it is that you want  to see, Box and  Whisker  Charts, Common Pitfalls 

Data Comparison

  • Correlation Analysis, the Autocorrelation Function, Practical considerations of Data Set Dimensionality, Multivariate and Non-linear

Histograms and Frequency of Occurrence

  • Histograms, Pareto Analysis (sorted histogram), Cumulative Percentage Analysis, the Law of Diminishing Return, Percentile Analysis

Frequency Analysis

  • The Fourier Transform, Periodic and  a-periodic data, Inverse Transformation, Practical implications of Sample Rate, Dynamic Range and  Amplitude

Regression Analysis and  Curve  Fitting

  • Linear and Non-linear regression, Order; Best Fit; Minimum Variance, Maximum likelihood, Least Squares Fits, Curve Fitting Theory, Linear, Exponential and  Polynomial Curve Fits, Predictive

Probability and  Confidence

  • Probability Theory, Properties of Distributions, Expected Values, Setting Confidence Limits, Risk and Uncertainty, ANOVA (Analysis Of Variance)

Some more advanced ideas

  • Pivot Tables, the Data  Analysis Tool Pack, Internet-based Analysis Tools,  Macros, Dynamic Spreadsheets, Sensitivity

 

DAY 1

Introduction and Descriptive Statistics                       

  • What is Data Analysis?
  • A Reminder of Elementary Statistics
  • A Quick-start Tutorial for Excel
  • Describing Data Sets using Statistics
  • Representing Data Sets Graphically
  • How to create infographic in Excel?
  • The Normal Distribution
  • Mini-Case Studies

DAY 2                                         

Frequency and Time Series Analysis              

  • Frequency of Occurrence
  • Histograms
  • Pareto Analysis
  • Pivot Tables and Pivot Charts
  • Creating Excel Dashboard
  • Time Series Analysis
  • Trending Data
  • Estimation Theory
  • Mini-Case Studies

DAY 3                            

Scenario Analysis, Confidence and Six Sigma

  • Modeling Scenario
  • Interactive Spreadsheets
  • Confidence Intervals
  • Control Charts
  • An Introduction to Six Sigma
  • Error Bars
  • Mini-Case Studies

DAY 4

Regression Analysis Equations and System Modeling 

  • Simple Regression Analysis
  • Curve Fitting
  • Describing Data using Equations
  • Prediction
  • Modeling Single Input Single Output Systems
  • Modeling Multiple Input Single Output Systems
  • Constraint optimization using Solver
  • Mini-Case Studies

DAY 5                                  

Correlation Analysis and Anova                       

  • Differences between Data Sets
  • Correlation Analysis
  • Analysis Of Variance (ANOVA)
  • Mini-Case Studies
  • Overall Review of Concepts Learned and How they can be applied in Practice

Quality Logo

GLOMACS is registered with NASBA as a sponsor of Continuing Professional Education (CPE) on the National Registry of CPE Sponsors. NASBA have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.

 

All Training Seminars delivered by GLOMACS by default are eligible for CPE Credit.



© 2017. Material published by GLOMACS 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 Logo
P.O. Box 74653, Dubai, United Arab Emirates
Tel : +971 - 04 - 425 0700, Fax : +971 (04) 425 0701, Email : info@glomacs.ae

Download Training Calendar

Want to stay in touch with what's happening in Glomacs?
Join the conversation on our social media channels:

Facebook Twitter LinkedinYouTube