Tableau: Creating Interactive Data Visualizations - Jen Stirrup - E-Book

Tableau: Creating Interactive Data Visualizations E-Book

Jen Stirrup

0,0
70,79 €

-100%
Sammeln Sie Punkte in unserem Gutscheinprogramm und kaufen Sie E-Books und Hörbücher mit bis zu 100% Rabatt.

Mehr erfahren.
Beschreibung

Illustrate your data in a more interactive way by implementing data visualization principles and creating visual stories using Tableau

About This Book

  • Use data visualization principles to help you to design dashboards that enlighten and support business decisions
  • Integrate your data to provide mashed-up dashboards
  • Connect to various data sources and understand what data is appropriate for Tableau Public
  • Understand chart types and when to use specific chart types with different types of data

Who This Book Is For

Data scientists who have just started using Tableau and want to build on the skills using practical examples. Familiarity with previous versions of Tableau will be helpful, but not necessary.

What You Will Learn

  • Customize your designs to meet the needs of your business using Tableau
  • Use Tableau to prototype, develop, and deploy the final dashboard
  • Create filled maps and use any shape file
  • Discover features of Tableau Public, from basic to advanced
  • Build geographic maps to bring context to data
  • Create filters and actions to allow greater interactivity to Tableau Public visualizations and dashboards
  • Publish and embed Tableau visualizations and dashboards in articles

In Detail

With increasing interest for data visualization in the media, businesses are looking to create effective dashboards that engage as well as communicate the truth of data. Tableau makes data accessible to everyone, and is a great way of sharing enterprise dashboards across the business. Tableau is a revolutionary toolkit that lets you simply and effectively create high-quality data visualizations.

This course starts with making you familiar with its features and enable you to develop and enhance your dashboard skills, starting with an overview of what dashboard is, followed by how you can collect data using various mathematical formulas. Next, you'll learn to filter and group data, as well as how to use various functions to present the data in an appealing and accurate way.

In the first module, you will learn how to use the key advanced string functions to play with data and images. You will be walked through the various features of Tableau including dual axes, scatterplot matrices, heat maps, and sizing.In the second module, you'll start with getting your data into Tableau, move onto generating progressively complex graphics, and end with the finishing touches and packaging your work for distribution. This module is filled with practical examples to help you create filled maps, use custom markers, add slider selectors, and create dashboards. You will learn how to manipulate data in various ways by applying various filters, logic, and calculating various aggregate measures. Finally, in the third module, you learn about Tableau Public using which allows readers to explore data associations in multiple-sourced public data, and uses state-of-the-art dashboard and chart graphics to immerse the users in an interactive experience. In this module, the readers can quickly gain confidence in understanding and expanding their visualization, creation knowledge, and quickly create interesting, interactive data visualizations to bring a richness and vibrancy to complex articles.

The course provides a great overview for beginner to intermediate Tableau users, and covers the creation of data visualizations of varying complexities.

Style and approach

The approach will be a combined perspective, wherein we start by performing some basic recipes and move on to some advanced ones. Finally, we perform some advanced analytics and create appealing and insightful data stories using Tableau Public in a step-by-step manner.

Sie lesen das E-Book in den Legimi-Apps auf:

Android
iOS
von Legimi
zertifizierten E-Readern

Seitenzahl: 638

Veröffentlichungsjahr: 2016

Bewertungen
0,0
0
0
0
0
0
Mehr Informationen
Mehr Informationen
Legimi prüft nicht, ob Rezensionen von Nutzern stammen, die den betreffenden Titel tatsächlich gekauft oder gelesen/gehört haben. Wir entfernen aber gefälschte Rezensionen.



Table of Contents

