Excel for Business Analysts

Introduction

• Benefit from business analytics

1. The Basics

• 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

2. Getting Started 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

3. Predictive Tools in Business Analytics

• 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

4. Reading Business Analytics Output

• 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

5. Business Analytics and AI

• Understanding AI tools and BA
• Using data with generative AI
• Limitations on AI and data

Conclusion

• Putting tools into action