2 mark question
Here are the 2-mark answers for each Tableau-related question in the image:
1. What is Tableau?
Tableau is a powerful data visualization tool used for converting raw data into an
understandable format using dashboards and worksheets. It helps in simplifying big
data into visual insights.
2. What are the advantages of Tableau Analytics Platform?
Easy to use with drag-and-drop interface.
Supports real-time data analysis.
Allows integration with various data sources.
Offers interactive dashboards for better decision-making.
3. Define measures and dimensions in Tableau.
Dimensions are qualitative fields (e.g., names, dates) used to categorize data.
Measures are quantitative fields (e.g., sales, profit) used for calculations and analysis.
4. Differentiate between data extracts and live connections.
Extracts are snapshots of data stored locally for better performance.
Live connections connect directly to the data source, ensuring real-time data
updates.
5. What is a join in Tableau?
A join is used to combine data from two or more tables based on a related column,
such as ID or name.
6. List any two chart types supported in Tableau.
Bar Chart
Line Chart
7. What is the purpose of a legend in data visualization?
A legend explains the meaning of colors, symbols, or patterns used in a chart, making
the visualization easier to interpret.
8. Define calculated field.
A calculated field is a new field created using existing data fields and formulas to
perform calculations or transform data.
9. What are quick table calculations?
Quick table calculations are pre-defined functions in Tableau, like running total or
percent of total, applied easily to visualized data.
10. Mention two types of maps that can be created in Tableau.
Symbol Map
Filled Map
11. What are map layers in Tableau?
Map layers in Tableau are visual components like base maps,
borders, names, and data layers that help create rich geographical
views.
12. Explain Gantt Chart.
A Gantt chart is a type of bar chart used in project management to
display project schedules, showing tasks along with time duration.
13. What is the purpose of filters in Tableau?
Filters allow users to include or exclude data from visualizations
based on specific conditions, helping focus on relevant data.
14. List the different data connections that can be made with a
dataset.
Live Connection
Extract Connection
15. What are the supported data types in Tableau?
String
Number (whole and decimal)
Boolean
Date/DateTime
Geographic
16. What is a calculated field, and how will you create one?
A caLet me know if you want these in a document or need 5-mark answers too.
Here are the 2-mark answers for each Tableau-related question in the image:
1. What is Tableau?
Tableau is a powerful data visualization tool used for converting raw data into an
understandable format using dashboards and worksheets. It helps in simplifying big
data into visual insights.
2. What are the advantages of Tableau Analytics Platform?
Easy to use with drag-and-drop interface.
Supports real-time data analysis.
Allows integration with various data sources.
Offers interactive dashboards for better decision-making.
3. Define measures and dimensions in Tableau.
Dimensions are qualitative fields (e.g., names, dates) used to categorize data.
Measures are quantitative fields (e.g., sales, profit) used for calculations and
analysis.
4. Differentiate between data extracts and live connections.
Extracts are snapshots of data stored locally for better performance.
Live connections connect directly to the data source, ensuring real-time data
updates.
5. What is a join in Tableau?
A join is used to combine data from two or more tables based on a related column,
such as ID or name.
6. List any two chart types supported in Tableau.
Bar Chart
Line Chart
7. What is the purpose of a legend in data visualization?
A legend explains the meaning of colors, symbols, or patterns used in a chart, making
the visualization easier to interpret.
8. Define calculated field.
A calculated field is a new field created using existing data fields and formulas to
perform calculations or transform data.
9. What are quick table calculations?
Quick table calculations are pre-defined functions in Tableau, like running total or
percent of total, applied easily to visualized data.
10. Mention two types of maps that can be created in Tableau.
Symbol Map
Filled Map
11. What are map layers in Tableau?
Map layers in Tableau are visual components like base maps, borders, names, and
data layers that help create rich geographical views.
12. Explain Gantt Chart.
A Gantt chart is a type of bar chart used in project management to display project
schedules, showing tasks along with time duration.
13. What is the purpose of filters in Tableau?
Filters allow users to include or exclude data from visualizations based on specific
conditions, helping focus on relevant data.
14. List the different data connections that can be made with a dataset.
Live Connection
Extract Connection
15. What are the supported data types in Tableau?
String
Number (whole and decimal)
Boolean
Date/DateTime
Geographic
16. What is a calculated field, and how will you create one?
A calculated field is a new field derived from existing fields using a formula.
To create one: Go to the Data pane > Right-click > "Create Calculated Field" > Enter
formula > Click OK.
Let me know if you want these in a document or need 5-mark answers too.
You said:
give answer for each 5 mark questions
ChatGPT said:
Here are the 5-mark answers for each of the Tableau questions shown in the image:
1. Explain the steps in setting up a data connector and selecting data tables in Tableau.
To set up a data connector in Tableau:
Step 1: Open Tableau Desktop – Launch Tableau and choose how you want to
connect to your data source (e.g., Excel, SQL, Web Data Connector).
Step 2: Choose a Data Source – Select the desired connection type from the
"Connect" pane.
Step 3: Provide Credentials/Path – For example, upload a file or enter server details
and credentials.
Step 4: Load Data Tables – Tableau displays available tables. You can drag and drop
the required tables into the workspace.
Step 5: Join/Union Tables (Optional) – Use joins or unions if multiple tables need to
be combined.
Step 6: Review Data in Data Source Tab – Preview and clean your data if needed
before creating visualizations.
2. Compare bar charts, line charts, and heat maps with suitable use cases.
Chart
Type Description Use Cases
Bar Displays categorical data with Sales by product category, revenue by
Chart rectangular bars. region.
Line Shows trends over time using points
Chart connected by lines. Monthly sales trends, stock prices over time.
Heat Uses color to represent data values Website traffic by day/hour, product
Map across two dimensions. performance by region and time.
Summary:
Bar charts are best for comparing discrete categories.
Line charts are ideal for showing data changes over time.
Heat maps are useful for spotting patterns or concentrations in large data grids.
3. Explain the role of aggregation and logical functions in creating advanced visualizations.
Aggregation:
Aggregation refers to summarizing data values, such as SUM, AVG, COUNT, etc. It
helps in creating high-level visualizations like total sales or average profit. Tableau
automatically aggregates measures depending on the visualization level.
Logical Functions:
These include functions like IF, IF ELSE, CASE, etc., used for creating conditional
fields. They help customize views and highlight specific patterns, e.g., flagging high-
profit regions.
Use in Visualizations:
Combine aggregations and logical conditions to create custom KPIs, highlight
conditions, or segment data.
Example: Create a calculated field to show "High Sales" if sales > $50,000.
4. Write short notes on parameters and level of detail (LOD) expressions.
Parameters:
Parameters are dynamic input values that can be used in calculations, filters, and
reference lines. They are user-driven and allow customization of visualizations (e.g.,
switching between measures like profit or sales).
Level of Detail (LOD) Expressions:
LOD expressions let you control the granularity of data aggregation.
Types:
FIXED – Calculates value regardless of the view.
INCLUDE – Adds dimension(s) to the view for calculation.
EXCLUDE – Removes dimension(s) from the view.
Example:
{ FIXED [Region] : SUM([Sales]) } – Calculates sales for each region, independent of the
view's dimensions.
5. Discuss the process of creating a symbol map and a density map in Tableau.
Symbol Map:
Connect to geographic data.
Drag a geographic field (e.g., city, state) to the view.
Tableau automatically creates a map with symbols (dots).
Drag a measure (e.g., Sales) to Size or Color to represent data values.
Customize using filters, colors, or map layers.
Density Map:
Also starts with geographic fields.
Drag latitude and longitude to Rows and Columns.
Switch the mark type from Automatic to Density.
Density maps use color intensity to show data concentration.
Useful for identifying hot spots, like customer density or high-sales areas.
6. What are the different types of charts available in Tableau?
Tableau supports a wide range of charts including:
1. Bar Chart – Comparison of values across categories.
2. Line Chart – Trends over time.
3. Pie Chart – Proportional contribution to the whole.
4. Scatter Plot – Relationship between two variables.
5. Histogram – Frequency distribution of data.
6. Heat Map – Color-coded matrix based on values.
7. Bullet Graph – Measures performance against a goal.
8. Gantt Chart – Project timelines and schedules.
9. Box-and-Whisker Plot – Distribution and outliers.
10. Treemap – Hierarchical data using nested rectangles.
11. Bubble Chart – Size and color to represent data values.
12. Waterfall Chart – Sequential values showing positive and negative contributions.
13. Maps (Symbol, Filled, Density) – Geographical data visualization.
Conclusion:
Each chart type serves a specific purpose and helps in uncovering different insights based on
the data.
Let me know if you'd like this as a downloadable PDF or DOC file.
Attach
Search
Study
Voice
ChatGPT can make mistakes. Check important info. See Cookie Preferences.