Tableau prep : up and running : self-service data preparation for better analysis / Carl Allchin.

Format:

Book

Author/Creator:

Allchin, Carl, author.

Language:

English

Subjects (All):

Computer science.

Tableau (Computer file).

Physical Description:

1 online resource (1 volume) : illustrations

Edition:

First edition.

Other Title:

Tableau prep up and running

Place of Publication:

Sebastopol, California : O'Reilly Media, Incorporated, 2020.

System Details:

text file

Summary:

For self-service data preparation, Tableau Prep is relatively easy to use—as long as you know how to clean and organize your datasets. Carl Allchin, from The Information Lab in London, gets you up to speed on Tableau Prep through a series of practical lessons that include methods for preparing, cleaning, automating, organizing, and outputting your datasets. Based on Allchin’s popular blog, Preppin’ Data , this practical guide takes you step-by-step through Tableau Prep’s fundamentals. Self-service data preparation reduces the time it takes to complete data projects and improves the quality of your analyses. Discover how Tableau Prep helps you access your data and turn it into valuable information. Know what to look for when you prepare data Learn which Tableau Prep functions to use when working with data fields Analyze the shape and profile of your dataset Output data for analysis and learn how Tableau Prep automates your workflow Learn how to clean your dataset using Tableau Prep functions Explore ways to use Tableau Prep techniques in real-world scenarios Make your data available to others by managing and documenting the output

Contents:

Why self-service data prep?

Part 1. Getting started. Getting started with Tableau prep builder

Planning your prep

Shaping data

Connecting to data in files

Connecting to a database

Part 2. Data types. Dealing with numbers

Dealing with dates

Dealing with string data

Dealing with boolean data

Part 3. The shape of data. Profiling data

Sampling data sets

Pivoting columns to rows

Pivoting rows to columns

Aggregating in prep builder

Joining data sets together

Unioning

Calculations

Part 4. Output. Choosing an output

Outputting to da database

Getting started with Tableau

Part 5. Cleaning data. Creating additional data

Filtering

Removing data during input

Splitting data fields

Cleaning by grouping data

Dealing with nulls

Using data roles

Dealing with unwanted characters

Deduplicating

Using regular expressions

Completing advanced joins

Creating leveel of detail calculations

Doing analytical calculations

Part 6. Beyond the basics. Breaking down complex data preparation challenges

Handling free text

Using smarter filtering

Managing conversion rates

Scaffolding your data

Connecting to programming scripts

Handling prep builder errors

Part 7. Managing your data. Documenting your data preparation

Deciding where to prepare your data

Managing data

Storing your data

Using identifiers and keys in data

Keeping your data up-to-date

Using history tables

Evaluating whether you need prep builder at all

Final thoughts.

Notes:

Includes index.

Description based on print version record.

ISBN:

9781492079590

1492079596

9781492079613

1492079618

OCLC:

1184041063