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
 

 

The course materials include over 50 files including videos, pdf documents and exercise files (see screen recording: https://cl.ly/6c2f017e0ab2)