Tableau Cert

Which of the following describes the Measure Names field?

-Measure name is a system generated field that contains the names of all the measures in your tableau workbook, including the system generated measures such as latitude and longitude -When you add Measure Names to the view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures

Approximately what percent of runs were scored by catchers?

10%

If you have a bar chart with a single Bar, but you want to subdivide that bar into multiple categories, what should you add to your view?

A Dimension

which of the following can you use to create a calculated field that returns data independent of the data granularity in a view?

A FIXED LOD calculation

Which of the following fields will have AGG in front of it when you add it to the view?

A calculated field with the formula SUM(Profit)

which of the following is true?

A dashboard CANNOT include a story, but a story CAN include a dashboard

You add two fields to your Tableau view "profit" and "average profit". When you add profit to the view, you see a pill with the label SUM(Profit). but when you add average profit to the view, you see a pill labeled AGG(Average Profit). Why does one field have SUM and the other AGG?

AGG indicated the average profit already includes some type of aggregation.

After setting up two data source connections, how can you create a blend?

Add at least 1 filed 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 data source and click the broken link icon.

Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides?

Alias -alaising is the alternative name that you can assign to a value in a dimension field

A field that shows average home values for the United States in 2016 is most likely:

An Aggregated Measure

Which of the following mark types cannot be adjusted using the size slider?

Area

Which of the following uses a primary and a secondary data source?

Blending

the data interpreter helps prepare _____ data for analysis

CSV and Excel

Which of the following will create a dashboard actions?

Click "more options" arrow on the worksheet included in the dashboard layout, then select "use as a filter"

You would like to create 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.

Context Filter -you need a filter that will execute BEFORE the set

Bins can be created for which of type of field?

Continuous Measures -bins can be created on a continuous measure or numeric dimension

which of the following functions can be used on string to create measures?

CountD

Which function will help you to find the number of customers in your data?

CountD(CustomerID)

Which of the following field types will create a color palette?

Discrete

Which field types are more common?

Discrete Dimension, Continuous Measure

Which fields are used in this view?

Discrete for the Date, continuous measure for % of delayed flights -date is discrete otherwise line wouldn't be segmented -% of delay is used on axis making it continuous

Gantt charts are useful for:

Displaying duration of events or activities over time

Using the southern region sheet, which state bordering Mississippi had the highest sales?

Drag state to view text > SUM(Sales) Tennessee

You want to create a line chart showing the daily open and close values for a stock. The y-axis shows the opening stock price and the x-axis shows the date. What steps should you take?

Drag the field "Closing" to the row shelf, then select the dual axis chart on the worksheet menu.

If fiscal year start is set to may, the year for the date April 1, 2004 would be shown as FY2005.

FALSE

Tableau automatically generates latitude and longitude for cities, but does not do so for larger areas such as countries or zip codes.

FALSE

when you sort data in hierarchy, tableau rearranges header that appear before the sorted field.

FALSE

Bins act as containers that summarize data for a specific range of values. Without using a calculated field, Tableau's bin features allow you to create variable sized bins

FALSE -If you want to create variable sized bins, you'll need to create a calculated field with IF THEN ELSE stmts.

When creating a union between tables, what will happen if the field names do not match?

Fields in the union that do not have matching field names will contain null values

You have a dashboard, 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?

Filter Action and Highlight Action

Interactive elements that you can add to a dashboard for users to use include:

Filter actions and URL actions

In the southern region superstore data, the product category, product subcategory, and product name might be combined using which of the following?

Hierarchy -hierarchies allow you to combine similar fields while groups and set combine values within a field -parameters allow the user to change a value, which can then be used in calculations, filters, and reference lines.

Which type of plots are most ofter used to visualize the distribution of continuous data?

Histogram, Box Plot

You created a group by selecting field labels in a view. How can you remove members from the group?

In the data pane, right-click the group and select Edit group

You start with a blank worksheet and add a continuous field to the row shelf. How will this new field change your view?

It will add a vertical axis

This type of Join will include all values from the left table:

Left

Which team has the biggest decrease in games won from 2013 to 2014?

Lions

Which of the following should be used if you are publishing a workbook to Tableau Server and for security purposes you'd like users to enter their database credentials in order to access the workbook?

Live connection

