Download Tableau Desktop Specialist Certification and more Exams Advanced Education in PDF only on Docsity!
Tableau Desktop Specialist Certification
Automatic folder created by Tableau in the Documents folder. - correct answer My Tableau Repository Each column in a dataset has... - correct answer a Role and a Type Role - correct answer Either a dimension (qualitative) or a measure (numeric). Each column in a dataset has a Role. Type - correct answer Data type (number (decimal), number (whole), date & time, date, string, boolean, geographic). Each column in a dataset has a Type. Continuous - correct answer - Green
- Creates Axes
- Usually Measures Discrete - correct answer - Blue
- Creates Headers
- Usually Dimensions Auto-generated Fields - correct answer - Measure Names
- Measure Values
- Latitude
- Longitude
- Number of Records Connections - correct answer - Live (default)
- Extract (saved subset)
Live Connection - correct answer default Extract Connection - correct answer - Saved subset
- Can use filters/et.c to get a subset of a large dataset
- Resides in Tableau
- Creats a .hyper file Advantages:
- Supports large data sets
- Help improve performance
- Support additional functionality (ex. allows you to compute Count Distinct)
- Provide offline access to data
- Full refresh or incremental refresh (only rows that are new since previous refresh) .tds - correct answer - Data Source
- Info necessary to connect to the data, but no visualizations
- Data source type
- Connection information
- Groups, sets, calculated fields, and bins
- Default file properties (formats, aggregation, and sort order) Use Data Source (.tds) if everyone who will use the data source has access to the underlying file or database .tdsx - correct answer - Packaged Data Source
- Contains all info in the data source (.tds) file, as well as a copy of any local file- based data or extracts
- A single zipped file
When a value in left doesn't have corresponding match from right, you will have null values Right Join - correct answer Contains all values from the right table and coresponding matches from the left table When a value in right doesn't have corresponding matches from left, you will have null values Unions - correct answer - Combine two or more tables by appending values (rows) from one table to another
- Increases number of rows
- When field names in the Union do not match, then both field names are present in the Union, but contain several null values Wildcard Search - correct answer Set up criteria to automatically include tables in a Union Blends - correct answer - Combines data from multiple sources
- Brings in additional info from a secondary data source and displays it with data from the primary data source directly in the view
- An asterik (*) in a view with blended data indicates multiple values
- Never truly combines data
- Results are aggregated to the appropriate level, and the results are presented visually together in the view
- Aggregates, and then combines data
- Always LEFT join Relationships - correct answer - Define how tables relate to one another.
- Relationships dynamically adjust the SQL join type applied between tables based on the fields used in your visualization.
- Default method for combining tables
- Can be used across tables with different levels of detail
- Flexible and adaptable
- Cannot be formed between tables from data sources published to Tableau Server/Online
- Cannot be formed based on calculated fields Primary Data Source - correct answer Blue Secondary Data Source - correct answer Orange Field Name - correct answer Name of field in Tableau Remote Field Name - correct answer Name of field in original data source Alias - correct answer Can only be created for dimensions - not measures Bar Chart - correct answer - 0+ Dimensions; 1+ Measures
- Compare data across categories
- Place a dimension on the Rows shelf and a measure on the Columns shelf, or vice versa Date Parts and Values - correct answer Date Part = Discrete (Sales in Q3, irrespective of year) Date Value = Continuous (Sales in Q3 2015) Line Charts - correct answer - Connect individual data points in a view
- Provides a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values Scatter Plots - correct answer - 0+ Dimensions; 2-4 Measures
- Visualize relationships between numerical variables
Table Calculations - correct answer - Running total
- Percent difference
- Difference
- Percent of total
- Rank
- Percentile What chart type uses binned data? - correct answer Histogram By default, measures placed in a view are aggregated. What type of aggregation is applied? - correct answer It depends on the context of the view What is stored in a .tds file? - correct answer - Data connection information
- Calculated fields
- Metadata edits What is the default path for all supporting files, data sources, icons, logs, etc.? - correct answer Documents > My Tableau Respository When you drop a continuous field on Color, Tableau displays a quantitative legeld with a ____ range of colors - correct answer Continuous _____ enables us to create workbooks/views/dashboards/data sources in Tableau Desktop, and then publish this content to our own server - correct answer Tableau Server Benefits of using Data Extracts - correct answer - Improved performance
- Faster to work with
- Ability to use data offline
Is it possible to add a field to more than one hierarchy? - correct answer Yes In order to avoid any confusions, what should you do after creating a dual-axis chart? - correct answer Synchronize the axes We can join a maximum of ______ tables in Tableau - correct answer 32 For Bullet Graphs, we need at least __ measures - correct answer 2 Dimensions containing ____ and ____ cannot be continuous - correct answer String; Boolean By default, what does Tableau do when you connect to a data source? - correct answer Creates a live connection What is the least number of fields possible for a Bullet Graph? - correct answer 2 Measures Data Granularity - correct answer Referes to level of detail for a piece of data What are compelling reasons to use a Stacked Bar Chart? - correct answer - Visualize parts of a whole
- Visualize complex info with fewer bars/marks By definition, Tableau displays Measures over time as ____ - correct answer A Line You add SUM(Profit) to the Columns shelf. What will it create? - correct answer A horizontal axis What are valid objects when creating a dashboard? - correct answer - Web page
- Extension
- Image
Which URL prefixes are permitted when creating a URL Action? - correct answer - HTTP
- HTTPS
- FTP Where can you add new shapes? - correct answer My Documents > My Tableau Repository > Shapes The number of marks will (increase/decrease) when you increase the number of Dimensions in a view? - correct answer Increase 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 yoru workbook for sharing with others who don't have access to the original data. - correct answer .twbx file What is the difference between normal calculated fields, and the calculated fields created after Data Blending? - correct answer Fields used in Blends must first be aggregated Area Charts - correct answer Typically used to prepresent accumulated totals over time and are the conventional way to display stacked lines In Tree maps, the size begins with the largest rectangle on the ________ and the smallest rectangle on the ________ - correct answer Top left; Bottom right What device options are available in the Device Preview section? - correct answer - Default
- Phone
- Tablet
- Desktop .tde file - correct answer Local copy of a subset or entire data set that you can use to share data with others, when you need to work offline or improve performance
Data Blending - correct answer Useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins How to create Sets - correct answer In the Data pane, right-click a dimension and select Create > Set Sets - correct answer - There are two types of sets: dynamic sets and fixed sets.
- The members of a dynamic set change when the underlying data changes.
- Dynamic sets can only be based on a single dimension. Order of Operations - correct answer 1) Extract Filters
- Data Source Filters
- Context Filters (Sets, conditional filters, top N, Fixed LOD)
- Dimension Filters (Include/Exclude LOD, data blending)
- Measure Filters (Forecasts, table calculations, clusters, totals) Table Calc. Filters (trend lines, reference lines) Parameter - correct answer A global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line. Ex. A calculated filed that returns True if Sales is greater that $500,000, and otherwise returns false You just created a histogram and want to be able to change the size of the bins dynamically. How can you satisfy this requirement? - correct answer Parameters When exporting a worksheet as an image, which formats are available? - correct answer - JPEG
- Windows Bitmap (.bmp)
- PNG
- Click on the Show Mark Lables icon in the Toolbar A method of appending values (rows to tables). You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data. - correct answer Union-ing How can you format numbers as currency? - correct answer Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop down menu. What is the default number of rows that are possible to view in the View Data window? - correct answer 10, Data blending simulates a traditional _____ join - correct answer Left What are valid ways of grouping data? - correct answer - Using the Labels in the View
- From the Dimensions shelf
- Using Marks in the view Aliases - correct answer Create for members in a dimension so that their labels appear differently in the view How can you change the Default Aggregation for a measure? - correct answer Right click the measure > Default properties > Aggregation What is the default duration for animations? - correct answer .3s ____ will only create a header. ____ will create header and axis both. - correct answer Dimesions; Measures Which chart does the Size option on the Marks Card not work? - correct answer Tree map
.hyper - correct answer - When you create a new extract, it uses the .hyper format instead of the .tde format.
- Creates larger extractracts
- Creates and refreshes extracts faster
- Experience better performance when interacting with views that use extract data sources How can you add color to Marks in the view? - correct answer From the Data pane, drag a field to Color on the Marks Chard What happens when field names in the Union do not match? - correct answer Both field names are present in the Union, but contains several null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. What are valid ways to make the font more readable? - correct answer - Make the font color sharper/darker than the background
- Use a clear and readable font
- Increase the font size If you have a dashboard and are displaying its filter, how can you rearrange it? - correct answer By clicking on the 2 lines on top and dragging the filter Suppose you have a bar chart. When we group labels in a view, which of the following happens? - correct answer A new mark (bar) is created, which consolidates all members of the group Padding - correct answer Padding lets you precisely space items on dashboard, while borders and background colors let you visually highlight them. Inner padding sets spacing between item contents and the perimeter of the border and background color; outer padding provides additional spacing beyond the border and background color.
Reference Lines - correct answer You can add reference lines, bands distributions, or box plots to any continuous axis in the view. You can add a reference line at a constant or computed value on the axis. What are valid Dashboard size options? - correct answer - Fixed Size
- Automatic
- Range Diverging Palette - correct answer When there are both negative and positive values for a field, the default range of values will use two color ranges Which calculations do not need a quick table calculation? - correct answer - Variance
- Standard Devation They are available by default When is an axis created for the visualization? - correct answer When we drag a continuous field to the row/column shelf Which are valid reasons to use Tableau Data Extract (.tde) over Live Connections? - correct answer - Help improve performance
- Fast to create
- Support additional functionality like Count Distinct Layout Containers - correct answer Lets you group related dashbaord items together so you can quickly position them The most important items on a dashboard should be positioned where? - correct answer Upper Left Which of the following is the best reason to use an extract instead of a live connection? - correct answer You need to apply aggregation that takes too long when using a live connection
You created a group by selecting field labels in a view. How can you remove members from the group? - correct answer In the Data pane, right click the group and select edit Group Which of the following can you use to create a calculated field that returns data independent of the data granularity in a view? - correct answer A FIXED LOD calculation Interactive elements that you can add to a dashboard for users include: - correct answer URL actions and filter actions A field that shows average home values for the US in 2016 is most likely a? - correct answer An aggregated measure As of Tableau 2018.3, Tableau is only available on a Windows Operating System? - correct answer False Which of the following is NOT a Tableau Desktop Application? - correct answer Tableau Express. Which of the following file types contains a Tableau Workbook along with local data?
- correct answer .twbx Which of the following is not a Tableau file type? - correct answer .tdx What is .tds? - correct answer Shortcuts for quickly connecting to the original data. A Tableau Workbook can contain multiple sources from different source systems? - correct answer True In Tableau, Data Blending is where you? - correct answer Merge data from two or more sources within a Tableau Worksheet
In a calculated field, this will be interpreted as a comment: - correct answer Anything after // will be treated as a comment Can you extend the functionality of Tableau through Third-Party companies? - correct answer True What can be used to combine the rows from one table with the rows from a second table? - correct answer Union Which join will always include all rows from both tables? - correct answer Full Outer A blend is most similar to which type of join? - correct answer Left Join What is the best reason to create a saved data source as a .TDS file? - correct answer You want to save the default field properties such as number formats and sort order When creating a union between tables, what will happen if the field names do not match? - correct answer Fields in the union that do not have matching field names will contain null values After setting up two data source connections, how can you create a blend? - correct answer Add at least one field from the primary data source to your view. Then, in the Data pane, click the data source that you want to designate as the secondary source and click the broken link icon Which of the following uses a primary and secondary data source? - correct answer Blending Which chart type will best visualize the relationship between two continuous measures? - correct answer Scatter plot
You would like a view that displays a filter allowing you to select the state, and use a Set to display the top 5 products with the greatest total sales within the selected state. What type of filter should you use to filter on the state? - correct answer Context Filter Bins can be created for which type of field? - correct answer Continuous measure You have a dashboard and you want to add a feature so that selecting an element on one of the worksheets on the dashboard causes a change on another worksheet in the same dashboard. What features will do this? (select all that apply) - correct answer Filter Action.Highlight Action What steps should you take to add a phone view to a dashboard? - correct answer Select Device Preview, then select Phone for Device Type, then click the button labeled "Add Phone Layout" You start with a blank worksheet and add a continuous field to the row shelf. How will this new field change your view? - correct answer It will add a vertical axis You have a scatter plot showing sales on the x-axis and profit on the y-axis, with each dot representing a different product subcategory. You want to show how the points on the scatter plot vary based on Net Profit, a third continuous variable. Which would be most appropriate? (Select all that apply) - correct answer Size and Color If you have bar chart with a single bar, but you want to subdivide that bar into multiple categories, what should you add to your view? - correct answer A dimension Which of the following fields will have AGG in front of it when you add it to the view?
- correct answer A calculated field with the formula SUM([Profit]) A histogram shows the distribution of ________ data by creating bins that are _________. - correct answer continuous, discrete
