Advanced Data Analysis Techniques

OBJECTIVES

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

Outline

Linear Programming

Newtonian and Genetic Optimisation Methods

Scenario Analysis

Markov Models

Monte Carlo Simulation