Course to Maximize your Business Intelligence, Data Visualization, Advanced Analytics skills to make foray into the BI, BIG DATA & ANALYTICS World!
Target Audience: Business Users, BI Analysts, Data Analysts, Business Analysts, Quality Analysts & IT Beginners.
MODULE-1: BUSINESS INTELLIGENCE & TABLEAU
-
Basics of Business Intelligence
-
Business Intelligence Market Overview
-
Tableau in Gartner’s Magic Quadrant BI and Analytics Platform
-
Products - Tableau Desktop, Server, Public, Online
MODULE-2: TABLEAU INTRODUCTION
-
Tableau Public Installation
-
Client Server Architecture
-
Data Connector Components
-
VizQL & Data Server
-
Tableau Public Installation
-
Initial Setup and Configuration
-
Understanding Tableau Desktop Structure
MODULE-3: KNOW YOUR TABLEAU ENVIRONMENT
-
Data Window
-
Cards & Shelves
-
Toolbars
-
Workspace Controls
-
Analytics Window
-
Mark Label & Tool Tip
-
Show Me Option
-
Sheets, Story & Dashboard
-
Customizing Workspace
MODULE-4: CONNECTING TO DATA
-
Connecting to Excel (File Data)
-
Connecting to Postgre Server (Relational DB)
-
Installation Setup for additional Database drivers
-
Connecting Live or Extracting
-
Fetching Data using Custom SQL
-
In Memory Data - Extract
-
Join Types
MODULE-5: DATA MODIFICATION AND BLENDING
-
Metadata Modifications
-
Field Alias
-
Rename
-
Split
-
Custom Split
-
Combine
-
Hide/Unhide
-
Working with Data Extracts
-
Replacing/Swapping Data Source
-
Using Data from Clipboard
-
Duplicating Data Connections
-
Data Blending (Creating Relationships)
-
Data Types – Measures and Dimensions
-
Converting Dimensions to Measure
-
Discrete and Continuous Measures
-
EXERCISE-1
MODULE-6: ANALYTICS PART-I
-
Tree, Heat & Geo Map
-
Crosstabs and Motion Charts
-
Heat and Tree Maps
-
Pie, Bar and Gantt Charts
-
Scatter Plots and Combination Charts
-
Area Charts and Line Charts
-
Bubbles and Histograms
-
Bullets and Dual Combination
-
Text Tables and Highlight Tables
-
Symbol Maps and Filled Maps
-
Horizontal Bars, Stacked Bars, Side-by-side Bars
-
Tabular View
-
Polygon Map
MODULE-7: ANALYTICS PART-II
-
Date Functions
-
Creating Calculated Fields
-
Sets, Bins, Groups & Hierarchies
-
Sorting Data
-
Formatting Viz
-
Aggregation & Disaggregation
-
Using Parameter
-
Trend Lines
-
Reference Lines
-
Confidence Band
-
Table Calculations
-
Blended Axis and Dual Axis
MODULE-8: ANALYTICS PART-III
-
Forecasting
-
Working with LOD expressions
-
Date Filters
-
Dimension Filters
-
Measure Filters
-
Interactive Filters
-
Highlighting Filters
-
EXERCISE -2
MODULE-9: CREATING DASHBOARDS & STORIES
-
Adding Views to Dashboard
-
Dashboard Formatting Toolset
-
Working with Horizontal and Vertical Sections
-
Dashboard Page Layout
-
Creating a Story
-
Story Workspace
-
Different Between Dashboard & Story
-
Crosstab & Exporting Data
-
Creating Dashboard Actions
-
Difference between Filter, Highlight and URL Action
-
EXERCISE -3
MODULE-10: ADVANCED ANALYTICS-I
-
Custom Map Geocoding
-
Background Map Source
-
Using Page Shelf for Animated Graphs
-
Cascading Filters
-
Using Viz as Filter
-
Dynamic Measure Filtering
-
Applying User Level Security on Workbooks
-
How to Tackle Tableau Limitations
MODULE-11: ADVANCED ANALYTICS-II
-
K Means Cluster Analytics
-
Cohort Analytics
-
Scenarios
-
Segmentation
-
What-If Analytics
-
Predictive Analytics
-
Integration with R
-
Tableau with Hadoop
-
EXERCISE -4
MODULE-12: TROBUBLESHOOTING TABLEAU REPORTS
-
Basic Performance Check Points
-
Recording Tableau Performance
-
How to read the Tableau Performance Dashboard
-
Reading Tableau Logs
MODULE-13: REPORT DEPLOYMENT TO TABLEAU SERVER
-
Connecting to Tableau Server
-
Selecting Sheets and Dashboards
-
Assigning Permissions
-
Embedding Passwords
-
Working with External Files
MODULE-14: PREPARING FOR TABLEAU CERTIFICATION & NEXT OPPORTUNITY
-
Dashboard Design Best Practices
-
Preparing for Tableau Certification and Interviews
-
Development Support
-
Q & A
Classes: 18-20 Hours
Lab Sessions: 20 Hours
Duration: 4 Weeks
LIVE Session FEE: $375 (Special Discount for Students)
***As per the tutor's discretion, some of the provided course content may be altered/omitted to suit the class needs***
**Products and Logos Mentioned are Trademarks of Tableau Software Corporation and the Respective Companies**
*Provided Individual Course Fee is not applicable for Corporate Customers & Students*