0% found this document useful (0 votes)
22 views4 pages

Tableau Basics: Workspace & Functions

The document provides an introduction to using Tableau, focusing on the workspace, key terminologies, and basic functionalities with the dataset vgsales.csv. It outlines steps for setting up the Tableau workspace, explains dimensions and measures, and demonstrates how to create basic visualizations, sorting, and filtering. Additionally, it covers creating dashboards by combining multiple visualizations for comprehensive data analysis.

Uploaded by

07jayanthc
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
0% found this document useful (0 votes)
22 views4 pages

Tableau Basics: Workspace & Functions

The document provides an introduction to using Tableau, focusing on the workspace, key terminologies, and basic functionalities with the dataset vgsales.csv. It outlines steps for setting up the Tableau workspace, explains dimensions and measures, and demonstrates how to create basic visualizations, sorting, and filtering. Additionally, it covers creating dashboards by combining multiple visualizations for comprehensive data analysis.

Uploaded by

07jayanthc
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

Program 1: Getting Started - Tableau Workspace, Tableau terminologies, Basic functionalities.

Working with Tableau that focuses on understanding the Tableau Workspace, Tableau terminologies,
and basic functionalities.

Dataset used: [Link]

1. Go to Start Page: Toggle between the active sheet and the Desktop Start Page.
2. Data Pane: Includes dimensions and measures, populated from your selected data source. May also
include calculated fields, parameters, or sets.
3. Analytics Pane: Includes options you can use to apply reference lines, forecasts, trend lines, to add
totals to crosstabs, and to build boxplots.
4. Workbook Name: The file name of our workbook.
5. View Cards: Used for modifying the worksheet.
6. Toolbar Icons: Icons are available for quick access to popular features.
7. Worksheet/View: Workspace for building your visualizations.
8. Go to Data Source: Returns you to the data source specification page.
9. Worksheet Tabs: Click to view a specific worksheet, dashboard, or story
10. New Worksheet, Dashboard, and Story Tabs: Click to create a new Worksheet, Dashboard, or Story.
11. Status Bar: Displays data about the fields and marks included in the view.
Steps:
1. Tableau Workspace Setup:

 Connect to Data:
 Open Tableau, and on the "Start Page," select Connect -> To a File -> Text File.
 Browse to the location of [Link] and open it.
 Data Preview:
 After loading, Tableau will show a preview of the data. You can rename columns if
necessary.
 Click on the "Sheet 1" tab at the bottom to go to your first worksheet.

2. Tableau Terminologies:
 Dimensions: These are qualitative fields. In [Link], examples
include Platform, Genre,and Publisher.
 Measures: These are quantitative fields used for calculations. Examples are
Global_Sales, NA Sales, and Year.
 Rows and Columns Shelf: Drag dimensions and measures to the Rows or
Columns shelves to build the structure of your visualization.
 Marks: Controls the appearance of the data. You can set marks to be circles,
bars, or other shapes and control size, color, and label.
 Filters: Used to limit the data displayed in the view.
 Pages Shelf: Used for creating animations or segmenting your view by categories.

3. Basic Functionalities:
a. Basic Visualization (Bar Chart of Global Sales by Genre):
 In your worksheet, drag Genre to the Columns shelf.
 Drag Global_Sales to the Rows shelf.
 You should see a bar chart. If the data isn’t aggregating correctly, check if the
aggregation is set to SUM by right-clicking Global_Sales -> Measure -> Sum.

b. Sorting:

 Click on the Global_Sales axis and sort descending to show the genres with the
most sales first.

c. Filtering:

 Drag Year to the Filters shelf.


 Choose the range of years you want to display (e.g., 2000-2016).
 Add Year to the Pages shelf to create a dynamic view of how sales changed over
time.

4. Additional Functionalities:
Dashboards: Combine different sheets to create a comprehensive dashboard. Go
to the Dashboard tab, drag your created sheets to the layout, and arrange them
accordingly.

a. Add one more worksheet - Global Sales Trend


by Year
 Drag Year to the Columns.
 Drag Global_Sales to the Rows.
 Create a line chart to show how global sales have trended over time.
 Add Genere to the Marks
 Apply color to Genere

b. Go to the Dashboard tab in Tableau.


c. Add multiple visualizations to a single dashboard. (To increase dashboard size -
select size-Automatic)
d. Arrange charts (e.g., a line chart for yearly sales, a bar chart for top genres, etc.).

Common questions

Powered by AI

