• Home
  • Career Progression Pathway: Finance Data Analysis- eLearning

Career Progression Pathway: Finance Data Analysis- eLearning



This activity is published by accountingcpd.

All year round, and on every accountingcpd purchase you make, get 10% off  as a CA ANZ member. Just use code CAANZ101.

Please note you will be directed to accountingcpd to purchase this product.

This Career Progression Pathway corresponds to the key Finance Data Analysis skills you need to develop. Complete all sections to unlock the end of pathway assessment and access your Certificate of Achievement.
As finance professionals, we understand data and use it every day. How can we analyse data for the good of our business? Through this pathway you will discover what data analysis is and how to use tools and technologies to analyse data. Improve your knowledge of Excel, statistics, data visualisation and financial models, and learn how you can utilise new skills to predict and plan your organisation's future. This pathway will enable you to use data analysis to have a real impact on your business or clients, and to become an essential part of decision making.

The course includes:
Analysing Finance Data - introduces the concept of data analysis and looks at some of the basics involved in working with data.
1.    Foundations of data analysis
2.    Data protection
3.    Analysing data

Excel Skills - we cover some key Excel skills to have at your disposal and look at how to clean and prepare data so that it is fit for purpose.
4.    Recent improvements
5.    Essential Excel skills
6.    Data preparation

Statistics and Data Modelling - how to use statistics to simplify your data, and how to create models and relationships between multiple tables and sources of data to help you uncover deeper insights.
7.    Descriptive statistics
8.    Hypothesis testing
9.    Getting started with Power BI
10.    Modelling with Power Pivot
11.    Modelling with DAX

Data visualisation - a core part of finance data analysis is telling the story of the data – techniques you need to be able to present your findings in a straightforward and compelling way, so that they can be easily understood by others, whatever their level of technical expertise, include charts, graphs, reports, interactive dashboards, and more.
12.    Communicating via data
13.    Engaging dashboards
14.    Highlighting issues

Financial models - using financial models, which take existing data and extrapolate from that to predict potential outcomes and to support decision making.
15.    Building spreadsheet models
16.    Successful business simulations

Supporting the business - armed with insights from your data, your organisation can improve decisions and strategy, reduce costs, function more efficiently, protect itself from threats, and take advantage of the opportunities available.
17.    Data-based strategy
18.    Data-driven decisions
19.    Business performance management
20.    Technology disruptors

Learning Outcomes 
Upon satisfactory completion of this activity, you will be able to:
•    Understand the concept of data analysis.
•    Recognise the importance of data cleansing.
•    Identify key concepts of data modelling.
•    Use Excel to transform data so that it is fit for purpose.
•    Create dashboards.
•    Create financial models.
•    Add value to your organisation by sharing expertise.

Benefits 
Discover how data analysis can enable you to provide valuable insights to your business and clients. This pathway provides the tools, technologies, and methodologies you need to ensure you play a key part in decision making.
Self-paced eLearning 
Samuel Ellis
Samuel Ellis is a chartered accountant with experience working in private accounting firms and a number of high growth businesses. He has spent the past six years working as Head of Finance for InterWorks, a global specialist data consulting practice. Sam was the founding Chair of the ACCA's Global Technology Forum and currently Chair of ACCA's Member Advisory Committee and a member of the ACCA's International Assembly.
 
Online 
Once you have completed all the elements of the pathway, you can take the assessment to access your Certificate of Achievement.

EVENT DETAILS


Topic: Corporate Finance

Sub-Topic: Business Planning & Analysis, Financial Modelling

Format: eLearning

Proficiency Level: Foundation, Intermediate

CPD: Upto 21 hours