tableau desktop specialist

Data Pane contains?

Dimension names Measure names

How can the users refresh an extract immediately in Tableau desktop?

- Select a Data Source on Data Menu -> Extract - Select a Data Source on Data Menu -> Extract -> Refresh -Sign in to Tableau Server -> Tasks -> Under Extract Refreshes select the workbook or data source -> On the Actions menu click Run now

What is the difference between Live and Extract connections?

-Live allows real-time data while extracts are kind of batch which needs to be refreshed from time to get the updated data -Live Connection takes more time to load data than Extract Connection

You have a line chart showing total sales by year. How can you change this to a bar chart? (2 ways)

-On the Marks Card -> select Bar from the drop-down list -on the Show Me menu -> select horizontal bars

Why the direct connection to the extract is not recommended?

-The table names will be different -The extract cannot be refreshed -The data model and relationships will be lost *it can be removed once it's connected directly

Best way to reduce size of an extract

-aggregate data to visible dimensions -select the "hide all unused fields"

what is crosstab

-visualization that is a table (text table

what is the order of operations for filters?

1. Extract Filter 2. Data Source Filter 3. Context Filter 4. Normal (dimension/measure) Filters

Relationship between default dashboard layout and device-specific layouts? (2 things)

1. Items on default do NOT have to be included on device-specific layouts 2. Items on device-specific MUST be present on default aka Device doesn't have to have all of default stuff, but all of Device stuff has to be on default... choose what to select on device from the default

How to change shape of scatter plot shapes? (for both in general and if you want to show dimensional categories)

1. click Shapes in Marks Card -> choose shape 2. Drag a dimension over Shape in the Marks card Click Shape -> click what you want to change -> desired shape -> Ok

What steps will create a dual axis chart? (two methods)

1. one dimension to Column and drag two measures to Row -> in the Rows right click any of the measures -> Select Dual axes -> Go to marks type of any of the measure and choose the chart type as Bar 2. Drag one dimension to Column and drag one measure to Row -> drag another measure to the chart itself and as the rectangle shape appears drop it -> marks type of any of the measure and choose the chart type as Bar

How to create a group from a field in the Data plane?

1. right click a field -> select Create -> in the Create Group box select members that needs to be grouped -> Group -> Ok 2. right click a field -> select Group

How can totals be added to crosstab view? (2 options)

Analytics Pane -> drag totals into view and choose which Analysis tab of Toolbar -> Totals then choose which

Which two can be used to combine tables at different levels of granularity without duplicating data?

Blend and Relationship

What color is a discrete field?

Blue

What is .tds

Data Source (.tds) - contains only the information you need to connect to the data source, including the following: -data source type -connection info (server address, port, location of local files) - groups, sets, calculated fields, bins -default field properties (number formats, aggregation, sort order)

How to show only orders placed in the current month?

Drag date field to filters area. Select Relative Dates. Then select Months and This Month.

How to create Highlight table or Heat Map in Tableau?

Drag one or more measures to Columns and Rows shelf Place a measure on the Color shelf and select Square as the mark type

How to change the points on the scatter plot so they are larger depending on quantity sold? (2 ways)

Drag the pill for Quantity Sold field to Size card Drag the pill for quantity Sold field into the center of the chart and release the mouse

How to create a Hierarchy in Tableau?

In Data plane drag a field and drop on top of another field -> enter name of hierarchy -> ok OR right click the dimension -> Hierarchy -> Create Hierarchy

When assigning geographic role to a field, tableau adds two fields to the Measurers area of the Data pane:

Latitude and Longitude

You have SUM([Minutes of Delay]) in your view. If aggregate measures is unchecked, what will the view show instead of SUM([Minutes of Delay])?

Minutes of Delay

Default formatting can be set for which type of data?

Numbers and Dates

A relationship is most similar to what type of join?

Outer

What is .tdsx

Packaged data source (.tdsx) - contains all information in the .tds file as well as a copy of the data (any local file-based data or extracts)

You've created a bar chart showing Sales by Category, but you'd like the user to be able to choose to have other measures shown in the same format. How could this be achieved?

Parameter

Relationships vs Joins

Relationships -do not combine rows from one table with rows from another -duplication is avoided

Your workbook has two different data sources, both sharing a field called "Business Name." How can a single filter be used to filter both data sources on this field?

Select "All using this data source" option for the filter

How to remove an extract?

Select the extract data source on the Data menu -> Extract -> Remove

You'd like to add the same worksheet multiple times, but with different filters selected. Which features support this? Dashboards only Stories only Both Neither

Stories Only

Lines/Bands options and differences

Table: Entire chart Pane: Per category Cell: Each bar

Which 3 interactive elements can you add to a dashboard?

URL Actions Highlight Actions Filter Actions

How to export a cross tab to excel? (You've created a crosstab view with dimensions and an aggregated measure.

Worksheet -> Export -> Crosstab to Excel

context filter

a set filter that will be carried out before any filters added on the worksheet (ex: you only want to see breakfast category, and then you want to filter top 10) -comes after extract ad data source filters

Which of the following are required to create a trend line? a) 2 measures on opposing axes, or a date and a measure on opposing axes b) 2 dimensions, or a date and a dimension on opposing axes c) 1 measure only d) 1 measure, or a date and a dimension on opposing axes

a) 2 measures on opposing axes, or a date and a measure on opposing axes

How do you change the color of a chart from Marks card? (select all that apply) select the All in marks card... a) Select Color -> Edit Colors -> from the Select Color Palette select any of the desired option -> From the select Data item choose desired color for each of the measure -> Apply -> Ok b) From the Select Color Palette select any of the desired option -> From the select Data item choose desired color for each of the measure -> Apply -> Ok c) Select Color -> Edit Colors -> From the Select Color Pallette select any of the desired options -> Apply -> Ok d) Select Color -> Choose the desired color -> Apply -> Ok

a) Select Color -> Edit Colors -> From the Select Color Palette select any of the desired option -> From the select Data item choose desired color for each of the measure -> Apply -> Ok c) Select Color -> Edit Colors -> From the Select Color Palette select any of the desired option -> Apply -> Ok

What is the default format (extension) that Tableau saves the files as? (multiple possible answers) a) .doc b) .tdsx c) .tds d) .pbix

b) .tdsx c) .tds

Aliases cannot be created for the following - (multiple possible answers) a) Discrete dimension b) Continuous dimension c) Measurers d) Dates

b) Continuous dimension c) Measures d) Dates

Which of the following are the types of sets in Tableau? a) Singleton set b) Dynamic set c) Fixed set d) Equal set

b) Dynamic set c) Fixed set

What types of trend lines are available in Tableau? a) logistic b) linear c) logarithmic d) multinomial e) polynomial

b) linear c) logarithmic e) polynomial

Advantages to using relationships to combine tables: (multiple possible answers) a) makes it easier to change the key fields used to combine tables b) makes it easier to analyze data across multiple tables at different levels of granularity c) makes it easier to combine rows from one table with rows from another d) tables are only queried when fields from the tables are added to the viz

b) makes it easier tho analyze data across multiple tables at different levels of granularity d) tables are only queried when fields from the tables are added to the viz (aka when required in the worksheet)

Which of the following quick table calculations are available? a) z-score b) percent of total c) rank d) percentile

b) percent of total c) rank d) percentile

a color gradient is used for? continuous measure discrete measure both neither

continuous

A field that shows average home values for the United States in 2020 is most likely: a) A discrete date part dimension b) A continuous date value dimension c) A geographical dimension d) An aggregated measure

d) An aggregated measure

How can we disaggregate data in Tableau? For any visualization... a) Go to File -> Uncheck the Aggregate Measures b) Go to Data -> Uncheck the Aggregate Measures c) Go to Worksheet -> Uncheck the Aggregate Measures d) Go to Analysis -> Uncheck the Aggregate Measures

