Carl Allchin - Tableau Prep

by Carl Allchin

Copyright 2020 Carl Allchin. All rights reserved.

Printed in the United States of America.

Published by OReilly Media, Inc. , 1005 Gravenstein Highway North, Sebastopol, CA 95472.

OReilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (http://oreilly.com). For more information, contact our corporate/institutional sales department: 800-998-9938 or corporate@oreilly.com.

• Acquisitions Editor: Michelle Smith
• Development Editor: Angela Rufino
• Production Editor: Daniel Elfanbaum
• Copyeditor: Rachel Monaghan
• Proofreader: Piper Editorial, LLC
• Indexer: Judith McConville
• Interior Designer: David Futato
• Cover Designer: Karen Montgomery
• Illustrator: OReilly Media, Inc.

• September 2020: First Edition

See http://oreilly.com/catalog/errata.csp?isbn=9781492079620 for release details.

The OReilly logo is a registered trademark of OReilly Media, Inc. Tableau Prep: Up & Running, the cover image, and related trade dress are trademarks of OReilly Media, Inc.

The views expressed in this work are those of the author, and do not represent the publishers views. While the publisher and the author have used good faith efforts to ensure that the information and instructions contained in this work are accurate, the publisher and the author disclaim all responsibility for errors or omissions, including without limitation responsibility for damages resulting from the use of or reliance on this work. Use of the information and instructions contained in this work is at your own risk. If any code samples or other technology this work contains or describes is subject to open source licenses or the intellectual property rights of others, it is your responsibility to ensure that your use thereof complies with such licenses and/or rights.

978-1-492-07962-0

[LSCH]

Data is everywhere, but for most people its largely unusable for these key reasons:

• Some data is stored in databases hidden behind a coding language that the majority of the workforce have never been taught.

• Some data lurks on individuals computers stored away from those who might find it useful.

• Some data is held in formats that only the developer of the system that created it could read.

So why should you care about this? Frankly, that data holds the answers to questions you have and questions you have yet to even ask. Self-service data preparation is a skill that will change what data analyses you can undertake, reduce the time you need to complete data projects, and fundamentally improve the quality of your analyses.

This book aims to teach you how to access this data and turn it into information to answer those questions using one of the most user-intuitive tools on the marketTableau Prep Builder. Released in April 2018 to support Tableau Desktop, Server, and Online users, Tableau Prep Builder enables you to turn messy data into a format where it can be analyzed in Tableaus software. Tableau Desktop, Server, and Online are software platforms that make data easy to explore and analyze visually.

Previously, the largest gap in Tableaus flow from source system to delivering insightful analysis was manipulating the data into a format thats easy to use. Tableau, like the majority of business intelligence tools, requires the data to be clean and structured into rows and columns. Many analysts used to take on this manual work themselves, hence the need to automate this task and spend that valuable time on the actual analysis instead.

Tableau Prep Builder allows users to easily clean, manipulate, and output data sets that are ready for analysis. Not only that, but Tableau has also embedded a number of its visual analytical approaches within the software so that users can often find the answers to their questions in Prep Builder without having to export the data at all.