Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Business Analytics Accelerator Program
Introduction to BAAP
Welcome to BAAP! (0:55)
How to prepare for the course and get the MOST out of it? (3:18)
Download Your BAAP Handbook
Setting Your WHY (1:01)
Facebook Group!
Module 1: Overview of Analysis Process
Download Module 1 Slide Deck
Analysis and Its Impact (3:38)
Overview of the Analysis Infrastructure (1:56)
Breaking Down the Analytics Blueprint (4:48)
Module 2: PLAN
Download Module 2 Slide Deck
Key Elements for Your Analysis Project Onboarding Deck (3:49)
Preparing Your Analysis Project Onboarding Deck Effectively (12:05)
Resource: Analysis Project Onboarding Deck Template
Identifying and Preparing KPIs (5:08)
Resource: Exhaustive List of KPIs for Different Objectives
Resource: Example of a Website KPIs List
Hands-On Exercise: Build Your Own Analysis Report Onboarding Deck
Module 3: COLLECT
Download Module 3 Slide Deck
Understanding the Basics of Data Collection (3:07)
Exploring Data Collection Methods and Data Sources (7:33)
Resource: Data Collection Tools List
Lay Your foundation in Website Tracking (2:49)
Selecting the Right Web Analytics Platform Based on Your Needs (1:43)
Hands-On Exercise: Set Up Your Data Collection Plan
Module 4: POLISH
Download Module 4 Slide Deck
Introduction to Data Cleaning and Formatting (2:13)
Strategies for Cleaning Raw Data to Ensure Accuracy (7:13)
DEMO: Data Cleaning Techniques Using Excel (4:22)
Techniques for Formatting Data to Facilitate Analysis (3:04)
DEMO: Data Formatting Tips in Excel (4:20)
Exploring Tools for Data Cleaning and Formatting (6:39)
Hands-On Exercise: Cleaning & Formatting Your Data
Module 5: VISUALISE
Download Module 5 Slide Deck
Introduction to Data Visualization (7:56)
Exploring Data Visualization Tools and Platforms (2:14)
Resource: Data Visualization Tools List
Common Graphs Used in Dashboards (3:43)
Proven Method to Manage Data Visualization projects (3:57)
Resources: Excel Dashboard Templates
DEMO: Designing an interactive dashboard in Excel (14:47)
Resource: Introduction to Google Analytics 4 (GA4)
DEMO: Creating dashboards in Google Analytics 'Explore' (11:09)
Hands-On Exercise: Design Your Own Dashboard
Module 6: ANALYSE
Download Module 6 Slide Deck
Understanding Different Types of Analysis (7:14)
The Basics of Exploratory Data Analysis (EDA) (5:54)
Adopting the 5 Steps Approach to analysis (2:10)
Use Case 1: Website Analysis (8:54)
Use Case 2: Funnel Analysis (10:23)
Use Case 3: Traffic Analysis (8:21)
Resource: Data used for Use Cases 4 to 6
Use Case 4: Pricing Analysis (5:47)
Use Case 5: Product Analysis (5:31)
Use Case 6: Social Media Analysis (9:09)
Hands-On Exercise: Practice the 5 Steps Approach to analysis + Data presentation
Module 7: NARRATE
Download Module 7 Slide Deck
Introduction to NARRATE (2:47)
Tips for Effective Storytelling with Data (3:22)
Resource: Analysis Report Template
Creating the Skeleton of Your Analysis Report (0:35)
Crafting a Captivating Introduction for Your Analysis Report (2:43)
Perfecting the Layout of your Reporting section in the Analysis Report (2:31)
Summarizing Your Analysis Findings for Clarity (1:41)
Formatting Your Learnings and Recommendations for Impactful Delivery (3:21)
Hands-On Exercise: Preparing Your Analysis Report
Module 8: EXECUTE
Download Module 8 Slide Deck
Introduction to EXECUTE (2:29)
Structuring Your Recommendations for Clarity (2:36)
Prioritizing Recommendations Using "The Recommendation Matrix" (3:09)
Key Components to Include in the Next Steps of the Analysis Report (0:49)
Hands-On Exercise: Finalising Your Analysis Report
That's a wrap!
Teach online with
Hands-On Exercise: Cleaning & Formatting Your Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock