TABLEAU

Length: I Class (1 Hour)

Duration – 30 days

Audience:

• Anyone who wants to start his/her career as a Tableau Administrator / Developer / Consultant.
• Anyone working on technologies which are doing not so good in the market like Mainframes, SAP, Siebel, Oracle, Java, Microsoft .Net
• Business Intelligence Architecture

Student Location– To students from around the world

Delivery Method: Instructor-Led – Live online Training

Lesson 0: Introduction to Tableau

• Benefits of Tableau
• Use of tableau in the industry

Lesson 1:Field Types & Visual Cues

• Application terminology and definitions
• View terminology and definitions
• Fields on shelves
• Fields in the data window
• Data terminology and definitions

Topics covered in DEMO

• The Tableau Environment, Start Page, Data Source Page, The Tableau Workspace, Workbooks and Sheets
• Data Types, Data Roles

Topics covered in Exercises

• Navigating the interface, Connecting to saved sample superstore data source, Creating a simple view

Lesson 2:Data Connections

• 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

Topics covered in DEMO

• Connecting to excel, Joining tables, creating extracts, Meta data
• Data Types, Data Roles

Topics covered in Exercises/Mini projects

• Connecting to sample superstore excel file & joining tables
• Connecting to sample - Coffee Chain access file via custom SQL
• Data blending

Lesson 3:Organizing & Simplifying Data

• Filtering
• Sorting
• Creating a Combined Field
• Grouping
• Sets
• Drilling, Hierarchies
• Grand Totals, Sub-totals, and Changing Aggregation
• Bins

Lesson 7:Chart Types

• Combined or Shared Axis Charts
• Combo charts – bar and line or mixed mark
• Geographic mappings and geocoding (tutorial)
• Scatter plots – scatter graph
• 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
• Spark lines

Lesson 10: Mapping

• 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