Microsoft Excel: VBA Automation

This practical course will help you to improve project performance, ensure outcomes are met and enable resources to be used efficiently, using Soft Systems Methodology (SSM), the best-known problem structuring method.

In this course you will learn how to utilise version control. This tool makes it possible to look back over all your previous configurations so removing the need to store a number of csv files. You will learn how to integrate version control into your project using RStudio.

This course will teach you how to update your reports at the click of a button using integrated R Markdown so your data reporting will efficient and reproducible.

Develop your understanding of Operational Research (OR), its processes and how they are used to address real world problems. Address the modelling issues you may encounter throughout your career. 

Develop your understanding of Operational Research (OR), its processes and how they are used to address real world problems. Address the modelling issues you may encounter throughout your career. 

An introductory course to equip you with a tool bag of core quantitative forecasting techniques that are adaptable to almost any organisational setting. Appreciate the qualitative methods of forecasting by making use of expert opinion, judgement and scenarios.

This course is for those conducting modelling and analysis using Microsoft Excel and are now looking to expand their knowledge. In this course you will learn tips and shortcuts to aid you in achieving efficient and effective analysis while improving your proficiency in Excel. 

This course will provide you with a systematic introduction to the nature and advanced functionality of Microsoft Excel. It will arm you with the skills needed for planning, formatting and formulas that will take your proficiency to an improved level. 

An introductory course to equip you with a tool bag of core quantitative forecasting techniques that are adaptable to almost any organisational setting. Appreciate the qualitative methods of forecasting by making use of expert opinion, judgement and scenarios.

Gain an understanding of the ideas and concepts of efficiency assessment of organisations and how Data Envelopment Analysis (DEA) models can be formulated and applied using Excel Solver.

This course offers a set of frameworks and methods based on behavioural science to support Operational Research (OR) Practice. The course can be useful for developing behavioural OR models, understanding behavioural issues with the implementation of OR models and the behavioural aspects of interventions.

Developed in response to the new age of data-centric activities and with data visualisation at its core method you’ll learn how to get your message across and leverage your data assets. OR practitioners, managers and policy makers will benefit from the data journalism approach leading to increased audience engagement.

Do you work in data analytics, BI/MI, data science, or machine learning? Do you want to make an immediate impact? This course is designed to equip delegates with a versatile skillset and deliver measurable results within your organisation.

Overview An introduction to Soft OR and the methods for working with strategic and complex problem situations and structuring qualitative data.

Develop your communication skills to present your data in a clear and impactful way allowing your organisation to reap the full benefits of your work.

Develop a practical understanding of System Dynamics qualitative and quantitative methods. 

Develop a practical understanding of System Dynamics qualitative and quantitative methods. 

Letting the Facts Speak for Themselves. The purpose of this course is to teach delegates how to present their facts in the most compelling manner. Familiarity with Key Principles, borrowed from the Worlds of Art and Modern Design, will allow delegates to present results in more compelling ways thus influencing their audience more effectively.

Data wrangling is the name given to the process of extracting useful information from large quantities of data. It generally involves: Discovering, Structuring, Cleaning, Enriching, Validating, and Publishing data to make it available for analysis. This necessarily involves processing large amounts of data and this course will teach you how to do that with the Python programming language. 

In this course you will learn how to build a culture of creativity across the team. One in which it is ‘safe’ to suggest ideas, where good ideas can be recognised. This will enable your team to creatively solve difficult problems.

A practical course applying sampling and regression analysis to ‘real world’ case study data and interpreting the results. Learn when and how to use these techniques to address ‘real world’ problems such as quality control.

A practical course applying sampling and regression analysis to ‘real world’ case study data and interpreting the results. Learn when and how to use these techniques to address ‘real world’ problems such as quality control.

Gain an understanding of the wide spectrum of skills used in Operational Research, including: problem structuring; data collection; analytics; modelling; and simulation. Learn and understand a typical problem cycle

