Introducing the Tableau Desktop Workspace
In this section, you will learn about tableau’s workspace controls. This chapter is intended as a supplement (not a replacement) to Tableau’s excellent online manual.
Using the Workspace Controls Effectively
If you are accustomed to working with spreadsheets or other analysis tools, learning Tableau’s desktop environment will be a breeze. If you have no familiarity with database terminology or spreadsheets you can still effectively use Tableau within a few hours.
The Start Page and Data Connection Page
Open TABLEAU and you’ll be presented with the start page displayed in Figure 1.4. Notice the small tabs in the upper-right side of the screen. The Home button with the orange house icon should be highlighted.
Figure 1.4: Tableau start page
On the left side, the data window presents connection options. If you click on Connect to Data, you’ll be taken to the data connection workspace. You can also access this page by clicking on the hard disk icon tab next to the Start button.
If you need to connect to one of the data sources listed in the On a Server section, you must go to Tableau’s website and download a connector for the desired database. Downloading a connector requires less than a minute if you have a decent web connection. There is no limit to the number of data connection drivers you can install, but some vendors require that you validate a valid license to their software before downloading their connector.
On the right side of the Connect to Data page, you will see saved data connections. Tableau provides four sample data for learning. Any other connections you have saved (.tds files) are displayed there as well.
Return to the Home button and look at the Workbooks area on the start page. The Workbooks area saves the last nine workbooks you’ve opened. If you want to keep a workbook there that you use frequently, hover over the workbook image and click on the push pin. That will prevent the workbook from being cycled out of view. Figure 1.5 displays a workbook related to this chapter that I want to keep on my start page.
Figure 1.5: Pin a workbook to the start page
To remove saved workbooks from the start page, click on the red X that appears when you hover over the workbook’s image. At the bottom of the start page, the Getting Started area provides links to training videos and promotional materials. The sample workbook area provides links to sample workbooks containing excellent example material. Clicking on More Samples takes you to Tableau’s visual gallery on the web with even more example workbooks.
Multiple Worksheet Page
There are two more workspace icons in the start page. The one with four gray boxes aligned in a square display all of the worksheets in the workbook. There is a workbook with all the examples in this chapter that you can see in Figure 1.6 containing 18 different worksheets. This is the “slide-deck” view— it looks like PowerPoint’s slide sorter view.
Related Page: How to build your first advanced dashboard in tableau
Figure 1.6: Multiple worksheet display
You can record worksheet tabs by dragging them to the desired position. Double-clicking will open that worksheet. If you have to give a presentation using a workbook with many worksheets, and you want the transitions from worksheet to worksheet to instantly appear, right-click while pointing anywhere in the page and select the (Refresh All Thumbnail) option. This will cause Tableau to update every view in the workbook and will make transitions to new worksheets appear instantly. This is particularly helpful if your datasource contains large files.
Clicking on the far left icon (with three squares) displays the Tableau Worksheet page and exposes the contents of the worksheet tab selected at the bottom of the screen. When you connect to a new data source there is a default workspace view. Go to the home page and select the Sample – Superstore Subset (Excel) spreadsheet file. You just opened a connection to a saved data source and should have a blank worksheet open.
There are many ways you can open a workspace page; for example, if you display Tableau’s icon on your desktop and you have a datasource displayed on your desktop. Dragging any datasource icon and dropping it on the Tableau icon opens Tableau’s worksheet page for the selected data source. Keep in mind that you can open as many connections as you want in Tableau by going to the start page or a data connection page and selecting a new connection. Figure 1.7 is worksheet-connected to the Sample-Superstore Sales-Excel data set used to create scatter plots.
Figure 1.7: Worksheet page
The annotations in figure 1.7 are the specifics that are covered in the remaining chapter.
What You Need to Know about the Menu
As Tableau Desktop has matured, the desktop menu has become less important. There has been a migration of features away from the main menu closer to the work in the worksheet, near marks, and in Tooltips. This section will focus on features that are still accessed via the main menu.
Like any Windows program, the file menu contains Open, Save, and Save As functions. The most frequently used features found in this menu is the Print to pdf option. This allows you to export your worksheet, or dashboard in pdf form. If you can’t remember where Tableau places files, or you want to change the default file-save location, use the repository location option to review and change it. A fast way to create a packaged workbook is available from the export packaged workbook option. Saving your workbook in this way eliminates a couple of clicks versus the more commonly used file/ saves as a method.
The Paste Data option is handy in a couple of ways. You can use this if you find some interesting tabular data on a website that you want to analyze with Tableau. Highlight and copy the data from the website then use the Paste Data option to input it into Tableau. Once pasted, Tableau will copy the data from the Windows clipboard and add a datasource in the data window. The Edit Relationships menu option is used in data blending. This menu option is necessary if the field names when two different data sources are not identical. It allows you to specifically define the related fields. Details related to data blending will be covered in Chapter 2.
Several frequently used features exist in this menu. The Export option allows you to export your worksheet as an image, an Excel crosstab, or in Access database file format. The Duplicate as Crosstab option creates a crosstab version of the worksheet and places it in a new worksheet. Figure 1.8 is the output from the Describe Sheet Menu option.
Related Page: Learn What is the right way to build a dashboard in tableau
The Action Menu is a very useful feature that is reached from both the Dashboard Menu and the Worksheet Menu. Chapter 8 covers the three types of actions in detail.
Figure 1.8: Describe worksheet output
As your skills advance you’ll venture to this menu to access the aggregate measures and stack marks options. These switches allow you to adjust default Tableau behaviors that are useful if you need to build non-standard chart types. You’ll build an example, in Chapter 7 that requires the use of these options. The Create Calculated Field and Edit Calculated Field options are used to make new dimensions or measures that don’t exist in your data source.
Related Page: ?Trend Lines And Reference Lines In Tableau
The Map Menu option is used to alter the base map color scheme between normal (water is colored blue), gray (water is white) or dark (land is black, water gray). The other menu options all relate in some way to replace Tableau’s standard maps with other map sources. You can also import geocoding for custom locations using the geocoding menu. All these options will be covered in detail in Chapter 5.
You may not use this menu very often because pointing at anything and right-clicking gets you to a context-specific formatting menu more quickly. On rare occasions you may need to alter the cell size in a worksheet. Do that from the Cell Size menu. If you don’t like the default workbook theme use the Workbook Theme menu to select one of the other two options.
Use this menu if you need to login and publish work to Tableau Server. If you are doing a little dashboard building for fun or for a blog post, use the Tableau Public menu. To use this, you must sign-up for a free Tableau Public account. The section on options in Chapter 10 for securing reports will describe how to use the menu option to create user filters. This provides row-level security by using a dimension to filter out data from the view.
If you have a large workbook with many worksheets and you want to share one of the worksheets with someone else, use the bookmark menu to create a bookmark file (tbm).
The top section of this menu includes menu options that access Tableau’s on-line manual, training videos, and sample workbooks. If you need to find your product key the Manage Product Key menu option will display it. Finally, if you have a slow loading dashboard— or one that doesn’t filter quickly— the Start Performance Recording activates Tableau’s performance analysis tool. Then actuate some filters to generate activity. When completed, go back to the menu and turn off the performance recorder. Tableau will create another workbook that contains performance metrics related to the source workbook. Performance tuning will be covered in detail later in Chapter 8 on dashboard design , and in Chapter 9 in the section on server performance turning.
Related Page: ?Heat Maps, Bar Chart And Line Charts In Tableau
Leveraging Toolbar Icons
The toolbar displayed in Figure 1.9 makes the most commonly needed functions to be readily accessible.
Figure 1.9: Worksheet toolbar
Tableau keeps an unlimited audit trail of every click made since the beginning of each session. The undo/ redo arrows allow you to scroll backward or forward in time—infinitely. If you make a mistake and don’t know exactly how to fix it, click the Undo button and go back in time until your error is removed. Use the Save button frequently because Tableau does not have an auto save feature. The new Dashboard/ Worksheet button is one of the ways to add a new page to your workbook.
The Duplicate Sheet button allows you to add an exact copy of a worksheet or dashboard page you’re currently in, to a new page. This is useful if you’re experimenting and don’t want to break your current view.
Using the Auto and Manual Update buttons is useful if you have a particularly large data set that requires a few seconds to generate visuals when you drag elements into the worksheet. Suspending Auto Update allows you to place elements without delay and then run the update after you’ve finished.
Quickly sort your worksheets by clicking the Ascending or Descending Sort buttons. The toolbar that looks like a paper clip allows you to multi-select marks in the worksheet and group them together. The Label Mark button turns toggles labeling of marks on and off.
Presentation mode is turned on or off using the small icon that looks like an upside-down television set or a projector screen. This option hides or un-hides the design shelves. Use this if you are giving a presentation and want to use Tableau as your presentation slide deck.
The reset card icon provides a menu that allows you to turn on and off screen elements that provide additional information. Caption provides a text description of items that comprise your worksheet. Summary adds statistical details about your visualization.
The fit menu allows you to control how Tableau fills the screen with the visualization. You can fit the entire view in the available space or stretch it vertically or horizontally. The default normal fit uses only the space needed by the visualization. If it is too large for the screen, scroll bars will appear. If it doesn’t require the entire screen, gray space will result.
The push pin fixes the axis of your view. Use this if you want to zoom into any chart and hold the view. This is particularly useful on maps. Chapter 5 covers map options in detail.
The highlight control enables comparison by highlighting selected combinations of dimensions. This is useful in many charts, but you will find it to be very helpful when highlighting marks in scatter plots.
Related Page: How To Sort Data In Tableau
The Data Window, Data Types and Aggregation
When you connect Tableau to a data source, it is expressed in the data window. You can connect to as many different datasources as you want in a single workbook. The small icons associated with data connections provide additional details about the nature of the connection. Figure 1.10 shows a workbook with three different data connections.
Figure 1.10: Data shelf
There are subtle visual clues regarding the exact state of each connection. The blue check circle next to the superstore data connection indicates that is the active connection in the worksheet. So, the bar chart in the worksheet was created using dimensions and measures from that data source. The coffee chain data connection is a direct connection that is indicated by the icon of the single can. Also note the blue highlighting. Those data source fields are currently displayed on the dimensions and measures shelves. The clipboard datasource at the top of the data window was cut and pasted into Tableau. It is also a data extract indicated by the icon displaying two cans with an arrow.
When you create data connections, Tableau will evaluate the fields and place them on the dimensions and measures shelves automatically. Tableau normally gets most of the fields placed correctly. If something is incorrectly placed, simply drag the field to the correct location. Errors occur sometimes when numbers are used to depict dimensions. For example, if you connect to a spreadsheet that contains customer identification numbers, that field may be placed into the measures shelf. It is important to get those fields properly placed. Dragging a customer identification number from the measures shelf into the worksheet would result in the field being summed. Properly placed on the dimensions shelf, the customer identification number would behave like a dimension and be expressed in a column or row as the same way category and state are expressed in Figure 1.10.
Tableau expresses fields and assigns data types automatically. If the data type is assigned by the data source, Tableau will use that data type. If the data source doesn’t specifically assign a data type, Tableau will assign one. Tableau supports the following data types:
Look at Figure 1.10 and focus on the icons next to the fields in the dimensions and measures shelves. These icons denote specific data types. Small globes are geographic features; calendars are dates. A calendar with a clock is a date/ time field. Numeric values have pound signs, and text fields are denoted by “abc” icons. Boolean fields have “T/ F” icons. Explore Tableau’s manual for more examples.
It is often useful to look at numeric values using different aggregations. Tableau supports many different aggregation types including:
If you aren’t a statistician or database expert, refer to Tableau’s manual for detailed definitions of these aggregate types. Adding fields into your visualization results in default aggregations being displayed. Tableau allows you to change the default aggregation or just alter the aggregation level for a specific view. To change the default aggregation, right-click on that field inside the data shelf and change its default by selecting the menu option (default properties/ aggregation). You can also change the aggregation of a field for a specific use in a worksheet. Figure 1.11 provides an example. By right-clicking on the SUM (Sales) pill and selecting the Measure (SUM) menu option, you can select any of the aggregations highlighted.
Figure 1.11: Changing aggregation
The data source used in Figure 1.11 is a data extract of an Excel spreadsheet. It is important to understand that if you relied on a direct connection to Excel, the median and count (distinct) aggregations would not be available. Excel, Access, and text files do not natively support these aggregate types. But Tableau's extract engine does.
Related Page: ?Tableau Show Me Feature
A Word about Dimension and Attribute
Most aggregates involve mathematical concepts comprehensible to most people. Even if you don’t understand specifically what standard a deviation is, you probably appreciate that it has something to do with variation of data within a set of numbers—not so with the dimension and attribute aggregations. The best way to explain these aggregates is to provide examples of them being used. Refer to the aggregate function definitions and examples in Appendix A— Understanding and Using Tableau Functions.
Building Visualizations with the Row and Column Shelves
Row and column shelves are used to express data in your worksheet. Dimensions and measures can be displayed in any order or either shelf. Figure 1.12 is a basic time series chart that shows sales trends by year and then by quarter.
Figure 1.12: Time series by year, quarter
The time series has breaks in the line because time is discretely broken down by year and then quarter. Figure 1.13 displays the same data, rearranging time by showing quarter first and then year, making it easier to see how sales changed in each quarter.
Figure 1.13: Time series by quarter, year
Placing the year pill to the right of the quarter pill alters the context of the view by making it easier to compare the sales trends within each quarter over time.
Number of Records, Measure Values, and Measure Names
Tableau automatically adds three fields to every data set. Number of records is a calculated value that sums the rows in the data source. Note that field icon preceded by an equals sign are calculated values. Measure names and measure values are special fields that allow you to display multiple measures on a single axis. Figure 1.14 was created by double-clicking on the measure names field and selecting the swap button on the toolbar to change the orientation of the chart.
When measuring values are deployed, a new shelf appears that holds the pills for every measure in the data set. Selecting measure names and measure values will automatically display all of the measures in your data source with their corresponding descriptions. You can use the measure names pill to filter out specific values by right-clicking in the pill and de-selecting measures that you no longer want to display on the axis.
Figure 1.14: Measure names, measure values
Understanding Color in Icons and Pills
Have you ever noticed whether the color of the pills placed on shelves is either green or blue? Look at Figures 1.12 and 1.14 again. Can you guess what those colors mean? Most people think blue pills are the dimensions and green pills are measures. That’s a good guess, but the right answer is more subtle. Figure 1.15 displays the time series without any breaks between the years. Notice that there is only one pill on the color shelf and it is green.
Green denotes continuous and blue measures discrete. When a time dimension pill is green the data is displayed using an unbroken, continuous line. In Figure 1.12, the time dimension pills are blue. Time buckets are displayed discretely by year and then by quarter. Measures aren’t always continuous either. Histograms convert normally continuous measures into discrete dimensions.
Figure 1.15: Time series: continuous date
Using the view cards to identify trends and outliers
The marks card is the primary means for using color, size, shape, position and text to express dimensions and measures in visualizations.
The Marks Card and Buttons
Tableau applies color, shape, and size to visualizations using the view cards. The view cards also enable filtering, labeling, and provide a way for you to add details on demand that are not visible in your chart. Visual details are added to the chart by placing field pills on the desired mark type.
Multiple fields can be placed on the color, label, detail, and Tooltip buttons. Figure 1.16 displays a scatter plot with color, shape, and size all being utilized to visualize a comparison of profit and shipping cost.
Figure 1.16: Scatter plot
The column shelf in figure 1.16 contains shipping expense, making it to measure plot horizontally across the page. Profit, on the row shelf, is displayed vertically. Color is being used to depict product category, shape shows order priority, and the size of the marks provides information on sales. This scatter plot is displaying three measures and three dimensions while displaying the outliers in a way that makes them stand out. Notice the customer names display only when they don’t overlap. All of the visual styles were applied by dropping individual fields on the desired marks card buttons. You can also alter the way each field in the marks card is used by pointing at the small icons to the left of each pill, clicking your left mouse button, and selecting another option.
The Pages Shelf
Any field placed on the pages shelf generates an auto-scrolling filter. Use it to create animated visualizations in Tableau Desktop. In Figure 1.17, you see that when a field is placed on the pages shelf another supporting shelf appears directly under it that contains a manual field selector and auto-scrolling controls providing forward/ pause/ stop, control over scrolling speed, and a show history check box.
Figure 1.17: Pages Shelf and Show History Menu
Checking the show history box exposes a menu that provides different options to control the way history is displayed and how many marks will be displayed while the filter increments through whatever field has been placed on the shelf. For example, if a date field is placed on the pages shelf, the pages shelf filter can automatically increment through each month contained in the data set.
Trails are lines that connect marks sequentially as scrolling occurs. Selections made in the show section of the menu, enable you to control whether marks, trails, or both marks and trails are displayed as the auto filter increments. The marks section provides controls over the color and fade of the marks. The trails section provides color and line style controls for the trails.
Auto-scrolling filters are not supported on Tableau Server, but they can be consumed via Tableau Reader or Tableau Desktop.
Any field placed on the filter shelf enables a filter for that dimension or field. The style of filter control is dependent on whether the field is continuous or discrete. If you want to expose a filter in the worksheet, right-click on any pill used anywhere in the workspace and select the menu option Show Quick Filter.
How the Status Bar Helps You Understand Visualizations
The status bar appears in the lower left of the worksheet. It provides basic metrics about the number of marks displayed on your visualization.
The map visualization in Figure 1.18 demonstrates the value of the status bar. The map in Figure 1.18 plot pie charts that show sales by city and product category. Notice that the status bar at the bottom left of the worksheet indicating 3,624 marks are in view. The total sales value of the marks is $14,915,601. Each slice in the pies counts as a mark. The status will change if a mark or groups of marks are selected on the worksheet, reflecting the count and value of the selection.
Figure 1.18: Status bar and summary
The larger summary card in the upper right is optional. You can enable it by using the toolbar highlighted in yellow, and then selecting summary.
Saving Time by Using the Show Me Button
Using the Show Me button allows you to build visualizations very quickly. If you can decide on the combination of dimensions and measures you want to analyze, Show Me will build your visualization for you. It will place all of the pills on shelves automatically. See how the maps in Figure 1.18 can be re-created using the Show Me button in Figure 1.19.
You may want to use sales by category and city on the map. To visualize them, multi-select those fields and click the Show Me button. The screen should look like Figure 1.19.
Figure 1.19: Building a map with Show Me
Show Me can be dragged to any location on your desktop. The text at the bottom provides additional feedback on the combination of dimensions and measures that should be selected in order for chart type to be available. Other highlighted chart styles are also supported by the selections of measures and dimensions. The charts that are grayed-out are not available. Note that the time series charts are all gray because a date dimension hasn’t been selected.
The map in Figure 1.18 was created by selecting the map highlighted by Show Me. Leaving the Show Me button open allows you to quickly pick many different chart styles and see the results. Show Me is a time-saver and a great way to see how different pill placements can affect the appearance of your visualization.
Now that you’ve got a basic introduction to the desktop workspace, in Chapter 2: Connecting to Your Data, you will learn a variety of ways to connect the data and the different kinds of datasources using Tableau Desktop.
Get Updates on Tech posts, Interview & Certification questions and training schedules