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

Helpful to Business

Business managers and owners use a number of different tools to determine how well the business is performing. The business dashboard is one of these tools that provide a snapshot of most of the important numbers needed to conduct effective business analysis. 

Dashboards can be used in all levels of business management but are typically most important to higher level managers who need a quick glimpse at how the company is performing.

Big Data Interpretation

This image shows how huge data is sorted and displayed in the form of graphs and charts by dashboard.

Better information and leads to better business decision. Every company deals with hundreds of transactions every day leading to accumulation of huge data. To keep check on company’s performance keen study of this data is mandatory. However, it is not possible for a company to interpret whole data so it is very important for a company to consider what data to transform information.

Solution to this complex problem is Dashboard. Dashboard helps a company not only to transform relevant data and information but also in displaying the information in a user-friendly manner through graphs, images and various charts which make the interpretation of raw data much easier.

Dashboard in Business Intelligence

The dashboard in business intelligence is used as a data visualization tool which transforms data into information and displays the information in a user-friendly manner through graphs, images and various charts.

Dashboards help to arrange numbers, metrics and sometimes performance scorecards on a single screen. The purpose of a dashboard is to provide critical information to business users at a glance or in other words it works as a snapshot of how business is performing. The real power of the dashboard comes into play when a different graph can be layered over the same chart or graph. 

What is a Dashboard?

A dashboard is an easy to read, graphical representation of the relationship between two or more variables. Dashboard is used to easily identify and indicate new pattern, trends and changes from the given statistics through different graphs and charts.

The dashboard is the output of an information system. The input is the data set (provided by teacher) and the process is the analysis which involves selecting what variables to compare.

Mission Statement

We are creating a dashboard to examine and analyze statistics related to different suppliers to identify which supplier is performing the best, months with high revenue, which unit is purchased the most and to view the top revenue generating items.