Cathy Sibley

This course explores the value of data and data analysis techniques available to an organisation to provide verifiable evidence in order to support strategic and operational decision-making. The techniques learned can play an important role in the successful implementation of strategic initiatives and directing operational decision-making.

WHO SHOULD ATTEND

This course is designed for those finance professionals who are actively involved in reporting and analytical roles that need to access and process data to provide useful information.

COURSE PROFILE

Information and data sources. Distinguishing between data and information - Internal and external sources - Cost-benefit analysis

Management information systems. Design - Formal and informal systems

Data and information types

Data and information analysis. Modelling principles - Model design and construction - Modelling use

Use of spreadsheets. General rules - Creating worksheets - Importing and exporting data - Data extraction  - Pivot tables and scenarios - Sorting and filtering data - Linking with other applications - Basic macros

Managing databases. General rules - Design and construction - Importing and exporting data - Sorting and filtering data

Information reporting. Use of graphics - Use of charts - The end user

Statistically modelling. Forecasting techniques - Regression analysis - Correlation strength between data - Time series analysis

Data mining. Functions and techniques

SKILLS ATTAINED

At the end of the course delegates will be able to:

Manage data as a valuable resource
Understand and implement data mining techniques
Conduct financial analysis
Design financial models
Create financial forecasts
Prepare financial reports

RELATED COURSES

• Budgeting and Forecasting for Modern Organisations F15
• Essential Management Accounting F69