Business Analysis

Overview

The course will take you through a proven, structured process to improve your ability to collect, analyse and Forecast information to generate valuable insights and make well-supported business decisions.Employing exercises and solutions easily adaptable for your own workplace, this course employs a combination Of written materials, screenshots, videos and over 60 professional spreadsheet models (especially developed for Excel 2007/2010/2013).

Learning Outcomes

  • Understand what drives change and predict future performance.
  • Communicate information to colleagues, clients and stakeholders effectively.
  • Understand your audience and present data using Excel.

Audience

  • Financial and business analysts, managers, planners, customer-service staff, operations staff and information-management personnel.
  • Professionals, team leaders and junior to intermediate Business Analysts would also benefit.

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 : Introduces four essential Excel techniques that differentiate good spreadsheets from average ones: using range names, conditional formatting, data validation and matching and ranking data.
  • 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 Chartin
  • 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

Duration

12 Hours