d) Go to Analysis -> Uncheck the Aggregate Measures

Rows and column shelve contain a) Grand totals b) Parameters c) Filters d) Pills

d) Pills

purple [ ] represent what in a formula?

parameter

How to change a map to see all major cities shown on the map?

toolbar -> Map -> Map Layers -> check the box next to Cities in the Map Layer pane

How to get average for each category in a bar chart?

use "Per Pane" and the Value to be SUM(Sales) using Average

How to create a Relative Data Filter a) drag a date field to the filter shelf -> Ok b) drag a date field to the filter shelf -> Select a time unit -> Ok c) drag a date field to the filter shelf -> Select a time unit -> Define the date period -> Ok d) drag a date field to the filter shelf -> Define the date period -> Ok

c) drag a date field to the filter shelf -> select a time unit -> define the date period -> ok

You have a bar chart showing monthly revenue by store. What should you do to combine the bars for two of the stores? a) set b) hierarchy c) group

c) group

after adding one table to the canvas, what steps should you take to create a relationship with a second table located on a different database?

-click Add Link to the right of the connections heading in the Left pane. Switch between data connections in the Left pane, then drag out the desired table to the canvas and release it

How to do a manual sort? (2 ways)

-right click the pill for the DIMENSION you'd like to sort. Select Sort, then Manual. Use arrows to sort and OK -Click a header of a dimension (whatever Alias) and drag it to the new location **can't manually sort measures

Which of the following applies for Density map in Tableau? a) To create a density map, the data source should contain Latitude and Longitude coordinates or location names b) Tableau can't recognize location names and create a density map using the points locations assigned to geocoding locations c) Density maps are most effective when the location data is very precise, such as location coordinates in a limited space d) Density marks work best where the specific locations change continuously and smoothy across space, rather than values constrained to discrete locations like borough or neighborhood.

a) c) d)

You can create ________ for members in a dimension so that their labels appear differently in the view a) Aliases b) Copies c) Parameters d) Duplicates

a) Aliases

How do you create a viz in tooltip? (select 2) a) Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Marks card -> Select insert and select the target worksheet b) Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the target worksheet, click Tooltip in the Marks card -> Select insert and select the target worksheet c) Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Analytics tab -> Select insert and select the target worksheet d) Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Worksheets tab -> Select insert and select the target worksheet

a) Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Marks card -> Select insert and select the target worksheet d) Create a visualization in the source worksheet in Tableau -> Create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify -> In the source worksheet, click Tooltip in the Worksheets tab -> Select insert and select the target worksheet

Select the correct pathway to edit the data source - a) Data Menu -> Select a Data source -> Edit Data Source b) Data Menu -> Select a Data source -> Extract Data c) Data Menu -> Select a Data source -> View Data d) Data Menu -> Select a Data source -> Edit Data Source Filters

a) Data Menu -> Select a Data source -> Edit Data Source

What are the differences between discrete date and continuous date values? (select all that apply) a) Discrete date part color is Blue whereas the Continuous date part color is Green b) Discrete date creates labels whereas the Continuous date creates axis c) Discrete date aggregates data at the selected unit whereas the Continuous date uses individual date values d) Continuous date part color is Blue whereas the Discrete date part color is Green

a) Discrete date part color is Blue whereas the Continuous date part color is Green b) Discrete date creates labels whereas the Continuous date creates axes c) Discrete date aggregates data at the selected unit whereas the Continuous date uses individual date values

How to create a stacked bar chart while using a separate bar for each measure? a) Drag a dimension to Color -> drag measure names to Columns and drag Measure values to Rows -> on Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> ok b) Drag a dimension to Color -> Drag Measure Names to Rows and also drag measure values to Rows -> on the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok c) Drag a dimension to Color -> Drag Measure Names to Columns and drag Measure Values to Rows -> on the Columns shelf right-click Measure Names -> Ok d) Drag a Measure Values to Color -> Drag Measure Names to Columns and drag Dimension to Rows -> on the Columns shelf right-click Measure Names -> select Filter -> select check boxes for the measures to display -> Ok

