The analysis and insight we produce is of little use if it does not drive action. This box set looks at how we can present our data to gain the buy-in and support of our stakeholders so we can drive change and improvement. This series includes 5 online learning modules to apply the learning in your own role to become an accredited professional.

You can watch each module on its own without applying for accreditation. You will then be charged for each individual module.

As analysts we can spend a lot of our time on repetitive tasks. Copying and pasting data from one file to another, cleaning and combining our data to produce regular reports. This is not only tedious and time consuming but it also can lead to errors.

Automating this work can free up our time to do more rewarding work and deliver extra value.

In this box set we show you the excel formula you need to create effective dashboards. These seven short modules start with the key basic techniques and from these, show how you can soon create complex formula.

 - Basic Mathematical Formulae
 - Structuring Formulae
 - Averages & Ranges
 - Decision Formulae
 - Reference Formulae
 - Dashboard Formulae
 - Pivot Tables

On completion of the box set you can become accredited at a foundation level in our Professional Accreditation Programme by sharing an example of how you have applied these techniques in your own work.

Learn how to apply the whole planning cycle, from capacity to scheduling & real-time, with the chance to explore further your role and where it fits in.

After this session, you will understand;

 - The key drivers of performance and how to explain them
 - How to set up effective data, reporting & comms plans
 - Crucial elements of a good plan and their impacts, including shrinkage, models & forecasting

Back Office & Processing operations are becoming a bigger focus within our industry.  These videos offer practical knowledge and examples for specialist teams, as well as key tips and guidelines for analysts, planners or managers looking to understand more, or curate knowledge in their own area of specialism.  

Introduction: Learn how to determine the optimal approach and build an operational playbook, in order to improve your Real-Time function and tactical planning framework.

After this course, you will understand;

 - The role of Real-Time and how to add most value as analysts
 - The predictability/impact of events. How to set effective triggers and actions
 - How to analyse your flexibility demands and manage shrinkage

Introduction: This course gives you knowledge to support you in your role and overcome the obstacles you face, to help you create a culture of data-driven decision making.

After this course, you will understand;

 - The key numbers in a capacity plan & how to explain them
 - How plans & forecasts flows from strategy & budgets through the entire planning cycle
 - Managing data to ensure a single version of the truth