What you will learn
- Gain proficiency in Tableau Desktop for data visualization and analytics.
- Create a wide variety of visualizations, from basic to advanced.
- Build interactive dashboards and compelling data stories in Tableau.
- Utilize advanced analytics features for deeper insights.
- Integrate Tableau with diverse data sources and automate data processes.
- Collaborate and share insights using Tableau Server, Online, and Public.
Beneficial for
- Data Analysts
- Business Intelligence Professionals
- Data Scientists
- Business Users involved in data analysis
- Anyone looking to harness the power of Tableau for data visualization.
Course Pre-requisite
- Basic understanding of data analysis concepts.
- Familiarity with Microsoft Excel is beneficial.
- Enthusiasm and curiosity for working with data and creating visualizations.
Course Outline
Benefits of Tableau
Use of tableau in the industry
Application terminology and definitions
View terminology and definitions
Fields on shelves
Visual cues for fields
Fields in the data window
Data terminology and definition
Connecting to Tableau Data Server
From the same database, Understand connection options
Working with extracts
Custom SQL Data Connection
Database joins
Database blending
Understand Kerberos authentication
Understanding Performance optimization
Parallel query
Data engine vectorization
Parallel aggregation
External query caching
Query fusion
Tableau Data Interpreter
Metadata grid
Pivot
Filtering
Sorting
Creating a Combined Field
Grouping
Sets
Drilling, Hierarchies
Grand Totals, Sub-totals, and Changing Aggregation
Bins
Use spatial analysis
Effectively use titles, captions and tooltips (tutorial)
Format results with edit axes
Formatting Your View
Format results with mark labels and annotations
Date hierarchies (tutorial)
Different date parts on different shelves
Discrete and continuous date parts
Continuous dates
Custom dates
Define a fiscal year
Relative date filtering
Date hierarchies and OLAP considerations
Measure values and names (tutorial)
When to use measure values and names
Number of records
Generated latitude and longitude
Combined or Shared Axis Charts
Combo charts – bar and line or mixed mark
Geographic mappings and geocoding (tutorial)
Scatter plots – scattergraph
Cross tabs – text tables or pivot tables
Highlight table
Motion Charts
Heat maps
Bins, histograms, calculated bins
Motion charts – working with Page Shelf and History
Pie charts
Bullet graphs
Bar in bar
Box plots – box and whisker diagram or plot (tutorial)
Market Basket Analysis
Waterfall Charts
Gantt bar chart
Manipulate strings calculations
Date Calculations
Build arithmetic calculations
Work with aggregation options (tutorial)
Build logic statements (tutorial)
Build grand totals, sub-totals and changing aggregation
Create quick table calculations
Use automatic & custom split
Use Ad-hoc Analytics
Creating Parameters
Using Parameters and Reference Lines
Using Parameters with Filters
Modify locations within Tableau
Import and manage custom geocoding (tutorial) (kb)
Use a background image map (tutorial) (kb)
Modifying Geocode Locations within Tableau
Use Geographic search
Use Map Data & Pan/Zoom
Use Lasso & Radial Selection
Reference lines
Reference bands
Reference distributions
Trend lines
Trend model
Statistical summary card
Drag & Drop Analytics
Instant Analytics
Build dashboards (tutorial)
Utilize visual best practices for dashboard design
Use options for running actions (kb)
URL actions
Highlight actions (kb)
Filter actions (kb)
Create a drill-down report (kb)
Sharing Your Work
