Course Introduction
Problem-Solving and Decision-Making (PSDM) Overview
Step 1 - Define & Understand the Problem
The Five Why's - Understand the Problem
Fishbone Diagram - Understand the Problem
Pareto Charts - Understand the Problem
Step 2 - Gather the Data
Step 3 - Analyze the Data
Step 4 - Recommendations
Step 5 - Align and Sell-in the Recommendation
Step 6 - Execute
4 Types of Data Analysis
Data Analysis Exercise - Monthly Churn Report
Descriptive Analysis
Diagnostic Analysis
Predictive Analysis
Prescriptive Analysis
Common Analytical Techniques
Common Analytical Techniques Excel File Walkthrough
Financial Ratio Analysis Overview
ABC Corporation P&L Financial Ratio Practice Exercise
Horizontal Analysis Overview
Horizontal Analysis Practice Exercise
Vertical Analysis Overview
Vertical Analysis Practice Exercise
Price Variance Mix (PVM) Overview
Price Variance Mix Formulas and Practice Exercise
Breakeven Analysis Overview
Breakeven Analysis Practice Exercise
Investment Evaluation Methods Overview
Investment Evaluation Methods Overview - Part 1
Investment Evaluation Methods Overview - Part 2
Investment Evaluation Methods Practice Exercise
Sensitivity Analysis Overview
Build a Sensitivity Table Walkthrough
Scenario Analysis Overview
Scenario Planning - Financial Model Example
Statistical Analysis Overview
Statistical Analysis Practice Exercise
Statistical Analysis Excel File Walkthrough
Industry Specific Metrics Overview
Artificial Intelligence Overview
Using Chat GPT to aid your analysis
Summarize Your Findings
The Power of Visuals
ACE your Presentation
Conclusion and Key Takeaways
