آموزش تحلیل بصری داده‌ها (Visual Analytics) - آخرین آپدیت

Module 1: Foundations of Visual Analytics in Tableau Module 1: Foundations of Visual Analytics in Tableau

• Course Overview Course Overview

• Module 1 Introduction Module 1 Introduction

• What Is Data Visualization? What Is Data Visualization?

• Seeing What Statistics Miss Seeing What Statistics Miss

• Seeing What Statistics Miss The Real World Impact Seeing What Statistics Miss - The Real-World Impact

• How Human Perceive Visual Information How Human Perceive Visual Information

• Cognitive Load in Data Visualization Cognitive Load in Data Visualization

• Decluttering Charts Without Losing Meaning Decluttering Charts Without Losing Meaning

• From Clean to Meaningful From Clean to Meaningful

• Creating Meaningful Charts Titles, Context, and Framing Creating Meaningful Charts - Titles, Context, and Framing

• Annotations That Add Analytical Value Annotations That Add Analytical Value

• Charts for Continuous Variables Charts for Continuous Variables

• Charts for Categorical Variables Part I Charts for Categorical Variables - Part I

• Charts for Categorical Variables Part II Charts for Categorical Variables - Part II

• When Tables (or Text) Are the Right Choice When Tables (or Text) Are the Right Choice

• The Tableau Workspace A Mental Model The Tableau Workspace - A Mental Model

• Connecting to Data The Global Superstore Dataset Connecting to Data - The Global Superstore Dataset

• Data Types, Dimensions and Measures Data Types, Dimensions and Measures

• Discrete vs. Continuous Fields (Including Dates) Discrete vs. Continuous Fields (Including Dates)

• Building Basic Charts with Shelves and Marks Building Basic Charts with Shelves and Marks

• Filters, Legends, and Interactivity Filters, Legends, and Interactivity

• Using the Show Me Button to Explore Charts Using the Show Me Button to Explore Charts

• Dual Axis Charts Basics Dual Axis Charts - Basics

• Dual Axis Charts Fine Tuning Dual Axis Charts - Fine Tuning

• More On Maps Color Encoding More On Maps - Color Encoding

• More On Maps Dual Axis More On Maps - Dual Axis

Module 2: Core Calculations for Analytical Insight Module 2: Core Calculations for Analytical Insight

• Module 2 Introduction Module 2 Introduction

• What Is a Calculated Field (and Why We Use Them) What Is a Calculated Field (and Why We Use Them)

• Creating Calculated Fields in Tableau Creating Calculated Fields in Tableau

• Adding Multiple Datasets to a Tableau Workbook Adding Multiple Datasets to a Tableau Workbook

• More on Use and Edit of Calculated Fields More on Use and Edit of Calculated Fields

• Granularity & Aggregation in Tableau Granularity & Aggregation in Tableau

• Row Level vs. Aggregate Logic in Calculated Fields Row-Level vs. Aggregate Logic in Calculated Fields

• Writing Aggregate Safe Calculated Fields Writing Aggregate-Safe Calculated Fields

• Fixing Aggregation Errors with MIN, MAX, and ATTR Functions Part I Fixing Aggregation Errors with MIN, MAX, and ATTR Functions -- Part I

• Fixing Aggregation Errors with MIN, MAX, and ATTR Functions Part II Fixing Aggregation Errors with MIN, MAX, and ATTR Functions -- Part II

• Parameters Explained Control Without Refiltering Parameters Explained -- Control Without Refiltering

• Using Parameters in Calculated Fields Using Parameters in Calculated Fields

• Top N Analysis with Parameter Driven Filters Top-N Analysis with Parameter-Driven Filters

• Swapping Measures Dynamically with CASE Logic Swapping Measures Dynamically with CASE Logic

• Measure Names and Measure Values – in Charts Measure Names and Measure Values – in Charts

• Measure Names and Measure Values – in Tables Measure Names and Measure Values – in Tables

• Dot Chart – An Application of Measure Names and Measure Values Dot Chart – An Application of Measure Names and Measure Values

