Tableau Qualified Associate Exam Prep 2
Pareto charts combine the following elements:
Bar and line graphs (none of the above)
How to create a bar in bar chart?
1.) bring in a dimension and a measure 2.) drag a measure to the left axis (creates two bar icon new mouse) 3.) then drag measure names over to color 4.) turn stag bars off 5.) drag measure names to size
Which of the following is equivalent to the upper hinge? 25th percentile 50th percentile 75th percentile
75th percentile
What are benefits to tableau reader?
A free desktop application that you can use to open and interact with data visualizations built in Tableau Desktop. Filter, drill down and discover. Allow analysts and content creators to distribute content they built in Tableau Desktop. Can be opened from email. Cant be refreshed, very little security, It cant be centrally managed, so the workbook can be unpacked and the user can look at the data. Doesn't work with tablets and smartphones. Tableau Reader users can only access and interact with local workbooks
What is required for blending?
A least one common field
What is a cube?
A multidimensional data source, speeds execution of queries. THey require restrictions. Typically are considered "OLAP"
How can parameters be used in Tableau?
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
A Reference Line cannot be added from the Analytics pane. True False
A reference line can be added from the analytics pane.
Which of the following statement is true? A. Parameters can be used both in calculated field and sets B. Parameters can be used in calculated field but cannot be used in sets C. Parameters cannot be used in calculated field but it can be used in sets D. None of above is correct
A. Parameters can be used both in calculated fields and sets.
While creating a dashboard multiple devices like Mobile, Desktop and Laptop. Which of the following options are available on Device Preview Page in tableau. A. Tablet, Phone, Desktop, Default B. Tablet, Mobile, Desktop, Default C. Tablet, Phone, Laptop, Default D. Table, Phone, Monitor, Default
A. Tablet, Phone, Desktop, Default
What will the function Left(3,"Tableau") return? Tab eau An error
An error. It should read LEFT("Tableau",3)
Which of the following statement is true about Dashboards and Sheets: A. Sheets which are used on dashboard cannot be hided B. Sheets that are used on a dashboard can be hided but not deleted C. Sheets which are used on dashboard can be hided but it gives warning on hiding D. Sheet that is used on a dashboard can be deleted
B. Sheets that are used on a dashboard can be hided but not deleted.
Which of the following is not a Trend Line model? Linear Trend Line Exponential Trend Line Binomial Trend Line Logarithmic Trend Line
Binomial Trend Line
By definition, Tableau displays measures over time as a ____________. Bar Line Histogram Scatter Plots
By definition, Tableau displays measures over time as a Lines.
How to use "Case"?
Case () when () then 0 ... repeat.. end
_______ is a technique in Tableau which will identify marks with similar characteristics.
Clustering
In Customer Segment Analysis Dashboard, There is a sheet Customer Segment showing the yearly trend of Sales in the Customer segment. At the moment when we click on any point on the line, It does not filter the data in other sheet accordingly. How can we link the Trend line sheet with other sheets to filter the data as per selected point on the trend line? A. By Using the Dashboard Actions and linking them by URL B. By the Creating filters on each work sheet and linking them C. By Using the Worksheet Actions and linking them D. By Using the Dashboard Actions and linking them through Filter Option
D. By Using the Dashboard Actions and linking them through Filter Option
Spatial files contain geographic information that can be very useful for visual analysis. Which of the following types of geometries are supported by Tableau. A. Point Geometries and Mix Geometries B. Only Point Geometries and Line Geometries C. Line Geometries are only geometries supported by Tableau D. Point Geometries, Line Geometries, Polygons
D. Point Geometries, Line Geometries, Polygons
If a field has a blue background, that means the field is discrete dimension measure continuous
Discrete
You open a Tableau workbook with a live connection to a large data source and are surprised that the workbook opens almost instantly. Which of the following most likely reduced the load time? Parallel Query Query Fusion External Query Caching Data Engine Vectorization Parallel Aggregation
External Query Caching
T or F SUM is a table calculation.
False
True or False A trend line using an exponential model type will be fit using exponential regression
False
True or False Adding a dimension to the row or column shelf will filter your data.
False
True or False All rows from both tables are returned in an INNER JOIN.
False
True or False Sorts can break the dimension hierarchy. In other words, Tableau will rearrange any the headers of the fields that appear to the left of the sorted field.
False
True or False The interquartile range is the difference between the 2nd and 3rd quartiles.
False
True or False The metadata grid displays the fields in your data source in columns.
False
True or False A visual best practice is that if you are using a color gradient to represent a continuous variable which can be negative or positive, you should use a single color range
False use 2 diverging colors like orange blue for negative and positive valeus respectively
T or F A Reference Band cannot be based on two fixed points.
False, A Reference Band can based on two fixed points.
T or F The dashboard can be shown on the tooltip of any field on any dashboard as we can show sheet on the tooltip.
False, Sheets can be used in the tooltip where dashboards cannot be shown in the tooltip.
Which of the following is an alternative to a Tile dashboard layout?
Floating
For creating variable sized bins we use? Sets Groups Calculated fields Table calculation
For creating variable sized bins we use a logical statement in a calculated field.
What type of join can a blend NOT do?
Full outer join
How do you determine if the quality of a forecast model?
Go into "describe forecast" and read the "quality" metric
Suppose that your data has a dimension called "Product Category," which has the values "Furniture," "Office Supplies," and "Technology." Which of the following should you use to combine Furniture and Office Supplies into a single category? Hierarchy Group Filter
Group
What is wrong with this If Statement If [Sales] > 100 and "Delivery Truck" then 0 else [Shipping Cost] End Nothing. The syntax is correct. Instead of "Delivery Truck" it should be [Shipping Mode] = "Delivery Truck" Instead of "Delivery Truck" it should be [Delivery Truck]
Instead of "Delivery Truck" it should be [Shipping Mode] = "Delivery Truck"
What does the blue check mark mean in the data source? What about the orange link sign?
It means (the first item that is used) becomes the primary data source. It means that the column has been blended with another
how to use calculations in join clauses
Join the data, then for the data source, select create join calculation.
Build a heat map
Main way: Two dimensions for cols and rows. - Then place a measure in color and create a gamut
Which of the following is equivalent to the 50th percentile? Average Median Mean Interquartile Range
Median The median of a set of numbers is that number where half the numbers are lower and the other half are higher. This is the same as the median.
Which of the following is used to assess trendline significance:
P value
The row and column shelves contain these: Grand Totals Pills Filters
Pills
Which of the following can combine multiple queries? Parallel Query Query Fusion External Query Caching Data Engine Vectorization Parallel Aggregation
Query Fusion "Query Fusion recognizes that the two queries have the same level of detail and simply draws the aggregation of one into the other.
When to build sets?
THey are useful when you want to combine sections (creating an in and out section)
Which of the following cannot connect to a SQL database and cannot be used with data that needs to remain private? Tableau Desktop Tableau Student Edition Tableau Public None of the Above
Tableau Public
You want to email a packaged workbook containing a Tableau Dashboard to a coworker who does not have a license for Tableau Desktop. Which application will allow her to view the dashboard you send via email?
Tableau Reader
Which of the following describes parallel aggregation? The data engine can now run aggregations in parallel, splitting the work across multiple cores. Allows multiple queries to run in parallel Allows query caching so that when you open a workbook that has already been opened before, the load time will be almost instant
The data engine can now run aggregations in parallel, splitting the work across multiple cores.
Which button would you click to make the pie chart larger? The arrow pointing left The three bars with the arrow pointing down The drop down with the word "standard" The three connected arrows
The drop down with the word "standard"
The calculation [Ship Date] - [Order Date] will return: An error. You cannot do subtraction on date fields. The number of months between the order date and the ship date. The number of days between the order date and the ship date.
The number of days between the order date and the ship date.
When do you use the "contains()" function?
To test if the string contains the substring. CONTAINS("Calculation", "alcu") = true
True or False A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.
True
True or False Bullet graphs combine bar charts and reference lines
True
True or False LEFT JOIN returns all rows from the left table, with the matching rows in the right table.
True
True or False The benefits of creating a Tableau data extract include improving performance and allowing offline access to the data.
True
True or False The median is the number separating the lower half of the data from the higher half. It is the same as the 50th percentile or the 2nd quartile.
True
Adding an Image to a Map should be in regards to some dataset and coordinates should be mapped to x and y axis values in the dataset. A. True B. False
True. Background images can be used on maps but coordinates on the maps should be mapped with values of x and y axis in the dataset.
Can you make "whiskers" around a prediction?
Yes, if you select "Shape, square, circle, bar, or pie" under your forecast mark type.
What is one reason why my box plots are not completing?
You are not disaggregating the box plots
Unlike trend analysis, what components do you need to create a "forecast"?
You need a time dimension, and an aggregated measure. Trend on the other hand do not need aggregation
When to use the ZN function??
ZN tests to see if a function is null, and if it is, it will return a value of zero.
What are the benefits of tableau viewer?
a role-based license option on Tableau Server which allows casual users to access and interact with trusted content created by Creators and Explorers, without putting the security of your data at risk. You benefit from the security and trust that comes with a governed server-based deployment and specifically can: 1. Access and interact with embedded, web-based and mobile content 2. Download underlying summary data for a visualization 3. Favorite content 4. Download visualizations as image files (PNG, PDF) 5. Comment on a visualization or dashboard 6. Create and receive subscriptions 7. Receive data-driven alerts
How to aggregate cities together in a map?
create a calculated field that creates categories
What action would be used to round dates to the nearest quarter
datetrunc()
what is a context filter??
filter that makes all filters dependent on this filter. Regular filter filters through all rows independent of the prior rows. This is not the case here.
how do you create a dynamic set vs a fixed set?
fixed: select the items in a filter then save as well dynamic: select filter based on top items, range, or formula and then save as set
Explain: data engine vectorization
improves the speed of queries (10x faster in Tableau 9.0)
What is a level of context calculation?
it allows one to have values fixed, - it is generally surrounded by curly brackets
what is a shadow extract
it is a temporary file of the items used for analysis - placed in temporary extracts - data type is hyperfile
what is a metadata grid?
it is the display (not gui based)
What type of clustering is used?
k-means
What operation is data blending most similiar to?
left join operation
where is the data pane?
located on the left part of the screen (measures, dimensions, sets, and parameters)
Explain: query fusion:
looks at all your queries and tries to find ways to simplify them
how to visualize confidence intervals of a projection together?
make a projection Then add the measure again select upper or lower confidence and then add
Explain: parallel queries
performing multiple queries at the same time
What are trend lines?
regression analysis
how to emulate an inner join using blending?
remove nulls after the blend
ZN()
returns 0 if null, the value if it is not.
What are very popular string functions?
right, ,left, contains, isnull()
Explain: external query caching
stores the results of queries to help with speed
what are the main components of a gantt bar chart?
two dimensions, and one of the dimensions use for color, and the measure used for size -make sure to select the "Gantt Bar" option.
how can you test if a parameter or an item is in a group or field?
use contains() and then form your condition or statement
How would you convert a string to a date?
use dateparse()
how to connect to spatial files?
you can connect to the following spatial file types: Shapefiles, MapInfo tables, KML (Keyhole Markup Language) files, GeoJSON files, TopoJSON files, and Esri File Geodatabases. You can then create point, line, or polygon maps using the data in those files. In current versions of Tableau, you can only connect to point geometries, linear geometries, or polygons. You cannot connect to mixed geometry types.
what would be an absolute best trend line?
A trend line where... at any point on the x axis, the trend is the same as the actual values
What is R-squared
Coefficient of determination. How much of the response variable variation that is explained by the model explained variation/total variation
A good reason to use a bullet graph. Analyzing the trend for a time period Comparing the actual against the target sales Adding data to bins and calculating count measure Displaying the sales growth for a particular year
Comparing the actual against the target sales
Difference between discrete and continuous?
Continuous is the default for aggregations, and will cause tableau to draw an axis to plot marks on. Discrete will list each discrete value resulting from your calculation.
What is the difference between dateadd() and makedate()?
Dateadd() adds an increment to the specified date and returns the new date. Makedate() returns a date constructed from a year, a month, and a day of the month.
Disaggregation returns all records in the underlying data source. True False
Disaggregation returns all records in the underlying data sources.
What is the difference between Fixed, include, and exclude LOD
FIXED level of detail expressions can result in measures or dimensions, depending on the underlying field in the aggregate expression. So MIN([Date])} will be a dimension because [Date] is a dimension, and {fixed Store : SUM([Sales])} will be a measure because [Sales] is a measure. When a FIXED level of detail expression is saved as a measure you have the option of moving it to dimensions. INCLUDE and EXCLUDE level of detail expressions are always measures.
T or F A Reference Distribution plot cannot be along a continuous axis.
False, A Reference Distribution plot can be along a continuous axis.
A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story. True False
False, A sheet can be used within a story directly.
Sets can be created on Measures. True False
False, Sets can be created on Dimensions.
The highlight action in a dashboard is similar to filtering action in a worksheet. TRUE FALSE
False, The highlighting action in dashboard will highlight the selection and related data in other view in a dashboard. It won't filter the selection.
For creating variable size bins we use _____________. Sets Groups Calculated fields Table Calculations
For creating variable size bins we use Calculated Fields.
If a context only shorters the size of the data set by 1/10, should you use it? What if your data is heavily indexed?
Generally, no... Don't use it for that either!
What model does Tableau use for forecasting?
Holt winters exponential smoothing
How are parameters used in Tableau?
If you need to have something for your visualization that is not exactly in your data, a parameter will allow you to provide a value to pass into Tableau. Parameters allow you to come up with scenarios or options that are not available in your data and create these values to put into your visualization. After creation, end users can control the input to see the results of the parameters effect.
2 reasons why use a context filter? How to remove it?
It can increase performance; from 9.0 does not create temp tables Creates a dependent numerical or top N filter − You can set a context filter to include only the data of interest, and then set a numerical or a top N filter. 1.) remove from the shelf 2.) edit the filter 3.) select remove from context
when you subtract two dates, what happens in tableau?
It gives you the number of days in between.
Explain a Pareto chart.
It is a way to view a measure (like profit) diminishing size overtime and then
How to get date difference?
Just subtract (but make sure they are of type date!)
The default join type in case of Blended data sources is? Cross Join Inner Join Left outer Join Full outer Join
Left outer Join is the default join type in case of Blended data sources. The primary dataset is considered to be the left table.
What are the benefits to tableau server?
License price cheaper Can publish dashboards from tableau desktop to there Helps users publish and share their data sources as an extractor live connection. Can create and maintain multiple sites. A web browser-based tools Is missing the ability to create and modify dashboard actions.
Can aliases, hierarchies be edited in tableau server online?
NO!!!
Is there only one way to perform an if statement?
No there are three types of IF statements. If sales > 100 then 1 else 0 end If sales > 100 then 1 elseif sales >0 and <100 then 2 elseif sales = 0 then 3 else 4 end IIF function IIF(test, then, else [unknown])
Can one make extracts of cubes?
No, it is not allowed
Can data blending be shared between worksheets?
No, it is worksheet specific
The best trend model for your view would be the one with? R-Squared value closest to 1 P-Value more than 1 R-Squared value greater than 1 R-Squared value equal to P-Value
R-Squared value closest to 1 is the best trend model for a view.
The aggregation function attr() returns a * when __________________. There is a single value for all rows in the group. It is a null value. There are more than one value in all rows in the group. The data is not present at the desired level.
The aggregation function attr() returns a * sign when there is more than one value in all the rows in the group.
If p-value is 0.07, what does that mean?
The analysis is "likely" not extremely significant
The icon associated with the field that has been grouped is a ______________. Paper Clip Set Hash Equal To
The icon associated with the field that has been grouped is a paper clip.
Create a pareto chart
The most complicated graph to make: 1.) discrete item in column 2.) Add two measures 3.) Create dual axis 4.) right click on one measure and create quick cal 5.) make a running of total sum 6.) create a secondary axis with percentage of total
In data blending, what does an "*" mean?
There are multiple values per line, you can either defined the primary in the data blend, or do a join
How do you combine dual axis charts?
To add a measure as a dual axis, drag the field to the right side of the view and drop it when you see a black dashed line appear. You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis.
T or F The term "addressing" refers to the direction of a calculation.
True
Bins cannot be created on dimensions. TRUE FALSE
True, Bins can only be created on measures.
Groups can be used in a calculated field. TRUE FALSE
True, From Tableau 10.x onwards, Groups can also be used in a calculated field.
The Highlighting action can be disabled for the entire workbook. True False
True, From the toolbar the Highlighting action can be disabled for the entire workbook.
It is possible to change the geographic roles of a dimension. True False
True, It is possible to change the geographic role of a dimension.
Trend Lines can only be used with numeric or date fields. True False
True, both axes must contain a field that can be interpreted as a number.
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser? True, with the use of Tableau Server True, with the use of a Web Page object False, not possible True, requires a plug-in
True, with the use of a Web Page object it is possible to deploy a URL action on a dashboard object to open a web page within a dashboard rather than opening the system's web browser.
Create A tree map
Two ways: 1.) Select a measure and a dimension, and then select tree map OR 2.) place a measure under size then add a dimension under text (add some coloring if you can)
Build a histogram
Two ways: 1.) click a measure and then select histogram OR 2.) right click, create bin size place in columns, then make a count of the measure
Create a Bullet Graph
Two ways: 1.) select two measures (not number of records) and select bullet chart OR 2.) Sum(measure) in detail and sum(measure) in rows or columns. Then add some details
Why does Tableau by default ignore the prior month in a forecast?
Typically the latest month is not over, so therefore it may need to bias in the model.
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)? No Yes
Yes, measures can be used multiple times in the same view.
How to reference lines differ from constant lines?
You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line. Constant places a line at the specified value on the axis.
What are the different ways to create a hierarchy?
You can: 1.) select the items and right click 2.) or you can click and drag one on top of another
How do you sort sub categories?
You created a "combined field", stick it inbetween the two fields, and sort by the combined field
How do you identify a continuous field in Tableau? It is identified by a blue pill in the visualization. It is identified by a green pill in a visualization. It is preceded by a # symbol in the data window. When added to the visualization, it produces distinct values.
b) It is identified by a green pill in a visualization
What is a cross tab
chart showing different combinations of dimensions using measures (kinda like a tree map but focused on text instead of color)
What do you do if a questions says "sales will increase by ** percent, what will it be next year?"
created a calculated field that multiplies the measure by 1 + percentage then filter the areas (especially for the specific year) This only works for consecutive years DO NOT DO A FORECAST!!!
How does one zoom into a graph in Tableau?
hold ctrl+shift then clikc
What does the pdf connector pull data into?
tables!!!! Don't overthink it!
