Supply Chain Analytics

About This Class

This 3 day course will equip finance/supply chain managers and analysts in a variety of industries with the skills to make data-driven decisions. Delegates will gain the ability to extract and interpret key business insights for competitive advantage. Furthermore, it will help individuals understand and forecast how customers purchase products and services and how they respond to supply chain management initiatives.

This course is designed specifically for individuals working in supply chain/finance, aspiring to work in supply chain analytics, or those in leadership positions looking to boost the efficiency and effectiveness of their supply chain departments. It will also benefit middle and senior managers seeking to upgrade their knowledge and move their careers in a new direction.

The course will enable delegates make data-driven decisions. All principles and concepts are demonstrated with practical examples in Excel, which will form a portfolio of examples to which delegates can refer back to.

Local Fee

R 12,999

International Fee

$ 900

Book my seat

Download Brochure

Day 1

01 Practical Dashboard Applications

02 Visualisation of Data into a selection of Charts

03 Combo Charts; Progress Charts; Sunburst Chart

04 Gauge Chart (including Spin Buttons)

05 Advanced Conditional Formatting

Day 2

01 Power Query and Power Pivot

02 Table Tools and Pivot Tables

03 Timelines and Slicers

04 Advanced Filters

05 Solver, Goal Seek

06 Data validation and protection

Day 3

01 Statistical analysis and sample tools

02 Logical functions (including nested IF statements)

03 Maths functions (including SUMIF and SUBTOTAL)

04 Date and time functions

05 Useful tools and shortcuts

Who should attend

This 3-day training course is specifically designed for:

The trainer for this course is a Chartered Accountant (SA), Associate Chartered Management Accountant, Chartered Global Management Accountant, with strong academic and industry experience. She holds a Master’s degree in Management Accounting and has more than nine years of lecturing experience at the University of Pretoria and North-West University respectively, for which she has received distinctive teaching awards.

As a lecturer, she specialised in Management Accounting, Costing, Financial Management and Business Strategy to students of various levels. This is besides providing business simulations, supervising research projects and external moderation and reviewing of other universities’ exam papers and study guides.

She has been delivering training to both government institutions and private sector companies in similar subject areas, including Microsoft Excel, financial and business skills training, as well as consultation in fields related to financial modelling in Excel, optimising power tools in Excel and Power BI.