• Visual Encodings for Line Charts Visual Encodings for Line Charts

• Reference Lines (and Bullet Chart) Introduction Reference Lines (and Bullet-Chart) Introduction

• Reference and Distribution Bands Reference and Distribution Bands

Module 3: Data Modeling & Preparation for Visual Analytics Module 3: Data Modeling & Preparation for Visual Analytics

• Module 3 Introduction Module 3 Introduction

• Basic and Custom Splits Basic and Custom Splits

• Cleaning Messy Data with Data Interpreter and Pivot Functionality Cleaning Messy Data with Data Interpreter and Pivot Functionality

• Creating Excel like Table in Tableau Creating Excel-like Table in Tableau

• Why Data Structure Matters Why Data Structure Matters

• Blending Data from Multiple Sources in Tableau Blending Data from Multiple Sources in Tableau

• Choosing the Right Data Combination Strategy in Tableau Choosing the Right Data Combination Strategy in Tableau

• Combining Data in Tableau Understanding Joins and Their Risks Combining Data in Tableau -- Understanding Joins and Their Risks

• Combining Data in Tableau Understanding Relationships Combining Data in Tableau -- Understanding Relationships

• Connecting Tables When Fields Don’t Match Connecting Tables When Fields Don’t Match

• Unions Appending Data Across Tables Unions -- Appending Data Across Tables

• Dealing with Mismatched Fields Dealing with Mismatched Fields

• Appending Data with Unions and Creating Output Files in Tableau Prep Builder Appending Data with Unions and Creating Output Files in Tableau Prep Builder

• Cleaning and Validating Data in Tableau Prep Builder Cleaning and Validating Data in Tableau Prep Builder

• Understanding Tableau Prep Flows Connecting to Data Understanding Tableau Prep Flows -- Connecting to Data

• Why Tableau Prep Builder From Raw Data to Analysis Why Tableau Prep Builder -- From Raw Data to Analysis-

• A More In Depth Tableau Prep Workflow Part I A More In-Depth Tableau Prep Workflow -- Part I

• A More In Depth Tableau Prep Workflow Part II A More In-Depth Tableau Prep Workflow -- Part II

• A More In Depth Tableau Prep Workflow Part III A More In-Depth Tableau Prep Workflow -- Part III

Module 4: Dashboard Construction, Interactivity & Use Case Design (Tableau) Module 4: Dashboard Construction, Interactivity & Use-Case Design (Tableau)

• Module 4 Introduction Module 4 Introduction

• What is a Dashboard? What is a Dashboard?

• Preparing worksheets for dashboard use with Visual Formatting Part I Preparing worksheets for dashboard use with Visual Formatting -- Part I

• Preparing Worksheets for Dashboard Use with Visual Formatting – Part II Preparing Worksheets for Dashboard Use with Visual Formatting – Part II

• Structural Formatting for Comparative Analysis – Part I Structural Formatting for Comparative Analysis – Part I

• Structural Formatting for Comparative Analysis – Part II Structural Formatting for Comparative Analysis – Part II

• Basics of Dashboard Layouts and Formatting Basics of Dashboard Layouts and Formatting

• Managing (Vertical and Horizontal) Dashboard Containers Managing (Vertical and Horizontal) Dashboard Containers

• Adding Images, Web Content, and Aligning with Containers Adding Images, Web Content, and Aligning with Containers

• Dashboard Layout Panel & Object Hierarchy Dashboard Layout Panel & Object Hierarchy

• Adding Interactivity to the Order Priority Dashboard Adding Interactivity to the Order Priority Dashboard

• Dashboard Actions Filter Actions Using Select Dashboard Actions -- Filter Actions Using Select

• Dashboard Actions Highlight Actions Using Hover Dashboard Actions -- Highlight Actions Using Hover

Module 5: Table Calculations & Analytical Time Based Patterns Module 5: Table Calculations & Analytical Time-Based Patterns

• Module 5 Introduction Module 5 Introduction

