Prepare your data for Tableau : a practical guide to the tableau data prep tool /

Part III: Load -- Chapter 11: Output -- Exercise 11.1: Simple Output -- Summary -- Appendix A: Preparing Data IN Tableau -- Tableau Builder Data Prep Checklist -- Sample Data -- Filter -- Hide Fields -- Rename -- Pivot -- Split -- Alias Contents -- Data Types -- Data Roles -- Defaults -- Strings --...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Costello, Tim (Autor), Blackshear, Lori (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [California] : Apress, [2020]
Temas:
Tableau (Computer file)
Information visualization.
Visualisation de l'information.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • What is ETL?
  • About the demo data
  • Connecting to data
  • Union joins
  • Joins
  • Audit
  • Cleaning
  • Group and replace
  • Aggregate
  • Pivoting data
  • Output
  • Appendix A: Preparing data in Tableau.
  • Intro
  • Table of Contents
  • About the Authors
  • About the Technical Reviewer
  • Foreword
  • Chapter 1: What Is ETL?
  • Extract
  • Transform
  • Load
  • Chapter 2: About the Demo Data
  • ZTCA to Census Tract
  • US_A. CSV
  • GEOCORR Education Data by State
  • US Population Density and Unemployment by Zip Code
  • Part I: Extract
  • Chapter 3: Connecting to Data
  • Working with Server-Based Data Sources
  • Connecting to SQL Server
  • Initial SQL (Running SQL on Connection)
  • Working with Tableau Data Extracts
  • Working with File-Based Data Sources
  • Connecting to Microsoft Access
  • Connecting to Microsoft Excel
  • Connecting to PDF Files
  • Connecting to Text Files
  • Summary
  • Chapter 4: UNION Joins
  • Exercise 4.1: Union Join
  • The Data Preview Pane
  • Data Types
  • Changes
  • Reviewing the Union Step
  • Union Join the Easy Way
  • Exercise 4.2
  • Exercise 4.3
  • Which Is Better?
  • Summary
  • Chapter 5: Joins
  • What Is a Table?
  • Equijoins
  • Join Types
  • Inner Joins
  • Left Joins
  • Right Joins
  • Outer Joins
  • The Shape of Your Data
  • Exercise 5.1: Joins
  • Missing Data
  • Finding Missing Records
  • Bringing It All Together
  • But Wait, There's More!
  • Summary
  • Part II: Transform
  • Audit
  • Clean
  • Group and Replace
  • Aggregate
  • Pivot
  • Chapter 6: Audit
  • Exercise 6.1: Connect to Data
  • Summary
  • Chapter 7: Cleaning
  • Exercise 7.1: Add Step
  • Exercise 7.2: General Cleanup
  • Merge and Clean
  • Make the Data More Consistent
  • Split
  • Exercise 7.3: Split
  • Recommendations
  • Handle NULL Values
  • Filtering Records
  • Summary
  • Chapter 8: Group and Replace
  • Manual Selection
  • Pronunciation
  • Common Characters
  • Spelling
  • Summary
  • Chapter 9: Aggregate
  • Aggregating Data
  • Summary
  • Chapter 10: Pivoting Data
  • Pivot
  • UnPivot
  • Part III: Load
  • Chapter 11: Output
  • Exercise 11.1: Simple Output
  • Summary
  • Appendix A: Preparing Data IN Tableau
  • Tableau Builder Data Prep Checklist
  • Sample Data
  • Filter
  • Hide Fields
  • Rename
  • Pivot
  • Split
  • Alias Contents
  • Data Types
  • Data Roles
  • Defaults
  • Strings
  • Colors
  • Shapes
  • Sort
  • Numbers
  • Number Format
  • Default Aggregation
  • Dates
  • Fiscal Year Start
  • Custom Date Format
  • Custom Date
  • Hierarchies
  • Groups
  • Comments
  • Organize Dimensions and Measures
  • Calculated Fields
  • Live or Extract
  • Tableau Data Server
  • Saved Data Sources
  • Save to Extract
  • Summary
  • Index

Ejemplares similares