Tableau fundamentals enable every analyst to connect data, create visualizations, and share insights. Master data sources, connections, worksheets, and dashboards—the building blocks for professional analytics.
Data Sources: Connecting to Your Data
Understanding Data Sources: Data sources are connections to your data files or databases. Tableau supports: Excel, CSV, JSON, databases (SQL Server, MySQL, PostgreSQL), cloud (Salesforce, Google Analytics, AWS). Connection types: live (real-time), extract (snapshot, faster). Live connections query database on interaction (slower but current). Extracts: download data, TDE/HYPER format (encrypted, compressed), faster but requires refresh schedule.
Creating & Managing Connections: File → New Data Source selects connection type. Connection string specifies database server, credentials, authentication. Tableau Server: centralize data sources, control access, refresh schedules. Published data sources shared across organization, version-controlled. Data source filters limit rows available to all worksheets using source.
Worksheets: The Canvas for Visualization: Worksheets are individual visualization pages. Drag fields to Rows/Columns shelves: creates chart axes. Drag to Marks (color, size, shape, label): encodes data properties. Shelves structure visualization: Pages (small multiples), Filters (subset data), Marks (visual encoding). Blue (discrete/categorical) vs Green (continuous/quantitative) fields affect behavior.
Dashboards: Combining Visualizations: Dashboards combine multiple worksheets into single view. Size: fixed (pixels), automatic (responsive), range (min-max). Layout objects: tiles (automatic sizing), floating (manual positioning). Filters dashboard-wide: drag worksheet filter to dashboard, affects all connected worksheets. Actions: click worksheet → filter other dashboards (dashboard actions, filter actions, highlight actions).
Publish & Share: Publish to Tableau Server/Online: share interactive dashboards, control permissions, automatic refresh. Workbooks: contain worksheets + dashboards + data connections. Share as PDF (static), web (interactive). Refresh schedules extract updates (hourly, daily, weekly). Schedule performance monitoring: know when slow.
5 Complete Solved Interview Problems
Question 1: Design Data Source Architecture
You have 1B row customer transaction table. Design data source: live vs extract? Authentication? Refresh strategy?
Google – Analytics Manager
Question 2: Connect Multiple Data Sources
Combine customers (database) + transactions (CSV) + web events (API). Design join strategy. Handle mismatches?
Meta – BI Engineer
Question 3: Create Interactive Dashboard
Build sales dashboard: region filter, product category dropdown, date range picker. Wire interactivity?
Amazon – Senior Analytics Engineer
Question 4: Optimize Worksheet Performance
Dashboard slow (10 sec load). Data source has 500M rows. Diagnose bottleneck. Solutions?
Apple – Analytics Engineer
Question 5: Handle Data Quality Issues
Data source has NULL values (30%), duplicate records (5%), outliers. Validation strategy?
Microsoft – Senior Analytics Engineer
15 Practice Questions
Question 6: Connect Salesforce CRM to Tableau as live data source. What authentication method do you use and how configure OAuth? When should you use live vs extract for Salesforce data?
Question 7: Compare live connection vs extract approach. What are pros/cons of each? How does refresh strategy differ between live and extract workflows in production?
Question 8: Design worksheet showing sales by region, month, and product category. Explain how to arrange pills in Rows/Columns shelves. What dimensions go where?
Question 9: Combine 4 separate worksheets (KPI cards, regional breakdown, product ranking, trend line) into single dashboard. How to fit all on screen without scrolling?
Question 10: Add region filter to dashboard affecting only one worksheet vs all connected worksheets. How does filter scope control which sheets respond?
Question 11: Publish workbook to Tableau Server with 50 users. What permissions control who can view, edit, download the dashboard? Role-based access?
Question 12: Data source has 2 tables: customers (100k rows) and orders (10M rows). How does join type (inner/left/right) impact row count in visualization? Which join to use?
Question 13: Extract containing 500M rows takes 45 minutes to refresh during peak hours. Identify 3 optimization strategies to reduce refresh time. What to prioritize?
Question 14: Create date range parameter enabling users to select start and end dates for dashboard filtering. Link parameter to calculated field. Implementation steps?
Question 15: Dashboard shows incorrect total revenue (sum doesn’t match database). Suspect duplicate rows from join. What validation approach to identify and fix duplicates?
Question 16: Multi-sheet dashboard (5 worksheets) loads slowly (8 seconds). How to diagnose whether bottleneck is worksheet query, filter complexity, or data source extraction?
Question 17: Connect CSV file (customer data) and SQL database (transactions) in single data source. How handle mismatch if CSV customer_id format differs from database?
Question 18: Implement row-level security showing each regional manager only their region’s data. How does Tableau Server user filtering enable this at connection level?
Question 19: Schedule extract refresh: when to refresh (timing), how often (frequency), how to handle failures. Best practices for production schedules?
Question 20: Design dashboard interactivity: clicking region chart should filter 3 other sheets and open detail dashboard. How to wire dashboard actions to create this flow?
Master Tableau Fundamentals
Get our comprehensive Data Analytics: Ace All The Interview Concepts course.