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