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 (2:44)
2.4.3 Stacked Charts (7:43)
2.4.4 Line Graphs (5:19)
2.4.5 Pie Graphs (3:13)
2.4.6 Histogram Charts (13:01)
2.4.7 Map Charts (9:13)
2.4.8 Tree Maps (5:16)
2.4.9 Waterfall Charts (9:37)
2.4.10 Box and Whisker Charts (12:58)
2.4.11 Scatter plots and Bubble Charts (13:31)
2.4.12 Area, Funnel and Heat Map (8:44)
2.4.13 Radar and Gauge Charts (4:27)
2.4.14 Bullet and Gantt Charts (5:44)
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 (9:00)
3.3 Growth (6:54)
3.4 Trends (7:21)
3.5 Rank & Sorting (11:00)
3.6 Mix (7:26)
3.7 Comparisons (3:59)
3.8 The Magic of 80/20 (12:47)
3.9 Correlation & Outliers (4:57)
3.10 5Ms: Min, Max, Mean, Median, Mode (70:40)
Case Studies
PharmaWorld
CyberWizz
Certification
Advanced Case Studies
Create Functions and Date Tables (12:54)
Case Studies (52:49)
Bonus Lessons
10 Tips to get INSIGHTS from any data (72:08)
Tips for Story Telling
Create a Dynamic Excel Dashboard (106:27)
2.4.2 Column Charts
Lesson:
Exercise:
Download
2.4.2.1. Exercise Column Charts v7.0.pdf
Download
FIFA V7.0.xlsx
Download
2.4.2.2. Exercise Bar Charts v7.0.pdf
Download
Womens Clothing E-Commerce Reviews v7.0.xlsx
Download
CSV Womens Clothing E-Commerce Reviews v7.0.zip
Complete and Continue
Discussion
0
comments
Load more
0 comments