Tableau: Creating Interactive Data Visualizations
Tableau: Creating Interactive Data Visualizations
Credits
Preface
What this learning path covers
What you need for this learning path
Who this learning path is for
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Module 1
1. A Short Dash to Dashboarding!
Introduction
Preparing for your first dashboard
How to do it...
How it works…
See also
Showing the power of data visualization
Getting ready
How to do it…
How it works…
There's more…
See also
Connecting to data sources
Getting ready
How to do it…
How it works…
There's more…
See also
Introducing the Tableau interface
Getting ready
How to do it…
How it works…
See also
Interacting with your first data visualization
Getting ready
How to do it...
How it works…
There's more…
Sharing your visualization with the world
Getting ready
How to do it…
How it works…
There's more…
2. Summarizing Your Data for Dashboards
Introduction
Arithmetic – the queen of mathematics!
Getting ready
How to do it...
How it works…
There's more…
Dashboards and dates
Getting ready
How to do it...
How it works…
There's more…
Grouping your data with calculations
Getting ready
How to do it...
How it works...
Correlation with calculations
Getting ready
How to do it...
How it works...
There's more...
Using cross-tabs flexibly
Getting ready
How to do it...
How it works...
There's more...
Simplifying your business rules with customer calculations
Getting ready
How to do it...
How it works…
There's more…
3. Interacting with Data for Dashboards
Introduction
Fun with filters – grouping your data with clarity
Getting ready
How to do it...
How it works...
See also
Hierarchies for revealing the dashboard message
Getting ready
How to do it...
How it works…
There's more...
See also
Classifying your data for dashboards
Getting ready
How to do it...
How it works...
See also
Actions and interactions
Getting ready
How to do it...
How it works...
See also
Drilling into the details
Getting ready
How to do it...
How it works...
Working with input controls
Getting ready
How to do it...
How it works...
There's more...
4. Using Dashboards to Get Results
Introduction
Enriching data with mashups
Getting ready
How to do it…
How it works…
There's more…
Page trails
Getting ready
How to do it…
How it works…
There's more…
See also
Guided analytics with Tableau
Getting ready…
How to do it…
How it works…
See Also
Sharing your results in a meeting
Getting ready
How to do it...
How it works…
Notes and annotations
Getting ready
How to do it…
Using external data to enrich your dashboard
Getting ready
How to do it…
How it works...
5. Putting the Dash into Dashboards
Introduction
Choosing your visualization
Getting ready
How to do it...
How it works...
There's more...
Using parameters in dashboards
Getting ready
How to do it...
How it works...
Using custom geocoding in Tableau
Getting ready
How to do it…
How it works...
See also
Profiting from Big Data to rev your visualization
Getting ready
How to do it…
How it works...
There's more...
Filtering your data for focus
Getting ready
How to do it…
How it works...
There's more...
See also
Creating choices in dashboards using conditional logic
Getting ready
How to do it...
How it works...
There's more…
6. Making Dashboards Relevant
Introduction
Adding an infographic to your Tableau dashboard
Getting ready
How to do it…
How it works…
There's more…
String manipulation in dashboards
Getting ready
How to do it…
How it works…
Correcting data exports from Tableau to Excel
Getting ready
How to do it…
How it works…
Blending data
Getting ready
How to do it…
How it works…
Optimizing tips for efficient, fast visualization
Getting ready
How to do it…
How it works…
7. Visual Best Practices
Introduction
Coloring your numbers
Getting ready
How to do it…
How it works…
See also
Dueling with dual axes
Getting ready
How to do it…
How it works…
There's more…
Where is the three dimensional data?
Getting ready
How to do it…
Eating humble pie – pie charts or not?
Getting ready
How to do it…
How it works…
See also
Sizing to make a data story
Getting ready
How to do it…
How it works…
See also
2. Module 2
1. Connecting to Data Sources
Introduction
Connecting to text files
Getting ready
How to do it...
How it works…
There's more...
Connecting to Excel files
Getting ready
How to do it...
How it works...
There's more...
Connecting to Access databases
Getting ready
How to do it...
How it works...
Connecting to a SQL Server
Getting ready
How to do it...
How it works...
Pasting from a clipboard
Getting ready
How to do it...
How it works...
There's more...
Connecting to other databases
Getting ready
How to do it...
How it works...
There's more...
Connecting to Windows Azure Marketplace
Getting ready
How to do it...
How it works....
There's more...
Understanding dimensions and measures
Changing data types
Getting ready
How to do it....
How it works...
Applying filters
Getting ready
How to do it...
How it works...
Merging multiple data sources
Getting ready
How to do it...
How it works...
There's more...
2. Creating Univariate Charts
Introduction
Creating tables
Getting ready
How to do it...
How it works...
Creating bar graphs
Getting ready
How to do it...
How it works...
Creating pie charts
Getting ready
How to do it...
How it works...
Sorting the graphs
Getting ready
How to do it...
How it works....
Creating histograms
Getting ready
How to do it...
How it works...
Creating line charts
Getting ready
How to do it...
How it works...
Using the Show Me toolbar
Getting ready
How to do it...
How it works....
Creating stacked bar graphs
Getting ready
How to do it...
How it works...
Creating box plots
Getting ready
How to do it...
How it works...
Showing aggregate measures
Getting ready
How to do it...
How it works...
Showing the top 10 items
Getting ready
How to do it...
How it works...
3. Creating Bivariate Charts
Introduction
Creating tables
Getting ready
How to do it....
How it works....
There's more...
Creating scatter plots
Getting ready
How to do it....
How it works...
There's more...
Swapping rows and columns
Getting ready
How to do it...
How it works...
Adding trend lines
Getting ready
How to do it...
How it works....
There's more...
Selecting color palettes
Getting ready
How to do it...
How it works...
There's more...
Using dates
Getting ready
How to do it....
How it works...
4. Creating Multivariate Charts
Introduction
Creating facets
Getting ready
How to do it...
How it works...
There's more...
Creating area charts
Getting ready
How to do it...
How it works…
There's more...
Creating bullet graphs
Getting ready
How to do it...
How it works...
There's more...
Creating dual axes charts
Getting ready
How to do it...
How it works...
Creating Gantt charts
Getting ready
How to do it...
How it works...
There's more...
Creating heat maps
Getting ready
How to do it...
How it works...
5. Creating Maps
Introduction
Setting geographic roles
Getting ready
How to do it...
How it works...
There's more...
Placing marks on a map
Getting ready
How to do it...
How it works...
Overlaying demographic data
Getting ready
How to do it...
How it works...
There's more...
Creating choropleth maps
Getting ready
How to do it...
How it works...
Using polygon shapes
Getting ready
How to do it...
How it works...
Customizing maps
Getting ready
How to do it...
How it works...
6. Calculating User-defined Fields
Introduction
Using predefined functions
Getting ready
How to do it...
How it works...
There's more...
Calculating percentages
Getting ready
How to do it...
How it works...
Applying the If-Then logic
Getting ready
How to do it...
How it works...
Applying logical functions
Getting ready
How to do it...
How it works...
Showing totals
Getting ready
How to do it...
Showing the percentage of totals
Getting ready
How to do it...
There's more...
Discretizing data
Getting ready
How to do it...
How it works...
Manipulating text
Getting ready
How to do it...
How it works...
Aggregating data
Getting ready
How to do it...
7. Customizing and Saving
Introduction
Adding title and caption
Getting ready
How to do it...
Modifying font sizes and colors
Getting ready
How to do it...
Applying various marks
Getting ready
How to do it...
How it works...
Adding colors
Getting ready
How to do it...
How it works...
Adding labels
Getting ready
How to do it...
How it works...
Changing marks sizes
Getting ready
How to do it...
Adding reference lines
Getting ready
How to do it...
Printing to PDF
Getting ready
How to do it...
Saving packaged workbooks
Getting ready
How to do it...
Creating a workbook data extract
Getting ready
How to do it...
There's more...
8. Exporting and Sharing
Introduction
Saving a workbook on a Tableau server
Getting ready
How to do it...
Saving a workbook on the Web
Getting ready
How to do it...
Exporting images
Getting ready
How to do it...
Exporting data
Getting ready
How to do it...
How it works...
9. Exploring Advanced Features
Introduction
Viewing data
Getting ready
How to do it...
Changing the mark size
Getting ready
How to do it...
Using the presentation mode
Getting ready
How to do it...
Adding annotations
Getting ready
How to do it...
Excluding data on the fly
Getting ready
How to do it...
Customizing mark shapes
Getting ready
How to do it...
Adding drop-down selectors
Getting ready
How to do it...
Adding search box selectors
Getting ready
How to do it...
Adding slider selectors
Getting ready
How to do it...
Creating dashboards
Getting ready
How to do it...
Creating animated visualizations
Getting ready
How to do it...
Creating parameters
Getting ready
How to do it...
3. Module 3
1. Getting Started with Tableau Public
A Tableau Public overview
Telling your story with Tableau Public
Installing Tableau Public
Exploring Tableau Public
Connecting to data
Opening files and creating your profile
Discover
Exploring the visualizations of other authors
Summary
2. Tableau Public Interface Features
Touring the Tableau Public user interface
The side bar
The Data pane
Visual cues
The Analytics pane
Menus and toolbars
Canvas and Column/Row shelves
Using the Columns and Rows shelves
Using the Marks card
The Filters and Pages shelves
The workspace control tabs of Tableau Public
The Show Me tool
Summary
3. Connecting to Data
Public data
Tables and databases
The data sources that Tableau Public connects to
The databases, tables, dimensions, facts, field formats and conventions
Connecting to the data in Tableau Public
The data source user interface
Using the data interpreter
Pivoting data
Filtering data sources
Joining tables
Connecting to web-based data sources
Summary
4. Visualization – Tips and Types
An overview of the development lifecycle
Ten visualization tips
The perception of visual clues
Using the Show Me tool to create charts
Answering questions using Show Me chart types
About dimensions and measures
Continuous and discrete dimensions and measures
Selecting aggregation types for measures
Swapping and sorting
Types of visualization
Line graphs
Continuous versus discrete date-time elements
Tables
Bar charts
Geographic maps
Scatter plots
Pie charts
Using groups and sets
Summary
5. Calculations
Creating calculated fields
Editing calculated fields
Types of calculations
The number functions
The date functions
Type conversions
The string functions
The aggregate functions
The logic functions
Blending data sources
Summary
6. Level of Detail and Table Calculations
About data sources
Creating quick table calculations
Changing over time
Compute using
Moving average
Editing table calculations
Manually editing table calculations
Ranking
Window versus running functions
A note on addressing
The level of detail calculations
A FIXED LOD calculation
The INCLUDE and nested LOD calculations
Summary
7. Dashboard Design and Styling
The dashboard design process
Best practices for dashboard design
Creating a dashboard
The dashboard tab interface
Layout objects
Setting the size of dashboard elements
Sizing the dashboard
Building a dashboard
Summary
8. Filters and Actions
Adding and using Filters
Adding Filters to worksheets
Adding Quick Filters to a dashboard
Moving the Quick Filter
Filtering across Data sources with parameters
Using parameters as Filters
Modifying titles
Filtering across multiple Data sources with parameters
Actions
URL actions
Summary
9. Publishing Your Work
Saving your work and logging in to Tableau Public
Opening work from the Cloud
Managing your profile
Viewing your work online
Managing workbook details
Summary
A. Bibliography
Index

