- 3 steps to workflow workflow, connect to the data by bringing in youe data, analyze it and build a viz (and share the analysis)
- create aliases for dimensions Right click on a dimension and click aliases
- crosstab table details of data within categories
- data pane lists all fields from the data source
- data source page A page where you can set up your data source. The Data Source page generally consists of four main areas: left pane, join area, preview area, and metadata area.
- Dimensions fields that are qualitative or categorical
- do tds files save visualizations? No
- does live data refresh automatically? Yes
- example of a crosstab table sub categories within categories
- example of a measure average cost or sales amount
- example of dimensions cities
- extract data tableau makes a local copy of the subset of the data
- extracts subsets of a data source – a copy of the data
- how to add a field in drag and drop
- how to change a dimension to a measure Drag the measure to the dimensions area or vice versa
- how to create a folder ◦ Right click on dimension or measure field and go to folders -> create folder
- how to edit default properties before they hit a shelf? ◦ Right click the field
◦ Go to default properties and choose which one you’d like to choose - how to fix metadata change errors? right click the field that’s erroring out -> replace references -> click the renamed field
- how to group data fields together go to arrow in data pane and click group by folder
- how to save a tds file ◦ Go to data in top toolbar -> go to data source -> add to saved data source
- how to see an entire chart without needing a scroll bar? change view to entire view
- how to use show me charts select the fields you want to use and control click
– click show me - if data is changed in tableau, is it changed to the data source? no, only locally
- if metadata is changed in a refresh, what does tableau do? tableau will inform you by showing an error on the visualizations page
- if you,ve changed the metadata, do you save as twbx? no, as a .tds (tableau data source)_ file
- In the Data Pane, Discrete values are which color? Blue
- In which scenario should you save changes as a .tds file? You change metadata and want to come back to the data connection again later.
- live connection data visualizations that are updated live
- mark shape used to represent data
- measures quantifiable / numerical value
- Metadata data that describes other data
- Metagrid shows fields in the data source as rows so you can easily examine the structure of the data
- Pages Shelf A shelf to the left of the view that you can use to split a view into a sequence of pages based on the members and values in a discrete or continuous field. Adding a field to the Pages shelf is like adding a field to the Rows shelf, except that a new page is created for each new row.
- refresh data click connection name in the data pane and click refresh
- show me charts recommended chart
- tds file saves: ◦ Saves groups
◦ Aliases
◦ Field properties
◦ Measures/dimensions converted to the other
◦ Calculated fields - undo back arrow
- What are three benefits of using a Tableau data extract instead of a live connection? – Aggregation of visible dimensions
– Faster loading of data into dashboards
– Filters to reduce the size of the dataset - What are two reasons to choose a live connection to a data source instead of a Tableau data extract? – You need the data to be as up to date as possible.
– You want to use the native security features of the underlying database. - what does a field in italics identify? tableau generated fields
- what does a tds file save? it does save properties to fields and it becomes a saved data source, rather than a file containing a visualization
- what does changing a default property of a field do? This can help avoid extra steps if you want the color to be what you want before you even take it out of the data pane
- what does creating a folder do? This organizes the fields shown so if you have many fields and want to see them all – creating folders would be a good way to do that
- what does creating an alias do? This helps if a value is not understandable to others who dont know your database
- what does saving as a twbx file do? saves the visualization and the data source
- What is a valid reason to create an alias for a dimension name? To display an alternate label for the dimension in the header of a viz
- what is a view? where the visualization is / the visualization itself
- What type of file to save a tableau file as? Twbix
- when do you use extracts? when you want the users to only see a limited amount of data – similar to row level security
- Which file extension is used for a Tableau data extract .hyper
- Which statement accurately describes using country names as geographic data? If Tableau does not automatically assign a geographic role to a field containing country names, it can be assigned manually by selecting Geographic Role on the Data Sources page.
- You need to change a single measure field to be displayed on all the worksheets within a workbook as a percentage. What should you use? Default Properties in the Data pane
Other Links:
See other websites for quiz:
Check on QUIZLET