Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analytics Bootcamp for End Users
Part I - Strategize (Preparation)
1.1 Understand the Data & Landscape (11:40)
1.2 Types of Data (4:56)
1.3 KPIs vs Metrics (7:21)
1.4 Data Integrity Checks (4:36)
1.5 Common Data Cleanup & Conforming Techniques (22:45)
1.6 Working with Dates (20:58)
Part II - Visualize (Charts & Dashboards)
2.1 Chart Types (7:17)
2.2 Visualization Methods (2:31)
2.3 Visualization Methodology (7:15)
2.4.1 Chart Building Introduction (24:04)
2.4.2 Column Charts (5:46)
2.4.3 Stacked Charts (3:12)
2.4.4 Line Graphs (5:19)
2.4.5 Pie Graphs (3:13)
2.4.6 Histogram Charts (7:49)
2.4.7 Map Charts (4:54)
2.4.8 Tree Maps (5:16)
2.4.9 Waterfall Charts (4:28)
2.4.10 Box and Whisker Charts (7:44)
2.4.11 Scatter plots and Bubble Charts (8:20)
2.4.12 Area, Funnel and Heat Map
2.4.13 Radar and Gauge Charts
2.4.14 Bullet and Gantt Charts
2.5.1 Dashboard Introduction & Types (5:00)
2.5.2 Dashboard Design Methodology (40:09)
2.5.3 Dashboard Design Principles (13:04)
Part III - Analyze (Insights that Drive Action & Story Telling)
3.0 Intro to Part III & Top 10 Insights Checklist (7:27)
3.0 Clothes R Us Data set
3.1 Value Drivers (17:23)
3.2 Targets (6:11)
3.3 Growth (2:56)
3.4 Trends (6:31)
3.5 Rank & Sorting (11:00)
3.6 Mix (7:14)
3.7 Comparisons (1:58)
3.8 The Magic of 80/20 (10:02)
3.9 Correlation & Outliers (5:06)
3.10 5Ms: Min, Max, Mean, Median, Mode (68:32)
Case Studies
PharmaWorld
CyberWizz
Advanced Case Studies
Create Functions and Date Tables (12:54)
Case Studies (52:49)
Bonus Lessons
10 Tips to get INSIGHTS from any data (PDF)
Tips for Story Telling
Create a Dynamic Excel Dashboard (106:27)
2.1 Chart Types
Objective:
In this module we will cover 19 of the most commonly used charts and what they are used for.
Key Concepts:
Download
Slides:
Download
Visualization – Chart Types.pdf
Complete and Continue
Discussion
0
comments
Load more
0 comments