Enrolment options

Course duration: 1,74h

Big data has transformed the world of business. Yet many people don't understand what big data and business intelligence are, or how to apply the techniques to their day-to-day jobs. This course addresses that knowledge gap, giving businesspeople practical methods to create quick and relevant business forecasts using big data. 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. Learn how to gather, compute, and use basic financial ratios, and then how to apply those ratios for forecasting purposes looking at key outcomes for the firm. 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.

Topics include:
  • Identify strategies for using data to enhance business performance.
  • Describe the steps in tying data to financial statements.
  • Explain the reason for using ratios.
  • Differentiate between various sources of data.
  • Define the reason for using regression to make forecasts.
  • Review the output of regression analysis in forecasting.

 

Guests cannot access this course. Please log in.