Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Learning Tableau 10
Learning Tableau 10

Learning Tableau 10: Business Intelligence and data visualization that brings your business into focus , Second Edition

eBook
R$80 R$271.99
Paperback
R$339.99
Subscription
Free Trial
Renews at R$50p/m

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Learning Tableau 10

Chapter 1.  Creating Your First Visualizations and Dashboard

Tableau is an amazing platform for seeing, understanding, and making key decisions based on your data. With it, you can achieve incredible data discovery, analysis, and storytelling. You'll accomplish these tasks and goals visually using an interface that is designed for a natural and seamless flow of thought and work. Tableau accomplishes this using VizQL, a visual query language. You won't have to learn VizQL. It's all done behind the scenes and you won't be forced to write tedious SQL scripts, MDX code, or painstakingly work through numerous wizards to select a chart type and then link everything to data.

Instead, you will be interacting with your data in a visual environment where everything that you drag and drop will be translated into the necessary queries and then displayed visually. You'll be working in real-time, so you will see results immediately, get answers as fast as you can ask questions, and be able to iterate through dozens of ways to visualize the data to find a key insight or tell a piece of the story.

Tableau allows you to accomplish numerous tasks, including:

  • Data connection, integration, and preparation: Tableau allows you to connect to data from sources and, if necessary, create a structure that is ready to use. Most of the time this is as easy as pointing Tableau to a database or opening a file, but Tableau gives you the tools to bring together even complex and messy data from multiple sources.
  • Data exploration: You can visually explore a dataset using Tableau in order to understand what data you have.
  • Data visualization: This is the heart of Tableau. You can iterate through the countless ways of visualizing the data to ask and answer questions, raise new questions, and gain new insights.
  • Data analysis: Tableau has an ever growing set of analytical functions that allow you to dive deep into understanding complex relationships, patterns, and correlations in the data.
  • Data storytelling: Tableau allows you to build fully interactive dashboards and stories with your visualizations and insights so that you can share the data story with others.

We'll take a look at each of these tasks in the subsequent chapters. This chapter introduces the foundational principals of Tableau and focuses on data visualization. We'll accomplish this through a series of examples that will introduce the basics of connecting to data, exploring and analyzing the data visually, and finally putting it all together in a fully interactive dashboard. These concepts will be developed far more extensively in the subsequent chapters. But don't skip this chapter, as it introduces key terminology and foundational concepts, including:

  • Connecting to data
  • Foundations for building visualization
  • Visualizing the data
  • Creating bar charts
  • Creating line charts
  • Creating geographic visualizations
  • Using Show Me
  • Bringing everything together in a dashboard

Connecting to data

Tableau connects to data stored in a wide variety of files and databases. This includes flat files, such as Excel and text files; relational databases, such as SQL Server and Oracle; cloud-based data sources, such as Google Analytics and Amazon Redshift; and OLAP data sources, such as Microsoft Analysis Services. With very few exceptions, the process of building visualizations and performing analysis will be the same no matter what data source you use. We'll cover the details of connecting to different data sources in Chapter 2, Working with Data in Tableau.

For now, we'll connect to a text file, specifically, a comma-separated values file (.csv). The data itself is a variation of the sample data provided with Tableau for Superstore, a fictional retail chain that sells various products to customers across the United States. It's preferable to use the supplied data file instead of the Tableau sample data as the variations will lead to differences in visualizations.

The Chapter 1 workbook, included with the code files bundle, already have connections to the file; however, for this example, we'll walk through the steps of creating a connection in a new workbook:

  1. Open Tableau; you should be able to see the home screen with a list of connection options on the left, thumbnail previews of recently edited workbooks in the center, links to various resources on the right, and sample workbooks on the bottom.
  2. Under Connect and To a file, click Text File.
  3. In the Open dialogue box, navigate to the \Learning Tableau\Chapter 01\ directory and select the Superstore.csv file.
  4. You will now see the data connection screen, which allows you to visually create connections to data sources. We'll examine the features of this screen in detail in the Connecting to data section of Chapter 2, Working with Data in Tableau. For now, notice that Tableau has already added and given a preview of the file for the connection:

    Connecting to data

  5. For this connection, no other configuration is required, so simply click on the Sheet 1 tab at the bottom to start visualizing the data! You should now see the main work area within Tableau, which looks similar to the following screenshot:

    Connecting to data

