Business Analytics + Tableau Advanced
Duration : 40 hours
Audience:
This course is designed to provide you with the skills required to become a Tableau power user. The course is designed for the professional who has solid working experience with Tableau and wants to take it to the next level. You should have a deep understanding of all the fundamental concepts of building worksheets and dashboards, but may scratch your head when working with more complex issues.
Duration:
30-35 Hours
Pre-requisites:
None
Learning Objectives: At the end of this class, the student will be able to:
Course Topics:
Introduction and Getting Started
Filtering, Sorting & Grouping– Filtering, Sorting and Grouping are fundamental concepts
when working with and analyzing data. We will briefly review these topics as they apply to Tableau
Working with Data– In the Advanced class, we will understand the difference between joining and blending data, and when we should do each. We will also consider the implications of working with large data sets, and consider options for when and how to work with extracts and the data engine. We will also investigate best practices in “sharing” data sources for Tableau Server users.
o Dimension versus Measures
o Data Types
o Discrete versus Continuous
o The meaning of pill colors
Working with Calculated Data and Statistics– In the Fundamentals Class, we were introduced to some basic calculations: basic string and arithmetic calculations and ratios and quick table calculations. In the Advanced class, we will extend those concepts to understand the intricacies of manipulating data within Tableau
o Arithmetic Calculations
o String Manipulation
o Date Calculations
o Quick Table Calculations
o Custom Aggregations
o Custom Calculated Fields
o Logic and Conditional Calculations
o Conditional Filters
o Understanding Scope and Direction
o Calculate on Results of Table Calculations
o Complex Calculations
o Difference From Average
o Discrete Aggregations
o Index to Ratios
Working with Parameters– In the Fundamentals class, we were introduced to parameters – How to create a parameter and use it in a calculation. In the Advanced class, we will go into more details on how we can use parameters to modify our title, create What-If analysis, etc
o Data types of parameters
o Using parameters in calculated fields
o Inputting parameter values and parameter control options
o Using parameters for titles, field selections, logic statements, Top X
Building Advanced Chart Types and Visualizations / Tips & Tricks– This topic covers how to create some of the chart types and visualizations that may be less obvious in Tableau. It also covers some of the more common tips & tricks / techniques that we use to assist customers in solving some of their more complex problems.
Best Practices in Formatting and Visualizing
o Drag to Legend
o Edit Legend
o Highlighting
o Labeling
o Legends
o Working with Nulls
o Table Options
o Annotations and Display Options