Course Overview
TOPThis Tableau course covers the complete workflow for effective Tableau use, including locating and evaluating data, connecting common file formats, preparing data for analysis, creating charts and maps, developing calculations, applying filters, and building dashboards and stories. Participants learn how Tableau organizes dimensions, measures, dates, and geographic information while working with realistic business data. The course emphasizes choosing appropriate chart types, presenting information accurately, and creating visualizations that are clear and easy to use. By the end of the course, participants will have created and formatted a multi-view interactive dashboard and will understand the options for saving, printing, exporting, and publishing Tableau content.;
Scheduled Classes
TOPWhat You'll Learn
TOP- Data and visualization fundamentals: Understand how data is organized, where business data is commonly found, and how visualizations help answer questions.
- Tableau fundamentals: Learn how Tableau Desktop works with Tableau Cloud, Tableau Server, Tableau Public, and other parts of the Tableau platform.
- Data connections: Connect to Excel, CSV, text, and other common data sources and understand the difference between live connections and extracts.
- Data preparation: Use Tableau tools to review field names, data types, null values, geographic information, and the structure of a dataset.
- Data organization: Use Data Interpreter, pivots, relationships, joins, and unions to prepare data for analysis.
- Visual analysis: Create tables, bar charts, line charts, treemaps, scatter plots, maps, and other common visualizations.
- Calculations and aggregation: Work with aggregations such as sum, average, minimum, maximum, and count, and create basic calculated fields.
- Sorting and filtering: Sort, group, filter, and organize information so that visualizations focus on relevant data.
- Formatting and interaction: Use color, size, detail, labels, tooltips, filters, and formatting controls to improve and customize visualizations.
- Dashboard and story creation: Combine worksheets into dashboards and stories that present information clearly and support user interaction.
- Sharing Tableau work: Save, package, print, export, and publish Tableau visualizations and workbooks.
Outline
TOPDay 1: Understanding Data and Creating Visualizations
Understanding data and visual analysis
- Understanding what data is and how it is used
- Recognizing records, fields, dimensions, and measures
- Identifying common sources of organizational data
- Understanding structured and unstructured data
- Recognizing characteristics of analysis-ready data
- Translating a business question into an analytical question
- Understanding how visualizations reveal comparisons, patterns, trends, and outliers
- Selecting visualizations based on the information being communicated
- Avoiding misleading or unnecessarily complicated visualizations
Getting started with Tableau
- Understanding common uses for Tableau
- Reviewing the Tableau product environment
- Distinguishing Tableau Desktop, Tableau Cloud, Tableau Server, and Tableau Public
- Understanding the basic Tableau workflow
- Opening Tableau and reviewing the start page
- Connecting to a sample dataset
- Creating a first visualization
- Saving a Tableau workbook
Navigating the Tableau Desktop workspace
- Working with workbooks, worksheets, dashboards, and stories
- Navigating the Data and Analytics panes
- Understanding shelves, cards, fields, and pills
- Working with the Marks card
- Understanding dimensions and measures
- Recognizing discrete and continuous fields
- Understanding blue and green fields
- Using the Show Me panel
- Changing the visualization suggested by Show Me
- Undoing, redoing, reverting, and saving work
- Duplicating and renaming worksheets
Connecting to and reviewing data
- Identifying data needed for an analysis
- Connecting to Excel workbooks
- Connecting to CSV and text files
- Reviewing other available data connectors
- Understanding common file and data formats
- Reviewing tables on the Data Source page
- Previewing records and source information
- Understanding live connections and extracts
- Creating and refreshing an extract
- Assigning and correcting data types
- Renaming and hiding fields
- Working with aliases
- Assigning geographic roles
- Recognizing null, missing, and incomplete values
- Refreshing a data connection
Preparing and structuring data
- Understanding how data should be structured for Tableau
- Recognizing headers, field names, records, and summary rows
- Using Data Interpreter to identify usable data
- Removing unnecessary headers and formatting from imported data
- Splitting combined values into separate fields
- Pivoting columns into rows
- Combining similarly structured data with unions
- Understanding the purpose of relationships
- Reviewing the basic difference between relationships and joins
- Recognizing when multiple tables are needed
- Confirming totals and record counts after preparing data
Creating foundational visualizations
- Starting a visualization with an analytical question
- Creating a text table
- Creating a highlight table
- Creating bar and stacked bar charts
- Creating line and area charts
- Visualizing changes over time
- Creating treemaps
- Creating scatter plots
- Changing mark types
- Using Show Me to explore appropriate chart options
- Applying fields to Color, Size, Label, Detail, and Tooltip
- Changing the aggregation applied to a measure
- Editing axes, headers, and titles
- Duplicating and modifying a visualization
- Comparing different visual approaches to the same data
Sorting, grouping, and filtering data
- Sorting data manually
- Sorting by field values
- Creating groups from related values
- Creating bins for numeric data
- Building and using hierarchies
- Drilling into and out of hierarchical information
- Filtering categorical values
- Filtering numeric measures
- Filtering dates and date ranges
- Keeping or excluding selected marks
- Displaying interactive filter controls
- Customizing the appearance of a filter control
- Selecting single-value and multiple-value filter options
- Applying a filter to multiple worksheets
- Clearing and resetting filters
Day Two: Calculating, Formatting, and Sharing Results
Working with calculations and aggregations
- Understanding how Tableau aggregates data
- Working with
SUM,AVG,MIN,MAX, andCOUNT - Changing the aggregation used for a measure
- Understanding row-level and summarized values
- Creating a calculated field
- Performing arithmetic calculations
- Creating ratios and percentages
- Building basic conditional calculations
- Using simple
IFstatements - Working with basic date calculations
- Handling null values in calculations
- Editing and validating calculated fields
- Applying calculated fields to a visualization
- Using quick table calculations
- Calculating percent of total
- Creating running totals and differences
- Adding totals and subtotals
- Confirming that calculated results are reasonable
Enhancing and Interacting with Visualizations
- Navigating Tableau’s formatting tools and menus
- Formatting an entire worksheet
- Formatting specific fields and parts of a view
- Formatting numbers, percentages, currency, and dates
- Editing fonts, alignment, lines, borders, and shading
- Editing and formatting axes
Prerequisites
TOPWe recommend that you have Tableau before starting this class.