ISM4402 practice Q

Answer this question with the Players worksheet from the Little League Create a bar chart showing runs by player name. Add a reference distribution showing standard deviations. What is one standard deviation below the mean? 8.70 172.58 27.07 1.94

1.94

Answer this question with the Players worksheet from the Little League Approximately what percent of runs were scored by catchers? 9.52% 87.33% 9.94% 10.00% 10.14%

10.00%

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)? 2002 2011 1998 2009

2002

Inner join Southern_Region with Returns using Order ID. 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? 2013 2016 2015 2014

2013

Which of the following fields will have AGG in front of it when you add it to the view? A date field A calculated field with the formula 5 * [Profit] A calculated field with the formula SUM([Profit]) A measure called Profit

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 A dashboard can include a story, but a story cannot include a dashboard A dashboard can include a story, and a story can include a dashboard A dashboard cannot include a story, and a story cannot include a dashboard

A dashboard cannot include a story, but a story can include a dashboard

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? A discrete field A measure A continuous field A dimension

A dimension

Answer this question with the Games worksheet from the Little League Create a line graph showing Away team runs for the Lions by month. Add a linear trendline. What is the R-squared value? -0.1346 .6846 .7503 .0573

.6846

How many failed votes were there for bills sponsored by Colorado Republicans in 2013? (The abbreviation for Colorado is CO) 36 1,188 66 3 78

36

Union the Stocks 2010-2013 and Stocks 2014 tables, and then 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? 4 0 5 6

5

Answer this question with the Players worksheet on the Little League Create a hierarchy Baseball Team - Position. For the Ninjas, how many runs were scored by the position with the lowest average batting average? 54 150 70 24

54

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 with the label, "AGG(Average Profit)."Why does one field have SUM and another AGG? AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view. Each field has default properties, including default aggregation. Profit had SUM set as its default aggregation, while Average Profit had AGG set as its default. AGG is applied by default to discrete fields, while SUM is applied to continuous fields. Average Profit was set to discrete, while Profit was set to continuous. AGG is applied by default to dimensions, while SUM is applied to measures. Average Profit is a dimension, while Profit is a measure.

AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

Which of the following will result in an error Aggregation on a field that is already aggregated A calculation that includes more than one aggregation A table calculation on a field that is already aggregated An aggregation on a level of detail expression

Aggregation on a field that is already aggregated

A field that shows average home values for the United States in 2016 is most likely: A geographical dimension A continuous date value dimension A discrete date part dimension An aggregated measure

An aggregated measure

Blend the Southern Region table from the South_Superstore file with the Subcategory Profit Targets table from 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? Bookcases Appliances Binders Art

Appliances

Which of the following mark types cannot be adjusted using the Size slider? Area Bar Line Pie

Area

Which function will help you to find the number of customers in your data? RANK([Customer ID]) COUNT([Customer ID]) COUNTD([Customer ID]) UNIQUE([Customer ID])

COUNTD([Customer ID])

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 shown on the map is closest to Hartsfield-Jackson Atlanta (ATL)? Charlotte Douglas International (CTL) George Bush Intercontinental (IAH) Chattanooga Metropolitan Airport (CHA) Orlando International (MCO)

Charlotte Douglas International (CTL)

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 Multiselect Filter Dimension Filter Wildcard Filter

Context Filter

Bins can be created for which type of field? Dimension Continuous Measure Discrete Date

Continuous Measure

Which of the following field types will create a color palette? Continuous Discrete Dimension Measure

Discrete A continuous field will create a color gradient

Which field types are more common? Continuous dimension, discrete measure Discrete dimension, discrete measure Continuous dimension, continuous measure Discrete dimension, continuous measure

Discrete dimension, continuous measure

The Data Interpreter helps prepare ______ data for analysis. Excel SQL Text CSV Hadoop

Excel CSV

Bins acts as containers that summarize data for a specific range of values. Without using a calculated field, Tableau's bin feature allows you to create variable sized bins. True False

False

