MBA 611 Data Visualization

This course focuses on the area of data visualization. This is the process of representing business or scientific data typically in a tabular format as images and charts that can aid in understanding the meaning of the data.

Lessons

WATCH: Getting Started (25 mins)

Tableau (Ch 1)

1. WATCH: The Tableau Interface (4 mins)
2. DO: Ch 1 Connecting to Data - pages 2-3 
3. WATCH: Getting Started with Mapping (3 mins)
4. WATCH: Maps in Tableau (4 mins)
5. DO: Ch 1 Visualizing Data (bar, line, maps, show me) - pages 13-32
6. DO: Ch 1 Building Dashboards - pages 37-39
7. WATCH: Distributing and Publishing (4 mins)

Working with Data in Tableau (Ch 2)

1. WATCH: Getting Started with Data (6 mins)
2. DO: Ch 2 Simple Example - pages 43-46
3. DO: Ch 2 Connecting to a Data File - pages 48-51
4. WATCH: Connect to Data from the Web (3 mins)
5. DO: Ch 2 Connecting to Data in the Cloud - pages 56-57
6. WATCH: Managing Metadata (4 mins)
7. DO: Ch 2 Managing Source Metadata - pages 60-61
8. WATCH: Managing Extracts (4 mins)
9. WATCH: Join Types with Union (4 mins)
10. WATCH: Cross-database Joins (3 mins)
11. WATCH: Data Blending (5 mins)
12. WATCH: Additional Data Blending Topics (4 mins)

Extras

• WATCH: Saving and Publishing Data Sources (7 mins)
• WATCH: Data Prep with Text and Excel Files (5 mins)
• WATCH: Connecting to PDFs (9 mins)
• WATCH: Connecting to Cubes (7 mins)

Moving Beyond Basic Visualizations (Ch 3)

1. WATCH: Getting Started with Visual Analytics (6 mins)
2. DO: Bar Charts - pages 79-93
3. DO: Bullet Chart page 83-86
4. DO: Bar-In-Bar Chart – pages 86-89
5. DO: Highlighting Categories of Interest – pages 90-91
6. WATCH: Date Calculations (3 mins)
7. DO: Ch 3 Stacked Bar Charts - pages 104-105
8. DO: Ch 3 Histograms - pages 119-121
9. WATCH: Drill Down and Hierarchies (5 mins)
10. WATCH: Sorting (5 mins)
11. WATCH: Grouping (4 mins)
12. WATCH: Additional Ways to Group (4 mins)

Calculations (Ch 4)

1. WATCH: Getting Started with Calculations (3 mins)
2. WATCH: Calculation Syntax (4 mins)
3. WATCH: Modifying Table Calculations (5 mins)
4. WATCH: Logic Calculations (3 mins)
5. WATCH: String Calculations (3 mins)
6. WATCH: Number Calculations (2 mins)
7. WATCH: Type Calculations (3 mins)
8. DO: Ch 4 Row Level Calculations - pages 136-140
9. WATCH: Aggregate Calculations (4 mins)
10. DO: Ch 4 Aggregate Level Calculations - pages 142-144
11. WATCH: Using a Parameter to Change Fields (3 mins)
12. WATCH: Parameters (5 mins)
13. WATCH: Dynamic Parameters (2 mins)
14. WATCH: Parameter Actions (7 mins)
15. DO: Ch 4 Fixing Data Issues – pages 154-155
16. DO: Ch 4 Enhancing User Experience, Analysis & Visualizations - pages 157-159

Extras 

Level of Detail Calculations (Ch 5)

1. WATCH: Introduction to LOD Expressions (6 mins)
2. WATCH: Conceptual Topics with LOD Expressions (4 mins)
3. WATCH: Aggregation and Replication with LOD Expressions (5 mins)
4. WATCH: Nested LOD Expressions (3 mins)
5. READ: Ch 5 – Level of Detail Calculations

Table Calculations (Ch 6)

1. WATCH: Intro to Table Calculations (3 mins)
2. DO: Working with Scope & Direction - pages 197-200
3. DO: Addressing and Partitioning - pages 201-205
4. DO: Dynamic Titles with Totals – pages 215-216

Making Visualizations (Ch 7) & Storytelling with Data Book

1. WATCH: Formatting (7 mins)
2. WATCH: The Formatting Pane (7 mins)
3. WATCH: Basic Tooltips (7 mins)
4. WATCH: Viz in Tooltip (6 mins)
5. READ: Ch 7 Making Visualizations Look Great
6. READ: Storytelling with Data Book

Telling a Data Story with Dashboards (Ch 8)

