Tableau Prep : Up & Running /

For self-service data preparation, Tableau Prep is relatively easy to use-as long as you know how to clean and organize your datasets. Based on the popular blog Preppin' Data, this practical guide takes you step-by-step through the fundamentals of data preparation using this popular tool. Carl...

Descripción completa

Detalles Bibliográficos
Autor principal: Allchin, Carl (Autor)
Autor Corporativo: Safari, an O'Reilly Media Company
Formato: Electrónico eBook
Idioma:Inglés
Publicado: O'Reilly Media, Inc., 2020.
Edición:1st edition.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Intro
  • Preface
  • Why I Wrote This Book
  • Who This Book Is For
  • How This Book Is Organized
  • Acknowledgments
  • Conventions Used in This Book
  • Using Code Examples
  • O'Reilly Online Learning
  • How to Contact Us
  • 1. Why Self-Service Data Prep?
  • A Short History of Self-Service Data Visualization
  • Accessing the "Right Data"
  • The Self-Service Data Preparation Opportunity
  • Tableau Prep Up and Running
  • Summary
  • I. Getting Started
  • 2. Getting Started with Tableau Prep Builder
  • Where to Get Tableau Prep Builder
  • How to Get a License for Prep Builder
  • The Tableau Prep Builder Screen
  • Basic Steps of Data Preparation
  • Input Step
  • Clean Step
  • Output Step
  • Saving a Flow
  • Summary
  • 3. Planning Your Prep
  • Stage 1: Know Your Data
  • Stage 2: Identify the Desired State
  • Stage 3: Determine the Required Transitions from KYD to the Desired State
  • Stage 4: Build the Workflow
  • Summary
  • 4. Shaping Data
  • What to Look for in Incoming Data Sets
  • What Shape Is Best for Analysis in Tableau?
  • Changing Data Set Structures in Prep Builder
  • Pivot
  • Aggregate
  • Join
  • Union
  • Applying Restructuring Techniques to the Ice Cream Example
  • Step 1: Pivot Columns to Rows
  • Step 2: Pivot Rows to Columns
  • Summary
  • 5. Connecting to Data in Files
  • Files Upon Files Upon Files
  • Spreadsheets
  • Other File Types
  • Where to Find Your Data Files
  • How to Connect to Files in Prep
  • Considerations for Saving Flows with File Inputs
  • Summary
  • 6. Connecting to a Database
  • What Is a Database?
  • How to Connect to a Database Within Prep Builder
  • When to Avoid Connecting to a Database
  • Summary
  • II. Data Types
  • 7. Dealing with Numbers
  • What Do We Mean by Numbers?
  • Types of Numbers
  • Category or Measure?
  • Aggregation
  • Formatting Numbers
  • Functions for Mastering Numerical Data
  • Summary
  • 8. Dealing with Dates
  • Why Are Dates Important?
  • Parts of a Date
  • Date Lookup Tables
  • Epoch Dates
  • Excel Serial Number
  • Entering Dates
  • The makedate() Function
  • The dateparse() Function
  • Summary
  • 9. Dealing with String Data
  • What Do We Mean by Strings?
  • How String Data Is Different
  • Character Order
  • Formatting Considerations
  • Names
  • Case sensitivity
  • Addresses
  • Spaces
  • Poor or inconsistent spelling
  • Common Functions for Preparing String Data
  • Grouping and Replace Options for Working with String Data
  • Summary
  • 10. Dealing with Boolean Data
  • What Is Boolean Data?
  • Why Is It So Useful in Data Analysis?
  • Functions Featuring Boolean Logic
  • IIF()
  • contains()
  • IsDate()
  • IsNull()
  • IF/THEN
  • CASE
  • Summary
  • III. The Shape of Data
  • 11. Profiling Data
  • What Is a Profile?
  • Why Visualizing the Data Set Is Important
  • Anscombe's Quartet
  • Visualizations Versus Data Tables
  • How Prep Builder Profiles Data
  • Generating Histograms and Mini-Histograms

Ejemplares similares