Instructions
Open the
this Tableau Workbook and take the steps to answer the following questions. Then save the workbook and check your steps using the Lab Solutions document. For a realistic practice exam experience, don't use outside resources (like google) to figure out how to solve these problems. A
PDF version of Tableau help is provided during the lab portion of the exam, so you should feel free to refer to it as you work through the problems.
Lab Questions
Lab Question 1
Modify the Avg Oil Price worksheet to use a moving average of the current month and the five months prior.
Lab Question 2
On the data source page, create a union of the PostCPI and PreCPI tables.
Lab Question 3
Create a calculation that combines Month and Year into a date field. Set the date to be the first of the month for the specified date and year so that for example “May” and “2018” becomes May 1st, 2018.
Lab Question 4
Rename the CPI field to “Consumer Price Index”
Lab Question 5
On the Oil Price Histogram worksheet, change the bin size to 10.
Lab Question 6
Update the “Cold Price Table” worksheet so that only the top 5 values with the highest average gold price are shown.
Lab Question 7
Change the default format for Gold Price to so that, for example, a value of 100 will have a default formatting of $100.00.
Lab Question 8
On the “Gold by Year/Month” worksheet, add a reference line showing the lowest value for each year
Lab Question 9
Add a linear trend line to the scatterplot.
Lab Question 10
Add subtotals to the Price Table worksheet.
Solutions
Download PDF solutions to these Data Analyst lab questions