Introduction to POA
Module 1: Overview of Analysis Process
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
-
🎁 (1:17)
Affiliates
