96. What is Tableau?
Answer:
Tableau is a Business Intelligence and Data Visualization tool used to analyze data and create interactive dashboards.
Features:
โ Drag-and-drop interface
โ Interactive dashboards
โ Real-time analytics
โ Data blending
โ Advanced visualizations
97. Difference Between Tableau and Power BI
Feature | Tableau | Power BI
Visualization | Stronger visualization capabilities | Better Microsoft ecosystem integration
Ease | Easier for advanced visualizations | More affordable
Performance | Faster with large visual analytics | Strong DAX and modeling
Usage | Popular in analytics consulting | Popular in enterprises
98. What are Dimensions and Measures?
Dimensions
Qualitative fields used for categorization.
Examples: โ Customer Name, โ Region, โ Product Category
Measures
Quantitative fields used for calculations.
Examples: โ Sales, โ Profit, โ Quantity
99. Explain Tableau Filters
Answer:
Filters limit the data displayed in visualizations.
Types:
โ Extract Filters
โ Data Source Filters
โ Context Filters
โ Dimension Filters
โ Measure Filters
100. What are Calculated Fields?
Answer:
Calculated Fields create new fields using formulas.
Example:
[Profit Ratio] = [Profit] / [Sales]Used for:
โ KPIs
โ Business calculations
โ Custom metrics
101. What are Parameters?
Answer:
Parameters allow users to input values dynamically.
Examples:
โ Select Top N Products
โ Change Year
โ Dynamic Measures
Benefits:
โ User interaction
โ Dynamic dashboards
102. What are Sets and Groups?
Groups
Combine related dimension members.
Example: Delhi + Mumbai + Pune = West Region
Sets
Custom subsets of data.
Example: Top 10 Customers
103. Explain Dashboards in Tableau
Answer:
A Dashboard combines multiple worksheets into a single interactive view.
Components:
โ Charts
โ Filters
โ KPIs
โ Maps
โ Parameters
104. What are Stories in Tableau?
Answer:
Stories present data insights in a sequence.
Think of them as: Slide 1 โ Slide 2 โ Slide 3
Used for:
โ Presentations
โ Business storytelling
โ Executive reporting
105. Explain Hierarchies
Answer:
Hierarchies organize data into drill-down levels.
Example: Country โ State โ City
Benefits:
โ Easy drill-down analysis
โ Better navigation
106. What is Tableau Prep?
Answer:
Tableau Prep is Tableau's data preparation tool.
Used for:
โ Data cleaning
โ Data transformation
โ Data combining
Common Tasks:
โ Remove duplicates
โ Merge datasets
โ Rename columns
107. Difference Between Live and Extract Connections
Live Connection
Data remains in source database.
Benefits: โ Real-time data
Drawbacks: โ Slower performance
Extract Connection
Stores a copy of data.
Benefits: โ Faster dashboards
Drawbacks: โ Requires refresh
108. Explain Joins and Blending
Joins
Combine tables before visualization.
Examples: โ Inner Join, โ Left Join, โ Right Join