You have SUM(minutes of delay) in your view, If aggregate measure is unchecked, what will view show instead of SUM(Minutes of Delay)?

Minutes of Delay disaggregating will show the underlying values, The aggregation will be removed, so we will just see "Minutes Of Delay"

The games data include information on games played in 2015, including shoeing the team that won each game. Which team had the biggest increase in winning games between 2014 and 2015?

Ninjas

You would like the person using your dashboard to select the year, and based on the year to adjust the interest rate in some related calculated fields. You want the year selection to limit the data in the view. What Tableau element should you let the user select the interest rate?

Parameter -a parameter will allow the user to set a value which you can then use in a calculated field. You can also use a parameter in a calculation, then use that in a filter to limit the data in the view.

Which type of visualization is NOT typically effective in showing change over time?

Scatter Plot -some of the best visualizations for showing values over time are line charts, area charts, and bar charts.

Which chart type is the best to visualize the relationship between two continuous measures?

Scatter Plot -scatter plot to visualize relationships between numerical variables -bar charts to compare data across categories -line charts compare numeric data over time -stacked bar charts compare numeric data over two dimensions.

What steps should you take to add a phone view to a dashboard?

Select Device Preview, then select Phone for Device Type, click the button labeled "Add Phone Layout"

Which of the following action types can be used to create proportional brushing?

Set action

Your data has a column which should be treated as a date, but when you change the data type to dat, you see a lot of null values or obviously incorrect dates like 12/30/1900. what can you do next since the date conversion didn't work?

Set the date type back to string, then try date conversion functions like DatParse and Date

The vizualization shows ship date and order date. are the dates discrete or continuous?

Ship date is discrete. order date is continuous -blue pills indicate discrete/headers -green pills indicate continuous/axis

You have a scatter plot showing sales on the x-axis and profit on the y-axis, with each dot representing a different 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?

Size and Color

Which type of filter usually works best with date fields?

Slider filters

which of the following is NOT a default property which can be set for a measure?

Sort -sort is a default property for dimensions NOT measures

An aggregated calculation can be multiplied by a non-aggregated constant

TRUE

Context filters are executed AFTER data source filters

TRUE

The AVG function does not treat null values as zeros. Rather, the AVG function ignores null values.

TRUE

The expression {AVG([Profit])} will find the average value of profit for the entire table

TRUE

You can combine multiple worksheets in a single dashboard

TRUE

A relative date filter works relative to:

The anchor Date -If you keep the default option, "Anchor relative to Today" then the relative date will work relative to the date when the work book is viewed but this can be changed to any date.

You connect Tableau to an Excel File with includes a column that has mostly numeric data, but has a few date and text values mixed in. Tableau set the data type for this field as Number. What happens to the date and text values when the data is imported to Tableau?

The date values are set to the number of days since 1/1/1900 and the text value is set to null

which of the following is a table calculation?

Total

What type of Dashboard Actions allow Tableau to open a page on an external website?

URL

New England consists of the following states: Connecticut, Maine, Massachusetts, New Hampshire, Rhode Island, and Vermont. Which year saw the greatest increase in adults on probation (for New England)

USE DATA INTERPRETER Highlight all columns except the first one, right-click, select PIVOT columns > SUM(number of people on Probation) *table calc-%diff rows > Year filter > State: Connecticut, Maine, Massachusetts, New Hampshire, Rhode Island, Vermont 2002 saw the highest level of people on probation

the most important items on a dashboard should be positioned where?

Upper Left

Which of the following is the best reason to use a Tableau data extract instead of a live connection

You need to apply an aggregation that takes too long when using a live connection

Which of the following is the best reason to create a saved data source as a .TDS file?

You want to save the default field properties such as number formats and sort order. TDS files save the data source metadata, such as the connection info, default field formatting, and sort order. They DO NOT save the data source itself.

which of the following will result in an error?

an aggregation on a field that is already aggregated

If you see duplicate data after doing a join, you can do the following...

change the join condition use data blending instead of a join

Using the flights table, create a bar chart showing the average minutes of delay per flight broken down by airport, and filtered by date to show only the last 3 months of 2013. Which airport had the lowest average minutes of delay per flight between October and December?

