Advanced Data Analysis Techniques

Advanced Data Analysis Techniques

Modelling, Simulation, Optimisation and Predictive Analytics using Microsoft Excel

(36)
KHDA NASBA
Course Schedule
Register
Training course in Advanced Data Analysis Techniques in 24-28 Nov 2025 - Lisbon
24-28 Nov 2025
Lisbon
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 24-28 Nov 2025 - Online
24-28 Nov 2025
Online
$3,950
Register
Register
Training course in Advanced Data Analysis Techniques in 01-05 Dec 2025 - Dubai
01-05 Dec 2025
Dubai
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 22-26 Dec 2025 - Amsterdam
22-26 Dec 2025
Amsterdam
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 09-13 Feb 2026 - Dubai
09-13 Feb 2026
Dubai
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 20-24 Apr 2026 - Dubai
20-24 Apr 2026
Dubai
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 18-22 May 2026 - Oslo
18-22 May 2026
Oslo
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 22-26 Jun 2026 - Online
22-26 Jun 2026
Online
$3,950
Register
Register
Training course in Advanced Data Analysis Techniques in 29 Jun-03 Jul 2026 - Dubai
29 Jun-03 Jul 2026
Dubai
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 06-10 Jul 2026 - London
06-10 Jul 2026
London
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 24-28 Aug 2026 - Dubai
24-28 Aug 2026
Dubai
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 07-11 Sep 2026 - London
07-11 Sep 2026
London
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 23-27 Nov 2026 - Lisbon
23-27 Nov 2026
Lisbon
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 23-27 Nov 2026 - Online
23-27 Nov 2026
Online
$3,950
Register
Register
Training course in Advanced Data Analysis Techniques in 30 Nov-04 Dec 2026 - Dubai
30 Nov-04 Dec 2026
Dubai
$5,950
Register
Register
Training course in Advanced Data Analysis Techniques in 21-25 Dec 2026 - Amsterdam
21-25 Dec 2026
Amsterdam
$5,950
Register

Course Overview

The statistical analysis of numerical information is proven to be a powerful tool, providing businesses with everyday insight into matters like corporate finance, manufacturing processes, service provision and product quality control.

However, the advent of the Internet of Things, the consequential growth in Big Data, and the ever-increasing business requirements to model and predict, mean that many of the analytical opportunities and needs of a modern, high performing company cannot be met using conventional data analysis methods alone.

More and more companies are wrestling with complex modelling and simulation problems, addressing matters like trying to optimize production systems, to maximize performance efficiency, to minimize operating costs, to combat risk, to detect fraud and to predict future behavior and outcomes.

This Advanced Data Analysis Techniques training course is 100% computer-based and shows by example how to use Microsoft Excel to solve a series of complex and realistic business problems. The problems are drawn from the widest possible range of applications – from robotics to refining, from supply chain logistics to production optimization and from financial risk management to the efficient provision of healthcare. All the problems are different and all convey carefully designed learning objectives.

Delegates will learn how to code and simulate realistic problems and then how to use these simulations to understand system operation, to optimize performance, and to predict future behavior. The training course is intended for people who are experienced in conventional data analysis techniques, and who now want to become specialist in the modelling and simulation of complex business activities.

What are the Goals?

This training course aims to provide those involved in monitoring, managing and controlling complex business processes with the understanding and practical capabilities needed to convert data into meaningful information via a range of very powerful modelling, simulation and predictive analytical methods.

The specific objectives of this Advanced Data Analysis Techniques training course are as follows:

  • To teach delegates how to solve a wide range of complex business problems which require modelling, simulation and predictive analytical approaches
  • To show delegates precisely how to implement a range of modelling, simulation and predictive analytical methods using Microsoft Excel 2016 (or 365)
  • To provide delegates with both a conceptual understanding and practical experience of advanced data analysis methods including: Bayesian models, conventional and genetic optimization methods, Monte Carlo models, Markov models, What If analysis, Time Series models, Linear Programming, and more
  • To engage delegates for the entire 3 days in the exploration and use of modelling and simulation methods within Microsoft Excel, to develop complete solutions to the 8 totally realistic business problems that are presented
  • To enable delegates to make the shift from intuition-based to information-based decision making in complex situations, hence enabling them to enhance their forecasting and future behavior predictions, increase their proficiency in risk assessment and risk-informed decision making, and to exploit to a much greater extent the wealth of information contained in Big Data
  • To provide a clear understanding of why the best companies in the world see modelling, simulation and predictive analytics as being essential to delivering the right quality products and optimized services at the lowest possible costs

Who is this Training Course for?

This GLOMACS Advanced Data Analysis Techniques training course has been designed for professionals whose jobs involve the manipulation, representation, interpretation and/or analysis of data. This training course involves extensive modelling and analysis using Excel 2010 (or higher) and therefore delegates must not only be numerate, but must enjoy detailed working with numerical data to solve complex problems.

