Excel for Business Analysts
1h 59mIntermediate2021-01-04
Authors
Michael McDonald
Researcher and Professor of Finance at Fairfield University
Course details
Business analytics is one of today’s fastest growing careers, but it's also an area where companies face a shortage of talent. In this course, Professor Michael McDonald walks you through everything you need to know to start implementing business analytics skills and concepts. Michael begins with the basics, explaining what you should know about business analytics, including definitions and uses. He demonstrates how to get started in business analytics, including accessing and integrating the correct data and constructing a data map. Michael shows how to use predictive tools in business analytics that can equip firms to make better decisions. Finally, Michael covers how business analytics can provide significant guidance for management in developing a strategy and understanding the market.
Skills covered
Business AnalysisSpreadsheetsMicrosoft ExcelPersonaProject ManagementBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Benefit from business analytics
1. The Basics
- 02 - What is business analytics
- 03 - Business analytics and company financials
- 04 - Basics of business analysis
- 05 - Finding data for business analytics
- 06 - Using business analytics for sales prospecting
- 07 - Testing marketing content with business analytics
2. Getting Started with Business Analytics
- 08 - Data access and availability
- 09 - Integrating data sets
- 10 - Data and business analytics
- 11 - Finding a data model
- 12 - Mapping your data
3. Predictive Tools in Business Analytics
- 13 - Business analytics and performance
- 14 - Using data in hiring plans
- 15 - Understanding HR issues with data
- 16 - Troubleshooting at the organization
- 17 - Forecasting with business analytics data
4. Reading Business Analytics Output
- 18 - Examining financial data
- 19 - Waterfall charts in Excel
- 20 - Competitor analysis and benchmarking
- 21 - Growing revenue with business analytics
- 22 - Business strategy and business analytics
- 23 - Product pricing with business analytics
- 24 - Price, volume, and sensitivity analysis
- 25 - Controlling costs in business
Conclusion
- 26 - Putting tools into action