Tableau: Creating Interactive Data Visualizations

Tableau: Creating Interactive Data Visualizations

Illustrate your data in a more interactive way by implementing data visualization principles and creating visual stories using Tableau

A course in three modules

BIRMINGHAM - MUMBAI

Tableau: Creating Interactive Data Visualizations

Copyright © 2016 Packt Publishing

All rights reserved. No part of this course may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this course to ensure the accuracy of the information presented. However, the information contained in this course is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this course.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this course by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

Published on: August 2016

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN: 978-1-78712-419-6

www.packtpub.com

Credits

Authors

Jen Stirrup

Ashutosh Nandeshwar

Ashley Ohmann

Matt Floyd

Reviewers

Shweta Savale

Darwin Witt

Victor Blær

Mohanganeesh Dorairaj

Joshua N. Milligan

Content Development Editor

Abhishek Jadhav

Graphics

Kirk D'Phena

Production Coordinator

Shantanu N. Zagade

Preface

With increasing interest for data visualization across the media, businesses are looking to design constructive dashboards that captivate the interest as well as liaise data. Tableau makes data available to everyone, and is a great way of dispensing enterprise dashboards across the business. Tableau is an extensive toolkit that lets you create high quality data visualizations effectively.

What this learning path covers

Module 1, Tableau Dashboard, introduces you to the theory and practice of delivering dashboards using Tableau through a step-by-step process of creating the building blocks of a dashboard. We then proceed towards the designing principles of putting the dashboard items together. You will learn how to summarize data as a way of conveying key messages on your dashboard along with the introduction to calculations. This module will facilitate structured investigation of data using guided analysis in Tableau. We will also focus on the graphical presentation of data using sparklines, KPIs, maps, and so on. Towards the end of the module, we will look at theming and adding more details to the dashboard by providing examples of more advanced features of Tableau.

Module 2, Data Visualization with Tableau, acquaints you with Tableau's user interface and creates perspicacious visualizations. In this module we start off by connecting various data sources, including text, Excel, as well as data sources on a Server. We move on further to create univariate, bivariate, and multivariate charts. This module will also help you create maps by setting geographic variables, placing markers, and overlaying demographic data. We will create new fields using predefined functions, calculate percentages, apply the if-then logic, discretize and aggregate data, manipulate text, and so on. You will be able to modify visualizations by adding information, changing the default marker size and shape settings. Finally, we not only learn to export images and data from the workbook and share them on the Web, but we also explore some of the advanced features of Tableau, such as customizing marker shapes, adding various selectors, and creating animated visualizations.

