We regret to inform you that we currently don't have any sessions scheduled for this course.
Please let us know your preferred date and venue, and we'll contact you soon.
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 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 an understanding and practical experience of a range of the more common 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 to 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 and concepts
- To explore the use of Excel 2010 or 2013 for data analysis and the capabilities of the Data Analysis Tool Pack
It should be noted that the course does not cover the subjects of data acquisition, databases, data management, data warehousing or the analysis of text-based information.
Training Methodology
The 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 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 course, as future learning resources.
The 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 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 into the use 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 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 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.
DAY 1
Setting the Statistical Scene
- Statistics as an evidence-based management decision support tool
- The process of evidence-based statistical decision making
- Overview of the components of the discipline of Statistics
- Applications review of Statistics for Engineers and Technologists
- Data – Raw material of Statistics – Factors affecting data quality/integrity (sources of data, data gathering approaches (sampling), data types (categorical and numeric), data preparation issues) (all impact on the validity, accuracy, completeness and representativeness of data to address management issues
Exploratory Data Analysis – Tools to Profile and Describe Sample Data
DAY 3
Basic Probability Concepts – Measuring Uncertainty
- Basic Probability Types, Rules and Concepts
- Normal Probability Distribution
DAY 4
Inferential Analysis – Statistical Decision Making
- Confidence Intervals – To estimate likely population measures
- Application of Confidence Intervals to Statistical Quality Control (process control charts (R-charts, x(bar)-charts, S-charts), control charts for attribute data, process capability indexes (SPC XL for Excel)
- Hypothesis Testing – Tests for statistical relationships between measures
- From two samples (t-tests for independent and matched samples)
- From multiple samples (Analysis of Variance ANOVA)
- Test for independence of association (the chi-squared test)
DAY 5
Statistical Modelling – Building Models for Prediction Purposes
- The model building process
- Correlation analysis
- Multiple Linear Regression models (Stepwise Regression modelling)
- Modelling with categorical measures
- Curve fitting (polynomial and auto-regressive models)
DAY 6
Basics of Data Mining
- Overview of data mining
- Review of data mining approaches and techniques (Descriptive data mining and Predictive data mining modelling approaches)
- On successful completion of this training course, GLOMACS Certificate will be awarded to the delegates
- Continuing Professional Education credits (CPE) : In accordance with the standards of the National Registry of CPE Sponsor, one CPE credit is granted per 50 minutes of attendance
Endorsed Education Provider
GLOMACS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy 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.NASBARegistry.org
In Association With
Oxford Management Centre
A GLOMACS - Oxford Management Centre collaboration aimed at providing the best training services and benefits to our valued clients.
GLOMACS Training & Consultancy
Typically replies within an hour