This course shows business analysts how to use Excel to measure the health of an organization. Learn how to use Excel to gather, assess, and use business analytics information.
Overview
Syllabus
Introduction
- Benefit from business analytics
- What is business analytics?
- Business analytics and company financials
- Basics of business analysis
- Finding data for business analytics
- Using business analytics for sales prospecting
- Testing marketing content with business analytics
- Data access and availability
- Integrating data sets
- Data and business analytics
- Finding a data model
- Mapping your data
- Business analytics and performance
- Using data in hiring plans
- Understanding HR issues with data
- Troubleshooting at the organization
- Forecasting with business analytics data
- Examining financial data
- Waterfall charts in Excel
- Competitor analysis and benchmarking
- Growing revenue with business analytics
- Business strategy and business analytics
- Product pricing with business analytics
- Price, volume, and sensitivity analysis
- Controlling costs in business
- Putting tools into action
Taught by
Michael McDonald