Module 3, Creating data stories with Tableau Public, provides guidelines on how to pursue an enthralling, rich story with data that will enlighten others. By the end of this module, we will create an ideal example of a dashboard that focuses on an issue that impacts everyone. We begin with an overview of the functions of Tableau Public along with its installation. Furthermore, you will be familiarized with various features in Tableau Public, such as cards, shelves, and ShowMe. This module will teach you how to format source data and explain some basic data modeling, such as Dimensions, Measures, and Joins. Topics such as Visualization, Calculation and Dashboard designing, which are studied in the previous modules, will be covered in detail. Finally, the module will explain how to build filters with their use in dashboards and familiarize you with the various methods to embed data visualization in blog posts, websites, and offline documents

What you need for this learning path

You need the following in order to work with Tableau:

Tableau Version 8.2Windows Live login ID and passwordMicrosoft ExcelInternet access

Users only need to download the Tableau Public client. The technical specifications for Tableau Public mirror those of Tableau Desktop Personal and are listed on the Tableau website at http://www.tableau.com/products/desktop. According to Tableau system requirements, PC users require the following minimum specifications:

Microsoft Windows Vista SP2 or newer (32-bit and 64-bit)Microsoft Server 2008 R2 or newer (32-bit and 64-bit)Intel Pentium 4 or AMD Opteron processor or newer (SSE2 or newer required)2 GB memory750 megabytes minimum free disk space

Who this learning path is for

Data scientists who have just started using Tableau and want to build on the skills using practical examples. Familiarity with previous versions of Tableau will be helpful, but not necessary.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or disliked. Reader feedback is important for us as it helps us develop titles that you will really get the most out of.

To send us general feedback, simply e-mail <[email protected]>, and mention the book's title in the subject of your message.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide at www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Downloading the example code

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 e-mailed directly to you.

You can download the code files by following these steps:

Log in or register to our website using your e-mail address and password.Hover the mouse pointer on the SUPPORT tab at the top.Click on Code Downloads & Errata.Enter the name of the book in the Search box.Select the book for which you're looking to download the code files.Choose from the drop-down menu where you purchased this book from.Click on Code Download.

You can also download the code files by clicking on the Code Files button on the book's webpage at the Packt Publishing website. This page can be accessed by entering the book's name in the Search box. Please note that you need to be logged in to your Packt account.

Once the file is downloaded, please make sure that you unzip or extract the folder using the latest version of:

WinRAR / 7-Zip for WindowsZipeg / iZip / UnRarX for Mac7-Zip / PeaZip for Linux

The code bundle for the book is also hosted on GitHub at https://github.com/PacktPublishing/Tableau-Creating-Interactive-Data-Visualizations. We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you could report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded to our website or added to any list of existing errata under the Errata section of that title.

To view the previously submitted errata, go to https://www.packtpub.com/books/content/support and enter the name of the book in the search field. The required information will appear under the Errata section.

Piracy

Piracy of copyrighted material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works in any form on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at <[email protected]> with a link to the suspected pirated material.

We appreciate your help in protecting our authors and our ability to bring you valuable content.

Questions

If you have a problem with any aspect of this book, you can contact us at <[email protected]>, and we will do our best to address the problem.

Part 1. Module 1

Tableau Dashboard

Over 40 recipes for designing professional dashboards by implementing data visualization techniques

Chapter 1. A Short Dash to Dashboarding!

In this chapter, we will cover:

Preparing for your first dashboardShowing the power of data visualizationConnecting to data sourcesIntroducing the Tableau interfaceInteracting with your first data visualizationSharing your visualization with the world

Introduction

This chapter starts with you being a Tableau beginner, then quickly moves you forward to creating your own visualizations and explains how to interact with the Tableau sample dashboards—how to find, open, and interact with them.

We can create visualizations by using Tableau in order to produce meaningful dashboards that communicate clearly. The six recipes in this chapter will explain how we can get up to speed with Tableau very quickly in order to produce dashboards that facilitate and expedite the decision-making process for strategic decision makers and operational team members within your organization.

Tip

For this book, we will be using version 8.1 to work with Tableau.

Preparing for your first dashboard

The following definition has been taken from the Intelligent Enterprise magazine's March 2004 issue:

 

A dashboard is a visual display of the most important information needed to achieve one or more objectives; consolidated and arranged on a single screen so the information can be monitored at a glance.

  --Stephen Few

For an enterprise, a dashboard is a visual tool to help team members throughout the ranks of the organization to track, monitor, and analyze the information about the organization in order to make decisions to support its current and future prosperity. In this recipe, we will interact with Tableau's sample dashboards, which are constructed from worksheets. People often learn by example, and this is a straightforward way of inspiring you with dashboard samples while also learning about Tableau.

What do dashboards help you to do?

Evaluate: Dashboards answer questions such as "Have the goals and objectives been met? Are we on track?"Reveal: Dashboards help you view and digest information very quickly, which means you have more time for strategic planning.Communicate: Using a visual tool can help to get the message across in a common format and create impact.Certainty: Dashboards help you to have confidence in your insights.

Dashboards help key team members to gain insights and discern the health of the organization very quickly. Tracking, monitoring, and analyzing the organization's data is an essential part of making accurate decisions.

Tableau provides a number of example dashboards, both online and as part of the Tableau Desktop installation. We will find, open, and interact with sample Tableau dashboards.

We can also use the example dashboards as a basis to make our own dashboards. They can form a source of inspiration to make your own compelling visualizations. For the purpose of this recipe, we will focus on the sample Sales workbook.

A key feature of dashboards is that they are interactive. There are different types of dashboards, and some references are included at the end of this recipe. A key feature of dashboards is their interactivity. Dashboards are not simply a set of reports on a page; they should tell a story about the business when they are put together. They should answer a clear business question. In order to facilitate the decision-making process, interactivity is an important part of assisting the decision-maker to get to the heart of the analysis as quickly as possible.

Fortunately, it is straightforward to interact with a dashboard that has been implemented in Tableau.

How to do it...

We will perform the following steps to see how we can interact with a dashboard:

