


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
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
1 / 4
This page cannot be seen from the preview
Don't miss anything!



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