In this video, the instructor helps you find questions to be answered with data.
- [Instructor] Business intelligence is useful…for making a wide variety of forecasts,…and helping businesses to be more efficient…in running their operations.…But not all questions can be answered by data realistically.…Some questions are inherently subjective…and don't require data to come up with an answer.…Democrat or republican?…Red Sox or Yankees?…What color is best?…Where should we live?…These are questions that are inherently based on…subjective opinions and there's no data that we can gather…that could help us to make a decision.…
But even when we have questions…that could be answered objectively in theory,…sometimes we don't have data available…or we don't have the right kind of data.…We refer to this as omitted variables bias.…In particular, if we think about questions…on forecasting sales for example,…if we're in a totally new environment…and we've never seen any environment like this before,…it's very difficult to gather data.…If our company has expanded internationally…for the first time selling a completely new product,…
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.