Dashboard Project Results

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)

Introduction - Retail Data Sample

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

• Mukesh Kumar
• Gagandeep Singh
• Parminder Singh

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
• Determing KPI (Key Performance Indicators)
• Decision making
• Measuring and Tracking Purposes.

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.

• Questions:

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