We'll refer to elements of the interface throughout the book using specific terminology, so take a moment to get familiar with the terms used for various components numbered in the preceding image:

  1. The menu contains various menu items for performing a wide range of functions.
  2. The toolbar allows for common functions, such as undo, redo, save, adding a data source, and so on.
  3. The sidebar contains tabs for Data and Analytics. When the Data tab is active, we'll refer to the sidebar as the data pane. When the Analytics tab is active, we'll refer to the sidebar as the analytics pane. We'll go into detail later in this chapter, but for now, note that the data pane shows the data source at the top and contains a list of fields from the data source and is divided into dimensions and measures.
  4. Various shelves, such as Columns, Rows, Pages, and Filters, serve as areas to drag and drop fields from the data pane. The Marks card contains additional shelves, such as Color, Size, Text, Detail, and Tooltip. Tableau will visualize data based on the fields you drop on the shelves.

    Note

    Data fields in the data pane are available to be added to the view. Fields that have been dropped on a shelf are called in the view or active fields, because they play an active role in the way Tableau draws the visualization.

  5. The canvas or view is where Tableau will draw the data visualization. You may also drop fields directly onto the view. In Tableau 10, you'll observe the seamless title at the top of the canvas. By default, it will display the name of the sheet, but it can be either edited or hidden.
  6. Show Me is a feature that allows you to quickly iterate through various types of visualizations based on data fields of interest. We'll look at Show Me towards the end of the chapter.
  7. The tabs at the bottom of the window gives you the option of editing the data source, as well as navigating between and adding any number of sheets, dashboards, or stories. Many times a tab (whether it is a sheet, dashboard, or story) is referred to, generally, as a sheet. We'll also often use these specific terms for a tab:
    • A sheet: A sheet is a single data visualization (such as a bar chart or line graph). Since sheet is also a generic term for any tab, we'll often refer to a sheet as a view because it is a single view of the data.
    • A dashboard: A dashboard is a presentation of any number of related views and other elements (such as text or images) arranged together as a cohesive whole to communicate a message to an audience. Dashboards are often interactive.
    • A story: A story is a collection of dashboards or single views arranged to communicate a narrative from the data. Stories can also be interactive.

    Note

    A Tableau workbook is the collection of data sources, sheets, dashboards, and stories. All of this is saved as a single Tableau workbook file (.twb or.twbx). We'll look at the difference in file types and explore details of what else is saved as a part of a workbook in later chapters.

  8. As you work, the status bar will display important information and details about the view and selections.
  9. Various controls allow you to navigate between sheets, dashboards, and stories, as well as view the tabs as a filmstrip or switch to a Sheet Sorter showing an interactive thumbnail of all sheets in the workbook.

Now that you have worked through connecting to the data, we'll explore some examples that lay the foundation for data visualization and then move into building some foundational visualization types. To prepare for this, do the following:

  1. From the menu, navigate to File | Exit.
  2. When prompted to save changes, select No.
  3. From the \Learning Tableau\Chapter 01 directory, open the file Chapter 01 Starter.twbx. This file contains a connection to the Superstore data file and is designed to help you walk through the examples in this chapter.

Note

The files for each chapter include a Starter workbook that allows you to work through the examples given in this book. If at any time, you'd like to see the completed examples, open the Complete workbook for the chapter.

With a connection to the data, you are now ready to visualize and analyze the data. As you start doing so, you will take on the role of an analyst at the retail chain. You'll ask questions of the data, build visualizations to answer those questions, and ultimately design a dashboard to share the results. Let's start by laying down some foundations to understand how Tableau visualizes data.

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Create stylish visualizations and dashboards that explain complexity with clarity
  • Learn effective data storytelling to transform how your business uses ideas and makes decisions
  • Explore all the new features in Tableau 10 and start to redefine what business analytics means to your organization

Description

