Tableau: A Comprehensive Guide to Data Visualization, Exams of Computer Science

A detailed overview of tableau, a powerful data visualization tool. It covers various aspects of tableau, including the data source page, data pane, dimensions and measures, marks card, filtering, and sorting. How users can leverage tableau's features to organize, analyze, and visualize data effectively. With its comprehensive coverage of tableau's functionalities, this document can serve as a valuable resource for both novice and experienced users seeking to enhance their data analysis and presentation skills.

Typology: Exams

2023/2024

Available from 09/21/2024

ROCKY-B
ROCKY-B 🇰🇪

4.4

(16)

40K documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
What is tableau? - Answers -A data visualization tool
Data source page - Answers -If needed, on the Data Source Page you can
Change Data Field Types
Update Column Names
Parse / Spilt Columns by using Custom Split
Identify which delimiter to split on and which Column(s) to keep within the data
Sort data
View Metadata
View a sample of the data
Data source page 2 - Answers -The user can choose what type of Connection they want
with the data
Live (default) - will automatically refresh the data within the views
Extract - creates a Tableau Data Extract (.tde) and will not automatically show the
refreshed data within the views and is recommended to increase performance
Data pane - Answers -The user can organize any of the fields in the Data Pane by
Folders or Sorting
Data pane Folders - Answers -Folders (Right click in the Data Pane and choose Create
Folder, then select Field(s), right click, Folders, Add to Folder, and choose the Folder
you want or click and drag the field to the folder)
Group by Folders - data is grouped by how you organized the data into folder names
Group by Data Source Table - the dimensions and measures are grouped according to
the database table they belong to
TABLEAU TEST
QUESTIONS
AND ANSWERS
pf3
pf4

Partial preview of the text

Download Tableau: A Comprehensive Guide to Data Visualization and more Exams Computer Science in PDF only on Docsity!

What is tableau? - Answers -A data visualization tool Data source page - Answers -If needed, on the Data Source Page you can Change Data Field Types Update Column Names Parse / Spilt Columns by using Custom Split Identify which delimiter to split on and which Column(s) to keep within the data Sort data View Metadata View a sample of the data Data source page 2 - Answers -The user can choose what type of Connection they want with the data Live (default) - will automatically refresh the data within the views Extract - creates a Tableau Data Extract (.tde) and will not automatically show the refreshed data within the views and is recommended to increase performance Data pane - Answers -The user can organize any of the fields in the Data Pane by Folders or Sorting Data pane Folders - Answers -Folders (Right click in the Data Pane and choose Create Folder, then select Field(s), right click, Folders, Add to Folder, and choose the Folder you want or click and drag the field to the folder) Group by Folders - data is grouped by how you organized the data into folder names Group by Data Source Table - the dimensions and measures are grouped according to the database table they belong to

TABLEAU TEST

QUESTIONS

AND ANSWERS

Data pane sorting - Answers -Sorting (Right click in the Data Pane and choose Sort by Name) Sort by Name - lists the dimensions and measures in alphabetical order according to their field aliases Sort by Data Source Order - lists the dimensions and measures in the order they are listed in the underlying data source Measures - Answers -are numeric data that can be calculated and aggregated Dimensions & measures - Answers -You can easily change a field from a Dimension to a Measure and vice versa by Clicking and dragging it under the Data Type you want it to be Or by right clicking and choosing "Convert to Measure" or "Convert to Dimension" Dimensions and measures icons - Answers -Icons that appear next to a Dimension or Measure tell you a little more about that field Blue means the field is Discrete Green means the field is Continuous Icons preceded by an equal sign indicate the field is a user-defined calculation or a copy of another field Icons with a red exclamation mark mean that the field is invalid or the calculation you created is not correct Dimensions and measures other icons - Answers -Other icons to the left of the Dimension or Measure indicate which field type Date is the calendar Date/Time would have a clock to the bottom right of the calendar

Numeric values

ABC Text values The Shelf - Answers -A plus sign to the left of a field notifies the user that they can drill up or down within the field of data and that there is a hierarchy within the data The sort icon to the right of a field indicates that field has been Sorted in the view A green pill indicates a Continuous field A blue pill indicates a Discrete field Data pane capabilities - Answers -Change the Default Comment Change the Default Color For Dimensions Only - Change the Default Shape and Sort For Measures Only - Change the Default Number Format, Aggregation, and Totals For Dates Only - Change the Default Date Format and Fiscal Year Start Dimensions - Answers -Dimensions are typically categorical data (Strings or Boolean values) and can include dates Clicking and dragging a Dimension to Rows or Columns creates axis Headers in a view

Filtering dates - Answers -Date Filters are used to filter a data subset for specific date or time criteria Filter dates for a range of dates or for a discrete date/time Date Filter options - Answers -General Condition Top sorting - Answers -Default Sort - can be set for a Dimension in the Default Properties (right click on the Dimension in the Data Pane) and determines how the field will be sorted when it is first added to the worksheet view Default Sort can be either Ascending or Descending Default Sort can be Alphabetical, by Data Source Order, or by a specified Manual Sort Right-click Sorting on a Dimension - Data will sort within a visualization only (right click on the Dimension Pill and select Sort) This Sort overrides the Default Sort and is dynamic meaning the sort order is modified as data changes sorting contin. - Answers -This Sort overrides the Default Sort and is dynamic meaning the sort order is modified as data changes