Dashboard

A).Dashboard means all visualization on single computer screen,it provides the glance view of the business process as well. Dashboards gives the sign about the something is right or something is wrong in the business process.Dashboards widely used in the corporate world.

Dashboards play very important role in business intelligence.It helps in data visualization tool that represent the current status of metrics and key performance indicator  for an enterprise.Dashboards gather and arrange numbers, metrics and sometimes performance scorecards on a single screen.The essential features of  a Business Intelligence dashboard product include a customizable interface and ability to pull real- time data from multiple sources.Dashboards make the data more accessible to a large audience including executive, and general consumer.Self- service dashboard solution that support large data set will help organisations interact with more information  and , At the same time provide insights to a wider range of users.

Dashboard is highly interactive and provide the facility of filtering and sorting the big data into summary .Also it provide the overview of the information very easily.The business dashboard is one of these tools that provide a snapshot of the most of the important number needed to conduct effective business analysis.Moreover,dashboard answer the fundamental questions of the business.Dashboards use generally at every level of the management but usually to higher level who need a quick view how company is performing.

Mission statement: We are creating a dashboard to analyze inventory sample data statistics to identify which store are performing best ,and to view the total sales of the different location.Also, to keep the track of the minimum and maximum on hand inventory.

B).Inventory data set represent the information regarding items and the shipment of the order, target shipment and total sales. Moreover, it also shows the location , location type and min & max on hand inventory, seasonal code and volume code.

Questions: 

1.At which location sales variability is highest and lowest?

2.What is the total sales according to the location as per week?

3.At which location target of order item is achieved.?

4.What is the Min on hand and Max on hand inventory as per store ?

5.At which location sales thru percentage is highest and lowest as per week?

Attributes:

1.Location,Location name, Location type.

2.Location name

3.Items,Location Name, Location Type.

4.Location Type, Min on hand, max on hand, Inventory On hand.

5.Location,Location name, Location type,week.

Metrics:

1.Sales variability.

2.Total sales

3.Target Orders, Target Shipments.

4.Sales variability.

5.Sales Thru%.