Using Data in Financial Analysis

Focused View

Michael McDonald

1:44:08

27 View

01 - Introduction

01 - The power of data in financial analysis.mp4

00:48

02 - 1. The Basics

01 - Data and business.mp4

05:44

02 - Conventional financial analysis.mp4

07:40

03 - Basics of financial regression analysis.mp4

04:52

04 - Predict values with regression analysis.mp4

03:56

05 - Doing a forecast in Excel.mp4

03:53

03 - 2. Financial Analysis

01 - Financial analysis with data.mp4

04:16

02 - Tying data to financial statements.mp4

06:52

03 - Financial ratios with data.mp4

05:25

04 - Benchmarking the competition.mp4

07:02

05 - Trend analysis in ratios.mp4

05:56

04 - 3. Forecasting in Finance

01 - Decide on a finance question.mp4

01:42

02 - Gather financial data.mp4

05:22

03 - Clean financial data.mp4

05:59

04 - Regression analysis in finance.mp4

04:45

05 - Regressions for forecasting.mp4

05:54

05 - 4. Interpret Forecast Results

01 - What do the results mean.mp4

08:10

02 - Confidence intervals around the result.mp4

06:06

03 - Stress testing the results.mp4

08:42

06 - Conclusion

01 - Stress testing the results.mp4

01:04

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Financial Accounting

Michael McDonald

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.