Open up the Tableau Desktop and you can see the Getting Started page. The following screenshot is an example:At the bottom of the entry page, you can see a section called Sample Workbooks that contains some examples.Let's take a look at the Sales dashboard. If you double-click on the Sales example, it will open and you will see the sample Sales dashboard, as shown in the following screenshot:A worksheet is like a tab in Excel; it is a data visualization on its own. A workbook, on the other hand, is a collection of worksheets. In Tableau, a dashboard allows you to combine and manipulate the worksheets together. Let's interact with this dashboard straightaway using the Sales dashboard sample that has been provided by Tableau. On the right-hand side of the dashboard, you can see a box called Sort by. You can see an example of this in the following screenshot, where the relevant section has been highlighted with a box:

When you click on the middle item, denoted as % quota descending, you can see that the horizontal bar charts in the main area of the dashboard change very quickly in response to the user interaction. The dashboard now looks quite different from the previous Tableau example, where the bars were sorted by Names. The rapidity of the change means that decision makers can "think as they click" in order to focus on their analysis.

There are a number of different ways in which Tableau can offer useful interactivity for dashboards. For example, we can include sliders, filtering by color, moving from dashboard to dashboard, radio buttons, drop-down lists, and timelines. For example, another interesting feature is that users can enter values into parameters in order to see the impact of their activity. A parameter is a dynamic value that responds to user input. In this example, we use it to filter the data by replacing constant values in calculations. We use the following steps to view the interactivity:

Let's see the impact of interactivity on the performance information given by the dashboard. In the Sales dashboard, increase the New quota level to $1,000,000.Next, increase the value in the Commission rate textbox to 15.0% by moving the slider to the right.Decrease the base salary to $40,000 by inserting this value in the Base salary textbox. Note that the estimated results are now quite different. You can see from the following screenshot that the number of people making the sales target decreases, and the chart now shows a significant increase in the number of people nearing their target or missing it altogether:

In the previous screenshot, note that the colors of the Estimated Results with These Assumptions bars have changed so that all of them now show red or yellow. The green bars have disappeared. This gives a visual cue that the estimated results have changed considerably for the worse after we made changes to the filter. We can also see this due to the presence of the target line, which shows whether the individual met his/her target or not. The following screenshot depicts this:

How it works…

Tableau gives you a series of sample dashboards as part of the installation. You can also see more samples online. Some samples are provided by Tableau team members, and you can also visit the Tableau website for samples submitted by keen data visualization fans from around the world. These samples can help to inspire your own work.

In this topic, we compared the changes on a dashboard in order to see how Tableau responded to changes. We noted that the color has changed along with the values. The dashboard provides quick feedback that the values do not change favorably for the new quotes, commissions, and base salary. When decision makers are interacting with dashboards, they are expecting quick-as-a-flash responsiveness from the dashboard, and the sample Tableau dashboards meet this expectation well.

See also

Tableau offers a number of sample dashboards on its website, and it is worthwhile to check the site for ideas and brainstorming for your own dashboards. Please take a look at www.tableausoftware.com for examples. If you are interested in dashboard theory in general, then you can look at the following references:

