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...

Full description

Bibliographic Details
Main Author: Allchin, Carl
Format: eBook
Language:English
Published: O'Reilly Media, Inc. 2020
Edition:1st edition
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 04852nmm a2200385 u 4500
001 EB001947119
003 EBX01000000000000001110021
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9781492079590 
020 |a 9781492079576 
020 |a 149207957X 
100 1 |a Allchin, Carl 
245 0 0 |a Tableau Prep  |b Up & Running  |c Allchin, Carl 
250 |a 1st edition 
260 |b O'Reilly Media, Inc.  |c 2020 
300 |a 300 pages 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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? 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
500 |a Made available through: Safari, an O'Reilly Media Company 
776 |z 9781492079620 
776 |z 1492079626 
776 |z 149207957X 
776 |z 9781492079590 
776 |z 1492079596 
776 |z 9781492079576 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781492079613/?ar  |x Verlag  |3 Volltext 
082 0 |a 001.4226 
520 |a 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 Allchin from the Data School in London provides a series of lessons to get you up to speed on Tableau Prep, including methods for cleaning and organizing your datasets. In just a short time, this tool has filled a valuable niche for self-service data preparation in the same way Tableau Desktop has for self-service data analytics. This book gets you started with Tableau Prep right away. Learn fundamental data preparation strategies for approaching complex challenges Understand how to apply those skills in more depth with Tableau Prep Manage projects that require data preparation with more confidence Learn how Tableau Prep will empower you to make informed decisions