An Interactive 5-Day Training Course
Data Analysis Techniques
Analysis Methods and Evidence-based Decision-making using Microsoft Excel
Course Overview
Everyone agrees that evidence-based decision making is the key to corporate high performance. In a world where everything is now measured and recorded, the data that companies hold can be a very rich and powerful source of evidence, but only if it can be analyzed and interpreted accurately and reliably. This Data Analysis Techniques training course shows delegates, by example, how to analyze and interpret data and hence how to make robust and defensible evidence-based business decisions.
The Data Analysis Techniques training course shows delegates how to use Microsoft Excel to perform a wide range of powerful analysis and interpretations, using real data. This is possible because, although most people are familiar with Microsoft Excel, they generally only use a small fraction of its true capability. This training course will show delegates how to make the most of Excel by explaining and demonstrating many of the very powerful analytical, visualization and interpretation capabilities that it is capable of.
This GLOMACS Data Analysis Techniques training course will highlight how to:
- Approach a data analysis problem in a logical manner
- Maximize the accuracy of analysis and minimize the chance of errors
- Extract and represent information from complex numerical data
- Interpret features from within data and make evidence-based decisions
- Perform a ‘what if’ scenario analysis
- Predict the future behavior of a system or a process using regression analysis
- Predict the future behavior of a system or a process, using data science methods
- Use analysis of variance (ANOVA) to minimize the risk of false interpretation
- Make the most of Microsoft Excel by using many of the advanced features that it contains
Training Objectives
This Data Analysis Techniques training course aims to provide those involved in analyzing numerical data with the understanding and practical capabilities needed to convert data into information via appropriate analysis, how to represent these results in ways that can be readily communicated to others in the organization, and how to use the information to make evidence-based business decisions.
At the end of this Data Analysis Techniques training course, you will have:
- A good understanding and extensive practical experience of a range of common analytical techniques and interpretation methods for numerical data
- The ability to recognize which types of analysis are best suited to particular types of problems
- The ability to judge when an applied technique will likely lead to incorrect conclusions
- A good understanding of a wide range of common statistical methods and approaches
- The ability to use Microsoft Excel 2016, 2019 or 365 to analyze and interpret a wide range of real data types
- Experience of how to transform numerical data into evidence and hence how to make informed business decisions
It should be noted that the course does not cover the subjects of data acquisition, databases, data management, dashboards or the analysis of text-based information.
Who should Attend?
This training course has been designed for any professional whose job involves the manipulation, analysis, representation and interpretation of data, including the subsequent evidence-based business decision making process.
Familiarity with a PC and in particular with Microsoft Excel (2013 or higher) is assumed, and delegates will be expected to be numerate and to enjoy working with numerical data on a computer.
This GLOMACS Data Analysis Techniques training course is suitable for a very wide range of professionals from any industry sector, but will greatly benefit people working in the following fields:
- Performance assessment and monitoring
- Planning
- Data analysis
- Management and leadership
- Finance
- Human resources
- Quality control
- Engineering and technology
- …in fact, any job function which uses data to make decisions.
About Saudi Glomacs
At Saudi GLOMACS, we specialize in delivering world-class training courses in Saudi Arabia and across various international locations. Our training courses are tailored to meet the unique demands of Saudi Vision 2030 and the Human Capability Development Program, focusing on empowering Saudi citizens and enhancing workforce skills. We offer diverse courses spanning leadership, management, engineering, and technical disciplines to cultivate expertise and drive professional growth. Our flexible learning options—whether in-person, online, or in-house—ensure accessibility and convenience for individuals and organizations alike.
With over 30+ years of experience through the GLOMACS global network, we are committed to delivering innovative, results-driven training solutions. Our expert instructors combine industry knowledge with dynamic teaching methods, fostering practical skill development and long-term career success. By choosing Saudi GLOMACS, you're investing in personal excellence and contributing to the Kingdom’s sustainable economic growth and vision-driven transformation.
Training Outline
DAY 1: Logical and Reliable Data Analysis, Descriptive Statistics, and Pivot Tables
- Importing data into Excel
- Best practice when analyzing data
- Analyzing and representing coded data
- Descriptive statistics and their real meanings
- Performing a frequency analysis
- The use of pivot tables and pivot charts
- Noisy and incomplete data, statistical significance and dealing with outliers
DAY 2: Data Mode Shape Analysis
- Plotting data against time
- Generating data mode shapes
- Fitting curves to data
- Correlating mode shape to time-based events
- Interpreting time series analyses
- Moving average calculations
DAY 3: Scenario Analysis and Interactive Spreadsheets
- Representing analytical problems as multi-input, single-output (MISO) systems
- Deterministic systems analysis
- What if and visual scenario analysis
- Dynamic / interactive spreadsheets and the use of forms control
- Moving window, conditional and adaptive calculations
- Measuring the sensitivity of calculated variables
DAY 4: Regression Analysis and Correlation
- Equations of curves
- The prediction of future behavior using data shape – regression analysis
- Linear, polynomial, exponential and power curve fits
- The dangers of over-fitting
- Data end effects
- Goodness of fit (sum of square error – SSE) and R2
- Evaluating equations, solving equations, and using Solver
- Correlation and causality
DAY 5: Data Driven Methods and Analysis of Variance
- Non-deterministic system
- Data driven methods
- One step ahead future prediction using data science (multivariate correlation)
- Single factor analysis of variance (ANOVA)
- Two factor analysis of variance
- A demonstration of artificial intelligence – the travelling salesman problem
Certificates
- 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
Accreditation
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.
Providers and Associations
Sessions in international locations
Online Sessions
What do you need to learn next?
Check our list of courses or let us customize a course for you.
View courses
