Tableau Practice Exam 2

2019-05-12  本文已影响0人  haidaozheng

数据源及答案
提取码: p5mv

1.

Answer the question using the Coca Cola stock price data Coca Cola stock price. What was the % change in adjusted closing stock price (Adj Close) for Coca Cola between June 1998 and June 2017?

2.

Answer using this data: TopBabyNamesbyState
Which boys’ names were only on the Top Names list only during the 1980s (1980 – 1989)

3.

Answer this using the SuperStore data.Find the total sales value from customers who made their first purchase in 2011.

4.Answer this question with the Superstore Data.What is the most common first name for SuperStore customers?

5.

The term “addressing” refers to the direction of a calculation.

6.

Using the Players sheet on the Little League data, what percent of players on the Lions scored between 5 and 10 runs?

7.

SUM is a table calculation.

8.

Use the Coffee Chain data to answer the following question.
Which area code was 25th place in sales for Espresso?

9.

Use this data to answer the following question. A group of people were surveyed regarding their smoking habits for each decade between 1960 and 2010. The survey data states “true” if the person was a smoker in the survey year, and “false” if they were not a smoker. Which decade saw the biggest decrease in the number of smokers?

10.

Answer this question using the Smoker data. In addition to the survey data, there is also a “College Smokers” which estimates the percent of smokers in the college student population by year. Combine the “Smoking Survey” data with the “Percent Smokers” data to determine the decade with the biggest difference between the college student % smokers and the % smokers in the survey data.

11.

Answer this question by joining the Smoking Survey data with the Demographics data. Join using the ID field. In the 1960 survey, which birth year had the highest percent of respondents who said that they were smokers?

12.

Using the Coca Cola data, combine the “Price Archive” and “Price” worksheets, which date had the greatest increase between the Adjusted Open price (Adj Open) and the Adjusted Close Price (Adj Open)

13.

The benefits of creating a Tableau data extract include improving performance and allowing offline access to the data.

14.

The metadata grid displays the fields in your data source in columns.

15.

Answer this question using the Order sheet from the SuperStore data. Create a scatterplot showing the sum of Profit on the Y-axis and sum of Sales on the x-axis for each Customer. Add a linear trendline. What is the function?

16.

Answer this question using the Games sheet from the Little League data. Create a box plot by Home Team to analyze the distribution of Home Team Runs by game. Which Home Team has the lowest ‘lower hinge’ of runs?

17.

_______ is a technique in Tableau which will identify marks with similar characteristics.

18.

A trendline using an exponential model type will be fit using exponential regression

19.

Which of the following is used to assess trendline significance:

20.

Answer this using the SuperStore data. Find the top 10 customers with the highest total sales. How many of these customers live in the Central region?

21.Answer this using the SuperStore data. What were the total sales for items ordered in 2013 with product name containing the word vacuum?

22.

If you would like your Top N or Bottom N set to change depending on what filter choices are changed, what type of filter should use use?

23.

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.

24.Answer this question using the “Coke Price” worksheet from the Coca Cola End of Day Stock Price workbook. Create a histogram for the Adj High price using a bin size of 5. Which of these bins has the highest average adjusted volume (Adj Volume)?

25.

Answer the following question using the SuperStore Subset data. Create a calculated field called “Profit Goal” equal to 25% of Sales. Create a bullet graph comparing Profit to Profit Goal by product sub-category. For which of the following sub-categories did the Profit meet or exceed Profit Goal?

26.

Which of the following are generated fields in Tableau? (select all that apply)

27.

Answer this question using the San Francisco Police Department Incidents burglary data. Create a scatter plot showing the number of unique incidents and number of arrests by PD District. Which two districts are the closest on these two measures?

28.

Pareto charts combine the following elements:

29.

Bullet graphs combine bar charts and reference lines

30.

Download the Contributors to Obesity dashboard: https://public.tableau.com/workbooks/contributorstoobesity.twb and open with Tableau. Looking at counties within the state of Indiana, which of the following is associated with higher rates of obesity?

31.

Answer the following question using the Contributors to Obesity dashboard. For counties in North Dakota, an increase of 1% of proportion of the population who smokes is associated with a _____ increase in the proportion of the population that is obese.

32.

Which of the following is an alternative to a Tile dashboard layout?

33.

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?

34.

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

35.

Answer the following question using the Contributors to Obesity dashboard. Which of the following counties in Rhode Island has the lowest rate of obesity?

36.

Answer this question using the Superstore data. For the states that border New York, which state has the lowest average sales per customer?

上一篇 下一篇

猜你喜欢

热点阅读