Quickly create financial forecasts using big data, predictive analytics, and Microsoft Excel.
Overview
Syllabus
Introduction
- Welcome
- What you should know
- Exercise files
- What is big data?
- Business intelligence and company financials
- Basics of financial regression analysis
- Predict values with regression analysis
- Conventional financial forecasting
- Decide on a finance question
- Gather financial data
- Clean financial data
- Financial forecasting applications
- Applied forecasting with data
- Regressions for forecasting
- Use Excel for regressions
- What do the results mean?
- Confidence intervals around the result
- Perform stress testing
- Wrap up
Taught by
Michael McDonald