Link for Dashboard: Retail Data Sample
Question 1
Which category of books produced highest revenue during the
year?
Attribute:Item category
Metrics:Revenue
Filter: no filter used
We chose vertical bar graph for this question because from
bar graph the answer of this question can be found easily. The number of item
categories was huge. So, bar graph was the most appropriate visualization to
answer this question.
Conclusion- Action movies recorded maximum revenue
($15,897,317) during the year.
Question 2
In the month of July, which city recorded maximum revenue?
Attribute: Month and City
Metrics: Revenue
Filter: Only month of July was selected.
We chose pie chart to answer this question because it
illustrate the revenue share of every city during the month of July and city
with maximum revenue can be easily visualized.
Conclusion- In the month of July New York recorded maximum
revenue ($3,075,061), which was 15.24% of total revenue in the month.
Question 3
In which month for Baltimore, the total revenue of Bantam
books was highest?
Attribute: City and Month
Metrics: Revenue
Filter: Only Baltimore was selected from cities
We used line graph for this question. It shows the behaviour
of total revenue during various months for the city of Baltimore. Highest and
lowest points can be easily identified from the visualization.
Conclusion- The revenue was maximum ($3,509,275) in the
month of August.
Question 4
Which Item category recorded maximum number of units sold
during the year?
Attribute:Item Category
Metrics: Units sold
Filter: no filter used
We used vertical bar graph for this question. It plots item
categories versus unit sold. From the number of item categories, we can easily
identify the highest and lowest points from height of the bars.
Conclusion- Action movies recorded maximum units sold
(275968 units)
Question 5
Which Item category had highest and lowest unit price in
November?
Attribute: Item category and Month
Metrics: Unit price
Filter: Only month of November was selected
We used horizontal bar graph and plotted item categories
against unit price for the month of November. Bar graph easily illustrates the
required results.
Conclusion- Action movies had maximum unit price ($6237.96),
Cameras has minimum unit price ($631.91)