• Introduction to Table Calculations Introduction to Table Calculations

• Scope and Direction in Table Calculations Scope and Direction in Table Calculations

• Customizing Table Calculations Customizing Table Calculations

• Rank Table Calculations Rank Table Calculations

• Application of Rank Sparklines Application of Rank - Sparklines

• SIZE, INDEX, and Total – Table Calculation Building Blocks SIZE, INDEX, and Total – Table Calculation Building Blocks

• Application of Index Jitter Plots Application of Index - Jitter Plots

• Percent of Total Calculations – Total Function in Use – Part I Percent of Total Calculations – Total Function in Use – Part I

• Percent of Total Calculations – Total Function in Use – Part II Percent of Total Calculations – Total Function in Use – Part II

• Moving Averages & Other Time Based Table Calculations Moving Averages & Other Time-Based Table Calculations

• Month over Month (MoM) Difference & Percent Difference Month-over-Month (MoM) Difference & Percent Difference

• From MoM to YoY Difference and Percent Difference Using LOOKUP From MoM to YoY -- Difference and Percent Difference Using LOOKUP

• How Tableau Thinks about Dates and Time How Tableau Thinks about Dates and Time

• Using DATEPART, DATEADD, DATETRUNC, and DATEDIFF – Part I Using DATEPART, DATEADD, DATETRUNC, and DATEDIFF – Part I

• Using DATEPART, DATEADD, DATETRUNC, and DATEDIFF – Part II Using DATEPART, DATEADD, DATETRUNC, and DATEDIFF – Part II

• Using DATEPART, DATEADD, DATETRUNC, and DATEDIFF – Part III Using DATEPART, DATEADD, DATETRUNC, and DATEDIFF – Part III

Module 6: Segmentation, Sets & Advanced Filtering Module 6: Segmentation, Sets & Advanced Filtering

• Module 6 Introduction Module 6 Introduction

• Categorization vs. Segmentation. What Problem Are We Solving? Categorization vs. Segmentation. What Problem Are We Solving?

• Creating Groups in Tableau Creating Groups in Tableau

• Why Groups Fail for Analytical Comparisons Why Groups Fail for Analytical Comparisons

• Creating Fixed Sets in Tableau Creating Fixed Sets in Tableau

• Using IN vs OUT Logic to Compare Subset vs Rest Using IN vs OUT Logic to Compare Subset vs Rest

• Building a Subset vs Rest Performance Benchmark Building a Subset-vs-Rest Performance Benchmark

• Using MIN() for Custom Layouts and Multi Metric Displays – Part I Using MIN() for Custom Layouts and Multi-Metric Displays – Part I

• Using MIN() for Custom Layouts and Multi Metric Displays – Part II Using MIN() for Custom Layouts and Multi-Metric Displays – Part II

• Dynamic Sets, Filter Logic, and Context Filters Dynamic Sets, Filter Logic, and Context Filters

• Driving Interactivity with Set Actions: Dynamic Part to Whole Analysis Driving Interactivity with Set Actions: Dynamic Part-to-Whole Analysis

• From Static Rankings to Interactive Insight From Static Rankings to Interactive Insight

• Build a Split Chart using a Trend Line Build a Split Chart using a Trend Line

• Sets Interacting with Sets Building Interactive Comparisons Part I Sets Interacting with Sets -- Building Interactive Comparisons -- Part I

• Sets Interacting with Sets – Cascading Selections Part II Sets Interacting with Sets – Cascading Selections -- Part II

• Sets Interacting with Sets Building Set Driven Comparisons Part III Sets Interacting with Sets -- Building Set-Driven Comparisons -- Part III

• Sets Interacting with Sets Refining the Dashboard Part IV Sets Interacting with Sets -- Refining the Dashboard -- Part IV

Module 7: Level of Detail (LOD) Expressions for Precision Module 7: Level of Detail (LOD) Expressions for Precision

• Module 7 Introduction Module 7 Introduction

• When the View Changes the Answer When the View Changes the Answer