1. WATCH: Getting Started with Dashboards and Stories (4 mins)
2. WATCH: Building a Dashboard (5 mins)
3. WATCH: Dashboard Objects (4 mins)
4. WATCH: Dashboard Formatting (4 mins)
5. DO: A Dashboard to Understand Profitability - pages 259-265
6. WATCH: Dashboard Interactivity Using Actions (5 mins)
7. DO: Implementing Actions - pages 266-267
8. WATCH: Ways to Filter (2 mins)
9. WATCH: Using the Filter Shelf (7 mins)
10. WATCH: Interactive Filters (4 mins)
11. WATCH: Where Tableau Filters (4 mins)
12. WATCH: Additional Filtering Topics (7 mins)
13. DO: Context Filtering, Actions - pages 268-270
14. WATCH: Creating Sets (6 mins)
15. WATCH: Working with Sets (4 mins)
16. WATCH: Set Actions (6 mins)
17. WATCH: Story Points (5 mins)
18. DO: Stories - pages 289-293 (only the parts that create new calculated fields that are used later)
19. DO: Stories – pages 294-300

Extras

• WATCH: Dashboard Extensions (4 mins)
• WATCH: Device Designer (5 mins)

Trends, Clustering, Distributions and Forecasting (Ch 9)

1. WATCH: Trend Lines (5 mins)
2. DO: Trend Lines - pages 304-308
3. DO: Customizing Trend Lines - pages 309-311
4. WATCH: Reference Lines (7 mins)
5. WATCH: Explain Data (5 mins)
6. OPTIONAL WATCH: How to Integrate R and Tableau (4 mins)
7. OPTIONAL WATCH: Using R within Tableau (4 mins)
8. OPTIONAL READ (PC Only): Exporting Statistical Model Details - pages 320-322
9. WATCH: Clustering (2 mins)
10. DO: Clustering - pages 324-327
11. DO: Distributions - pages 328-330
12. WATCH: Forecasting (6 mins)
13. DO: Forecasting - pages 332-336
14. WATCH: Analysis with Cubes and MDX (5 mins)

Advanced Visualizations (Ch 10)

1. SKIP

Dynamic Dashboards (Ch 11)

1. SKIP

Exploring Mapping and Advanced Geospatial Features (Ch 12)

1. SKIP

Understanding the Tableau Data Model, Joins and Blends (Ch 13)

1. DO: Creating a Data Model – pages 406-408
2. DO: Joining Tables – pages 423-426
3. DO: Join Calculations – page 427
4. DO: A Blending Examples – pages 433-436

Cleaning & Structuring Messy Data (Ch 14)

1. DO: The Data Interpreter - pages 451-456
2. DO: Unioning three text files - pages 458-460

Taming Data with Tableau Prep (Ch 15)

1. WATCH: Getting Started with Tableau Prep Builder (5 mins)
2. WATCH: The Tableau Prep Builder Interface (8 mins)
3. WATCH: The Input Step (5 mins)
4. DO: Connecting to Data - pages 483-489
5. WATCH: The Cleaning Step (7 mins)
6. WATCH: The Profile Pane (6 mins)
7. WATCH: The Union Step (5 mins)
8. DO: Cleaning the Data - pages 490-492
9. WATCH: Group and Replace (6 mins)
10. DO: Grouping and Cleaning - pages 492-498
11. WATCH: The Pivot Step (4 mins)
12. DO: Calculations and Aggregations in Tableau Prep - pages 499-503
13. WATCH: The Aggregate Step (5 mins)
14. DO: Aggregations – pages 504-505
15. WATCH: The Output Step (5 mins)
16. DO: Output Step – pages 506-507
17. DO: Filtering Data – pages 508-509
18. WATCH: The Join Step (4 mins)
19. DO: Transforming the Data - pages 510-519
20. WATCH: Tableau Prep Conductor (5 mins)

Sharing Your Data Story (Ch 16)

1. READ

Unassigned Bonus Learning Items

Why is Tableau Doing That?

• WATCH: Understanding Pill Types (5 mins)
• WATCH: Measure Names and Measure Values (5 mins)
• WATCH: Aggregation, Granularity, and Ratio Calculations (4 mins)
• WATCH: When to Blend and When to Join (6 mins)
• WATCH: Filtering for Top Across Panes (6 mins)

How To

• WATCH: Polygon Maps (4 mins)
• WATCH: Mapbox Integration (2 mins)
• WATCH: WMS: Web Mapping Services (2 mins)
• WATCH: Finding the Second Purchase Date with LOD Expressions (7 mins)
• WATCH: Cleaning Data by Bulk Re-aliasing (2 mins)
• WATCH: Bollinger Bands (4 mins)
• WATCH: Bump Charts (1 min)
• WATCH: Control Charts (4 mins)
• WATCH: Funnel Charts (3 mins)
• WATCH: Step and Jump Lines (3 mins)
• WATCH: Pareto Charts (4 mins)