If Fiscal year start is set to May, the year for the date April 1, 2004 would be shown as FY 2005. True False

False

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

False

When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field. True False

False

When creating a union between tables, what will happen if the field names do not match? Tableau will automatically merge the fields, combining fields with similar field names. Fields in the union that do not have matching field names will contain null values. Tableau will return an error message, explaining that you must modify the tables so that all tables used in the union have the same field names. Fields with non-matching field names will be dropped, so that the union will contain only those fields with matching field names

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

In the Southern Region Superstore data, the Product Category, Product Subcategory, and Product Name might be combined using which of the following: Group Parameter Hierarchy Set

Hierarchy

You created a group by selecting field labels in a view. How can you remove members from the group? On a color legend, right-click a member you want to remove and select Format legends. In the view, right-click the group members you want to remove and select Exclude. In the Data pane, right-click the group and select Edit Group. In the view, right-click the group members you want to remove and select Format.

In the Data pane, right-click the group and select Edit Group.

Create a map view and zoom in to southern California. What city is the closest city to Costa Mesa with more Tableau job postings than Costa Mesa? Santa Ana Los Angeles Irvine San Diego

Irvine

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 horizontal axis It will add a horizontal header It will add a vertical axis It will add a vertical header

It will add a vertical axis

For boys born between 2000 and 2012, the most common first letter for TopBabyNamesbyState was: W D J M

J

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 ATTR([Minutes of Delay]) Minutes of Delay (bin) AGG([Minutes of Delay])

Minutes of Delay

Answer this question with the Teams 2014 and Games worksheets on the Little League The Games data includes information on games played in 2015, including showing the team that won each game. Which team had the biggest increase in winning games between 2014 and 2015? Bears Ninjas Lightning Knights

Ninjas

Using the Stocks 2014 table, create a dual axis chart showing the daily Open and Close values. Use a filter to limit to filter on October 2014 and use a filter to limit the data to Biogen Idec. On which date was there the greatest difference between Open and Close October 20th October 15th October 13th October 12th

October 13th

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 will like the year selection to limit the data in the view. What Tableau element should you to let the user select the interest rate? Context Filter Parameter Dimension Filter Change Set values Dashboard Action

Parameter

A bullet chart combines a bar chart with: Circle views Reference lines Filled bubbles Scatter plot

Reference lines

Which chart type will best visualize the relationship between two continuous measures? Stacked Bar Line Chart Bar chart Scatter Plot

Scatter Plot

Which type of visualization is not typically effective in showing change over time? Line Chart Scatter Plot Area Chart Bar Chart

Scatter Plot

What steps should you take to add a phone view to a dashboard? On the "Show Me" menu, click the Phone icon Select Layout, then adjust the dimensions until they are appropriate for a phone (750x1334) Select Device Preview, then select Phone for Device Type, then click the button labeled "Add Phone Layout" Instruct the those viewing the dashboard on mobile to put "m." in front of the dashboard URL to get the mobile-friendly view.

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

Which of the following action types can be used to create proportional brushing? URL Action Filter Action Set Action Sheet Action

Set Action

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) Size Tooltip Label Color

Size Color

Which type of filter usually works best with date fields? List filters Check boxes Slider filters Text search

Slider filters

Which of the following is not a default property which can be set for a measure? Color Sort Aggregation Number Format

Sort

Which of the following is a table calculation? AVG STDEV TOTAL SUM

TOTAL

Using the Southern Region sheet of the South Superstore data, which state bordering Mississippi had the highest Sales? Florida Tennessee Alabama Arkansas

Tennessee

A relative date filter works relative to: The data the workbook was created or updated The current date when the workbook is viewed The anchor date A parameter or field you select when creating the filter

The anchor date

You connect Tableau to a Excel file which 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 and text values are both set to null he date values are set to the number of days since 1/1/1900 and the text value is set to zero. The date and text values are both set to zero The date values are set to the number of days since 1/1/1900 and the text value is set to null.

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

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

True

Context Filters are executed after data source filters. True False

