Join Michael McDonald for an in-depth discussion in this video Wrap up, part of Financial Forecasting with Big Data.
- [Michael] In this course, we've talked…about what business intelligence is,…and the role that it plays in business analytics.…We've explained how to use regression analysis…to make forecasts of key performance indicators…based on hard data.…We've outlined the steps involved…in a business forecasting project,…from choosing a question to gathering data,…to running a regression, to stress-testing our results.…And, we've performed several examples…of real-world business forecasting based…on actual data from companies just like yours.…
Remember, business analytics is complex…and making forecasts is one…of the most challenging parts of the discipline.…So what can you do from here?…Well, I urge you to keep developing your skills.…Think about how you can apply regression analysis…to key questions you see in your day-to-day role.…Look for opportunities to put data…to use in new ways.…Keep an eye out for ways to answer questions…with data that others might not have thought of.…
And of course, look for future courses…in this subject right here in the library.…
Join 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.
- List the two methods of making decisions.
- Identify the most common method of conventional financial forecasting.
- Describe common challenges that come when trying to merge data.
- Assess the types of questions that business intelligence is best suited to answer.
- Distinguish the statistic that is most useful for estimating the impact of an X variable on a Y variable.