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
- Dealing with data Issues
- Tools for business analysis
- Business analytics and performance
- Using data in hiring plans
- Understanding HR issues with data
- Troubleshooting at the organization
- Forecasting with business analytics data
- Making corporate investment decisions
- 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
- Understanding AI tools and BA
- Using data with generative AI
- Limitations on AI and data
- Putting tools into action
Taught by
Michael McDonald