Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to Business Analysis With Excel
Course Introduction
My Business Analysis Journey (7:18)
It's All About the Process
All Business Outcomes Result from a Process (15:50)
All Processes Have Variation (13:00)
Numeric Literacy
Don't Panic! (1:13)
Numeric Summaries (9:45)
Ratios (6:29)
Apples & Oranges (4:30)
Probability Intuition (2:49)
Data Visualization
Visualizing Processes (0:55)
Histograms (14:00)
Bar Charts (14:55)
Pareto Charts (5:53)
Line Charts (10:17)
Lab 1 - Data Visualization with Excel
Lab Instructions
Lab Walkthrough (19:30)
Analyzing Process Data
Data Analysis Fundamentals (10:37)
Process Data is Different (3:11)
The Mighty Process Behavior Chart
Summarizing the Process (6:46)
Quantifying Process Variation (4:17)
Characterizing Process Variation (10:23)
Lab 2 - Your First Process Behavior Chart
Lab Instructions
Lab Walkthrough (13:48)
Analyzing Data With the Chart
What Data Can Be Analyzed (15:56)
Predictable Processes (7:19)
Detecting Process Changes (14:15)
Lab 3 - Analyzing Data With the Chart
Lab Instructions
Lab Walkthrough (5:55)
Becoming a Data Detective
How the Chart Works (5:07)
Buried Signals (3:57)
Uncovering Insight (7:27)
Lab 4 - Becoming a Data Detective
Lab Instructions
Lab Walkthrough (9:35)
Data Detective Mastery
Meet Charissa (2:20)
Data Sleuthing (10:00)
Comparing Groups of Data (9:50)
Lab 5 - Comparing Groups
Lab Instructions
Lab Walkthrough (5:31)
Median Charts
How to Use Median Charts (13:34)
Lab 6 - Median Charts
Lab Instructions
Lab Walkthrough (6:54)
Dealing With Seasonality
Smoothing Data With Moving Ranges (6:55)
Deseasonalizing Data With Seasonal Factors (25:43)
Lab 7 - Seasonality
Lab Instructions
Lab Walkthrough (11:12)
Additional Resources
Continue Your Learning (5:25)
Data Sleuthing
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock