ism4402 practice 2

Create a left join to combine the southern region worksheet with the rewards customer worksheet. The join field should be customer ID What percentage of all sales does Alan Shonely account for?

.10% Customer ID, customer names, percentage filter from the top, analysis?

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

17.36%

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 2014 2015 2016

2013

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 2013 2014

2014

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 35,407 356,315 5,769

35,407

which of the following can you use to create a calculated field that shows the change from the prior month total? an aggregate calc a basic calc a subtraction calc a table calc

A table calculation

If you are creating a geographic map with cities, but some of the locations are showing as ambiguous, how might you correct this?

Add a field called "states" to the view

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.

which of the following will increase the granularity of the view?

Adding a dimension to the marks area

Union the stocks 2010-2013 and stocks 2014 tables, and then create a table showing the max high stock price for each company in each quarter Following Q2 of 2013, which company increased its max high stock price the most quarters in a row? Amazon, max high increased for three quarters in a row Biogen, max high increased for three quarters in a row biogen, max high increased for four quarters in a row apple, max high increased for three quarters in a row

Amazon, max high increased for three quarters in a row Biogen, max high increased for three quarters in a row

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? Appliances Art Binders Bookcases

Appliances

Union the stocks 2010-2013 and stocks 2014 tables, and then create a visualization showing the maximum High stock price for each company in each quarter. Starting from Q3 of 2013, which of the following statements is true? Biogen, max High increased for four quarters in a row Amazon, max High increased for four quarters in a row Apple, max High in increased for four quarters in a row

Biogen, max High increased for four quarters in a row Apple, max High in increased for four quarters in a row

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

Blending

Your view has a histogram showing the distribution of sales. You'd like to use a color gradient to shade the bars according to the value of profit. you drag profit to the color mark. how would you adjust the colors so that all negative values are shown in one color and all positive values are shown in a second color?

Click the arrow on the colors mark, select edit colors, select a diverging palette from the dropdown and check stepped color with 2 steps and check center on zero

You have a dashboard containing multiple worksheets. One of the worksheets in the dashboard has a scroll bar. Which of the following steps an you take to remove the scroll bar?

Click the more option arrow, select fit, and select fit height

When creating a union between tables, what will happen if the field names do not match? 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. 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. 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.

Editing the font at the worksheet level applies the changes you make to all text fields in the view except for which of the following?

Header Tooltip

Which file type can include an extract? Packaged Workbooks (.twbx) Packaged Data Source (.tdsx) Data Source (.tds) Workbooks (.twb)

Packaged Workbooks (.twbx) Packaged Data Source (.tdsx)

Profit has color. CONT? DISCRETE?

Profit is discrete, Sales is continuous

Profit and sales are continuous measures in the workbook. Order ID is a dimension. Which of the following is already aggregated and therefore will not be further aggregated when it is added to the view?

SUM([Sales])

Which of the following fields is most likely to be a dimension

Sales (bin)

Which of the following is most likely to reduce the size of the extract?

Select "Multiple Table" rather than "Single Tables"

Your view has a numeric field set as a discrete measure/dimension which of the following visualizations can you create with this type of field?

Text table

which of the following is an example of metadata that can be managed in Tableau? select all The default aggregation for the field Which fields are hidden The data type of the data in the source database The number of rows in the data

The default aggregation for the field Which fields are hidden

If a Tableau workbook does not include the fields Latitude (generated) and Longitude (generated) this indicates which of the following?

The workbook does not include any fields with a geographic role of state, city, country, or zip code

For which of the following is it NOT possible to adjust the size of the marks?

Tree Map

Which of the following is the best reason to create a saved data source as a .TDS file 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. 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.

Which of the following does Tableau automatically put into a hierarchy? geographic fields date fields numeric fields keywords

date fields (year>month>day)

Which visualization always represents a measure using color? combo chart pie chart highlight table scatter plot

highlight table

if you drag a field called sales to the filter area, and you do not get a menu like (all values, sum, ave..) but are immediately taken to the filter menu. What does this indicate about sales?

it is set as a dimension

you would like to divide your customers into two categories-- those with samples above a certain threshold and those below that threshold Which of the following tools will allow you to do this? select all that apply set hierarchy parameter calculation

set calculation