Tableau
Overview
Tableau is the market-leading business intelligence and data visualization platform that enables users to see and understand their data. Founded in 2003 and acquired by Salesforce in 2019, Tableau has become the gold standard for interactive data visualization and self-service analytics.
What is Tableau?
Tableau is a visual analytics platform that transforms raw data into actionable insights through interactive dashboards and visualizations. Unlike traditional BI tools, Tableau emphasizes:
- Visual Discovery: Explore data through drag-and-drop visualizations
- Self-Service Analytics: Enable business users to answer their own questions
- Live Connections: Connect directly to data sources for real-time insights
- Interactive Dashboards: Create dynamic, filterable visualizations
- Governed Analytics: Centralized data management with enterprise security
Why Use Tableau?
Key Strengths
- Best-in-Class Visualization: Industry-leading visual analytics capabilities
- Ease of Use: Intuitive drag-and-drop interface for non-technical users
- Performance: Optimized query engine (Hyper) for fast analytics
- Flexibility: Connect to 100+ data sources
- Enterprise Scale: Supports organizations with thousands of users
When to Choose Tableau
- Executive Dashboards: When leadership needs intuitive, interactive reports
- Self-Service BI: Empowering business users to explore data independently
- Complex Visualizations: Advanced chart types and custom visualizations
- Large Organizations: Enterprise-grade security, governance, and scalability
- Salesforce Integration: Deep integration with Salesforce CRM data
Tableau vs Alternatives
| Feature | Tableau | Power BI | Looker | Metabase |
|---|---|---|---|---|
| Ease of Use | Excellent | Good | Moderate | Good |
| Visualization | Best | Good | Good | Basic |
| Price | $$$$ | $$ | $$$ | Free/$ |
| Cloud vs Desktop | Both | Both | Cloud-first | Cloud-first |
| Best For | Enterprises | Microsoft shops | Data teams | Startups |
Core Concepts
Workbooks and Sheets
Workbook: A Tableau file (.twb or .twbx) containing worksheets, dashboards, and stories.
Worksheet: A single visualization canvas
Dashboard: Combination of multiple worksheets with interactivity Story: Sequence of visualizations that tell a narrative
Data Connections
Live Connection: Query data source in real-time
Extract: Import data snapshot into Tableau
Supported Data Sources:
- Databases: Snowflake, PostgreSQL, MySQL, Oracle, SQL Server, Redshift
- Cloud: BigQuery, Azure Synapse, Databricks, Amazon Athena
- Files: Excel, CSV, JSON, Parquet, PDF
- Applications: Salesforce, Google Analytics, SAP
- 100+ connectors via Tableau Exchange
Calculations
Basic Calculated Fields:
Table Calculations:
Level of Detail (LOD) Expressions:
Parameters
Interactive controls for user input:
Filters
Filter Hierarchy (order of operations):
- Extract Filters
- Data Source Filters
- Context Filters
- Dimension Filters
- Measure Filters
- Table Calculation Filters
Filter Types:
Sets
Dynamic grouping of dimension members:
Tableau Products
Tableau Desktop
Personal Edition: For individual analysts
- Full authoring capabilities
- Publish to Tableau Public only
- $70/user/month
Professional Edition: For organizations
- Full authoring capabilities
- Publish to Tableau Server/Cloud
- Connect to more data sources
- $70/user/month (with Creator license)
Tableau Server
On-premises BI platform:
Tableau Cloud (formerly Online)
Cloud-hosted BI platform:
Tableau Prep
Visual data preparation tool:
Tableau Mobile
iOS and Android apps for on-the-go analytics:
- View and interact with dashboards
- Offline access to favorites
- Touch-optimized interactions
- Snapshot and annotation
- Mobile-specific layouts
Dashboard Best Practices
Layout and Design
The Rule of Thirds:
Visual Hierarchy:
- Largest visualization = most important insight
- Use color to draw attention to key data points
- White space prevents clutter
- Consistent color scheme across dashboard
Interactivity:
Performance Optimization
Optimize Queries:
Optimize Visualizations:
Monitor Performance:
Integration Patterns
Data Integration
Joining Data:
Blending Data:
Relationships (Tableau 2020+):
dbt Integration
Embedded Analytics
Embed Tableau in Applications:
Connected Apps (OAuth):
Licensing
User Roles
Creator: $70/user/month
- Tableau Desktop or Prep
- Full authoring on web
- Connect to any data source
- For data analysts and developers
Explorer: $35/user/month
- Web authoring (limited)
- Edit existing workbooks
- No Desktop or Prep
- For business analysts
Viewer: $15/user/month
- View and interact with dashboards
- No authoring capabilities
- For business users
When Not to Use Tableau
- Pixel-Perfect Reports: Use Crystal Reports or SSRS instead
- Very Simple Dashboards: Consider Metabase or Redash (lower cost)
- Operational Dashboards: Consider Grafana for real-time monitoring
- Code-First Teams: Consider Looker or Mode for SQL-based BI
- Budget Constraints: Consider Power BI or open-source alternatives
Getting Help
- Documentation: https://help.tableau.com/
- Community: https://community.tableau.com/
- Tableau Public: https://public.tableau.com/ (free visualizations)
- Training: https://www.tableau.com/learn/training
- YouTube: https://www.youtube.com/user/tableausoftware
- Support: Premier support available for Enterprise customers