Data Interpretation & Analysis

Data Interpretation Training provides you the secrets of  Analyzing & Interpreting Data for decision makingAnalyzing performance & Continuous Improvement of processes.

A number of statistical Data Analysis Techniques for Predictive Analytics are demonstrated with examples & exercises for participants.

Classroom based demonstration with hands-on Exercises using Microsoft Excel, used as a Data Analysis Tool.

Extremely Practical, Hands-on Training with our Excel Guru Master Trainer Mr. Vinai PrakashPMP, MBA, Six Sigma, GAP, ITIL Certified  ACTA Trainer.

Mr. Vinai has over 28+ years of experience in Data Warehousing, Data Quality, Data Mining, and Advanced Data Analytics & Business Intelligence.

Course Objectives

Objectives of Data Interpretation & Analysis Training

  • The objectives are to equip the participants with a sound grounding of Using Microsoft Excel for day to day analysis of data.
  • Many advanced concepts and features of Microsoft Excel are highlighted to the students.
  • Learn  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 Data Analytics workshop.
  • Be able to analyze any given data set, and summarize it to highlight the key points and make it presentable for clients or management.

These Data Interpretation & Analysis Workshops are highly practical, and the participants learn by  doing a number of exercises using Predictive Analytics – Correlation, Regression & Modeling Techniques to Analyze and Interpret data.

Different methods & techniques to forecast & analyze data with advanced features of Microsoft Excel are taught in this hands-on training. We also cover advanced Exceld data analysis topics like Data-Tables, Using Goal Seek, Performing Scenario Analysis, and Advanced Pivot Table techniques in analyzing data within Excel.

 Learn The Secrets of Data Analysis With Excel, & Be a Power Ninja Data Analyst!

Target Audience

This data analysis course is intended for Managers, Data analysts, Professionals, Executives  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.

Certification:
Certificate of attendance would be given to participants. 

Materials:
Notes in folders will be provided. Exercises with sample data are available for use in the class.

Class Size: 
15-30 participants

Data Interpretation & Analysis Training

Course Outline

Quality & Decision Support Systems
  • Modelling and its relationship to management
  • Different Types of Data Analysis Techniques
  • Single Variable & Multi-Variate Forecasting

Understanding Data & Forcasting Statistically

  • How to Forecast Based on Historical Information
  • Data Analysis using Statistical Analysis Techniques
  • Introduction to Correlation & Regression
  • Discussions & Lab Exercises

Tables & Charts in Data Analysis

  • Types of Charts, Tables
  • Building Simple Models
  • Pivot Tables and Advanced Excel Techniques

Descriptive Summary Measures

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

Single & Multiple Regression

  • Stepwise Modelling
  • Multiple and non-linear regression analysis
  • Application of Regression in Business
  • Lab exercise
Troubleshooting
  • Problem Simulation
  • Application to Business / Management
  • Lab exercise

Applications of Advanced Data Analysis With Excel

  • What-if analysis
  • Goal Seek
  • Scenario Manager
  • Application to Business / Management
  • Lab exercise

Continuous Improvement

  • Total Quality Management
  • Kaizen & Moving to Six Sigma
  • Holistic Approach to Continuous Improvement.

Discussion & Future Steps on
Data Analysis in the real world.

Learn The Secrets of Data Analysis With Excel

Get Your Hands On This  Practical Training 
That will Assist You Forever in Your
Data Analysis.
REGISTER TODAY


 

Course Trainer

This training course is created and delivered by Mr. Vinai Prakash, Master Trainer & Founder of Intellisoft.

He has authored several articles on Data analysis, Excel Dashboarding Techniques, Data Warehousing, Data Mining, Using SQL Databases for Creating Data Rich applications,  which are published all over the world.

Click Here to Download The 8 Habits of Highly Effective Data Analysts (An article written by Vinai Prakash, published in The Straits Times Newspaper in Singapore)

Pre-Requisites

You should be familiar with Microsoft Excel and should be able to write & edit basic formulas and functions. You should also have some data to analyze and a desire to learn advanced techniques in data analysis.

This Data Interpretation & Analysis will be held in Jakarta on October 22-26, 2018.

Need Help?

Call us at +65 6392-4590 or Send an email  to  corporate@intellisoft.com.sg