Business Analysis

• Traditional Classroom: 1-day Duration
• Virtual Instructor-led: Two 4-hour sessions

This hands-on data workshop provides participants with an introduction to the practice of data analysis. Participants will actively plan, collect, record, analyze, and present data designed to enhance problem solving and decision making in business. Throughout the workshop participants will work using Microsoft® Excel to organize and analyze data.

Target Audience

Individuals who will benefit from this course include those seeking to improve their capability in analyzing complex data and visualizing and presenting key findings.

Learning Objectives

• Understand data basics, types, and formats.
• Evaluate data sources, assess quality and utility.
• Utilize Excel for data transformation and visualization.
• Make informed judgments based on data.
• Create compelling narratives using data.

Course Outline

Introduction to Data and Data Analysis

• Session Overview and Learning Objectives
• Data Types and Sources
• Business Questions
• Audience and Context Analysis
• Exercise: Determine Stakeholders’ Needs

Data Collection and Preparation

• Data Gathering
• Data Cleaning
• Data Transformation
• Exercise: Practice Using AI Agents for Data Research

Exploratory Data Analysis

• Comparative Analysis
• Statistical Methods
• Pattern and Relationship Identification
• Exercise: Practice Using Excel for Statistical Analysis

Data Modeling and Predictive Analytics

• Introduction to Modeling
• Regression Analysis
• Statistical Modeling
• Exercise: Practice Creating Statistical Models in Excel

Data Visualization and Communication

• Visualization Tools
• Storytelling with Data
• Actionable Insights
• Exercise: Practice Creating and Evaluating Graphs in Excel

Summary and Next Steps

BAV331-1 Course Code