Full familiarity with Microsoft Excel (version 2007 or higher), and the ability to analyze data using common statistical methods, are fundamental prerequisites for attendance on this  Advanced Data Analysis Techniques training course.

How will this Training Course be Presented?

This training course on Advanced Data Analysis Techniques adopts a problem‐based learning approach, in which delegates are presented with a series of real problems drawn from the widest possible range of applications – they range from insurance to supply chain logistics, from chemistry to engineering, and from production optimization to financial risk assessment. Each problem presents and exemplifies the need for a different modelling or analytical approach.

This training course is entirely applications‐oriented, minimizing the time spent on the theory and mathematics of analysis and maximizing the time spent on the use of practical methods from within Excel, along with the understanding of how and why such methods work.

Delegates will spend almost all of their time exploring the use of modelling and simulation methods using Microsoft Excel, to develop solutions to the totally realistic problems that are presented.

Course Outline

Day 1
  • Introduction to Optimisation; Multi‐variate Optimisation Problems; Determining the Objective Function; Constraints to Problems; Sign Restrictions; The ‘feasibility region’; Graphical Representation; Implementation using Solver in Excel
  • Using Linear Programming to Solve Production and Supply Chain / Logistics Problems, such as optimising the products from a refinery, and minimising the manufacturing and delivery costs for a complex supply chain (with and without batch manufacturing, and with and without warehousing)
Day 2
  • Linear and Non‐linear Optimisation Problems; Stochastic Search Strategies; Introduction to Genetic Algorithms; Biological Origins; Shortcomings of Newton‐type optimisers; How to Apply Genetic Algorithms; Encoding; Selection; Recombination; Mutation; How to Parallelise; Implementation using Solver in Excel
  • How to Solve a range of Optimisation Problems, Culminating in the classic ‘travelling salesman problem’ by optimising the motion trajectory of a large manufacturing robot, both with and without forced constraints
Day 3
  • Introduction to Scenario Analysis; A What‐If example in Excel; Types of What‐If analysis; Performing manual what‐if analysis in Excel; One Variable Data Tables; Two‐variable data tables
  • Using Scenario Manager in Excel; Using scenario analysis to predict business expenses and revenues for an uncertain future
Day 4
  • Understanding Risk; Introduction to Markov Models; 5 Steps for Developing Markov Models; Manipulating Arrays and Matrices inside Excel; Constructing the Markov Model; Analysing the Model; Roll Back and Sensitivity Analysis; First‐order Monte Carlo; Second‐order Monte Carlo
  • Decision Trees and Markov Models; Simplifying Tree Structures; Explicitly Accounting for Timing of Events
  • Using Markov Chains to simulate an insurance no claims discount scheme, and Modelling the Outcomes of a Healthcare System
Day 5
  • Introduction to Monte Carlo Simulation; Monte Carlo building blocks in Excel; Using the RAND() function; Learning to model the problem; Building worksheet‐based simulations; Simple problems; How many iterations are enough?; Defining complex problems; Modelling the variables; Analysing the data; Freezing the model; Manual recalculation; "Paste Values" function; Basic statistical functions; PERCENTILE() function
  • Monte Carlo Simulation solutions to problems of traffic flow in a city, dealing with uncertainty in the sale of product, predicting market growth and assessing risk in currency exchange rates

Accreditation

KHDA

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.

Would you like to take this course as a team?
Contact Us

Frequently Asked Questions

AI Academy offers a wide range of specialized training courses focused on Artificial Intelligence and emerging technologies. Our courses cover areas such as Machine Learning, Data Science, AI in Business Strategy, Digital Transformation, and Automation, designed to help professionals enhance their technical and strategic capabilities.

Our courses are open to professionals at all career levels — from beginners seeking to understand AI fundamentals to senior executives aiming to integrate AI into organizational strategy. Each course clearly outlines the ideal participant profile to help you choose the best fit for your goals.

You can easily register through our website by selecting your preferred course and completing the online registration form. Once your registration is confirmed, you’ll receive a confirmation email with course details, venue or online access information, and next steps.

Yes. AI Academy offers both online and classroom-based courses to provide flexibility and convenience. The mode of delivery depends on the specific course and its learning objectives, ensuring participants receive an engaging and effective learning experience.

Yes. Upon successful completion of any AI Academy training course, participants receive an official Certificate of Completion, recognizing their professional development and newly acquired AI competencies.

Each course description on our website includes detailed information about the learning outcomes, target audience, and objectives. You can also contact our support team for personalized guidance on selecting a course that aligns with your experience level and career ambitions.

Can’t find what you are looking for?

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam

Contact Us

Get Started Today.

Contact Us