To create a comprehensive dashboard in Tableau, you should first design multiple worksheets with various visualizations, such as a line chart for yearly sales and a bar chart for top genres. Once individual visualizations are prepared, navigate to the Dashboard tab, and drag the selected sheets into the layout. It's helpful to adjust the dashboard size to Automatic for responsive design. Different visualizations can be integrated by ensuring they convey related insights and are arranged in a logically coherent manner, such as placing graphs side by side to provide an easily comparable view of different data aspects .

Analytical features in Tableau, such as trend lines and forecasts, provide predictive insights that are vital for strategic decision-making. Trend lines can reveal historical patterns and trajectories in data, allowing businesses to understand underlying movements, while forecasts extrapolate these patterns to predict future outcomes, such as sales growth or market demand. These tools enable businesses to anticipate changes, plan accordingly, and make informed decisions backed by data-driven evidence, which is crucial for maintaining competitiveness and adapting to market shifts .

Sorting is crucial in Tableau visualizations as it helps highlight important patterns and trends by ordering data elements such as bars, lines, or columns. For instance, sorting the Global_Sales axis in descending order allows users to immediately identify the genres with the highest sales, making the visualization more intuitive and informative. This technique enhances clarity by prioritizing significant data points and structuring information accessibly, thereby supporting better decision-making and analysis processes .

The basic components of the Tableau Workspace include the Start Page, Data Pane, Analytics Pane, Workbook Name, View Cards, Toolbar Icons, Worksheet/View, Data Source Page, Worksheet Tabs, New Worksheet/Dashboard/Story Tabs, and Status Bar. These components collectively enable users to connect to data sources, organize and manipulate data, build visualizations, and create dashboards. For instance, the Data Pane organizes dimensions and measures, the Analytics Pane provides advanced features like trend lines and forecasts, and the Workspace allows for arranging and visualizing data through interactive components like sheets and dashboards .

To set up a basic bar chart in Tableau for analyzing Global Sales by Genre, you start by dragging the Genre field to the Columns shelf and the Global_Sales measure to the Rows shelf. This creates a bar chart where each bar represents a different genre. To ensure the data is aggregated correctly, you need to verify that the aggregation method is set to SUM. This can be adjusted by right-clicking on Global_Sales and selecting Measure -> Sum. This ensures the visualization accurately reflects the total sales for each genre .

Tableau filters can be used to limit the data displayed in a view by setting conditions such as a specific year range. For instance, dragging the Year field to the Filters shelf and selecting a range (e.g., 2000-2016) allows for focusing on certain time periods. Additionally, using the Pages shelf with the Year field added enables the creation of dynamic views that animate changes in the data over time. This setup provides users with the ability to visually track how data variables evolve, enhancing exploratory data analysis and storytelling capabilities .

To ensure a Tableau dashboard is adaptable to different screen sizes, set the dashboard size to 'Automatic' in the Dashboard tab. This setting changes the dashboard layout based on the viewer's screen size, ensuring all elements are visible and aesthetically pleasing regardless of the device used. This adaptability is crucial for maintaining the usability and accessibility of dashboards across diverse platforms, supporting stakeholder engagement and effective data communication in various contexts .

Calculated fields in the Data Pane allow users to perform custom calculations on their data, enabling the creation of tailored metrics for specific analysis purposes, such as new ratios or conditional logic outputs. Parameters provide flexibility by allowing users to input different values or thresholds in analyses, thereby supporting what-if scenarios and dynamic data analysis. Sets enable the grouping of data points based on specific criteria, allowing for more nuanced segmentation or highlighting of data subsets. These features collectively empower users to perform more sophisticated and targeted analyses, unlocking deeper insights within datasets .

The 'Marks' card in Tableau allows for extensive customization of data appearance by modifying attributes like shape, size, color, and labels. This flexibility supports data storytelling and enhances visual appeal. For example, setting marks to circles or bars can emphasize different aspects of the data, while adjusting color gradients or sizes can draw attention to variations and trends. Practical uses include using color to differentiate between categories such as genres or regions, and size to represent quantitative values, providing a multi-dimensional, intuitive view of the dataset .

In Tableau, dimensions are qualitative fields such as Platform, Genre, and Publisher that categorize data, while measures are quantitative fields like Global_Sales, NA Sales, and Year that are used for numerical calculations. Dimensions are often used in the Rows and Columns shelves to define the structure of a visualization, while measures typically populate the graphs, providing the numerical values that are visualized. By organizing and displaying data in this way, users can gain insights into trends and patterns within the dataset .

You might also like