Mastering Tableau Calculations II (Virtual) | Pacific Time

Don't be afraid of advanced Tableau calculations! Join us for a two day workshop to become a master of Sets, Parameters and LODs!
About this Event

Day One

8:30 AM - 12:30 PM Pacific

Day Two

8:30 AM - 12:30 PM Pacific

Calculations are one of the most intimidating topics in Tableau. Especially when it comes to advanced features like incorporating Sets and Parameters into your formulas and utilizing Level of Detail expressions to alter levels of aggregation.

Years in the making, Mastering Tableau Calculations II will open doors you didn't know existed! From de-duplicating data to filtering multiple time periods with a single input, this workshop will teach you the skills you need to be a certified Tableau calculation ninja.

Are you ready to take your Tableau calculation game to new heights? Join us!

Topics we will explore include:

Sets and Calculations

Top 10 and Other
Asymmetric Drilldowns
M ulti-Select Sets in Calculations
Segmented Comparisons

Adjust Values with Parameters

Change Top N
Dynamic Goals and Reference Lines
Filtering on Top Percent of Values
Dynamic Labels

Swap Fields with Parameters

Swap Measures
Swap Dimensions
Swap Worksheets

Customize Dates with Parameters

Swap Date Units
Filter Multiple Date Fields at Once
Custom Date Filters
Dynamic Date Parameter

Level of Detail Expressions Introduction

FIXED
INCLUDE and EXCLUDE
Data Source Level Aggregation

Level of Detail Expressions for Analysis

Cohort Analysis
Frequency Analysis
Finding Highest/Lowest Values in a Range
M ulti-Row Logic
Keep Only Values with Multiple Records

Level of Detail Expressions for Duplication

Return a Single Record Count for a Stacked Bar Chart
De-Duplicate Repeated Values
Keep Only Over Value per ID

Requirements:

A Personal Computer
An External Monitor (strongly recommended)
Tableau Desktop Professional 2020.1 or later

Prerequisites:

Some experience using Tableau Desktop. You should be able to do the following:

Combine Multiple Tables of Data for Analysis in Tableau
Write Calculations
Build and Share Dashboards

What will you get?

In addition to two half-days of instruction, attendees will walk away with a 100+ page digital manual, data files to revisit the concepts on their own later, and access to class recordings for two weeks.

Where will this be hosted?

This training will be hosted virtually. Details will be sent after registration.

What people are saying about OneNumber and trainer Eric Parker:

"After spending a couple days working with OneNumber, we are months, no, lightyears ahead of where we would be otherwise." - A OneNumber client to their CEO.

"Eric is one of the best instructors that I have ever had. Everything was paced very well and the content was extremely valuable. Personable, helpful and patient. Willing to explore with us students and excited about using Tableau, like we are!" -A Former Student

[email protected]

onenumber.biz