PMP Exam Prep Tips

Receive PMP Exam Preparation Tips & Project Management Articles

Master Trainer Vinai's
articles are published in books,
magazines & newspapers

Our article in The Straits Times

Learning For Life

Subscribe to our Learning for Life Newsletter & Get Interesting Articles & Training Updates!

 Email:
Name:

Enquiry / Registration

Status
Enquiry Registration
Course Title*
Course Date*
Self / Company Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Number of Participants*

 

Data Interpretation & Analysis


Course Duration: 2 Days - Full Time Course on Analyzing Data (Singapore)

SDF Funding now Available for SME companies. Call 6296-2995 for Details.

This course teaches the basic skills & techniques of gathering, presenting & interpreting data for decision making, analysing performance & continuous improvement of processes.

Benefits of Data Interpretation & Analysis
  • The benefits are a sound grounding of Using Excel for day to day analysis of data. Many advanced concepts and features of Excel are highlighted to the students.
  • Learn how to conduct surveys, collect data, and get to know the best practices in data collection, analysis and decision making.
  • The key feature is the number of exercises and real life examples used in the 2 day workshop.

Target Audience

This course is intended for managers, data analysts and support staff from Sales, Service, Finance, Marketing, R&D and IT Departments, who are assisting the management in the presentation of charts, graphs, comparing past performance, doing forecasting, budgeting, trend analysis and decision making based on past and present data.

Day 1: Introduction

Quality & Decision Support Systems
* Modelling and its relationship to management
* Types of problems, planning a study
* Framing a hypothesis

Identifying Problems and Understanding Data
* Data Handling
* Sampling design
* Surveys and their design aspects
* Discussions & Lab Exercises

Tables & Charts
* Types of Charts, Tables
* Patterns & Behaviour
* Building Simple Models
* Pivot Tables and Advanced Excel Techniques

Descriptive Summary Measures
* Correlation and Regression
* Correlation Analysis
* Correlation versus causation
* Summary Measures

Probability & Distributions
* Statistical Analysis, Process & Control
* Application to Business / Management

Single Regression & Correlation
* Stepwise Modelling
* Multiple and non-linear regression analysis
* Application of regression in Business
* Lab exercise

Day 2: Statistical Inferences

* Time Series Analysis
* Filters
* Forecasting, prediction, estimation
* Cross correlogram
* Practical Application in Business / Management
* Lab exercise

Troubleshooting
* Problem Simulation
* Sensitivity analysis
* Application to Business / Management
* Lab exercise

Applications of Optimization
* What-if analysis
* Linear Programming
* Application to Business / Management
* Lab exercise

Continuous Improvement
* Total Quality Management
* Kaizen
* Six Sigma
* Holistic Approach to Continuous Improvement.

General Discussion on Applications in the real world

 

Classroom based lecture with hands-on training using Microsoft Excel, used as a statistical analysis tool.

Certification:
Certificate of attendance would be given to participants.

Materials:
Notes in folders will be provided.

Class Size:
5-10 participants

Course Dates: In-house customised Corporate Training is available for a group of 4 or more participants. Contact us if you have a team of 4 or more data analysts interested in improving their data interpretation skills.

Call (65) 6296-2995 or (65) 9877-3485 to enquire about the Data Interpretation & Analysis training course, or email to training@intellisoft.com.sg