Instructor for this course
more

This course prepares participants to make more accurate financial forecasts with standard format generally accepted accounting principles (GAAP) financial statements by using business intelligence (BI). Particular focus is on the difference between conventional financial forecasts based on simple growth assumptions and financial forecasts using growth rates derived from data. The course is intended as an applied primer in forecasting using new techniques resulting from the growth in Big Data and BI techniques.

***Please download and open all supporting materials before starting the course videos.***

Learning Objectives

  • Discover how to create a basic set of income statement, cash flow, and balance sheet forecasts
  • Recognize the linkages between different items across the financial statements
  • Identify how changes in growth assumptions impact financial forecasts
  • Explore the use of regression analysis to determine forecast growth rates using outside variables (e.g., GDP and inflation) 
Last updated/reviewed: January 25, 2018

Included In Certifications

This course is included in the following Expert Certifications:

15 CoursesCertified Data Analyst Professional

  1. The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
  2. How is Industry Using Big Data? – A Case Study Reading
  3. Business Intelligence - Data Collection and Cleaning
  4. Business Intelligence - Structuring Data for Analysis
  5. Business Intelligence - Fundamentals of Data Analysis
  6. Business Intelligence - Using Big Data Analytics
  7. Doing Data Analytics In Excel (Hands-on module)
  8. Regressions in Excel (Hands-on module)
  9. Financial Forecasting
  10. Advanced Analytics – Omitted Variables
  11. Advanced Analytics – Fixed Effects
  12. Case Study in Data Analytics
  13. Using Regressions for Forecasting
  14. Financial Forecasting in Excel (Hands-on module)
  15. Blockchain for Business

6 Reviews (36 ratings)Reviews

Member's Profile
This course has a lot of complex data and calculations for preparing and measuring a forecast. This is a textbook lesson but not real helpful in developing a forecast.
3
Member's Profile
Good overview of models and high level theories, but would have liked to see some of the examples actually done in Excel or another tool.
3
Member's Profile
Solution for problems - if you can show via formulas with data input or in excel that would be very helpful
4
Member's Profile
Very good video, one of the better topics for discussion that's more interesting
4
Member's Profile
revisit of regression analysis helpful and correlation aspects of analysis
5
Anonymous Author
Very informative

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  2:49Introduction to Financial Forecasting
  11:48Module 1: Overview of Forecasting
  12:13Module 2: Quantitative Forecasting
  7:40Module 3: Dealing with Trends in Demand
  9:41Module 4: Evaluating Forecasts
CONTINUOUS PLAY
  44:11Financial Forecasting
SUPPORTING MATERIALS
  PDFSlides: Financial Statement Forecasting Using Business Intelligence
  PDFFinancial Statement Forecasting Using Business Intelligence Glossary/Index
REVIEW AND TEST
  quizReview Questions
 examFinal Exam