a) Drag a dimension to Color -> Drag Measure Names to Columns and drag Measure Values to Rows -> on the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok

What steps should be taken to change a vertical Baar chart to horizontal? a) Drag the measure to the columns shelf and the dimension to the row shelf b) Drag the measure to the rows shelf and the dimension to the column shelf c) Drag the measure to both the row shelf and the columns shelf d) Drag the dimension to both the rows shelf and the column shelf

a) Drag the measure to the columns shelf and the dimension to the row shelf

How can we create a dashboard? (Select all that apply) a) Go to Dashboard and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width. -> Ok b) Go to Analysis and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok c) Go to Worksheets and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width -> Ok d) Select the New Dashboard option -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width. -> Ok

a) Go to dashboard and select New Dashboard -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width. -> Ok d) Select the New Dashboard option -> Drag the desired worksheets to the dashboard to work for -> Adjust the dashboard length and width. -> Ok

Which of the following are true for using fonts for visualization? (Select all that apply) a) If the workbook is created in Tableau Desktop than we can use any font installed on the computer in the workbook b) If the workbook is created using Web Authoring we can use any font installed on the computer in the workbook c) If the workbook is published to Tableau Server ay custom font must be installed on all server nodes. If the font is not installed on Tableau Server, the uninstall font will be replaced with a substitute font upon publishing. d) If the workbook is published to Tableau Online we can use any font installed on the computer in the workbook.

a) If the workbook is created in Tableau Desktop than we can use any font installed on the computer in the workbook c) If the workbook is published to Tableau Server any custom font must be installed on all server nodes. If it is not installed, the uninstall font will be replaced with a substitute font upon publishing

Which of the following is true for Measures? (select all that apply) a) Measures contain numeric, quantitive values b) Measures contain qualitative values (names, dates, geo data) c) Measures can be used to categorize, segment, and reveal details in the data d) Measures can be aggregated

a) Measures contain numeric, quantitative values d) Measures can be aggregated

Which of the following are the differences between dimensions and measures? (select all that apply) a) Measures contain quantitative values whereas Dimension contain names, dates, or geo data b) Measures contain continuous values with green pills whereas dimensions contain discrete values with blue pills c) Dimension contain numeric, quantitative values whereas Measures can be used to categorize, segment, and reveal the details win the data d) Dimensions are aggregated when added to the view while measures increase the level of detail in the view e) Dimensions increase the level of detail inn the view while measures are aggregated when added to the view

a) Measures contain quantitative values whereas Dimensions contain names, dates, or geo data e) Dimensions increase the level of detail in the view whole measures are aggregated when added to the view *** b) is incorrect because there can be discrete measures and continuous dimensions

How can we manually add separate device layout in Tableau? a) Open a dashboard -> On the Dashboard tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode b) Open a dashboard -> On the Analytics tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode c) Open a Worksheet -> On the Dashboard tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode d) Open a dashboard -> On the Dashboard click on Format tab and select Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode

a) Open a dashboard -> On the Dashboard tab on the left, click Device Preview -> Take a moment to click through the Device types and Models and explore the different screen sizes ->Also there is a button to turn the dashboard into landscape or portrait mode

How can we publish a workbook? a) Open the desired workbook for publish. Go to File. Click on Save to Tableau Public As. Sign in to the server. Name the workbook for publish. Ok b) Open the desired workbook for publish. Go to Data. Click on Save to Tableau Public As. Name the workbook for publish. Ok c) Open the desired workbook for publish. Go to Analytics. Click on Save to Tableau Public As. Name the workbook for publish. Ok d) Open the desired workbook for publish. Go to Format. Click on Save to Tableau Public As. Name the workbook for publish. Ok

