Dashboards?

What is a Dashboard?

A typical method that the marketplace uses to organize and display Business Intelligence and other relevant information such as, finances, sales, etc is through a dashboard. A dashboard is a visual display of information that is crucial for business users to understand at a glance.

What is the Role of Dashboards in Business Intelligence? 

Providing critical and relevant information is essential in Business Intelligence. Because of this, role of the dashboard is very important. It allows marketers to not only track personal finances, spending and applying calculations, but it also allows the business to monitor the effectiveness of their strategies. Dashboards are able to do this by linking the strategies to measures and indicators which gives access to see the progress. 

How can dashboards help with the Big Data?

Dashboards can help organize big data into charts, tables statistics that can be easily compared between relevant data. It also offers full control of your findings at your fingertip in a few clicks instead of having to draw potential inaccurate charts. Dashboards also provide the ability to compare data from previous years without having to go through the trouble of seeking old documents.

How are Dashboards useful in business?

Managing teamwork, providing faster and credible information and ensuring cost reductions in an organization are several ways which dashboards are useful in business. 

Based on the information that the dashboard provides, it allows team to share data with each other much easier. It also makes it easier for teams to assign tasks in specific areas to improve results such as revenue, organization spending, etc. Teams are also able to make better decisions because dashboards produce and prepare visual information. 

Dashboards save a lot of time and money for organizations as expenses no longer have to be spent to have people construct charts and data manually.


Inventory Data

(Click to enlarge)

The data above represents very specific data related to the inventory of solid cotton maroon kings such as: locations, type of locations, how much is available in each location, how many orders and which of those orders are to be shipped and minimum and maximum available items in each location

Current and future transactions, sales and sales for all season for each item in each location is also provided in the data set.

Five analysis questions that we have asked about our data set and the attributes and metrics that gave us insight to these questions are:

Which location has the most items on hand?

Attributes: location, location name
Metric: Inventory on hand

Which location name has the most total sales?

Attributes: Location Name
Metric: Total Sales

What is the average minimum amount of items on hand

Metric: Minimum Items on Hand

Which season code held the most sales?

Attribute: Season Code
Metric: Total Sales

Which store-type generates the most and least sales?

Attributes: Store Type
Metric: Total Sales

By: Ashley Quijano, Cindy Tran, Steven Tran and Sandeep Kanda