Tuesday, 26 March 2013

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

No comments:

Post a Comment