How would you calculate GDP per capita in Tableau?

Reveal Solution Hide Solution

_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Reveal Solution Hide Solution

Download the Dataset from:

https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing

Using the Time Series Table, create a line chart to show Sales over time.

Which Month and Year witnessed the lowest Sales?

Reveal Solution Hide Solution

Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter.

In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

Reveal Solution Hide Solution

Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color.

What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

Reveal Solution Hide Solution

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment.

For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Reveal Solution Hide Solution

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment.

For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Reveal Solution Hide Solution

What was the Store count in 2017 for Texas (TX)?

Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map.

What was the Store count in 2017 for Texas (TX)?

Reveal Solution Hide Solution

Using the Geo Data Table, create a Map showing Sales made per State.

For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

Reveal Solution Hide Solution

Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view.

Which Item Number ID made the maximum sales across all assortments?

Reveal Solution Hide Solution