Retail Data Sample: March 2013

Hello Everyone.
We are doing our dashboard project on retail data sample. The names of group members are:

PART A:

Some basic information about dashboards is as follows:

Dashboard: It is a Common way to organizing and presenting Business Intelligence or related information resources.

Role of dashboard in BI: To provide critical information to business users at a glance by using graphical visualizations.
Dashboards use spread sheets with large amount of data to make various calculations and represent it in Graphical manner highlighting the critical data. It enables users to interpret the useful data easily.
Business Applications of dashboard: Databoards are used for following business applications

PART B:

Enterprise:We are preparing a dashboard on retail data for Bantam Books.
Activity: To keep track of sales of different item categories to various cities according to months.

Question 1: Which category of books produced highest revenue during the year?

Attribute:Item category

Metrics:Revenue

Question 2: In the month of July, which city recorded maximum revenue?

Attribute: Month and City

Metrics: Revenue

Question 3: In which month for Baltimore, the total revenue of Bantam books was highest?

Attribute: City and Month

Metrics: Revenue

Question 4: Which Item category recorded maximum number of units sold during the year?

Attribute:Item Category

Metrics: Units sold

Question 5: Which Item category had highest and lowest unit price in November?

Attribute: Item category and Month

Metrics: Unit price

Reference used: Norrie, Introduction to Business Information Systems, Third Canadian Edition

Retail Data Sample