Learn about business analytics and its importance in the industry. Perform business
analytics tasks using Microsoft Excel and create visual insights using charts and
dashboards. Become proficient in business analytics with foundational statistics
and techniques—an initial step in the data analytics program.
Learning Outcomes
- Understand the significance of business analytics in the industry
- Master Excel analytics functions and conditional formatting
- Analyze complex data sets using pivot tables and slicers
- Visualize insights using charts and dashboards
- Apply statistical tools in Excel, including moving averages,hypothesis testing, ANOVA, and regression.
Topics Covered
- Introduction to Business Analytics
- Dashboard Creation
- Conditional Formatting and Essential Functions
- Excel in Business Analytics
- Analysis with Pivot Tables
