Search training courses
Advanced Data Analysis Techniques

An Intensive 5-Day Training Course

Advanced Data Analysis Techniques

Modelling, Simulation, Optimisation and Predictive Analytics using Microsoft Excel

Scheduled Dates

22 - 26 Apr 2024 Dubai - UAE $5,950
24 - 28 Jun 2024 Dubai - UAE $5,950
19 - 23 Aug 2024 Dubai - UAE $5,950
02 - 06 Sep 2024 London - UK $5,950
18 - 22 Nov 2024 Lisbon - Portugal $5,950
25 - 29 Nov 2024 Dubai - UAE $5,950
16 - 20 Dec 2024 Amsterdam - The Netherlands $5,950
Enroll Now View Online Format In-House Options

Are the scheduled dates matching with your needs?

We provide a wider range of training options. Tailored and customized, we can deliver your organization’s training needs anytime, anywhere.

Why Choose this Training Course?

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 PetroKnowledge 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 Advanced Data Analysis Techniques 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 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?

Who is this Training Course for?

This PetroKnowledge training course has been designed for professionals whose jobs involve the manipulation, representation, interpretation and/or analysis of data. The 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 analyse data using common statistical methods, are fundamental prerequisites for attendance on this course. Only delegates who have attended the Data Analysis Techniques course will be eligible to attend this programme, because without mastery of the capabilities taught in the Data Analysis Techniques course a delegate will not be able to succeed on this training course.

How will this Training Course be Presented?

How will this Training Course be Presented?

This PetroKnowledge training course 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.

The 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.

Organisational Impact

Organisations which are able to make optimum decisions, and which can reliably predict future trends and behaviours, are able to enhance substantially their ability to compete on the global stage; as a result of sending their employees on this course, organisations can expect to benefit from:

  • A shift from intuition-based to information-based decision making
  • The provision of accurate solutions to complex problems
  • Enhanced forecasting and future behaviour prediction
  • Advanced modelling and simulation of business processes
  • More capable risk assessment and risk-informed decision making
  • Improved capitalisation on the wealth of information contained in Big Data

Personal Impact

Participants will each gain extensive understanding and lots of practical experience of a wide range of the more common modelling, simulation and predictive analytical techniques, all of which will have direct relevance to a wide range of business issues; specifically delegates will acquire:

  • New insights into the use of optimisation, modelling and prediction using Microsoft Excel
  • Experience of Linear Programming
  • An understanding of how and when to use Newtonian and Genetic Optimisation Methods
  • Knowledge of Scenario Analysis, Markov Modelling and Monte Carlo Simulation
  • The ability to recognize which types of analysis are relevant to particular types of issues
  • Sufficient situational knowledge to judge when a technique will lead to incorrect conclusions

Daily Agenda

Day One: Linear Programming

  • 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 Two: Newtonian and Genetic Optimisation Methods

  • 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 Three: Scenario Analysis

  • 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 Four: Markov Models

  • 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 Five: Monte Carlo Simulation

  • 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

Certificate

  • On successful completion of this training course, a PetroKnowledge Certificate will be awarded to the delegates

In Association With

GLOMACS Training

Our collaboration with GLOMACS aims to provide the best training services and benefits for our valued clients

Visit Website ›

Oxford Management Centre

Our collaboration with Oxford Management Centre aims to provide the best training services and benefits for our valued clients.

Visit Website ›

Koukash Consultancy

Our collaboration with Koukash Consultancy aims to provide the best training services and benefits for our valued clients.

Visit Website ›

Frequently Asked Questions

How can I register for a training course?

  • To register online through our website, please click “Enroll Now” on the course page, complete and submit the form. A confirmation e-mail and instructions will be sent to the participant’s e-mail.
  • You may also get in touch with our Registration Team on
    +971 50 981 7386 | +971 2 557 7389 or send an email to reg@petroknowledge.com

When and how do I arrange payments?

  • Payments can be made in USD or UAE local currency AED (Arab Emirates Dirhams) either by Bank Transfer or by Credit Card. Our Bank Account details will be provided on the invoice.
  • Course fees are payable upon booking unless a valid, authorized Purchase Order is provided and accepted.
  • Invoices will be sent via email/courier to the ID/name and address provided.
  • The course fee shall be settled prior to course start date. Corporate payments with existing payment policy shall be relayed to us in advance.

When should I expect to receive confirmation of registration?

Upon successful registration online, enrolment on the respective training course will be confirmed by Registration Team by e-mail along with the invoice and joining instruction.

Is there a discount for more than one registrant/course?

For corporate fees and group registration, please send your query to info@petroknowledge.com.

Download PDF

© 2024. Material published by PetroKnowledge shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.


Sending your message. Please wait...

Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form and check the recaptcha before sending.