True

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

True

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

True

You can combine multiple worksheets in a single dashboard. True False

True

What type of dashboard action allows Tableau to open a page on an external website? Highlight Filter URL Web

URL

The most important items on a dashboard should be positioned where? Bottom Upper Right Center Upper Left

Upper Left

If you see duplicate data after doing a join, you can do the following ....[select all that apply] Add a duplicate filter to your data Use data blending instead of a join Change the join condition Change to a full outer join

Use data blending instead of a join Change the join condition

Which of the following describes the Measure Names field (select all that apply) When you add Measure Names to a 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. It is a Measure automatically created by Tableau Measure Names 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 create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view.

When you add Measure Names to a 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. Measure Names 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

Which of the following is the best reason to use a Tableau data extract instead of a live connection? You need to join tables that are in the data source. You need to apply an aggregation that takes too long when using a live connection. You need the freshest possible data at all times. Your data source only supports a live connection via ODBC.

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 a snapshot of the data that will not update even when the underlying data changes. You want to save the default field properties such as number formats and sort order. Those who wish to use the data do not have access to the underlying data. You need to apply an aggregation that takes too long when using a live connection.

You want to save the default field properties such as number formats and sort order.

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

alias

A histogram shows the distribution of ________ data by creating bins that are _________. date, discrete continuous, discrete numeric, continuous discrete, continuous

continuous, discrete

Interactive elements that you can add to a dashboard for users include ______.(Select all that apply.) filter actions URL actions edit tooltip options hide and unhide all sheet options

filter actions URL actions

Reference Distributions can show the following? [select all that apply] confidence intervals the normal distribution percentiles the lognormal distribution

percentiles

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

6

Answer this using the SuperStore data. What is the maximum number of months between the ship date and the order date? How many orders took this many months to ship? 5 months, 1 order 3 months, 1 order 3 months, 2 orders 5 months, 2 orders

3 months, 2 orders

Find the total sales value for all product subcategories for customers who ordered office furnishings. 2,786,637 8,119,645 3,864,069 2,258,326

3,864,069

Using the Flights table, create a bar chart showing the average of Minutes of Delay per Flight brokendown by Carrier Name, and filtered by State to only show Minnesota (MN). What was the average minutes of delay per flight for United in Minnesota? 62.98 53.69 2,582 61.74

62.98

For films where Disney was not the lead studio, what was the % decrease in profitability from 2010 to 2011? 7.2% 86.28% 55.3% 11.59%

7.2%

Answer this question with the Games worksheet on the Little League data. Find the moving average for the total number of runs in three months prior to May 2015. 753.8 749.3 749.3 796.0

753.8

Which of the following can you use to create a calculated field that returns data independent of the data granularity in a view? A table calculation. An INCLUDE LOD calculation. A basic calculation. A FIXED LOD calculation.

A FIXED LOD calculation.

After setting up two data source connections, how can you create a blend? 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 data source and click the broken link icon. On the data sources pane, drag tables from both connections onto the canvas. Then click the venn diagram and select the blending fields. On the data source page, double-click New Blend to set up the blend. Drag a table from the left pane to the blend dialog box. Select Data, then Edit Relationships, tthen Select the secondary data source in the Secondary data source pane, select Custom in the relationships list, and then click the Add button.

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 data source and click the broken link icon.

Using the Southern Region sheet of the South Superstore data, find the customer name with the largest number of unique order ids. Sean Miller Paul Prost Barry Gonzalez Christopher Martinez

Barry Gonzalez

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. Drag the field "Closing" to the path mark. Drag the field "Closing" to the row shelf, then select the dual axis chart on the "Show Me" menu. Drag and drop the field "Closing" to the y-axis.

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

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) Filter Action Url Action Drilldown Action Highlight Action

Filter Action Highlight Action

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 FULL OUTER INNER RIGHT BLEND

LEFT

This type of join will include all values from the left table: Right Blend Left Inner

Left

