Course Objective Summary

• Understand the many options for connecting to data
• Understand the Tableau interface / paradigm – components, shelves, data elements, and Terminology.
• The student will be able to use this knowledge to effectively create the most Powerful visualizations.
• Create basic calculations including string manipulation, basic arithmetic calculations,custom Aggregations and ratios, date math, logic statements and quick table calculations.

Introduction To Tableau

• Introduction To Tableau
• Tableau Installation

Tableau Fundamentals

• Help MENU AND SAMPLES
• Connecting to data
• Dimensions and measures
• The tableau interface
• Single table & Multiple table
• Copy and paste

Tableau Server Comprehensive

• Single Installer
• Worker Installer
• Authentication
• Processes
• Data Server
• Backgrounder
• SSL
• Create the First Admin User
• Create Projects and Groups
• Assign Permissions to Projects
• Licensing
• Data Connections
• Metadata management
• Connecting to data with Data Server
• Updating data sources

Tableau Advanced

• Custom SQL
• Editing data connection
• Data menu
• Exporting data connection
• Size and transparency
• Highlighting
• Dual Axis multiple measures
• Dates
• Difference from previous
• Table calculations with other calculations
• Running total
• Cumulative metrics
• Creating custom calculations
• If/then calculations
• Date calculations
• Table calculations
• Efficiency Tips

Administration

• Create Projects and Groups
• Assign Permissions to Projects
• Licensing
• Data Connections
• Effects of different permissions
• Grouping users
• Server security

Visual Analytics

• Grouping
• Aliases
• Filtering
• Cross Tabs-(Pivot tables)
• Aggregation & Disaggregation
• Trend lines
• Page trial
• Total & Subtotal
• Labels and Annotations
• Sharing Workbooks
• Publish to Reader
• Publish to Office
• Publish to PDF

Advanced Tableau

Other Advanced Topics (Any 3)

• Efficiency Tips

• Statistical Calculations

• Logical Calculations

• Table Calculations

• String Calculations

• User and Type Calculations

• Date Calculations

• Authoring for Interactivity

Tableau Advanced Charts (any 4 charts)

• Benford’s Law

• Boxplots

• Bollinger Bands

• Bump Charts

• Control Charts

• Funnel Charts

• Histograms

• Pareto Charts

• Waterfall Charts