TABLEAU

– Connecting to data
– Introduction to data source concepts
– Working with data files versus database servers – Understanding the Tableau workspace
– Dimensions and measures – Using Show Me!
– Tour ofshelves (how shelves and marks work) – Building basic views
– Help menu and samples
– Saving and sharing your work

– Overview of other connection options
– Joining multiple tables
– Data blending
– Copy and paste
– Data extracts
– Custom SQL
– Publishing and reusing data connections
– Understand how to deal with data changes in your data source such as field addition, deletion or name change
– Re-using and sharing data connections (meta data)
– Working with multiple connections in the same workbook

Creating Views
– Marks
– Highlighting
Working with Dates
– Date aggregations
– Discrete vs. Continuous
– Multiple measures
– Different mark types
– Page trails
– Density chart
– Pie charts
– Aggregate vs. disaggregate
– Size and transparency
– Dates
– Date parts
– Dual axis
– Combo charts
– Geographic map
– Heat map
– Scatter plots
– Bar charts
– Small multiples
Analyzing
– Sorting
– Grouping
– Aliases
– Filtering and quick filters
– Cross-tabs (pivot tables)
– Drilling and drill through
– Percent of total
– Totals and subtotals
– Aggregation disaggregation
– Stats and trend lines

– Publish to Reader
– Packaged Workbooks – Publish to Office
– Publish to PDF
– Publish to Tableau Server and sharing on the web

– Scenario-based review exercises
– Best practices

1)Working with string functions
2) Basic arithmetic calculations
3) Date math
4) Working with totals
5) Custom aggregations
6) Logic statements