Tableau has for some time been one of the most popular Business Intelligence and data visualization tools available. Why? Because, quite simply, it’s a tool that’s responsive to the needs of modern businesses. But it’s most effective when you know how to get what you want from it – it might make your business intelligent, but it isn’t going to make you intelligent… We’ll make sure you’re well prepared to take full advantage of Tableau 10’s new features. Whether you’re an experienced data analyst that wants to explore 2016’s new Tableau, or you’re a beginner that wants to expand their skillset and bring a more professional and sharper approach to their organization, we’ve got you covered. Beginning with the fundamentals, such as data preparation, you’ll soon learn how to build and customize your own data visualizations and dashboards, essential for high-level visibility and effective data storytelling. You’ll also find out how to so trend analysis and forecasting using clustering and distribution models to inform your analytics. But it’s not just about you – when it comes to data it’s all about availability and access. That’s why we’ll show you how to share your Tableau visualizations. It’s only once insights are shared and communicated that you – and your organization – will start making smarter and informed decisions. And really, that’s exactly what this guide is for.

Who is this book for?

Got data? Not sure what to make of it? This is the guide for you – whether you’ve been working with Tableau for years or are just beginning your adventure into business analytics.

What you will learn

  • Find out how to build effective visualizations and dashboards
  • Prepare and clean your data so you can be sure Tableau is finding answers to your questions – not raising more problems
  • Discover how to create advanced visualizations that explain complexity with clarity and style
  • Dig deeper into your data with clustering and distribution models that allow you to analyze trends and make forecasts
  • Learn how to use data storytelling to aid decision-making and strategy
  • Share dashboards and visualizations to cultivate a culture where data is available and valued

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Sep 30, 2016
Length: 432 pages
Edition : 2nd
Language : English
ISBN-13 : 9781786466358
Vendor :
Tableau
Category :
Languages :
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Sep 30, 2016
Length: 432 pages
Edition : 2nd
Language : English
ISBN-13 : 9781786466358
Vendor :
Tableau
Category :
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
R$50 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
R$500 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just R$25 each
Feature tick icon Exclusive print discounts
R$800 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just R$25 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total R$ 953.97
Mastering Tableau
R$306.99
Tableau 10 Business Intelligence Cookbook
R$306.99
Learning Tableau 10
R$339.99
Total R$ 953.97 Stars icon

Table of Contents

11 Chapters
1. Creating Your First Visualizations and Dashboard Chevron down icon Chevron up icon
2. Working with Data in Tableau Chevron down icon Chevron up icon
3. Moving from Foundational to More Advanced Visualizations Chevron down icon Chevron up icon
4. Using Row-Level, Aggregate, and Level of Detail Calculations Chevron down icon Chevron up icon
5. Table Calculations Chevron down icon Chevron up icon
6. Formatting a Visualization to Look Great and Work Well Chevron down icon Chevron up icon
7. Telling a Data Story with Dashboards Chevron down icon Chevron up icon
8. Deeper Analysis – Trends, Clustering, Distributions, and Forecasting Chevron down icon Chevron up icon
9. Making Data Work for You Chevron down icon Chevron up icon
10. Advanced Visualizations, Techniques, Tips, and Tricks Chevron down icon Chevron up icon
11. Sharing Your Data Story Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2
(10 Ratings)
5 star 40%
4 star 50%
3 star 0%
2 star 10%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Donald Q Mar 18, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Very good information in this book. Well written. Assumes some experience with computers and programming.
Amazon Verified review Amazon
Not Hidden Dec 20, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Learning on the job just wasn't cutting it at all as everyone here seems to fumble thru development. I felt much more confident after reading chapter 1.
Amazon Verified review Amazon
Amazon Customer Jun 18, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Well done. Using it to teach Tableau around the country.
Amazon Verified review Amazon
MN mom May 27, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Purchased for online course. Pleased with the book.
Amazon Verified review Amazon
S. Tescione Jun 15, 2017
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book made my job so much easier! We are implementing three new software applications: Tableau, Webi, and Alteryx. These books have been enormously helpful in figuring out what the lessons and job aids should be for new users. This book is easy to understand and I can use the practice files to set up the lessons and figure out content and then use my company's data sources for the actual course materials.This book has been a lifesaver on a project with a short timeline. My only complaint is that entirely too much space is spent on how Tableau works with lots of explanation. Frankly my dear, my users don't give a hoot. They don't want to know what it is and how it works. They want to know how to use it. So it could use a lot less on technical explanation and a lot more "cookbook".
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.