Data Analytics short courses

Accelerate discovery of the insights hidden within your data!

Data Analysis Masterclass

A half-day workshop to improve your ‘critical thinking’ skills by learning how to use business data to drive more effective actions. This intermediate level, hands-on workshop provides the disciplines, proven-practices & skills to analyse data and draw conclusions from it. Improving your skills in working with data will enhance the impact of your knowledge and experience when tackling issues such as identifying the drivers of customer satisfaction/ retention, understanding the sources of variation in demand/ supply chains, prioritising where to focus cost reduction efforts/ productivity gains, and more.

To be able to successfully participate in this Group tutorial based session, it is assumed participants:
• can bring along their own business data: Safety, Customer, Operations, Service, Commercial, Purchasing etc.
• are familiar with using Excel (working with formulas and functions, creating charts, sorting and filtering data).
• have access to a laptop with Microsoft Excel 2010 or later.

Target audience

This workshop is suitable for:
• Anyone working with business data who needs to go beyond just reporting where the issues are and start identifying what actions to take.
• Anyone involved in continuous improvement activities wanting to build on their existing skills and use data to target effective actions.
• Process Improvement practitioners who want to ‘freshen up’ their skills in data analysis with proven tools and techniques

Next session

10th December 2019

Venue: Westrac Training Institute, Tomago

Cost: $450 incl. GST pp
includes light refreshments

Workshop details

Objectives

By the end of this workshop you will have:
• Developed an understanding of the approach to conducting effective data analysis
• Gained knowledge on how to structure and prepare business data for analysis
• Used a range of techniques to summarise and present data to provide a targeted study of key themes and issues.
• Learned how to identify key insights and opportunities from data analysis using summary statistics and graphical techniques

Topics covered

• Planning data analysis – deciding the data structure, which data is required, along with how much and what type
• Preparing data – how to validate and address the data quality (Complete, Correct and Consistent)
• Data analysis routines – executing analysis using the Practical – Graphical – Analytical method
• Analysis Reporting – which type of graph type to use when, best practices in data visualisation

Take-aways

• A printed reference summary guide will be provided to each participant
• A Data Analysis Toolkit (Excel XLSX file) containing the essential data analysis tools and techniques
• A Certificate of Completion to recognise the knowledge and understanding gained through attending

Managing process variation

Statistical Process Control (SPC) provides sound information upon which to track process performance on a real-time basis and make decisions. This one day, intermediate level workshop develops skills in the practices and statistical methods of SPC to improve the consistency and performance of any work process, resulting in reduced costs and less waste.

This course incorporates many practical group activities to reinforce the learning experience, with data generated during the course and used to construct and interpret various charts. It is assumed participants:
• are familiar with using Excel (working with formulas and functions, creating charts, sorting and filtering data).
• have access to a laptop with Microsoft Excel 2010 or later.

Target audience

This workshop is suitable for:
• Anyone wishing to explore how SPC techniques can be used in their own environment.
• Anyone in roles focused on process, product or quality control management wanting to build on their existing understanding and skills.
• Process Improvement practitioners who want to ‘freshen up’ or further extend their skills in SPC

Next session

First Quarter 2020

Venue: Westrac Training Institute, Tomago

Cost: $650 incl. GST pp
includes light refreshments

Workshop details

Objectives

By the end of this workshop you will have:
• Developed an understanding of how to apply an SPC approach in order to better manage processes
• Practiced how to validate the data measurement and decide statistically valid data sampling approaches
• Practiced how to select, construct and interpret process control charts and process capability charts.
• Developed strategies to manage the ongoing process control and risks using Control plans and FMEA

Topics covered

• Statistical Process Control (SPC) design – Output features and process variables
• Measurement and Sampling practices – measurement validation and data sampling techniques
• SPC tools – assessing process stability using Control charts and process performance using Capability analysis
• Process management controls and risk reduction – Control Plans and Failure Modes and Effect Analysis (FMEA)

Take-aways

• A printed reference summary guide will be provided to each participant
• A SPC Toolkit (Excel XLSX file) providing the essential SPC tools and techniques
• A Certificate of Completion to recognise the knowledge and understanding gained through attending