Career Progression Pathway: Finance Data Analysis- eLearning
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.
The course includes:
Analysing Finance Data - introduces the concept of data analysis and looks at some of the basics involved in working with data.
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.
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.
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.
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.
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.
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.
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.
EVENT DETAILS
Topic: Corporate Finance
Sub-Topic: Business Planning & Analysis, Financial Modelling
Format: eLearning
Proficiency Level: Foundation, Intermediate
CPD: Upto 21 hours