DAY 1 : TABLEAU INTRODUCTION
- Need for Business Intellgence (BI)
- Need for Reporting Tools
- Need for Data Visualizations
- Tableau Data Analyst Roles
- Tableau Business Analyst Roles
- Tableu - Scope and Advantages
- Why Tableau? Why Visualizations?
- Level Setting and Terminology
- Tableau Product Line in Real-world
- Licensing and Pricing in Tableau
- Integration Components in Tableau
- Comparing Tableau and Power BI
- Comparing Tableau and QlikView
DAY 2 : TABLEAU INSTALLATION
- Installing Tableau Desktop Tool
- Understanding the Interface
- Menu Options and Data Access Options
- Integration Components in Tableau
- Designing Basic Reports in Tableau
- Understanding the Tableau workspace
- Understanding Dimensions and Measures
- Using "Show Me" Options & Workspace
- Working of Shelves and Marks
- Building Basic Views in Tableau
- Help Menu and Samples in Tableau
- Saving and Sharing your work
- Application Terminology, Definitions
- Data Source Page, Tableau Workspace
- Distributing and Publishing Reports
DAY 3 : TABLEAU PREP
- Tableau Prep Interface - Examples
- Building Flows in Tableau Interface
- Input Step and Cleaning Step
- Adding Data to Flow, Wildcard Union
- Data Sampling, Additional Inputs
- Data Cleansing - Context, Process
- Annotations and Cleaning Options
- Group & Replace, Out of Domain Values
- Fuzzy Matching Algorithms and Notes
- Profile Pane in Tableau & Errors
- Data Highlighting, Distribution
- Pivot Step and Aggregation Step
- Join Configuration Pane, Join Edits
- Union Configuration Pane, Union Edits
- Output Step : Creation and Edits
- Running the Flow, Multi Output
- Preview in Tableau Desktop
DAY 4 : DATA SOURCES IN TABLEAU
- Connecting to DAT and CSV File Sources
- Connecting to Excel File Sources, Sheets
- Connecting to OLTP Database Sources
- Connecting to DWH Database Sources
- Connecting to OLAP Database Sources
- Connecting to Cloud Databases Tableau
- Connecting to Files & Folders in Tableau
- Working with Multiple Sheets - Live, Extract
- Extract Refresh, Publish Data Source
- Metadata Edits, Connection Edits
- Join Types: Inner, Outer and Union
- Cross Database Joins, Data Blending
- Data Blending - Calculations, Aggregations
- Aestricks, Pdf Connections. Headers, Pivots
DAY 5 : VISUAL ANALYTICS - Level 1
- Marks and Mark Types in Power BI
- Number, Aggregations in Marks
- Bulding View, Highlights, Details
- Hierarchies and Drilldown Options
- Sorting from Pill, Nested Sorts
- Grouping Headers, Grouping Pane
- Grouping Marks, Visual Grouping
- Calculations, Parameters in Grouping
- Creating and Combining Sets - Marks
DAY 6 : VISUAL ANALYTICS - Level 2
- Data Filters and Fitler Shelf - Usage
- Pill Types in Filtering and Dates
- Measures and Continous Dimensions
- Interactive Filters - Layout Modes
- Casading Interactive Filters - Usage
- Where Tableau Filters, Summaries
- Data Source Filters, Record Filters
- Context Filters and Worksheets
- Filter Order with Filter Queries
- Parameters in Tableau - Types
- Parameters and Filters Usage
- Parameters with Sets, Calculated Fields
- Parameters with Reference Lines
|
DAY 7 : VISUAL ANALYTICS - Level 3
- Formatting Options with Tableau
- Labels, Annotations and Tooltips
- Formatting Specific Parts of the View
- Editting, Formatting Axes. Map Layers
- Formatting Pane: Formatting Menu
- Font, Alignment, Shading, Borders
- Lines, Copy/Paste, Workbook Formats
- Tooltips: Storytelling, selection, Action
- Command Buttons, Conditional Tooltips
- Viz in Tooltip, Size and Filters
- TrendLines, Significance and Residuals
- Command Buttons & Conditional Tooltips
- Reference Lines: Adding, Edits, Formats
- Lines, Bands, Distribution and Boxes
- Reference Bands, Reference Distributions
- Box Plots, Drop Lines and Forecasts
DAY 8 : VISUAL ANALYTICS - Level 4
- Forecast Fields and Descriptions
- k-means Cluster Analysis, Conditions
- Using MDX and cohort Calculations
- Grouping and Calculated Members
- OLAP Cube Reports in Real-time
- Map Reports : Latitudes, Longitudes
- Coordinate Points, GeoCoding
- Plotting Graphs, Symbols, Filled Maps
- WMS and Map Layers. Spatial Data
- Polygon Maps, Background Images
- Mapbox Integration - Classic and GL
DAY 9 : CALCULATIONS
- Tableau ─ Operators and Functions
- Calculations Syntax, LOD Expressions
- Numeric Calculations, String Calculations
- Table Calculations and FieldSet, Edits
- Manual, Quick Table Calculations
- Aggregate Calculations, Columns
- Date Calculations, Tableau Dates
- Logic Calculations, String Calculations
- Number Calculations, Type Calculations
- Nested LOD Calculations, Integrations
- Granularity and Ratio Calculations
DAY 10: TABLEAU CHARTS - Level 1
- Bar Chart : Simple Bar Chart
- Bar Chart Color Range , Stacked Bar
- Line Chart Simple Line Chart
- Multiple Measure Line Chart
- Line Chart with Label Tableau - Pie Chart
- Simple Pie Chart Drill-Down Pie Chart
- Crosstab, Simple Crosstab Crosstab
- Color Encoded Crosstab - Row Percentage
- Scatter Plot, Simple Scatter Plot
- Scatter Plot - Color Encoded Properties
- Scatter Plot - Drill-Down Scatter Plot
DAY 11: TABLEAU CHARTS - Level 1
- Bubble Chart : Simple Bubble Chart
- Bubble Chart with Measure Values
- Bubble Chart with Measure Colors
- Bullet Graph and Real-time Use
- Box Plot Creating Box Plot Tableau
- Creating Tree Map - Bump Chart
- Bump Chart and Gantt Chart
- Gantt Chart Versus Histogram
- Motion Charts and Properties
- Waterfall Charts and Properties
DAY 12 : DASHBOARDS & STORIES
- Dashboards and Stories in Tableau
- Bulding Dashboards - Views, Sheets
- Dashboard Size, Views, Objects
- Legends and Quick Filters in Tableau
- Tiles, Floating Layouts in Tableau
- Layout Containers, Images, Web Pages
- Dashboard Extensions, Management
- API Extensions - Usage in Tableau
- Device Designer - Default Layout
- Adding and Customizing Layouts
- Story Points - Creation and Updates
- Bollinger Bands - Views, Summary
- Data Cleansing - Bulk Re-aliasing
REAL-TIME CASE STUDY
Working with Tableau Prep
Working with Tableau Desktop
Cloud Data Sources, Mapping
Data Cleansing and LOD Expressions
Calculations and Dashboards
Storytelling with Analytics, Filters
|
DAY 13 : TABLEAU ONLINE
- Tableau Online - Architecture
- Publish Tableau Workbook, Verify
- Sharing Options and Layouts
- Adding Device Layouts in Tableu Online
- Adding Custom Layouts in Tableau Online
- Adding Content to Custom Layouts
- Java Script API in Table Online
- Security Advantages @ Tableau Online
DAY 14 : TABLEAU SERVER
- Tableau Server - Architecture
- Tableau Server - Installation Process
- Publish Tableau Workbook, Verify
- Sharing Options and Layouts
- Adding Device Layouts in Tableu Server
- Adding Custom Layouts in Tableau Server
- Adding Content to Custom Layouts
- Java Script API in Table Server
- Tableau Online Versus Table Server
- Security Advantages @ Tableau Server
- Performance Advantages @ Tableau Server
DAY 15 : Colloborate TABLEAU ONLINE
- Tableau Online - Purpose, LIVE Reports
- Projects and Workbooks in Tableau Online
- Tableau Report Views in Tableau Online
- Searching Content, Data Sources, Sites
- Account Settings, Drill Down, Actions
- Custom Views, Comments - Tableau Online
- Downloads, Exports - Tableau Online
- Sharing, Subscription and favorites
- Web Authoring, Edits and Publish Online
- Data Driven Alerts - Refining, Managing
- Stacked Bars and Views For Alerting
- Navigations, Snapshots, Searching
- Mobile Reports - Phone Marks and Maps
- Interacting with Content on Tableau Online
DAY 16 : Colloborate TABLEAU SERVER
- Tableau Server - Purpose, LIVE Reports
- Projects, Workbooks in Tableau Server
- Tableau Report Views in Tableau Server
- Searching Content, Data Sources, Sites
- Account Settings, Drill Down, Actions
- Custom Views, Comments in Tableau Server
- Downloads and Exports in Tableau Server
- Sharing, Subscription and favorites
- Web Authoring, Edits and Publish Online
- Data Driven Alerts - Refining, Managing
- Stacked Bars, Alerting Views in Server
- Navigations, Snapshots, Searching in Server
- Mobile Reports - Phone Marks and Maps
- Interacting with Content on Tableau Server
DAY 17 : MANAGE TABLEAU ONLINE
- Tableau Online - Administration Concepts
- Tableau Sites, Users and Groups Security
- Schedules, Tasks, Status in Tableau Online
- Settings and Alerts in Tableau Online
- Tableau Bridge - Need, Requirements
- Brdige Client Setup and Secured Usage
- Tableau Bridge Client - LIVE Connections
- Tableau Command Line Utility - Usage
- R Integration with Tableau Online
- Cloud Integration with Tableau Online
DAY 18 : MANAGE TABLEAU SERVER
- Tableau Server - Administration Concepts
- Tableau Sites, Users, Groups Security
- Group Rules, Web Edits in Tableau Server
- Project Permission and Locking Options
- Data Security with user Filters in Server
- user Filters and Hybrid Models in Server
- Access Roles, Schedules, Extraction
- TSM : Tableau Services Manager
- TSM Configuration for Real-time Use
- Browser, Maintenance, GUI and CLI
- Backups and Restores with Tableau TSM
- TSM Upgrades For Tableau Report Config
- Tabcmd : Command Line Utility - Imports
- Tabcmd : user Import via CSV File
- Comparing Tableau & Microsoft Power BI
REAL-TIME CASE STUDY
Working with Tableau Online
Working with Tableau Server
Table Bridge with LIVE Edits
Data Refresh - Auto, Manual
Dashboards & Worksheets - Security
Users, Roles and Group Security
|