a) Open the desired workbook for publish. Go to File. Click on Save to Tableau Public As. Sign in to the server. Name the workbook for publish. Ok

Choose the correct path to add a default comment for a field - Right click a field in the Data Pane and then: a) Default Properties -> Comment b) Aggregation -> Default Properties -> Comment c) Comment d) Describe -> Comment

a) Right click a field in the Data Pane -> Default Properties -> Comment

How to add a default comment for a field a) Right click a field in the Data pane-> Default Properties-> Comment b) Right click a field in the Data pane-> Aggregation -> Default Properties-> Comment c) Right click a field in the Data pane -> Comment d) Right click a field in the Data pane-> Describe-> Comment

a) Right click a field in the Data pane -> Default Properties -> Comment

___________ contains the visualization info needed to build the visualizations, and a copy of the data source. a) Tableau Package Workbook (.twbx) b) Tableau Data Extract (.tde) c) Tableau Bookmark (.tbm) d) Tableau Workbook (.twb)

a) Tableau Package Workbook (.twbx)

When relating tables, the fields that define the relationships must have the same data type. a) True b) False

a) True

Which are true for URL actions? (select all that apply) a) URL action is a hyperlink that points to web page, file, or other web-based resource outside of Tableau b) We can use URL actions to create an email c) We can use URL actions to link additional information about the data d) To customize links based on our data, we cannot automatically enter field values as parameters in URLs

a) URL action is a hyperlink that points to web page, file, or other web-based resource outside of Tableau b) We can use URL actions to create an email c) We can use URL actions to link additional information about the data

3) Interactive elements that you can add to a dashboard for users include_________ a) URL actions b) Edit tooltip options c) Filter actions d) Hide and unhide all sheet options

a) URL actions c) Filter actions

When working with Excell, text file data, JSON file, .pdf file data, you can use ____________ to union files across folders, and worksheets across workbooks. Search is scoped too the selected connection. a) Wildcard Search b) Union Search c) Pattern Search d) Regex Search

a) Wildcard Search

Which option leads to adjusting the granularity of data in Tableau? a) aggregate b) group by c) grouped fields d) extract

a) aggregate

The main types of calculations you can use to create calculated fields in Tableau a) basic calculations b) Level of Detail (LOD) expressions c) statistic calculations d) table calculations

a) basic calculations b) LOD expressions d) table calculations *NOT statistic

How to show subtotals in a visualization a) Click the Analytics pane -> In the Analytics pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals b) Click the Analytics pane -> Click the Subtotals c) Click the Data pane -> In the Data pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals d) Click the Data pane -> Click the Subtotals

a) click analytics pane -> under Summarize drag Totals into Add Totals dialog -> drop it over Subtotals

Which of the following can prevent a refresh for a refreshable list of parameter values? (select all that apply) a) default field returns null b) default field does not return a single value c) default field is in a data source that's not yet connected d) user cancels the query to the data source while Tableau is attempting to connect

a) default field returns null c) default field is in a non-connected source d) user cancels the query

Which of the following are applicable for nested sort in Tableau? (select all three) a) nested sort considers each pane independently and sorts the rows per pane b) nested sorts look correct within the context of the pane, but don't convey the aggregated information about how the values compare overall c) sorting from an axis does not give a nested sort by default d) while creating a nested sort, the sort is inherited when we drill down through dimensions

a) nested sort considers each pane independently and sorts the rows per pane b) nested sorts look correct within the context of the pane, but don't convey the aggregated information about how the values compare overall d) while creating a nested sort, the sort is inherited when we drill down through the dimensions

How can we change the size of marks?

a) select size -> move slider to right or left to increase or decrease.

How many data sources can we blend in Tableau? a) two b) three c) four d) five

a) two

When you drag additional tables to the logical layer canes, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible a) True b) False

b) False **it will ask you to define the relationship, so it is possible but you have to do it