Dashboard Confusion byStephen Few, Intelligent Enterprise, 20045 Best Practices for Creating Effective Dashboards by Tableau Software (http://www.tableausoftware.com/learn/whitepapers/5-best-practices-for-effective-dashboards)

Showing the power of data visualization

Dashboards rely on the power of visualization in order to let people see the message of the data to make effective decisions. How can you show the power of a dashboard when compared to a crosstab table?

In this recipe, we will see how a data visualization can have more impact than a straightforward crosstab. We will make a crosstab table in Tableau and then turn it into a data visualization to see the impact in action!

Understanding your data is an essential part of data visualization, regardless of the technology you are using. Tableau can help you to understand your data by automatically distinguishing between measures and dimensions. How do you know which are which? Look at the title of a report or dashboard. For example, if a dashboard is called Sales by Country, then anything that comes after the by word is a dimension and the item being counted is a measure. Dimensions and measures are explained as follows:

Dimensions: Dimensions describe dataMeasures: Measures are usually numbers

In this recipe, we will look at the difference between a plain table and a graphical representation of the data. While tables are data visualizations in themselves, Tableau's power lies in its ability to visualize data graphically and quickly. This recipe will demonstrate the ease of going from a table to a picture of the data. We will create a map, and the color intensity of the map coloring reflects the value.

Getting ready

Let's start by opening up Tableau to get ready for your first visualization.

We will need to get some data. To obtain some sample, download the Unicef Report Card spreadsheet from the following link: http://bit.ly/TableauDashboardChapter11Unicef

It will have the following columns:

CountryAverage ranking position (for all 6 dimensions)Material well-beingHealth and SafetyEducational well-beingFamily and peer relationshipsBehaviors and risksSubjective well-being

How to do it…

In Tableau, click on File in the top left-hand corner and click on New. You can see this in the following screenshot:When you've clicked on New, you will get a blank Tableau workbook. This is shown in the following screenshot:Let's insert our downloaded data. To do this, go to the Excel spreadsheet and select all of the data by pressing CTRL + A.Once you have done this, go to Tableau and press CTRL + V to paste it. Here is an example of the workbook:

The following points describe the different panels in Tableau:

Data window: This holds the measures, dimensions, and calculations in the dataThe Tableau view: This shows the items held in the Rows, Columns, Marks, Pages, or Filters shelfShelf: This is a place where you drag a measure or a dimension

The following steps can be performed to create a quick visualization:

When you paste the data, it appears as a crosstab. We can see the data, but it is quite difficult to see any patterns in the data.Using the preceding list as a basis, it is very simple to create a quick visualization.Let's take a copy of our work so that we can compare before and after. To do this, click on the Sheet 1 tab at the bottom of the worksheet. Right-click on the worksheet tab at the bottom of the Tableau interface and a pop-up menu appears.Select the option Rename Sheet and rename the worksheet as Before.Then, choose the option Duplicate Sheet, as shown in the following screenshot, to take a copy of the worksheet, and rename the new copy as After.In the After worksheet, look for Tableau's Show Me feature. This is a key feature of Tableau, and you can see the Show Me toolkit at the right-hand side of the Tableau interface, as shown in the following screenshot:

For the purposes of this recipe, we will choose a map visualization.

Using the Afterworksheet, click on the first Measures column called Average ranking position_(for all 6 dimensions) to select it. Right-click on the column and choose Keep Only. This excludes the rest of our measures, retaining only this column. The result can be seen in the following screenshot:When we exclude the other options, the Show Me toolkit changes in response to the amendments that have been made in the data table. Now, the map options are available to us. The Show Me toolkit changes can be seen in the following screenshot:

When we select the filled maps option, which is bordered with a heavy line at the top right-hand side row, our screen now changes to look like a filled map, in which each color corresponds to the average rank of each country. An example is shown in the following screenshot:

Note

We have Denmark ranked as 7 and the United Kingdom is ranked at 18. Denmark is considered as having a higher ranking, even though it has a lower number.

To change the color settings, we right-click on the colors item that is located on the left side of the screen, centered vertically. We can see an example in the next screenshot:

The Edit Colors dialog box appears. An example can be found in the next screenshot:

Using the square box, you can change the color. Here, it has been changed to blue. The important item to note here is the Reversed option. This option allows us to reverse the color so that lower numeric values are represented by higher intensities. When we click on Ok, we get the final result as shown in the following screenshot:

How it works…

The Show Me toolkit takes the guesswork out of what data visualization tool to choose by offering you a selection of visualizations that are based on your data types.

The Show Me button helps you to choose which data visualization is most suited to your data. It does this using an in-built, intelligent, knowledge-based system that is part of Tableau. This helps to take the guesswork out of selecting a data visualization, which can often be a contentious issue among data consumers and business intelligence professionals alike.

Data visualization is telling a story; the value is depicted by a corresponding color intensity. This example topic involved ranking data. Therefore, the higher the number, the lower the value actually is. Here, the value refers to the country rank.

How can we make the message clearer to the users? When we visualize the data in a map, we can still use color in order to convey the message. Generally speaking, we assume that the brighter or more intense a color is, then the higher the value. In this case, we need to adapt the visualization so that the color is brighter in accordance with the rank, not the perceived integer.

There's more…

Color theory is a topic in itself, and you will see practical applications as we proceed throughout this book. For further references, please see the See also section.

See also

Data visualizations can also be known as dataviz for short. On Twitter, #dataviz is a well-used hashtag

Connecting to data sources

In the previous recipe, we inserted data into the Tableau workbook by simply copying and pasting. In the real world, however, we need to be able to connect to different data sources that may contain large amounts of data.

We will now look at connecting to multiple data sources at a time. This is a useful way of enriching our data. We have access to multiple data sources. We can open up Tableau and connect numerous data sources.

First, we will see how we can connect to the Windows Azure Datamarket cloud data source, and then continue to connect to the local Excel file. Windows Azure Marketplace is an online market to buy and sell finished Software as a Service (SaaS) applications and premium data. Some data on Windows Azure Datamarket is free. We will be using one of the free data samples, which will give us a lot of information about individual countries, such as the country code, population, size, and so on. In data warehousing terminology, this data can be considered as a dimension, which is another way of describing data. In this definition, it is a field that can be considered an independent variable, regardless of the datatype. Tableau has a more specific definition of a dimension. Tableau treats any field containing qualitative, categorical information as a dimension, such as a date or a text field.

To connect the online data and local data, we will connect to Windows Azure Datamarket using OData, which is a standardized protocol to provide Create, Read, Update, Delete (CRUD) access to a data source via a website. It is the data API for Microsoft Azure, but other organizations use it as well, such as eBay, SAP, and IBM.

Getting ready

Before you start, you need to create a folder where you can download data to run through the examples. You should pick a folder name that is meaningful for you. Also, be sure to select a location that has plenty of space. In this example, we will use the following location to store data: D:\Data\TableauCookbook. For the example in this chapter, we will create a folder called Chapter 1.

How to do it…

To connect to Windows Azure Datamarket, please sign up for a free account using a Windows Live ID. To do this, please visit https://datamarket.azure.com/ and follow the instructions. This may involve activating your account via a link, so please follow the instructions carefully.Sign in to Windows Azure Datamarket and navigate to the following URL:

https://datamarket.azure.com/dataset/oh22is/countrycodes#schema

About half way down the page, look for the Sign Up button and click on it.This will take you to a terms and conditions page. After you've read the terms and conditions, and, if you agree with them, tick the box to specify that you agree and click on Sign Up.This will take you to a Thank You page. Look for the EXPLORE THIS DATASET link on this page and click on it, as shown in the following screenshot:When you click on EXPLORE THIS DATASET, you will be able to see the data appear in the browser, which you can slice and dice. Here is an example screenshot:In this example, we will load the data in Tableau rather than in the Data Explorer URL. To do this, we need the primary account key. In Windows Azure Datamarket, this is easy to obtain. From the previous example, we can see a feature called Primary Account Key. If you click on the Show link next to Primary Account Key, then your primary account key will appear.Copy the primary account key to your clipboard by selecting it and pressing the CTRL + C keys. You will need the primary account key to access the data using Tableau.You will also need to get the OData feed for the Country Codes data of the Windows Azure Datamarket Country Codes store. To get the OData feed, you can see it under the sentence URL for current expressed query, and you should copy this information.Before you proceed, you should note the OData URL and the primary account key. Select them and press the CTRL + C keys simultaneously. The following table shows an example of how your data might look:

OData URL

https://api.datamarket.azure.com/oh22is/CountryCodes/v1/CountryCodes

Primary account key

Aaa0aaAa0aAa00AAaAAA0aaA0AaaOa0aAaeAaA1AAA

To connect to Windows Azure Datamarket, let's open up Tableau and open the Chapter 1 Demo workbook that we started in the Getting ready section of the Showing the power of data visualization recipe.Go to the Data menu item and choose Connect to Data….This action takes you to the Connect to Data window, and you can see that there are a variety of data sources for you to choose from! A sample of the list can be seen in the next screenshot:In this example, we are interested in connecting to Windows Azure Datamarket. Here, we will use the information that we saved earlier in this section. You will need the OData connection link. The connection panel only needs a few items in order to connect to the Country Codes data in Windows Azure, and an example can be seen in the next screenshot:Insert the OData URL into the textbox labeled Step 1: Select or enter a URL.Next, take a look at the step labeled Step 2: Enter authentication information, select the radio button next to the option Use an Account key for Windows Azure Marketplace DataMarket, and insert the account key into the textbox. Then, click on the Connect button.All being well, the data connection will be successful and we can save the Tableau workbook before proceeding to connect to the Excel data source.We will download the GNI data from the World Bank. The URL is as follows:

http://data.worldbank.org/indicator/NY.GNP.PCAP.CD?page=1

To do this, open an Internet browser and navigate to the URL. You can see the web page in the following screenshot:You will see a button called DOWNLOAD DATA, which is on the right-hand side.Click on this button and you will be presented with two options: EXCEL and XML. We will download all of the data in Excel format.Before accessing the data source, let's save the file into the directory that you created earlier.Once the file is saved, open it in Excel and take a look. If you don't see any data, don't be alarmed.

You will see that there are three sheets and the workbook may open on Sheet 2. This will only provide metadata about the data held in the worksheet, and we need to look at Sheet 1. Then, we'll perform the following steps:

Let's rename Sheet 1 to something more meaningful. Right-click on the sheet tab name and rename it as GNI.Remove the first two rows of the file. They will only add noise to the import.Once you've done this, save the workbook. Now, you can exit Excel. We will go back to Tableau to connect to the data.To connect to the Excel file, go to the Data menu item. Select Connect to Data… and a browser will appear.Navigate to the location where the files are stored.Select the worksheet to analyze and double-check whether you are looking at the correct file.We are given the option of selecting a single file, multiple files, or a custom SQL.At step 3, labelled Does the data include field names in the first row?, select the option No.At step 4, labelled Give the connection a name for use in Tableau, type in GNI and click on OK.We can now decide whether to import the data or to connect live. We will connect live to the Excel workbook.Now, we can see the Tableau workbook in the following screenshot. In the Data view at the top, we can see two connections: our Windows Azure Datamarket connection and our Excel file connection.If we want to flip between each data source, we can click on each connection and see that the dimensions and measures change in response.

How it works…

Tableau connects to each data source and talks to it using drivers that are specific to each datatype. For example, Tableau has some connectors to popular programs, such as R, Google Analytics, and Salesforce.

You can find more information about drivers on the Tableau website at the following link:

http://www.tableausoftware.com/support/drivers

There's more…

Tableau will connect to each data source independently. Even though they are different types of data sources, they appear to look the same in Tableau. From the user perspective, this is very useful since they should not be distracted by the differences in the underlying data source technologies. This means that the user can focus on the data rather than trying to put the data into one data source. Further more, it means that the sources of data can be refreshed easily because the Tableau visualization designer is able to connect directly to the source, which means that the data visualization will always be up to date.

See also

Tableau can import data into its own in-memory engine. We will look at this in a later section.

Introducing the Tableau interface

In this recipe, we will look at the components of the Tableau interface and use these features in order to create a simple Tableau visualization. In the previous recipe, we connected to data in Windows Azure Datamarket and a local Excel spreadsheet. We will use these data sources in our example here in order to produce a quick and easy data visualization.

Getting ready

Make sure that you have a copy of the Chapter 1 Tableau data visualization open. You should be able to access both data sources. To do this, click on the Tableau Data connection that you will see in the top left-hand corner of the Tableau interface, as shown in the following screenshot:

You should be able to click on the CountryCodes and the GNI connections alternately, and see the differences in the dimensions and metrics contained in the two data sources.

How to do it…

In the Chapter 1 Tableau data visualization, click on the GNI data source. This will change the dimensions and measures, which you can see in the left-hand side column of the Tableau interface. An example is shown in the next screenshot:You might notice that some of the dimensions are called 1960 and 1961, but the rest are considered to be metrics.Fortunately, this is very easy to change. You can simply drag the 1960 and 1961 dimensions down to the Measures area. The Tableau interface now looks like the following screenshot:Now that we see the measures, you can see that they are still specified as a string datatype and they are specified as a Count.Fortunately, this is also very easy to change. If you right-click on the measure 1960, a pop-up menu will appear. You can see an example of the pop-up menu in the next screenshot:If you do this for both 1960 and 1961, you can change both the datatypes to number. The result can be seen in the next screenshot:Now that the data has been prepared, let's move to visualizing the data.Earlier, we were introduced to the Show Me panel. Before we use the Show Me panel, however, we need to put some data on the shelves. This is a location where we drag-and-drop the dimensions and metrics in order to make them part of the data visualization.Pick the dimension Country Name and drag it onto the Rows shelf.Pick the metric 2012 and place it on the Columns shelf.You can now see that the data visualization has changed from a table to a horizontal bar chart. We can make it look better by sorting the bars in descending order. This allows us to quickly identify the highest GNI amounts for the top n countries.To sort in descending order, look for the button that shows a downward arrow next to a horizontal bar chart. When you wave the mouse over it, you will see that it sorts by the metric. An example is shown in the following screenshot:

Once you've sorted the data, it will look neater and easier to understand. We can see this in the following screenshot:

How it works…

One of Tableau's features is that it works out automatically whether the data is a dimension or a measure. Tableau does this by looking at the datatype in the columns. So, for example, in this case, it has identified text and geographical types as dimensions and integers as measures.

You may be wondering why we have data that has a year for each column rather than a column Year. This is a good question to ask, and we will look at different ways of shaping the data and how that affects the resulting visualization throughout the course of this book.

Tableau has an internal knowledge base that it uses in order to determine the most appropriate visualization for the data that it sees. Initially, in this case, it has suggested a horizontal bar chart in blue. Why is this the case?

We have a horizontal bar chart rather than vertical because we can read more easily along rather than up and down. For people in the West, we tend to read left to right, so we see the country name on the left followed by the bar and the value on the right.

By having horizontal bars, it is easy to see how the bars compare within the chart itself. We have the visual information from the bar itself as well as the metrics labelled at the end of the bar.

See also

A book list will be provided at the end of the book for people who are interested in research on data visualization

Interacting with your first data visualization

In this recipe, we will learn about interacting with your first visualization and look at different visualizations that are available to you in Tableau. The Show Me panel provides you with a range of options to create data visualizations. Some of these can be adapted so that they pack a lot of information into a very small space, which is ideal for dashboarding. In this recipe, we will look at creating a bullet chart, which has been designed to retain a balance between packing the maximum amount of information into the minimum amount of space while also retaining clarity.

The bullet chart was devised by a data visualization expert and thought leader, Stephen Few. It is designed to replace charts and graphs that show a lot of ink or take up a lot of space on the page but do not show a lot of data. The bullet graph is effective because it takes up little space and allows the viewer to see whether the actual data is comparable to the target by reading from left to right along the bar. Playing with the colors on the bullet chart is a useful way to understand this useful chart better.

We are using a very simple dataset as a starting point, and we will move towards more complexity in terms of data and visualizations for dashboarding as we proceed throughout the book.

Getting ready

Before we open Tableau, let's download the data from a Google Docs spreadsheet provided by the Guardian Datastore, which is provided by The Guardian newspaper that is published in the UK. You can visit the following link:

http://bit.ly/TableauCh1TargetData.

You may need a Google account to open the spreadsheet. Once you have opened the spreadsheet, you copy the data that you see highlighted in the following screenshot:

Select the table of data as in the preceding screenshot, copy it using Ctrl + C, and then paste it into Tableau. This will import the copied data into the model contained in the Tableau worksheet. Alternatively, you could download the Google spreadsheet as an Excel spreadsheet by navigating to File | Download as | Microsoft Excel (.xlsx). Since we will be changing the original visualization in the Chapter 1 workbook, it is good practice to take a copy of your current visualization and work on the copy. When you work in Tableau, it is very easy to keep clicking around and changing visualizations. However, if you want to roll back to an earlier point, you might find that you've easily clicked away quite far from your preferred point.

In this example, we will work on a copy of the Chapter 1 workbook so we can compare our progress from start to finish quite easily. We will use data from the Guardian Datastore which shows whether countries are on target to meet their environmental targets according to the Kyoto agreement. This is a good preliminary example of dashboard data, because we are displaying the actual versus target data, and this is a common dashboarding scenario.

How to do it...

Once the data is copied into Tableau, the workbook will appear as follows:If the years appear as dimensions, then drag them to the Measures pane on the left-hand side.Our starting point is a table. In our duplicate sheet, go to the Show Me panel at the right-hand side. Select the horizontal bars option. You can see a sample of the Show Mepanel in the next screenshot:Once you have selected the horizontal bars option, your screen will look like the following screenshot:We are interested in the target data. To show the scenario of comparing actual data with target data, remove all of the green pills from the Columns shelf, except SUM(2010) and SUM(2020 Target).Once these columns have been removed, the Show Me panel will show more options. We will choose the bullet graphs option, which is highlighted with a blue box in the following screenshot:Once the bullet graphs option has been clicked on, look for the small icon that looks like a horizontal bar chart on the taskbar. You will find it below the menu items. When you wave the mouse over it, you will see that it is a tooltip that says Sort Country Descending by 2012. It is circled in the following screenshot:The result can be seen in the next screenshot, which shows rows of bullet charts:This is still a lot of data to show on a dashboard and still be sure that the data consumer is able to remember and understand it quickly. The idea is that the thick horizontal line displays the actual data and the vertical line on each row displays the target. We can resize it so that the rows are smaller in height. To do this, you can resize by grabbing the bottom of the white canvas and pulling it upwards. This will make the data visualization smaller.We could filter this further in order to show the top five countries who have the greatest share of renewable energy sources in 2010. To do this, drag the Country dimension from the left-hand side of the Tableau workbook to the Filter panel located just above the Marks panel. The following wizard will appear:Select the Toptab and select the By Field radio button.Then, put the number 5 into the textbox and select the 2010 column from the drop-down list.Click on OK to clear the Filter wizard.Then, right-click on Country in the visualization and select the option Hide Field Labels for Rows, as shown in the following screenshot. This will remove unnecessary ink from the screen, which means that there are fewer unnecessary items to distract the viewer.Once this is done, resize the visualization so that it is only a few inches in length. To do this, go to the right-hand side of the visualization and drag the end along to the desired size. The data visualization now looks like the following screenshot:

How it works…

Copying and pasting the data into Tableau is a great way of importing data quickly. Note, however, that this data is static and will not change with any changes in the data source.

There's more…

Removing unnecessary ink from the screen is a useful way of cutting down the items displayed on the dashboard. In this example, the label was redundant and its removal made the graphic neater.

If you require more information on the bullet chart, please visit the following link:

http://bit.ly/BulletGraphbyStephenFew

Sharing your visualization with the world

In the first recipe, we specified communication as one of the key features of a dashboard. We need to be able to share the information to the right audience at the right time, to the right people in the right format.

Tableau offers a number of different ways to share the dashboard in order to help team members throughout the organization to track, monitor, and analyze the metrics about their organization, and we will look at these in the current section.

Given that Tableau offers a number of ways to share a dashboard, what is the best way to do this? The best way to decide which method to use to share your information fundamentally rests on the user requirements. These are listed in the following table:

Objective

Method

For other Tableau users who don't have access to the data

Exporting a Tableau packaged workbook

To view data online and share the data

Sharing your workbook with Tableau Public

For Tableau users who do have access to the data

Sharing your workbook with Tableau Server

In this recipe, we will look at the first two methods of sharing data: exporting a Tableau packaged workbook and sharing your workbook with Tableau Public. When we export a workbook as a packaged workbook, it wraps up the data as part of the Tableau workbook. Why would you want to do this? The following are some reasons:

You may want to send the workbook to someone who does not have access to the data sourceYou may be prototyping a workbook with some sample data