A practical introduction to the most used methodologies in OR, linear programming and optimisation.

A practical course using multivariate statistical techniques to gain greater insights from your analysis.

A practical course using multivariate statistical techniques to gain greater insights from your analysis.

This Foundation Plus Python course will teach attendees how to deliver scripted data wrangling with provable results. Attendees will be able to demonstrate how repeatable data wrangling pipelines increase speed, efficiency and accuracy and learn more advanced scripting techniques to expand their skill portfolio.

This course builds on the skills learned in Foundation and Foundation Plus to help attendees use core data science to deliver rapid statistics and analysis. This Intermediate course will teach attendees how to deliver scripted data wrangling with provable results. Attendees will be able to demonstrate how repeatable data wrangling pipelines increase speed, efficiency and accuracy and learn more advanced scripting techniques to expand their skill portfolio.

This course will give you robust processes when you need to have innovative ideas ‘on demand’. You will have the chance to practice applying these tools and techniques that should be as much part of the OR practitioner’s tool kit as simulation and optimisation.

Explore the operational research methods and models available for supporting strategy. You will be able to develop your skills in a full session in scenario planning. This course better equips you to apply OR principles for strategic planning activities.

Using case studies and Public Sector Scorecard (PSS), you will create an integrated strategy map, service improvement plan and performance measurement framework of your OR projects.

Improve your personal productivity for generating rapid and insightful results from large data sets using R.

This course will provide OR practioners with the competency to navigate the various legal frameworks regarding data protection while becoming fluent in the language of data for effective communications.

This course is a natural follow on for delegates who have completed the Foundation course in forecasting and now wish to develop their toolbox further with Autoregressive Integrated Moving Average (ARIMA).

A practical introduction to simulation modelling, allowing you to understand the benefits of simulation and when to use it.

This two-day workshop will provide the state-of-the-art on the use of big data to improve service operations and will introduce several useful big data and machine learning techniques to help analysts, managers, and other stakeholders enhance operational performance.

A practical introduction to simulation modelling, allowing you to understand the benefits of simulation and when to use it.

Learn to use visualisations to summarise insights and communicate information effectively to stakeholders.

Learn six simple steps in the visualisation cycle and why some visuals are more pleasing to the eye than others and how this can be incorporated into your data results to transform your interactions with decision makers.

This course will provide OR practitioners with the competency to navigate the various legal frameworks regarding data protection while becoming fluent in the language of data for effective communications.

Learn how scripted data wrangling can deliver reproducible, provable results. This course will show you how repeatable data wrangling pipelines increase speed, efficiency and accuracy and how simple scripting techniques can expand an analyst’s skill portfolio.

This Foundation Plus Python course will teach attendees how to deliver scripted data wrangling with provable results. Attendees will be able to demonstrate how repeatable data wrangling pipelines increase speed, efficiency and accuracy and learn more advanced scripting techniques to expand their skill portfolio.

This course builds on the skills learned in Foundation and Foundation Plus to help attendees use core data science to deliver rapid statistics and analysis. This Intermediate course will teach attendees how to deliver scripted data wrangling with provable results.

Developed in response to the new age of data-centric activities and with data visualisation at its core method you’ll learn how to get your message across and leverage your data assets. OR practitioners, managers and policy makers will benefit from the data journalism. "

This one day course will provide some approaches to help approach transformation in different ways, while taking into account both the hard and soft elements of transformation. It will incorporate the creation and evaluation of learning journeys and the pathways to transformation.

This course will teach you the skills needed to make multi criteria decisions. It will tackle a number of situations by exploring the main components of Goal Programming (GP), a fundamental topic within multi objective optimisation and will include goals, aspiration levels, achievement functions, deviation variables and priority sequence.

TBA

Gain the theoretical and practical understanding on how to process and model time series data in your analytical and forecasting workflows using R programming language. This course will provide you with essential knowledge to allow wrangling, processing, analysis and forecasting of time series data in the R programming language.