How can we enable the option of Animation? a) Analysis -> Choose Animations -> Select On from Animations Tab b) Format -> Choose Animations -> Select On from Animations Tab c) Dashboard -> Choose Animations -> Select On from Animations Tab d) Worksheet -> Choose Animations -> Select On from Animations Tab

b) Format -> Choose Animations -> Select On from Animations Tab

You created a group by using field labels in a view. How can you remove members from the group? a) From the view, right-click the group members and select Exclude. b) From the Data pane, right-click the group and select Edit Group. c) From the view, right-click the group members and select Format. d) From the color legend, right-click the group members and select Format legends.

b) From the Data pane, right-click the group and select Edit Group

Which of the following are FALSE about joins? Choose 3 a) They are displayed with Venn diagram icons between physical tables b) Joins can be defined at the time of query dynamically c) May drop unmatched measures values d) Joined tables are never merged into a single table e) They are more dynamic way than relationships to combine data

b) Joins can be defined at the time of query dynamically d) Joined tables are never merged into a single table e) They are a more dynamic way than relationships to combine data

Choose the correct path to change the data type for a field in the view - Right click the field in the Data pane and then: a) Change Data Type -> Data Types -> choose appropriate type b) Change Data Type -> choose appropriate type c) Data Types -> Choose appropriate type d) choose appropriate type

b) Right click the field in the Data pane -> Change Data Type -> Choose appropriate type

How can we export a view as an image file? a) Select Data > Export> Image -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save b) Select Worksheet > Export> Image -> In the Export Image dialog box, select the elements we want to include in the image. If the view contains a legend, under Image Options, select the legend layout -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save c) Select Format > Export> Image -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save d) Select Worksheet -> Click Save as -> In the Save Image dialog box, specify a file location, name, and format. Then click Save

b) Select Worksheet > Export> Image -> In the Export Image dialog box, select the elements we want to include in the image. If the view contains a legend, under Image Options, select the legend layout -> Click Save -> In the Save Image dialog box, specify a file location, name, and format. Then click Save

You can ___________ your data to combine two or more tables by appending values (rows) from one table to another a) Concatenate b) Union c) Join d) Blend

b) Union

Which option creates a dashboard action? a) Explain data b) Use as filter c) Swap sheets d) Add show/hide button

b) Use as filter

Aliases CAN be created for which of the following? a) continuous dimension b) discrete dimension c) measures d) dates

b) discrete dimension

What is the difference between a dual axis chart and a combined axis chart? a) dual axis and combined axis mean the same b) dual axis chart creates two independent axes while a combined axis chart merges two or more measures into a single axis c) combined axis chart creates two independent axes while a dual axis while a dual axis chart merges two or more measures into a single axis d) dual axis chart becomes a combined axis chart once two or more measures are combined into a single axis

b) dual axis chart creates two independent axes while a combines axis chart merges two or more measures into a single axis

What will the following function return? LEFT("Tableau", 3) a) error b) tab c) eau d) ble

b) tab

Filter dialog box offers the following tabs for filtering (select all that apply) - a) report b) wildcard c) condition d) top

b) wildcard c) condition d) top

blend vs relationship

blend: never truly combines it, only supports left joins, can't be published, combines two different data sources relationship: aggregates and then combines, supports full outer join, can be published since it can create a table in the background

discrete vs continuous dimensions

blue vs green -discrete will show HEADERS, continuous AXES -discrete will create a TABLE, continuous will be a single bar chart (generally a COUNT)

How can we create a story? a) Go to Analysis -> Click on New Story -> Ok b) File -> Click on New Story -> Ok c) Click on the New Story tab -> lower-left corner of the screen, choose a size for the story -> double click on any sheet or dashboard to add it -> By default the story name gets its title from the -> Click Add a caption to summarize the story point d) Go to Data -> Click on New Story -> Select Ok

c) Click on the New Story tab -> lower-left corner of the screen, choose a size for the story -> double click on any sheet or dashboard to add it -> By default the story name gets its title from the -> Click Add a caption to summarize the story point

