Financial Forecasting with Big Data
1h 22mIntermediate2017-07-19
Authors
Michael McDonald
Researcher and Professor of Finance at Fairfield University
Course details
Big data is transforming 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. 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.
Learning objectives
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.
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.
Learning objectives
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.
Skills covered
Corporate FinanceData EngineeringMicrosoft ExcelFinance and AccountingData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Welcome
- 02 - What you should know
- 03 - Exercise files
1. The Basics
- 04 - What is big data
- 05 - Business intelligence and company financials
- 06 - Basics of financial regression analysis
- 07 - Predict values with regression analysis
- 08 - Conventional financial forecasting
2. Forecasting in Finance
- 09 - Decide on a finance question
- 10 - Gather financial data
- 11 - Clean financial data
3. Performing Forecasting
- 12 - Financial forecasting applications
- 13 - Applied forecasting with data
- 14 - Regressions for forecasting
- 15 - Use Excel for regressions
4. Interpreting Forecast Results
- 16 - What do the results mean
- 17 - Confidence intervals around the result
- 18 - Perform stress testing
Conclusion
- 19 - Wrap up
Related courses
- Financial Forecasting with Analytics Essential Training
- Data, Economic Modeling, and Forecasting with Stata
- The AI-Driven Supply Chain Manager
- Excel: Learning Cash Flow Forecasting
- The AI-Driven Financial Analyst
- Leveraging Generative AI in Finance and Accounting
- Excel: Financial Modeling with Dynamic Arrays
- Automated Financial Reporting with AI
Related learn paths
- Advance Your Skills in Predictive Analytics
- Become a Corporate Financial Planning Analyst
- CFI Financial Analysis and Modeling Professional Certificate
- Advance Your Business Analytics Skills
- Become a Business Intelligence Specialist
- Become an Economist
- Get Ahead in Business Analytics and Analysis
- Strategic Execution and Business Impact for Senior Managers and Senior Leaders