Training on Business Intelligence & Analytics for Finance Professionals

Module 1: Understanding Business Models and Business Processes

• Creating Value for Key Organisational Stakeholders
• The Role of the 21st Century Finance Professional
• Business Models and Business Processes
• Business Process Improvement and Re-engineering
• Introduction to Business Intelligence and Business Analytics
• Introduction to Data Driven Decision Management (DDDM)
• Key Financial Measures and Shareholder Value Drivers
• Key Success Factors and Key Performance Measures

Module 2: Purpose and Principles of Business Intelligence and Business Analytics

• Implementing a Business Performance Management Framework
• The Definition and Purpose of Business Intelligence (BI)
• History and Development
• Features Tools and Terminology of BI Systems
• The Definition and Aims of Business Analytics (BA)
• Understanding Descriptive and Predictive Analytics
• Sources and Types of BI and BA Tools

Module 3: Principles of Statistical and Predictive Analytics

• Defining Statistical, Descriptive and Predictive Analytics
• Business Database Features and Design
• Principles of Distribution and Probability Theory
• Time Series Data Analysis
• Trend Analysis and Forecasting using Moving Averages
• Trend Analysis and Forecasting using Linear Regression
• Analysis and Forecasting with Monte Carlo Simulation in Excel
• Predictive Analytics using ‘what-if’ Forecasts

Module 4: Data Visualisation and Infographics for Finance Professionals

• Defining Data, Information and Insight
• Comparing Data Visualisation and Infographics
• Using Charts and Graphics for Data Visualisation
• Designing Visuals and Infographics for Non-financial Users
• Using Excel and Powerpoint for Data Visualisation
• Designing and Using Scorecards and Dashboards
• Practical Tips for Building Dashboards and Mashboards in Excel

Module 5: BI / BA – Implementing Systems and Managing Change

• An Agile Approach to Systems Development
• Practical Steps in Agile BI / BA Systems Design and Implementation
• The Importance of Urgency
• Effective Steps to Achieving Change
• Overcoming Resistance to Change