Overview
-
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.
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