columns > AVG(Minutes Of Delay Per Flight) rows > Airport Name filters > MDY(Date) Field Sort > AVG(Minutes Of Delay Per Flight) Baltimore/Washignton International

Using the flights table, create a bar chart showing the average of minutes of delay per flight broken down by carrier name and filtered by state to only show Minnesota (MN). What was the average minutes of delay per flight for UNITED in MN?

columns > Carrier Name rows > AVG(Minutes of Delay Per Flight) filters > State: MN 62.98

Using the stock 2014 table, create a dual axis chart showing the daily open and close values. Use a filter to limit the filter to Oct 2014 and a filter to limit the data to Biogen Idec. On which date was there the greatest difference between Open and Close?

columns > DAY(Date) rows > SUM(close), SUM(open) filters > MY(Date) :Oct 2014, Company: Biogen Make dual axis, synchronize axis October 13th

Using the flights data, determine the average minutes of delay per flight by the month (using DATE). Using a table calculation, find the percentage difference in average minute of delay per flight between June 2013 and May 2013.

columns > MONTH(Date) filters > MY(Date) text > AVG(minutes of delay per flight) quick table calc > % difference 14.11%

Create a line graph showing away team runs for the lions by month. Add a linear trend line. What is the R-squared value?

columns > MONTH(Date) rows > Sum(Runs for away) filters > away team: lions r-squared = 0.6846

Using the flights data, create a line chart showing the average minutes of delay per flight by month. create a filter for carrier name of US Airways. Which month saw the biggest decrease in average minutes of delay per flight compared with the previous months?

columns > MONTH(Date) *continuous rows > AVG(Minutes of delay per flight) filters > Carrier Name: US Airways March 2013

Using the stock 2010 - 2013 table, create a chart to see the monthly change in volumes of stocks, from the beginning of 2010 to the end of 2013. Which two consecutive months saw the least fluctuations in increase or decrease?

columns > MONTHS(Date) rows > SUM(Volume) show me > lines(continuous) March 2012 - April 2012 saw the least fluctuations

For the Ninjas, How many runs were scored by the position with the lowest average batting average?

columns > Measure Names rows > Baseball Team, Positions filters > Baseball Teams: Ninjas; Measure Names text > Measure Values: AVG(Batting Average), SUM(Runs) 54

Blend the southern region table from the South_Superstore file with the Subcategory Profit Targets file. Add Subcategory, AVG(Profit) and Profit Target to the view. For which of the following subcategories was average profit higher than the target?

columns > Measure Names rows > Subcategory filters > Subcategory: appliances, art, binders, bookcases ; measure names text > Measure Values, AVG(Profit), AVG(profit target) Appliances

Create a bar chart showing runs by player name. Add a reference distribution showing standard deviations. What is 1 standard deviation below the mean?

columns > Name rows > SUM(Runs) reference line > Distribution > Value:STD DEV 1.94

Using the flights table, create a crosstab showing the sum of Flights broken out by ontime category and airport. then add grand totals to the view. What were the number of flights for Dallas/Fort Worth and the number of flight for Dallas/Fort Worth Delayed by Security?

columns > OnTime Category rows > Airport name text > Number of flights Analytics > totals > Row Grand Totals 262,667 and 53

Using the stock 2010 - 2013 table, create a crosstab showing the sum of volume per company per year, then add grand totals to the view. What was the total volume for Apple in 2013 and the total volume of Apple for 2010-2013?

columns > YEAR(Date) rows > Company text > SUM(Volume) Use analysis menu to add a grand total for rows 25,606,397,999 ; 127,322,019,216

Union the stocks 2010 - 2013 and stocks 2014 tables, and then create a chart showing average Open by year and for each company from 2010 to 2014. In which year was the Average Open for Biogen Idec closest to Amazon's average open?

columns > YEAR(Date), AVG(Open) rows > company 2014

Union the stock 2010-2013 and stock 2014 tables, create a chart showing the average close price by year and quarter for each company from 2010 to 2014. For how many quarters was Amazon's average closing price over $300?

columns > YEAR(Date), QUARTER(Date) rows > AVG(Close) filters > Company: Amazon Show Me > Stacked Bars 5 are above $300

Using the stocks 2010 - 2013 table, create a chart that shows the percentage difference in volume for each company by year and quarter. For how many quarters did Biogen Idec show a positive percent difference in volume?

