Business, Public Service and TourismScience, Technology, Engineering, and Mathematics

Using Data in Financial Analysis

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.

Learn More