What steps should be taken to create a geographical hierarchy? a) Analytics pane right click geographic field -> create hierarchy b) Analytics pane right click the create Hierarchy -> select hierarchy -> ok c) Data pane right-click the geographic field -> Hierarchy -> Create Hierarchy d) Data pane right-click the geographic field -> Transform -> select Hierarchy -> create hierarchy

c) Data pane right-click the geographic field -> Hierarchy -> Create Hierarchy

Which of the following 2 fields cannot be deleted in Tableau? a) Calculated fields b) Number of Records c) Measure Names d) Measure Values

c) Measure Names d) Measure Values

How can we change the aggregation of a measure in Tableau? For any visualization right click o the measure... a) Go to Aggregate -> select desired b) Go to Analysis -> select desired c) Go to Measure -> select desired d) Go to Format -> select desired

c) Right click the measure -> Go to Measure -> select desired

Which of the following are valid options to define the scope of a reference line? (Choose 3) a). Window b) Axis c) Table d) Cell e) Section f) Pane

c) Table d) Cell f) Pane

Which of the following is true about the display of a discrete field when dragged to Color in Marks Card? a) When dragged to the color of marks card, Tableau displays a palette with colors based on the order of the fields b) When dragged to the color of marks card, Tableau displays a quantitative legend with a continuous range of colors c) When dragged to the color of marks card, Tableau displays both the categorical palette and a legend with a color for each value of the field d)When dragged to the color of Marks card, Tableau displays a stepped color gradient

c) When dragged to color in marks card, Tableau displays both the categorical palette and a legend with a color for each value of the field

Which of the following is the best reason to use an extract instead of a live connection? a) Your data source only supports a live connection via ODBC b) You need to refresh the data as often as possible c) You need to apply an aggregation that takes a very long time when using a live connection. d) You need to join tables in the data source

c) You need to apply an aggregation that takes a very long time when using a live connection

How can we change the shape of the marks for a chart? a) Choose any two measures and drag them to columns and rows -> select any measure and drag it to the color of Marks card -> select any measure and drag it to the shape of the Marks card b) Choose any one measures and drag it to columns and choose any dimension and drag it to rows -> select any dimension and drag it to the color of Marks card -> select any dimension/measure and drag it to the shape of the Marks card c) Choose any two dimensions and drag them to columns and rows -> select any dimension and drag it to the color of Marks card -> select any dimension/measure and drag it to the shape of the Marks card d) Choose any two measures and drag them to columns and rows -> select any dimension and drag it to the color of Marks card -> select any dimension/measure and drag it to the shape of the Marks card

d) Choose any two measures for rows and columns -> drag a dimension to color of Marks card -> select any dimension/measure and drag it to the shape of the Marks card

___________ is hosted by Tableau to share our visualizations publicly with the world. a) Tableau Desktop b) Tableau Server c) Tableau Reader d) Tableau Public

d) Tableau Public

In a Relationship we need to define the following Join type- a) Inner Join b) Left Join c) Right Join d) it is not required to define a join type in a relationship

d) it is not required to define a join type in a relationship

discrete vs continuous measures

discrete is blue pills, continuous green pills -discrete will show bars (broken) -continuous will be more of a line chart (complete whole, no breaks)

synchronized vs not synchronized dual axis charts

either the same (synchronized) numbers on the axis or different (not)

How to get to tooltip?

either through Marks card or worksheet (top apple row)

You wish to organize related dimensions into a series of different levels. Which feature should you use?

hierarchy

what combines dimension to enable drill down? set or hierarchy

hierarchy

How do you create a Binned Dimension in Tableau?

in the Data pane right click a measure -> Create -> Bins -> Create Bins box accept the proposed New Field Name or change it -> size of bins -> Ok **needs to be a histogram

what is granularity

level of detail of the data -how big/how many rows/columns