columns > YEAR(Date), QUARTER(Date) rows > Company , SUM(Volume) Show Me > Stacked Bars Quick Table Calculation > percentage difference click label on marks card, show mark labels. 6 total positive % differences

Inner Join Southern_region with returns using OrderID. This will limit the data to only those orders which were returned by the customer. Create a chart that shows sales by year of order date. In which year was the sales value of the returned items the lowest?

columns > YEARS(Order Date) rows > SUM(Sales) 2013

Create a union of World literacy rate 1976 to 1991 and world literacy rate 1992 to 2016. What is the difference between the 1976 rate and the 2016 rate?

columns > Year(date) filters > Year(date) text > Sum(world literacy rate %) table calc- difference 17.36%

Create a histogram showing batting averages using a bin size of 0.05. Find the average number of runs scored for players with a batting average between 0.55 and 0.6

columns > batting average(bin) rows > sum(number of records) text > AVG(runs) 13.53

For films where Disney was NOT the lead studio, what was the difference in profitability from 2010 to 2011?

columns > measure names rows > year filters > Lead Studio: exclude Disney text > SUM(Profitability) *table calc-%difference; SUM(Profitability) 7.2%

Find the moving average for the total number of runs in three months prior to May 2015

columns > month(date) rows > SUM(total runs) * table Calc- moving average >edit table calc - avg previous 3 753.8

A histogram shows the distribution of _______ data by creating bins that are ______.

continuous, discrete.

What is the max number of months between the ship date and the order date? How many orders took this many months to ship?

create calculation > DATEDIFF("month", [order date][ship date]) rows > Calculation 1 text > CNT(Orders) 3 months, 2 orders

For boys born between 2000 and 2012, the most common first letter for Top Baby Names By State was:

create calculation > MID(top name,1,1) columns > SUM(occurrences) rows > calculation 1 filters > Gender: M, Year: 2000 - 2012 J was most common

Find the total sales values for all product subcategories for customers who ordered office furnishings

create calculation > {FIXED[CustomerID] :MAX(IF (product Subcategory)="Office Furnishings" THEN 1 ELSE 0 END)} filters > Calculation 1: 1 text > SUM(sales) 3,864,069

How many failed votes were there for bills sponsored by Colorado (CO) Republicans (R) in 2013?

filters > YEAR(Vote Date): 2013 , Vote Result: Failed, State: CO, Sponsor Party: R Text > CNT(bills) 36 bills failed

When using a _____ join, the result is a table that contains all values from the left table and corresponding matches from the right table.

left

Reference Distributors can show the following

percentiles

A bullet chart combines a bar chart with:

reference lines

Open the flights data and assign the geographic role for Airport Code as Airport. Add the airport code to the view and drag the airport name to the label mark. Which airport is closest to ATL?

right-click Airport Code > Geographic Role = Airport 1.) drag Airport code to detail - creates the map 2.) drag Airport name to Label CTL is closest to ATL

Create a set for the top 2 teams with the highest average batting average. What percent of the total runs were scored by these three teams?

rows > Baseball Team filters > Baseball Team: Bears, Falcons, Badgers text > SUM(Runs) *table calc- %diff 34.55%

Using the Southern Region sheet, find the customer name with the most unique order IDs

rows > Customer Name text > CNTD(orderID) Sort field OrderID Barry Gonzalez

Using the Souther Region Sheet of the South Superstore data, find the total sales value of items shipped in January and February 2014.

rows > Years(ship Date), Quarter(ship Date), Month(ship Date) filters > month(ship Date): January, February; Year(ship Date): 2014 text > Sum(sales) 6132

Left join Southern_region with returns using OrderID. Add sales and status to the view. What is the value for SUM(sales) for status returned?

rows > status text > SUM(Sales) 35,407

How many players have the first name "Anna"?

split name col on Data source filters > name-split 1: Anna rows > Name 2 people named Anna

Analysts hope that Apple stock price will increase by 10% in 2015. Using the stock table create a caluclated field called 2015 High that multiples the value of high by 1.1 Use MAX aggregation to determine the max value of New High for Apple Stock.

text > AVG(High), AVG(2015 High) filter > Company: Apple Calculated Field > MAX(high * 1.1 131.7