Mastering Tableau Calculations Workshop (Virtual)

At OneNumber, we are focused on educating the next great wave of Tableau experts! We're here to provide classes, consulting and content to help you take your skills to the next level. As a Tableau partner, we've served thousands of Tableau users and we hope to play a role in your Tableau journey too!

OneNumber

Don't be afraid of Tableau calculations! Join us for a two day workshop to become a calculation expert!

<h2>Day One</h2><p>8:30 AM - 12:30 PM Pacific</p><h2>Day Two</h2><p>8:30 AM - 12:30 PM Pacific</p><p></p><p>Adopting new technology is daunting, especially if you are coming from another platform you already know well. Many people that are learning Tableau have a background in Excel and maybe even SQL so they understand how calculations work but don't know Tableau's syntax yet. </p><p>This workshop will bridge that gap. <strong>We'll condense months of learning into two, half-days</strong>. I'll be sharing all the tips and tricks I've learned from using the product since 2014, teaching 2,000+ students and working with dozens of companies.</p><p>Topics we will explore include:</p><h3>Math Functions</h3><ul><li>Number Functions Review</li><li>When to Use the ZN Function</li><li>The ABS Function</li></ul><h3></h3><h3>Aggregation</h3><ul><li>Aggregation Functions Review</li><li>W﻿hen to Use Aggregations</li><li>Dealing with Aggregation Errors</li></ul><h3></h3><h3>Logic Functions</h3><ul><li>Basics of Operators and IF THEN</li><li>Grouping with IF THEN</li><li>How to Create Dynamic, Color-Changing Labels</li><li>Combining Multiple Fields with IFNULL</li><li>Meeting a Goal</li></ul><h3></h3><h3>String Functions</h3><ul><li>String Functions Review</li><li>Wildcard Filtering Limitations</li><li>Regular Expressions (REGEXP)</li></ul><h3></h3><h3>Date Functions</h3><ul><li>Calculating Differences Between Dates</li><li>Comparing Month to Date to Previous Month to Date</li><li>Comparing Year to Date to Previous Year to Date</li></ul><h3></h3><h3>Table Calculations</h3><ul><li>How Table Calculations Work</li><li>Comparing Time Periods Apples to Apples</li><li>Highlighting Points in a Line Graph</li><li>W﻿INDOW Functions</li><li>Keeping Only Recent Transactions</li><li>What Does "Specific Dimensions" Mean?</li></ul><h3></h3><h3>LOD Calculations</h3><ul><li>Level of Detail Expressions</li><li>F﻿IXED at the Data Source Level</li><li>Filtering on the Max Date in a Data Set</li><li>Calculating  a Set Percent of Total</li><li>Custom Title Worksheets</li></ul><h3></h3><h3>Best Practices</h3><ul><li>Naming Calculated Fields</li><li>Adding Comments</li><li>Utilizing Folders</li><li>Case Sensitivity</li><li>Line Breaks</li></ul><p></p><h2>Requirements:</h2><ul><li>A Personal Computer</li><li>An External Monitor (strongly recommended)</li><li>Tableau Desktop Professional 2020.1 or later</li></ul><ul></ul><p></p><h2>Prerequisites:</h2><p>Some experience using Tableau Desktop. You should be able to do the following:</p><ul><li>Connect to a data source.</li><li>Understand the difference between measures and dimensions.</li><li>Be able to build calculated fields on your own.</li><li>Build a basic dashboard.</li><p></p></ul><h2>What will you get?</h2><p>In addition to two half-days of instruction, attendees will walk away with a 100+ page digital manual and data files to revisit the concepts on their own later.</p><p></p><h2>Where will this be hosted?</h2><p>This training will be hosted virtually. Details will be sent after registration.</p><p></p><h2>What people are saying about OneNumber and trainer Eric Parker:</h2><p>"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.</p><p>"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</p><p>eric.parker@onenumber.biz</p><p><a href="http://onenumber.biz/" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">onenumber.biz</a></p>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}