Answer this question with the Teams 2013 and Teams 2014 worksheets on the Little League Which team had the biggest decrease in games won from 2013 to 2014? Lions Lightning Tigers Bears

Lions

Which of the following should be used if 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: Extract Hyper Live Connection Packaged data source

Live Connection

Using the Stocks 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 fluctuation in increase or decrease? March 2012 - April 2012 November 2012 - December 2012 December 2011 - January 2012 January 2012 - February 2012

March 2012 - April 2012

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 month? April 2013 February 2013 January 2013 March 2013

March 2013

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work? Set the type back to string, then try date conversion functions like DateParse and Date Instead of setting the field to Date, set to Date & Time Switch the metadata grid, then right click the field and select "date format settings" Edit your computer's date settings to that they correspond to the format of the date you're trying to use in Tableau

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

Using the Flights table, create a bar chart showing the average of Minutes of Delay per Flight broken down by Airport, and filtered by date to show only the last three months of 2013. Which airport had the lowest average minutes of delay per flight between October and December? Seattle/Tacoma International Chicago/O'Hare International Baltimore / Washington International George Bush Intercontinental

Baltimore / Washington International

Which of the following uses a primary and secondary data source? Blending Cross-database joins Aggregation Unions

Blending

Which types of plots are most often used to visualize the distribution of continuous data? (select all that apply) Box Plot Tree Maps Histogram Scatter Plot

Box Plot Histogram

Which of the following functions can be used on string to create a measure? COUNTD SUM + DATEDIFF

COUNTD

Which of the following will create a dashboard action? Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter" Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as Filters" and select the filter that you'd like to apply to the whole dashboard. Then go to the filter menu, right click, and select "apply to all using this data source" Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "action," add action, and Filter Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as Filters" and select the filter that you'd like to apply to the whole dashboard

Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter"

Gantt charts are useful for: Displaying the distribution of a continuous variable Showing how a measure varies with respect to one or more dimensions Displaying duration of events or activities over time Showing changes to a continuous variable over time

Displaying duration of events or activities over time

Answer this question with the Players worksheet on the Little League Create a histogram showing batting averages using a bin size of .05. Find the average number of runs scored for players with a batting average between .55 and .6. 15.64 13.53 18.92 13.38

13.53

Analysts hope that Apple stock price will increase by 10% in 2015. Using the Stocks table, create a calculated field called 2015 High that multiplies the value of High by 1.1. Use MAX aggregation to determine the maximum value of New High for Apple Stock. 119.8 23,439 131.7 448.9

131.7

Using the Flights data, determine the average minutes of delay per flight by the month (using Date). Using a table calculation, find the % difference in average minute of delay per flight between from June 2013 compared with May 2013. -8.2% 14.11% 59.5% 60%

14.11%

What percent of job postings for Developers mention Python skills? 19% 13% 17% 15%

15%

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? 20.12% 25.17% 34.71% 17.36%

17.36%

Answer this question with the Little League data. How many players have the first name "Anna" 1 4 3 2

2

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? 2011 2012 2014 2013

2014

Using the Stocks 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 for Apple for2010 through 2013, respectively? 25,606,397,999 and 127,322,019,216 25,606,397,999 and 26,695,067,569 26,695,067,569 and 134,264,642,523 365,212,953 and 134,264,642,523

25,606,397,999 and 127,322,019,216

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 then number of flights for Dallas/Fort Worth Delayed by Security? 262,667 and 53 45,677 and 93 1,001 and 650,751 72,489 and 51

262,667 and 53

Answer this question with the Players worksheet on the Little League data. Create a set for the top three teams with the highest average batting average. What percent of the total runs were scored by these three teams? 92.27% 34.55% 7.73% 8.97%

34.55%

Left join Southern_Region with Returns using Order ID. Add Sales and Status to the view. What is the value for SUM(Sales) for Status returned? 40,980 356,315 35,407 5,769

35,407

Using the Southern Region sheet of the South Superstore data, find the total sales value of items shipped in January and February 2014. 6,132 6,122 46,474 44,239

6,132