Using the Profit Analysis Dashboard twbx file, find out the profit recorded in October 2016 by California State in the West region? You can add the functionality to the dashboard.
Answer(s): C
Select California State from the Map
Connect to the "Global Superstore" data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?
Answer(s): B
Create a Calculation to get the first alphabet of the customer name.Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:
Connect to the "Global Superstore" data source and use the Orders table. Predict the profit of January 2016 using the profit data through December 2015. What is the profit value of January 2016?
Answer(s): A
Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:Go to the Analytics tab and drop the Forecast to your view. Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months,$35,152 is the correct answer.
Why we convert a numeric measure to a dimension?
Answer(s): D
Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.
Connect to the "Significant Volcano Eruption" data source. In 1899, the Dona Juana volcano erupted in Colombi
Drop the Latitude and Longitude fields to Rows and Columns shelf respectively. Or double click on these fields.Drop the Location field to Filter shelf, select the Location as Colombia.Drop the Name field to the Label.To show the cities go to the Map -> Map layer and Check the Cities.Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:Zoom-in the map, you will find Purace is the nearest one in the Popayán city and Dona Juana was having 55 deaths.
Post your Comments and Discuss Tableau Desktop-Certified-Associate exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the Desktop-Certified-Associate content, but please register or login to continue.