Preface
When Tableau was first introduced, it was a dramatic paradigm shift away from clunky reports and endless data integration projects that often produced results long after relevant decisions could have been made. Tableau disrupted the paradigm for visually interacting with data. It made it easy and intuitive (and fun!) to be hands-on with the data, to receive instant visual feedback with every action, and to ask questions and uncover insights in a natural flow of thought and interaction. The result is an ever-growing #datafam, a community that loves Tableau for its simplicity, beauty, and its ability to make working with data fun!
Tableau continues to expand and evolve in ways that make seeing and understanding data easier and more powerful. New features such as the Tableau Data Model, set and parameter actions, ever-growing geospatial support, animations, and new dashboard objects expand what's possible and make it easier than ever to gain and share insights from data.
The continued evolution of Tableau Prep brings the same intuitive instant feedback to data prep and cleansing that Tableau Desktop brought to data visualization, greatly extending the analytical platform of Tableau. We'll cover these new features (and more) in the chapters of this book!
We'll look at Tableau through the lens of understanding the underlying paradigm of how and why Tableau works, in the context of practical examples. Then, we'll build on this solid foundation of understanding so that you will have the tools and skills to tackle even the toughest data challenges!
Who this book is for
This book is for anyone who needs to see and understand their data! From the business user to the hardcore data analyst to the CEO, everyone needs to have the ability to ask and answer questions of data. Having a bit of background with data will definitely help, but you don't need to be confident with scripting, SQL, or database structures.
Whether you're new to Tableau, or have been using it for months or even years, with this book you'll gain a solid foundation of understanding Tableau, and the tools and skills required to build toward an advanced mastery of the tool.
What this book covers
Chapter 1, Taking Off with Tableau, introduces the foundational principles of Tableau. We'll walk through multiple examples in a logical progression that will introduce everything—from the interface, to connecting to data, to building your first visualization and even a dashboard. This chapter will give you a solid foundation for the terminology and concepts that will be used throughout the book.
Chapter 2, Connecting to Data in Tableau, using several practical examples, this chapter covers the foundational concepts involved in connecting to data. It covers the various types of connections, file types, cloud-based and on-premise databases, and how to work with metadata.
Chapter 3, Moving Beyond Basic Visualizations, builds on the basic visualization principles covered in the first chapter to explore variations and extended possibilities. You will learn when and how to use a wide variety of visualizations to analyze and communicate data.
Chapter 4, Starting an Adventure with Calculations and Parameters, introduces calculations and parameters, giving an overview of the major types of calculations, and then detailed examples of row-level and aggregate calculations. It combines conceptual knowledge with practical examples, and concludes with performance considerations.
Chapter 5, Leveraging Level of Detail Calculations, takes an in-depth look at level of detail expressions and how to use them to solve complex data challenges. It not only gives an overview, but dives into examples of FIXED, INCLUDE, and EXCLUDE variations.
Chapter 6, Diving Deep with Table Calculations, gives you a strong foundation for understanding and using table calculations to solve a wide range of data challenges. It covers the concepts of scope and direction, addressing and partitioning, and walks through several in-depth practical examples.
Chapter 7, Making Visualizations That Look Great and Work Well, covers how to extend and alter the default formatting applied to visualizations by Tableau, to customize options such as font, color, lines, shading, annotations, and tooltips to effectively communicate a data story.
Chapter 8, Telling a Data Story with Dashboards, builds on concepts that were introduced in the first chapter and expanded on throughout, walking through several practical examples of various kinds of dashboards to help you gain a solid understanding of what a dashboard is, how to build one and make it interactive, and how to use it to tell a compelling data story.
Chapter 9, Visual Analytics – Trends, Clustering, Distributions, and Forecasting, introduces the visual and statistical analytics capabilities built into Tableau and supplies you with practical examples of how and when to leverage these capabilities. This includes adding and modifying trend models, leveraging clustering capabilities, using and modifying forecast models, and visualizing the distribution of data. You will not only understand how to employ statistical models, but also evaluate their accuracy.
Chapter 10, Advanced Visualizations, builds upon the visualizations and techniques already covered, demonstrating how Tableau can be used to create any kind of visualization. A multitude examples demonstrate a wide variety of advanced visualizations, from bump charts to Marimekko charts to animated visualizations.
Chapter 11, Dynamic Dashboards, builds your dashboard skills by demonstrating various techniques to show, hide, and swap content on a dashboard. The result is a truly dynamic user experience that enhances your ability to communicate data.
Chapter 12, Exploring Mapping and Advanced Geospatial Features, demonstrates everything about maps and geospatial visualization, from map basics to geospatial functions, custom territories, and plotting data on custom background images.
Chapter 13, Understanding the Tableau Data Model, Joins, and Blends, explores the major ways of relating data in Tableau, including the new Data Model capabilities introduced in Tableau 2020.2. With practical examples and detailed descriptions, you will understand the difference between logical and physical layers and how to leverage relationships, joins, and blends to achieve great analytical results.
Chapter 14, Structuring Messy Data to Work Well in Tableau, acknowledges that real-world data is sometimes a mess and gives you a foundation for understanding well-structured data and a toolset for dealing with data that isn't structured well in Tableau.
Chapter 15, Taming Data with Tableau Prep, explores the Tableau Prep Builder tool, including the overall paradigm and specific features. You will work through an extended practical example to understand how to leverage Tableau Prep's amazing ability to clean and structure data.
Chapter 16, Sharing Your Data Story, concludes the book with a look at a wide range of options for sharing your story. From printing to sharing interactive dashboards to output PDFs and images—you'll be ready to share the stories contained in your data with those who need it most.
To get the most out of this book
This book does not assume specific database knowledge, but it will definitely help to have some basic familiarity with data itself. We'll cover the foundational principles first, and while it may be tempting to skip the first chapter, please don't! We'll lay a foundation of terminology and explore the paradigm that will be used throughout the remainder of the book.
You'll be able to follow along with many of the examples in the book using Tableau Desktop and Tableau Prep Builder (in Chapter 15, Taming Data with Tableau Prep).
Most examples can be completed with almost any recent version of Tableau, but to fully explore the new Data Model capabilities, you will need Tableau 2020.2 or later.
You may download and install the most recent versions from Tableau using these links:
Tableau Desktop: https://www.tableau.com/products/desktop/download
Tableau Prep Builder: https://www.tableau.com/products/prep/download
Please speak to a Tableau representative for specific licensing information. In most cases, you may install a 14-day trial of each product if you do not currently have a license.
Depending on the terms of your license, Tableau also typically allows you to use your license on two machines. This means you might have Tableau installed at the office (perhaps even an older version) but can also install the latest version on your home machine. Check your licensing agreement and speak to a Tableau representative to verify details in your case.
Download the example code files
You can download the example code files for this book from your account at http://www.packtpub.com. If you purchased this book elsewhere, you can visit http://www.packtpub.com/support and register to have the files emailed directly to you.
You can download the code files by following these steps:
- Log in or register at http://www.packtpub.com.
- Select the SUPPORT tab.
- Click on Code Downloads & Errata.
- Enter the name of the book in the Search box and follow the on-screen instructions.
Once the file is downloaded, please make sure that you unzip or extract the folder using the latest version of:
- WinRAR / 7-Zip for Windows
- Zipeg / iZip / UnRarX for Mac
- 7-Zip / PeaZip for Linux
The code bundle for the book is also hosted on GitHub at https://github.com/PacktPublishing/Learning-Tableau-2020. We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!
Download the color images
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here: https://static.packt-cdn.com/downloads/9781800200364_ColorImages.pdf.
Conventions used
There are a number of text conventions used throughout this book.
CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. For example; "Connect to Hospital Visits.xlsx and generate an extract."
A block of code is set as follows:
IF LEFT([Room], 1) = "1"
THEN "First Floor"
ELSEIF LEFT([Room], 1) = "2"
THEN "Second Floor"
END
Bold: Indicates a new term, an important word, or words that you see on the screen, for example, in menus or dialog boxes, also appear in the text like this. For example: "Select Table Layout | Advanced from the Analysis menu."
Warnings or important notes appear like this.
Tips and tricks appear like this.
Get in touch
Feedback from our readers is always welcome.
General feedback: Email feedback@packtpub.com, and mention the book's title in the subject of your message. If you have questions about any aspect of this book, please email us at questions@packtpub.com.
Errata: Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you have found a mistake in this book we would be grateful if you would report this to us. Please visit, http://www.packtpub.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details.
Piracy: If you come across any illegal copies of our works in any form on the Internet, we would be grateful if you would provide us with the location address or website name. Please contact us at copyright@packtpub.com with a link to the material.
If you are interested in becoming an author: If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, please visit http://authors.packtpub.com.
Reviews
Please leave a review. Once you have read and used this book, why not leave a review on the site that you purchased it from? Potential readers can then see and use your unbiased opinion to make purchase decisions, we at Packt can understand what you think about our products, and our authors can see your feedback on their book. Thank you!
For more information about Packt, please visit packtpub.com.