Scribd
Upload
15 views10 pages

Tableau Data Visualization Techniques

The document outlines the process of creating various data visualizations in Tableau, including bar charts, line graphs, pie charts, and heat maps. It also discusses the use of filters, data aggregation, statistical functions, and parameters to enhance interactivity and control over the displayed data. Key steps for creating visualizations and applying filters or parameters are provided to facilitate user engagement with the data.

Uploaded by

kalpanaman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views10 pages

Tableau Data Visualization Techniques

The document outlines the process of creating various data visualizations in Tableau, including bar charts, line graphs, pie charts, and heat maps. It also discusses the use of filters, data aggregation, statistical functions, and parameters to enhance interactivity and control over the displayed data. Key steps for creating visualizations and applying filters or parameters are provided to facilitate user engagement with the data.

Uploaded by

kalpanaman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Experiment 3:

Aim:
Creating a View - formatting charts, adding filters, creating calculated fields and
defining parameters.
Data Visualization
We can perform various visualization operations on data in Tableau. Some of them are bar cart,
histogram, bubble chart, heat map etc.

Bar chart:
Bar charts can be created in 3 variations in Tableau: Horizontal bars, stacked bars, side-by-side
bars.
Horizontal bars can be created by selecting that type of chart from Show Me menu on right
hand side of Canvas. The type of chart in box on right hand side represents horizontal bar graph.

In similar to above, stacked bar graph can be created and the result is shown below.
Side-by-side bar chart can be created in following way.

Line graph: Line graph can be continuous or discrete.


Continuous line graph is shown below:

Discrete line graph is shown below:


Pie chart:

Bubble chart:
Heat map:

Filters:
In Tableau, filters are powerful tools used to control the data that is displayed in your
visualizations.

General Filter:
Drag category and sub category as Column and sales as rows and swap it . Then select city a
color card.

Then drag city to filter shelf


Select the cities and click ok

Wildcard Filter:
Drag sub category as Row and Sales as Column then drag sub category to filter shelf and
click wildcard option and click starts with and enter the letter A then click OK.
Condition filter:
Select Row as Sales, Column as Category and Sub category and drag product name to filter
shelf then condition by field select quantity and average and click load select the option less
than 1000 and click ok.

Top Filter:

Drag row as subcategory and column as sales and drag the sub category the select top and
specify the number and click ok.

Data aggregation and statistical functions


We can apply various aggregation and statistical functions on data such as count,
minimum, maximum, standard deviation, variance etc. This is shown below. This can be
done by right clicking on the required field of dataset, click on Default properties and click
on aggregation.

Or the above operation can be done by creating a calculated field as shown below. To
create a calculated field, click on the down arrow button beside search tab above Tables
panel, drag a field to that calculated field window.
Then click on apply and results are shown below:
In the same way we can apply any aggregate or statistical function on data with the help
of calculated fields.
Parameters:
Parameters in Tableau are dynamic values that can replace a constant value in
calculations, filters, or reference lines. They allow users to input or select values,
providing a more interactive experience. Here’s how to define and use parameters in
Tableau:
Creating a Parameter
Open the Parameter Dialog:
o Right-click in the Data pane and select Create Parameter.
Define the Parameter:
o Name: Give your parameter a descriptive name.
o Data Type: Choose the data type (e.g., Integer, Float, String, Date).
o Current Value: Set the default value that will be used when the parameter
is first created.
o Allowable Values: Decide how users will interact with the parameter:
 All: Any value is allowed.
 List: Provide a specific list of values for users to choose from.
 Range: Set a minimum and maximum value with an increment
(step size).
Click OK: Save the parameter.
Using the Parameter:
In Filters:
 You can filter your data based on the parameter. For instance, create a
filter to show only sales greater than the parameter value.
Select Column as Sum(sales) and Rows as Sub Category. Then arrange it in descending
order. Then drag sub category in filters card.

In Top Select By Field and enter 10 and click OK.

For changing the value In filters click top then select creating a new parameter name the
parameter as TOP N, give the minimum and maximum values then apply OK.

Right side can adjust the parameter value. Click and Type In the values also.
In Sets:
Right click the sub category create set give the name of the set then Top select By Field and
click TOP N then click ok set is created.

Then Right click the parameters select show parameters. You can adjust the parameter
control. Put the set in Color card.

Common questions

Powered by AI

Wildcard filters in Tableau significantly enhance data exploration by allowing users to filter data based on specific patterns or characters. For instance, one might filter entries that start with the letter 'A' by selecting the wildcard option and specifying the desired pattern. This feature helps in focusing on a subset of data quickly, enhancing the ability to explore and analyze relevant information without manually selecting entries .

Top filters in Tableau are used to filter data to show only the top-ranked data points according to a specified measure. Structure-wise, they require selecting a dimension for rows and columns to order data. Then in the filters card, set a top filter to display top N records based on a measure such as sales. This helps in quickly identifying leading categories or trends within large datasets, enhancing interpretative efficiency .

Tableau enhances data insights through aggregation and statistical functions by allowing transformation of raw data into meaningful summaries and statistical indicators. Aggregations such as count, min, max, mean, and custom calculated fields condense and summarize data, enabling insights into distributions and trends. Statistical functions like standard deviation and variance further reveal patterns and variabilities, furnishing a deeper understanding of datasets beyond surface-level observations .

In Tableau, to create a side-by-side bar chart, you first need to arrange the necessary input fields in the Columns and Rows shelves. Typically, you drag fields to the Columns and Rows in such a way that you get a distinct set of data segments that you want to compare side-by-side. This type of chart is significant because it allows for easy comparison of different categories against a measure, facilitating a visual understanding of differences or similarities in data .

Continuous line graphs in Tableau connect data points along a continuous axis, showing a trend over time or a progression with intermediate points visible on an unbroken curve. Discrete line graphs, however, represent data points as distinct and separate, useful for categorical comparison where intervals are not meaningful or required .

Heat maps in Tableau are used to depict data density, enabling visualization of patterns and correlations in large datasets. They assign colors to data, where intensity or shade indicates values or frequency. Heat maps are effective for identifying areas of high activity or significant values across different segments, allowing quick identification of trends, hotspots, or outliers visually, complementing detailed analysis in various domains .

To create a calculated field in Tableau, click the down arrow beside the search tab above the Tables panel, select "Create Calculated Field," and enter your calculation formula. Calculated fields allow for custom computations on data, enabling complex data analysis tasks such as dynamic sorting, categorization, or inter-field operations, enhancing Tableau's analytical capacity by extending beyond native data fields .

Using filters in Tableau can significantly impact data presentation by determining which data points are displayed, thus focusing analysis on relevant segments and enabling clearer, more targeted insights. Filters like general, wildcard, condition, and top filters allow selective data reduction, potentially simplifying complex datasets into more manageable and comprehensible visual forms. This enhances the user's ability to explore and interpret data patterns .

When defining allowable values for a parameter in Tableau, choices include "All" which allows any user input, "List" for selecting from specified options, and "Range" to limit input to a defined numeric interval. Each choice tailors interaction to fit analysis needs, ensuring that parameter inputs are valid and meaningful, thereby maintaining analysis integrity and facilitating appropriate data manipulations .

Parameters in Tableau can be used to replace constant values in calculations, filters, or reference lines, offering dynamic modification of visualizations. They allow users to input or select varying values, providing a more interactive experience. For example, users can adjust a parameter to change threshold values in filters, affecting the data presented in real-time. This interactivity makes parameter-driven dashboards especially powerful for tailored analytics and responsive data exploration .

You might also like