Author
Michael McDonald
Released
7/5/2017Join Professor Michael McDonald and discover how to use predictive analytics to forecast key performance indicators of interest, such as quarterly sales, projected cash flow, or even optimized product pricing. All you need is Microsoft Excel. Michael uses the built-in formulas, functions, and calculations to perform regression analysis, calculate confidence intervals, and stress test your results. You'll walk away from the course able to immediately begin creating forecasts for your own business needs.
- Understanding big data and predictive analytics
- Gathering financial data
- Cleaning up your data
- Calculating key financial metrics
- Using regression analysis for business-specific forecasts
- Performing scenario analysis
- Calculating confidence intervals
- Stress testing
Skill Level Intermediate
Duration
Views
- [Michael] Hi, I'm Dr. Michael McDonald. I'm a professor of finance and a data science researcher. I've taught big data and financial forecasting to numerous executives at many Fortune 500 companies and government agencies. In this course, I'm going to show you how to use data to effectively forecast key performance indicators in business. Business analytics is one of the fastest growing fields in business, and it is a key area in which firms are looking for talent.
Making forecasts with data is a critical part of the business analytics discipline. In this course, you will explore how to use data to make forecasts based on a statistical technique called regression. We'll explore the steps involved in going from a straight forward business question to a complete forecast for the future. This includes gathering data, cleaning data sets, and performing complex data analysis.
Let's get started.
-
Introduction
-
Welcome1m 11s
-
What you should know1m 40s
-
Exercise files38s
-
-
1. The Basics
-
What is big data?4m 5s
-
-
2. Forecasting in Finance
-
Gather financial data6m 48s
-
Clean financial data7m 33s
-
3. Performing Forecasting
-
Regressions for forecasting2m 30s
-
Use Excel for regressions4m 26s
-
4. Interpreting Forecast Results
-
What do the results mean?5m 46s
-
Perform stress testing4m 9s
-
-
Conclusion
-
Wrap up1m 16s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome