Next Level Tableau for Power Users (Intermediate Tableau)

Learn to use core Tableau date and reporting functions for an intermediate-level of expertise

Course Code : 1244

[RICH_REVIEWS_SNIPPET stars_only=”true” category=””]

$1795

Overview

This two-day, fast-paced, hands-on intermediate and beyond level Tableau training program aims to help Tableau users take their skills to the next level and become a true Power User. The course requires participants to have a complete understanding of all the fundamental concepts of building worksheets and dashboards. The course equips participants with all the necessary skills and knowledge to use the core Tableau data and reporting functions to acquire an intermediate level of expertise in working with Tableau.

Schedule Classes

Delivery Format
Starting Date
Starting Time
Duration

Live Classroom
Thursday, 6 June 2019
10:00 AM - 6:00 PM EST
2 Days

Delivery Format
Starting Date
Starting Time
Duration

Live Classroom
Monday, 26 Aug 2019
10:00 AM - 6:00 PM EST
2 Days

Delivery Format
Starting Date
Starting Time
Duration

Live Classroom
Thursday, 5 December 2019
10:00 AM - 6:00 PM EST
2 Days

Looking for more sessions of this class?

Course Delivery

This course is available in the following formats:

Live Classroom
Duration: 3 days

Live Virtual Classroom
Duration: 3 days

What You'll learn

  • Build advanced chart types and visualizations
  • Build complex calculations to manipulate data
  • Work with statistics and statistical techniques
  • Work with parameters and input controls
  • Implement advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data
  • Joining multiple tables
  • Data blending
  • Performance considerations and working with the Data Engine
  • Sharing connections as meta data
  • Understand when to implement which connection method
  • Build better dashboards using techniques for guided analytics, interactive dashboard design and visual best practices
  • Implement many efficiency tips and tricks
  • Understand the basics of Tableau Server and other options for sharing your results

Outline

  • Why Tableau? Why visualization?
  • The Tableau product line
  • Level setting – terminology
  • Getting started – creating some powerful visualizations quickly
  • Review of some key fundamental concepts
  • Filtering, sorting and grouping are fundamental concepts when working with and analyzing data
  • Advanced options for filtering and hiding
  • Understanding your many options for ordering and grouping data
    • Sort
    • Groups
    • Bins
    • Sets
  • Understanding how these options inter-relate
  • Learn the differences between joining and blending data
  • Consider the implications of working with large data sets, and options for when and how to work with extracts and the data engine
  • Investigate best practices in ‘sharing’ data sources for Tableau server users
  • Data types and roles
    • Dimension vs. measures
    • Data types
    • Discrete vs. continuous
    • The meaning of pill colors
  • Database joins
  • Data blending
  • Working with the data engine/extracts and scheduling extract updates
  • Working with custom SQL
  • Adding to context
  • Switching to direct connection
  • Building meta data via shared data source connections
  • Performance considering and working with Big Data
  • OLAP considerations (overview)
  • Understand the intricacies of manipulating data within Tableau
    • Quick review of basic calculations
    • Arithmetic calculations
    • String manipulation
    • Date calculations
  • Quick table calculations
  • Custom aggregations
  • Custom calculated fields
    • Logic and conditional calculations
    • Conditional filters
  • Advanced table calculations
    • Understanding scope and direction
    • Calculate on results of table calculations
    • Complex calculations
    • Difference from average
    • Discrete aggregations
    • Index to ratios
  • Understanding where calculations occur
    • Statistics
    • Reference/trend lines
    • Statistical calculations
    • Summary stats
    • Cohort analysis
  • Working with dates and times
    • Continuous vs. discrete dates
    • Dates and times
    • Reference dates
  • Working with mapping functions
  • Working with custom geographies and geo-coding
  • Working with alternate WMS server and spatially visualizing non-geographic data
  • Fundamentals review: Building basic maps
    • Fixing geographies
    • Geographic fields
    • Map options
  • Built-in demographics/layering
  • WMS – working with a Web Map Service
  • Importing custom geographies
  • Assigning geographies to non-geographic fields
  • Distance calculations
  • Spatially visualizing non-geographic data using background images and geo-coding
  • How to use parameters to modify our title, create What-If analysis, etc.
  • Parameter basics
    • Data types of parameters
    • Using parameters in calculated fields
    • Inputting parameter values and parameter control options
  • Advanced usage of parameters
    • Using parameters of titles, field selections, logic statements, Top X
  • Create chart types and visualization that may be less obvious in Tableau
  • Common tips and tricks
  • Techniques to assist customers in solving more complex problems
  • Bar in bar
  • Box plot
  • Bullet chart
  • Custom shapes
  • Gantt chart
  • Heat map
  • Pareto chart
  • Spark line
  • KPI chart
  • Formatting tips
    • Drag to legend
    • Edit legend
    • Fill 100% black line
    • Highlighting
    • Labelling
    • Legends
    • Working with Nulls
    • Table options
    • Annotations and display options
  • Introduction to visualization best practices
  • How to build effective and interactive applications via dashboarding
  • Interactive dashboards
    • Quick filters
    • Dashboard objects
    • Filter actions
    • Highlighting and actions
    • Performance
    • Publish to web
    • Zones
  • Guided analytics
    • Cascading filters
    • Highlighting
    • Quick filter options
    • Select then see visuals
    • Self-populating dashboards
    • Shortcuts
    • URL actions
  • Publishing to tableau server – overview of publishing, scheduling and security options
  • Tableau server usage – Interacting with published visualizations
View More

Prerequisites

This is an intermediate and beyond-level Tableau course, and participants need to have attended one of the below courses or have skills equivalent to the same –

  • Introduction to Tableau | Tableau JumpStart
  • Working with Tableau | With next level topics
  • Tableau desktop fundamentals

Who Should Attend

The course is highly recommended for –

  • Integration analysts
  • Data analysts
  • Data visualizers
  • Financial analysts
  • Business analysts
  • Programmers
  • Business intelligence professionals

Interested in this course? Let’s connect!