Business Courses

Business Analysis Training (CGT)


Description



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


Business Analysis




Who is the course for? 

This online course is for business analysts and those who aspire to work in the role. It is ideal for those currently working as business analysts, internal and external consultants and advisors, managers, team leaders and members of improvement teams.

Why Study Business Analysis Foundation? 

The Business Analysis Foundation course is conducted online on a self paced schedule, comprising theory, and practical assignments. In addition to providing a firm foundation for business analysis this certificate can be used to provide a foundation in the subject for specialists in other disciplines, particularly Project Managers and System Developers.

Course covers the broad range of principles and techniques within the sphere of Business Analysis.

The certificate is relevant to a number of professions including business analysts, business managers and their staff, business change managers and project managers. 

When an information technology project fails, it is often due to poor communications during the requirements gathering process, not a lack of technical acumen.

66% of software projects aren't expected to finish on time or on budget
Completed projects typically operate at only 52% of the proposed functionality
56% of project defects originate in the requirements phase of the project
Improving communication with stakeholders, project teams and developers allows for:



Content
  • 1. Business Analysis Course_Introduction
  • 1. What is Business Analysis_
  • 2_Business_Analysis_Concept
  • 3_Successful_business_and_financial_models
  • 2. Practice Task
  • 4_Range_Names_for_Business_Models
  • 4a._Method in Action - Range_Names_for_Business_Models
  • 05_Focus_on_Results
  • 5a_Method in Action - Focus_on_Results
  • 06_Validation_of_Numbers_and_Lists
  • 6a. Exercise
  • 07_Matching_and_Ranking_Data
  • 7a. Exercise
  • 08_Maintaining Control of Your Worksheets
  • 09_Maintaining_Control _Continue_
  • 9a. Exercise
  • 9b. Exercise
  • 10_Testing_and_Simulating_Models
  • 10a. Exercise
  • 11. Error Free Worksheets
  • 11a. Exercise
  • 11b. Exercise
  • 12. Section 2 Plenary Video
  • 13. Importing Business Data
  • 13a. Exercise
  • 14. Extracting Business Data
  • 14a. Exercise
  • 15. Concept of Exporting Data
  • 16. Exporting Business Data
  • 16a. Exercise
  • 16b. Exercise
  • 17. Dynamic Ranges
  • 17a. Exercise
  • 17b. Exercise
  • 18_Extracting_Data_with_Logical_Functions
  • 18a. Exercise
  • 19. Concept of Using Frequency Distributions
  • 20. Using Frequency Distributions
  • 20a. Exercise
  • 21. Section_3_Plenary
  • 22. Concept of Matching Stakeholders_ Requirements
  • 22a. Exercise
  • 23. Exercise - EFFECTIVE TABLES_ CHARTS AND PRESENTATION MEDIA
  • 24. Exercise - PRESENTING KEY DATA RELATIONSHIPS
  • 25_Graphical_Text_and_Tables
  • 25a. Exercise
  • 25b. Exercise
  • 26. Section_4_Plenary
  • 27_Chart_Styles_and_Templates
  • 27a. Exercise
  • 28. Concept of Conditional Format Charts
  • 29. Conditional Format Charts
  • 29a. Exercise
  • 30. Concept. of Charting from Large Datasets
  • 31. Charting from Large Datasets
  • 31a. Exercise
  • 32. Techniques for Dynamic Charts
  • 32a. Exercise
  • 33. Charts That Pan and Zoom
  • 34a. Exercise
  • 34. Some Special Charts
  • 35__Section_5_Plenary
  • 36. Concept of Grouping and Cross Tabulating Data
  • 37. Grouping and Cross Tabulating Data
  • 38. Large Data Analysis with Pivot Tables
  • 37a. Exercise
  • 38a. Exercise
  • 39. Concept of Comparisons in Pivot Tables
  • 39a. Comparisons in Pivot Tables
  • 39b. Exercise
  • 40. Concept of Slicers and Filters
  • 40a. Slicers and Filters
  • 40b. Exercise
  • 41. Pivot Charts
  • 41a. Exercise
  • 42. Pivot Table Frequency Distributions
  • 42a. Exercise
  • 43. Keeping Pivot Tables Current
  • 44. Section 6 - Plenary Video
  • 45. Concept of Single Variable Data Tables
  • 45a. Concept of Single Variable Data Tables
  • 45b. Exercise
  • 46. Multiple Variable Data Tables
  • 46a. Exercise
  • 46b. Exercise
  • 47. Concept of Selecting Scenarios
  • 47a. Selecting Scenarios
  • 47b. Exercise
  • 48. Scenario Manager Outputs
  • 49. Section 7- Plenary Video
  • 50. Curve Fitting and Trendlines
  • 50a. Exercise
  • 51. Concept of Linear Forecasting
  • 51a. Linear Forecasting
  • 51b. Exercise
  • 52. Concept of Smoothing Data
  • 52a. Smoothing Data
  • 53. Seasonal Facts
  • 53a. Exercise
  • 54. Concept of Regression
  • 54a. Introduction to Regression
  • 54b. Exercise
  • 55. Section 8 Plenary video
  • 56. End of Course
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever