Tableau
This file extension contains a single worksheet
.tbm (bookmark)
You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?
.tds file; .twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well.
What is the best Tableau file for sharing Tableau work with others who don't have access to the original data?
.twbx
Requirements for Unions
1) Same table structure, 2) Same data types, 3) Data must come from the same connection
Why are TDEs advantageous?
1) Supports large data sets: You can create extracts that contain billions of rows of data. 2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data. 3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data. 4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct. 5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
1, 4; 1 dimension (measure name), 4 measures (latitude, longitude, number of records, measure values)
As a general best practice, your pie chart should contain ___ to ___ categories.
2 to 5
What is the maximum number of tables on which Tableau can join?
32
What is a bullet graph?
A bullet graph is a bar marked with extra encodings to show progress towards a goal or performance against a reference line.
Which of the following would you use to connect to multiple tables in a single data source at once?
A join
What is an extract file?
A local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
How can you make DateTrunc discrete?
Add datetime pill to view as normal, which defaults to continuous (green). Right click and click "discrete." The view still shows a continuous chart, but the view has headers instead of an axis. The pill is blue.
How can you make DatePart continuous?
Add datetime pill to view as normal, which defaults to discrete (blue). Right click and click "continuous." The view still shows the date part (disregarding the year, quarter, month, week if daypart is by day) but the view is on an axis. The pill is green.
What color are discrete variables?
Blue
.tbm file extension
Bookmark files; Bookmarks contain a single worksheet and are an easy way to quickly share your work
Drag tables from the left pane into the [blank] in order to add them to the data source
Canvas
Which parts of the view can affect the granularity of the view when a variable is dropped into it?
Columns, Rows, Sheet, Pages, Color, Size, Label, Detail, Path
Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which filter type should you apply on Region?
Context filter
Variable is generally adds axes to a view
Continuous
Variable treated as an infinite range
Continuous
variable forms an unbroken whole, without interruption
Continuous
By default, what does Tableau do when you connect to a data source?
Creates a live connection to the data; Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places. By default, when you connect a data source to Tableau, Tableau will create a live connection to the data.
Use this file format if everyone who will use the data source has access to the underlying file or database defined in the connection information
Data Source (.tds)
.tds file extension
Data Source; Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.
____ refers to the level of detail for a piece of data, wherever you are looking
Data granularity
How does DatePart differ from DateTrunc?
DatePart: Blue pills and discrete, only considers one part of a date (ex. groups by month regardless of year) DateTrunc: Green pills and continuous, looks at the part of the date you selected and everything preceding it, effectively truncating the datetime (ex. For a month selection, it considers, year, quarter and month)
Affect the level of granularity in the view
Dimensions
Contain qualitative values
Dimensions
The Context
Dimensions
are used to categorize, segment, and reveal the details in data
Dimensions
If you decide you want to see all the marks in the view at the most detailed level of granularity, you can ___ in the view
Disaggregate the measures
Variable is generally adds headers to a view
Discrete
variable is treated as finite
Discrete
The default path for all supporting files, data sources, icons, logs etc is in
Documents -> My Tableau Repository
An LOD that is performed at a less granular level
EXCLUDE
A local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance
Extract
Tableau Order of Operations Filters
Extract, Date Source, Context, Dimension, Measure, Table Calc
.hyper or .tde file extension
Extract; Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
TRUE or FALSE: The default type of aggregation for a measure placed in a view is always a sum.
FALSE: It is usually, but not always a sum
An LOD that is performed at an independent level
FIXED
T/F: Filters affect the granularity of a view
False
True or False: A set is a dimension
False. It is neither a dimension or measure
Clicking this option allows the user to only select values that are still applicable. ex. Say you have a region and country filter. You check the box for "North America." Clicking this option will make country box selections only countries in North America.
Filter: Relative Values
Group or Set: Always static
Group
Group or Set: Member are merged into a single label
Group
Contains a workbook along with any supporting local file data and background images
Packaged workbook
An LOD that is performed at a more granular level
INCLUDE
What happens to a measure when you create a group?
It converts to a dimension
What does incremental refresh do?
It only adds rows that are new since the previous refresh
With a [BLANK] connection, Tableau makes queries directly against the database or other source and returns the results of the query for use in the workbook.
LIVE
How do you make two dimension filters execute separately (one after the other)
Make the first filter your want to execute a context filter
Why would you make DateTrunc discrete?
Making the datetime discrete removed emptiness caused by gaps in time because a continuous graph is an uninterrupted whole. You can also remove date ranges you don't want to see
Adhere to the level of granularity in the view
Measures
Can be aggregated
Measures
Contain numeric, quantitative values that you can measure
Measures
The content
Measures
The [blank] shows the column names without the data in the Data Source Page
Metadata grid
Are data extracts information stored in a .tds file?
NO
Are videos valid objects when creating a dashboard in Tableau?
NO
Are visualizations stored in a .tds file?
NO
Do you work with the freshest data at all times when using a Tableau Data Extract?
NO
Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?
NO
Is SUM a table calculation?
NO; It is an aggregate function
If you use a percent difference Quick Table Calculation, what value will be the first data value?
NULL
Can you aggregate dimensions?
Not technically, but there is a work around. If you put the dimension in a column/row and then pick a default aggregation, then you can choose count, count(distinct), max and min.
How many measures do you need to create a histogram?
ONE
What is the minimum number of worksheets a .twb file can hold?
ONE
A workbook holds ___ or more worksheets plus ___ or more dashboards and stories.
ONE, ZERO
Use this file format if you want to share your data source with people who do not have access to the underlying data that is defined in the connection information
Packaged Data Source (.tdsx)
.tdsx file extension
Packaged data source; Tableau packaged data source files have the .tdsx file extension. A packaged data source is a zip file that contains the data source file (.tds) described above as well as any local file data such as extract files (.hyper or .tde), text files, Excel files, Access files, and local cube files. Use this format to create a single file that you can then share with others who may not have access to the original data stored locally on your computer.
.twbx
Packaged workbook; A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.
What shape does a heat map use by default?
SQUARE
Group or Set: Like a shopping list
Set
Dimensions containing ______ and ______ values cannot be continuous.
String, Boolean
Most viewers scan content starting at the _____________ of a page.
TOP LEFT (according to Tableau's official documentation)
True or False: The highlighting action can be disabled for the entire workbook.
TRUE
True or False: Trend lines can only be used with numeric or date fields
TRUE
What is the minimum number of measures needed for a bullet graph?
TWO
A single zip file that contains a workbook along with any supporting local file data and background images
Tableau Packaged Workbook
.twb file extension
Tableau workbook files; workbooks hold on or more sheets, plus zero or more dashboards and stories
What are the data types in Tableau? (7)
Text/string, numerical, date values, datetime values, boolean values, geographic values, cluster groups
True or False: A group is a dimension
True
Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?
Using 2 measures; for example, you can show how actual sales compared to expected sales.
Relationships are represented by ___ in the physical layer
Venn diagrams
Simultaneous Filter
When two Tableau filters are on the the same level in the Tableau order of operations
Field Sort Vs Nested Sort
When you sort by field, the sort ignores other dimensions you added to the shelf. It only sorts by one dimension. Nested sort takes into account other dimensions you added to the shelf. It sorts within each subgroup. For example, if you had Region and Income Group, Field Sort would only sort high to low in the same way it would have without Region on the shelf. Nested Sort sorts high to low for each region.
Are calculated fields stored in a .tds file?
YES
Are metadata edits stored in a .tds file?
YES
Can you use data offline with a Tableau Data Extract?
YES
Is data connection information stored in a .tds file?
YES
Is it possible to add a field to more than one hierarchy?
YES
Can bins be created on dimensions?
YES, they just have to be numeric ex. ID
Can you union tables from different Excel workbooks?
Yes. When working with Excel, text file data, JSON file, .pdf file data, you can also use wildcard searches to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page
Why would you make a DatePart continuous?
You can do more to axis than header views; ex. reference lines or drop lines
What is the minimum number of dashboards a .twb file can hold?
ZERO
What is the minimum number of stories a .twb file can hold?
ZERO
What kind of connection do you need to work with the most up to date data?
a LIVE connection
What is a Tableau Data Extract?
a compressed snapshot of data stored on disk and loaded into memory as required to render a Tableau viz.
What calculation is being made with a simultaneous filter?
an AND calculation is being made. Ex. Say you have a region filter set to Europe and a Top ten filter. Your result with be only countries that are in Europe and in the top ten; you may return less than ten countries.
What aggregations can you do on a dimension?
count, count(distinct), max and min.
variable is individually separate and distinct
discrete
What color are continuous variables?
green
By definition, Tableau displays measures over time as a ___
line
Relationships are represented by ___ in the logical layer
noodles
A group is represented by an icon that looks like a [blank]
paperclip
What is a live connection in Tableau?
refers to a data source that contains direct connection to underlying data, which provides real-time or near real-time data. With a live connection, Tableau makes queries directly against the database or other source, and returns the results of the query for use in a workbook. Users can create live connections and then share them on Tableau Server so that other Tableau users can use the same data using the same connection and filtering settings.
What is the difference between twb and twbx?
twb allows you to save a workbook and maintain a live connection. twbx is a Tableau Packaged Workbook and allows you to save the workbook and the data together. This way, you can send someone both the workbook and the data together.
A set is represented by an icon that looks like a [blank]
ven diagram
