: Mercury Training Center
: Istanbul-Turkey: +905395991206 - Amman-Jordan: +962785666966 - London (UK): +447481362802

Finance and Accounting Courses

Business Intelligence & Analytics for Finance Professionals


Introduction:

This course will highlight how, in a world where firms face intense competition for both customers and investors, the key challenge for today’s finance professional is to step-up and support the value creation process by moving from a narrow reporting role to embrace and exploit the full opportunities provided by today’s Business Intelligence (BI) and Business Analytics (BA) systems. It will focus on the tools and techniques used by world-class finance functions to provide the critical business insights C-Suite executives need for effective data-driven decision management

Targeted Groups:

  • Finance Professionals across the organization
  • Head Office Planning Managers
  • Budgeting and Forecasting Teams
  • Commercial Managers
  • Finance Strategic Business Partners

Course Objectives:

At the end of this course the participants will be able to:

  • Frame financial insights in the context of business process improvement
  • Exploit the tools of Business Intelligence and Analytics systems
  • Develop financial and non-financial key performance measures
  • Apply the tools and techniques of predictive analytics
  • Design powerful graphics for data visualization and infographics

Targeted Competencies:

  • The Vital Role of the 21st Century Finance Function
  • How Finance Professionals can fully exploit BI and BA tools
  • Using BI and BA to improve business processes and performance
  • Principles and Practice in Statistical Analysis and Forecasting
  • Practical Skills for Data Visualisation and Infographics
  • Applying Agile Methods to BI and BA Systems Development

Course Content:
Unit 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

Unit 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

Unit 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

Unit 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 Dashboards in Excel

Unit 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


Jordan (Amman)
7/11/2021 - 11/11/2021
Euro 2500
UAE (Dubai)
21/11/2021 - 25/11/2021
Euro 2500
Oman(Muscat)
21/11/2021 - 25/11/2021
Euro 2500
USA (Boston)
29/11/2021 - 3/12/2021
Euro 5000
Turkey (Istanbul)
5/12/2021 - 9/12/2021
Euro 3000
Egypt (Cairo)
12/12/2021 - 16/12/2021
Euro 2500
Manama (Bahrain)
12/12/2021 - 16/12/2021
Euro 2500
Spain (Barcelona)
13/12/2021 - 17/12/2021
Euro 4500
Germany (Munich)
13/12/2021 - 17/12/2021
Euro 4500
Canada (Toronto)
20/12/2021 - 24/12/2021
Euro 5000
Morocco (Casablanca)
3/1/2022 - 7/1/2022
Euro 2500
Switzerland (Geneva)
10/1/2022 - 14/1/2022
Euro 4500
Singapore (Singapore)
10/1/2022 - 14/1/2022
Euro 4500
Manama (Bahrain)
23/1/2022 - 27/1/2022
Euro 2500
Spain (Barcelona)
24/1/2022 - 28/1/2022
Euro 4500
Egypt (Cairo)
30/1/2022 - 3/2/2022
Euro 2500
Turkey (Istanbul)
30/1/2022 - 3/2/2022
Euro 3000
UK (London)
31/1/2022 - 4/2/2022
Euro 4500
UAE (Dubai)
13/2/2022 - 17/2/2022
Euro 2500
Online
13/2/2022 - 17/2/2022
Euro 1250
Spain (Marbella)
14/2/2022 - 18/2/2022
Euro 4500
Jordan (Amman)
27/2/2022 - 3/3/2022
Euro 2500
Malaysia (Kuala Lumpur)
27/2/2022 - 3/3/2022
Euro 3500
Egypt (Cairo)
17/4/2022 - 21/4/2022
Euro 2500
Oman(Muscat)
17/4/2022 - 21/4/2022
Euro 2500
Egypt (Sharm El-Sheikh)
24/4/2022 - 28/4/2022
Euro 2500
Turkey (Istanbul)
1/5/2022 - 5/5/2022
Euro 3000
Online
8/5/2022 - 12/5/2022
Euro 1250
UK (London)
9/5/2022 - 13/5/2022
Euro 4500
France (Paris)
9/5/2022 - 13/5/2022
Euro 4500
Malaysia (Kuala Lumpur)
15/5/2022 - 19/5/2022
Euro 3500
Netherlands (Amsterdam)
23/5/2022 - 27/5/2022
Euro 4500
UAE (Dubai)
19/6/2022 - 23/6/2022
Euro 2500
Italy (Rome)
4/7/2022 - 8/7/2022
Euro 4500
Spain (madrid)
4/7/2022 - 8/7/2022
Euro 4500
Italy (Rome)
11/7/2022 - 15/7/2022
Euro 4500
Online
17/7/2022 - 21/7/2022
Euro 1250
UAE (Dubai)
31/7/2022 - 4/8/2022
Euro 2500
Germany (Munich)
1/8/2022 - 5/8/2022
Euro 4500
Netherlands (Amsterdam)
8/8/2022 - 12/8/2022
Euro 4500
Turkey (Istanbul)
14/8/2022 - 18/8/2022
Euro 3000
Spain (Barcelona)
15/8/2022 - 19/8/2022
Euro 4500
Greece (Athens)
15/8/2022 - 19/8/2022
Euro 4500
Manama (Bahrain)
4/9/2022 - 8/9/2022
Euro 2500
Kuwait (Kuwait)
4/9/2022 - 8/9/2022
Euro 2500
UK (London)
5/9/2022 - 9/9/2022
Euro 4500
Spain (madrid)
12/9/2022 - 16/9/2022
Euro 4500
Ukraine (Kyiv)
12/9/2022 - 16/9/2022
Euro 3500
Egypt (Cairo)
25/9/2022 - 29/9/2022
Euro 2500
Jordan (Amman)
25/9/2022 - 29/9/2022
Euro 2500
France (Paris)
26/9/2022 - 30/9/2022
Euro 4500
Canada (Toronto)
26/9/2022 - 30/9/2022
Euro 5000