• Why Standard Aggregation and Table Calculations Are Not Enough Why Standard Aggregation and Table Calculations Are Not Enough

• The Gap LODs Are Designed to Solve The Gap LODs Are Designed to Solve

• An Important Aside on FIXED An Important Aside on FIXED

• Computing at a Hidden Granularity with FIXED Part I Computing at a Hidden Granularity with FIXED -- Part I

• Computing at a Hidden Granularity with FIXED Part II Computing at a Hidden Granularity with FIXED -- Part II

• FIXED LOD Syntax and Mental Model FIXED LOD Syntax and Mental Model

• Stable Percent of Total with FIXED LODs Stable Percent-of-Total with FIXED LODs

• Using FIXED LODs for Benchmarks and Reusable Analytical Layers Part I Using FIXED LODs for Benchmarks and Reusable Analytical Layers -- Part I

• Using FIXED LODs for Benchmarks and Reusable Analytical Layers Part II Using FIXED LODs for Benchmarks and Reusable Analytical Layers -- Part II

• INCLUDE LODs Adding Granularity Carefully INCLUDE LODs -- Adding Granularity Carefully

• EXCLUDE LODs Removing Dimensions from the View Part I EXCLUDE LODs -- Removing Dimensions from the View -- Part I

• EXCLUDE LODs Removing Dimensions from the View Part II EXCLUDE LODs -- Removing Dimensions from the View -- Part II

• More Complex Examples Using LODs – Stable Denominator Problems More Complex Examples Using LODs – Stable Denominator Problems

• More Complex Examples Using LODs – Nested Time Grain Problems More Complex Examples Using LODs – Nested Time-Grain Problems

• More Complex Examples Using LODs – Cohort Problems Part I More Complex Examples Using LODs – Cohort Problems -- Part I

• More Complex Examples Using LODs – Cohort Problems Part II More Complex Examples Using LODs – Cohort Problems -- Part II

Module 8: Spatial Analytics & Integrated Dashboards Module 8: Spatial Analytics & Integrated Dashboards

• Module 8 Introduction Module 8 Introduction

• When a Traditional Map Is Not the Best Choice When a Traditional Map Is Not the Best Choice

• Building Stylized Maps in Tableau Building Stylized Maps in Tableau

• Building a Trellis Map in Tableau Part I Building a Trellis Map in Tableau -- Part I

• Building a Trellis Map in Tableau Part II Building a Trellis Map in Tableau -- Part II

• Building the Trellis Chart Structure in Tableau Building the Trellis Chart Structure in Tableau

• Centering Labels Horizontally in the Trellis Chart Centering Labels Horizontally in the Trellis Chart

• Centering Labels Vertically in the Trellis Chart Part I Centering Labels Vertically in the Trellis Chart -- Part I

• Centering Labels Vertically in the Trellis Chart Part II Centering Labels Vertically in the Trellis Chart -- Part II

• Two Cautions with Automatic Trellis Layouts Two Cautions with Automatic Trellis Layouts

• Using Hexbin Plots for Dense Spatial Data Using Hexbin Plots for Dense Spatial Data

• Intro to Spatial Analysis Preparing the Selected Location Intro to Spatial Analysis -- Preparing the Selected Location

• Building Points and Calculating Distance in Tableau Building Points and Calculating Distance in Tableau

• Building Radius and Coverage Views with BUFFER Building Radius and Coverage Views with BUFFER

• Connecting Locations with MAKELINE Connecting Locations with MAKELINE

• Combining Maps with Analytical Context Combining Maps with Analytical Context

• What Role Should the Map Play in a Dashboard What Role Should the Map Play in a Dashboard

• A Guided Analysis of Exploratory and Explanatory Dashboards – Part I A Guided Analysis of Exploratory and Explanatory Dashboards – Part I

• A Guided Analysis of Exploratory and Explanatory Dashboards – Part II A Guided Analysis of Exploratory and Explanatory Dashboards – Part II

Summative Course Assessment Summative Course Assessment