Final Dashboard

This is the final dashboard prepared by our group which consist of all the five questions discussed by us in the earlier posts of this blog. 

Revenue and Cost of each item

Q 5 Which item earned highest revenue?

Attributes- Item Category

Metrics-    Revenue and Cost

These graphs show the revenue earned and the cost of each item or products.

This graph collectively shows revenue and cost of each item. In this graph we can notice Action and Comedy movies are the genre with highest revenue whereas electronics like cameras, computers and TV’s are the products with lowest revenue.

This is different type of presentation of the same data.

First graph shows revenue and cost together however this graph shows revenue and cost separately.

Months with highest Sales and Revenue

Q 4 In which month revenue and sales are highest?

Attributes- Month

Metrics-     Revenue and Sales

In this question months with highest revenue and sales are shown. Months, Revenue and Sales are the key factors used for this dashboard.

In the pie chart we can see September, November and December are the months with highest revenue i.e. over $22,000,000. On the other hand, January and February are the months with least earnings i.e. $20,000,000.

October, November and December are the months with highest sales whereas January, February and March are the months with less than 350000 units of sales.

Sale of each item

Q 3 How many units of each item are sold?

Attributes- Item Category

Metrics-    Units Sold

This ring chart demonstrates the overall sale of each item. Significant elements used in this question are item category and Units sold.   

In this chart we can see Action movies, Drama and Country music have highest sales among all other products i.e. more than 250,000 units each. Whereas many electronics item like cameras, computer and audio equipment are not performing so well and have sales less than 100,000 units.

Units availability and sales in each city

Q 2 How many units were available and sold in each city?

Attributes- Location

Metrics-    Units Available and Units Sold

This graph displays the sale and availability of units in each area. Unit sales and Units availability are the crucial factors used in this dashboard.

From this graph we can see New York and Baltimore have the highest sales i.e. more than 500,000 units and these two cities also have the highest units available i.e. more than 15, 00,000 units.

On the other hand, Morristown, Nutley and Rutherford are the areas with lowest units available i.e. less than 600,000 units and lowest sales i.e. less than 180,000 units.

Supplier Performance

Q 1 How each supplier is performing?

Attributes- Supplier

Metrics-    Revenue and Units Sold 

This horizontal bar graph shows how different suppliers are working in the market. Revenue and sales are the key factor to measure how different suppliers are working in the market.

From these graphs we can see BMG, Virgin Record; Columbia Pictures are performing extremely well with revenue more than $10,000,000 and sales more than 180,000 units. On other hand side Digital Office Inc., DSS Applications Co. and ATF Electronics are among suppliers with lowest sales and revenue.

Introducing Data Set

The data set given to us for this project represent the item sold, sales, revenue, cost and other important statistics of major retailers present in the market. Different movie and music distributor like BMG, Columbia Pictures, 20th century Fox, MGM studio, Sony Music are performing extremely well in the market. Suppliers of books like Warner Books, Vintage Books, and Bantam Books are among supplier with highest sales and revenue.

Items with high sales are movies specially action, comedy and drama movies, pop and rock music, books and different electronics.

Following are the five questions asked of our data set :-

Q 1 How each supplier is performing?

Attributes- Supplier 

Metrics-     Revenue and Units Sold

   

Q 2 How many units are available and sold in each city?

Attributes- Location

Metrics-     Units Available and Sold

Q 3 How many units of each item are sold?

Attributes- Item Category

Metrics-     Units Sold

Q 4 In which month revenue is highest?

Attributes- Month

Metrics-     Revenue

Q 5 Which item earned highest revenue?

Attributes- Item Category

Metrics-     Revenue and Cost