Business Analysis Online Training
- Sample Module -
What is Business Analysis? (pdf document)
The course materials include over 50 files including videos, pdf documents and exercise files (see screen recording: https://cl.ly/6c2f017e0ab2 )
COURSE DESCRIPTION AND CURRICULUM
Transform numbers and data into business success.
Success depends on the ability to make the best business decisions. To do that, you must make the most of the numbers available to you.
This course will greatly enhance your ability to collect, analyse and forecast business and financial data to generate valuable insights from business data.
By the end of this course you’ll be able to:
- Make better business decisions for greater profits
- Understand the data that drives your business
- Impress stakeholders, clients and managers with your insight and presentation skills
- Maximise the value you get from your current tools and desktop systems
- Save time and money spent on data handling thanks to your elevated efficiency
In this course you will learn:
- How to turn buckets of data into sound business decisions
- Financial modelling theory
- Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
- How to effectively and clearly present your findings to relevant stakeholders
- Different forecasting techniques, including Moving Averages and Regression
Syllabus:
Section 1: Introduction
▸Unit 1.1 – Turning Numbers into Better Business Decisions
Section 2: The Business Analyst’s Excel Toolbox
▸Unit 2.1 – Essential Excel for Business Analysis
▸Unit 2.2 – Professional Tools for Business Analysts
Section 3: Collecting and Managing Business Data
▸Unit 3.1 – Importing and Exporting Data
▸Unit 3.2 – Power Functions for Managing Business Data
Section 4: Communicating Your Message
▸Unit 4.1 – Your Stakeholders and Their Needs
▸Unit 4.2 – Data Presentation Formats That Work
Section 5: Winning Charts for Business Communication
▸Unit 5.1 – Professional Charting
▸Unit 5.2 – Dynamic Charts
▸Unit 5.3 – Some Special Charts for Business Analysis
Section 6: Looking Inside Your Data (Analysis)
▸Unit 6.1 – Analysing Data with Pivot Tables
▸Unit 6.2 – Managing Pivot Tables Output
Section 7: Comparing Business Scenarios
▸Unit 7.1 – Decision Making with Compared Scenarios
▸Unit 7.2 – The Scenario Manager
Section 8: Looking Outside Your Data (Forecasting)
▸Unit 8.1 – Time Series and Forecasting
▸Unit 8.2 – Working with Moving Averages
▸Unit 8.3 – Introduction to Regression
Section 9: Ending
▸Unit 9.1 – Ending