Metrics, Attributes, and Analysis of Inventory

Which location has the most inventory on hand?

Attributes: Location, location name
Metric: Inventory on hand

(Click to Enlarge)

For this question, we used the attribute "location name" to provide us with insight to the answer. We felt that portraying our results in a pie graph was the most appropriate option, as the information is well organized into sections. Because the question asks which location has the most inventory on hand, it is easy to visually spot the answer on this graph (Obviously the biggest section). As shown, the location with the most inventory on hand is "East Coast DC" - the biggest pink section.

Which location name has the most total sales?

Attributes: Location Name
Metric: Total Sales

(Click to Enlarge)

Similar to the first question, "location name" was needed to find the answer. In addition, we have used the metric "total sales" to help us identify which location had the highest total sales. As displayed on the pie graph above, "East Coast" is also the answer to the question asking which location holds the highest total sales.

Once again, we have visually portrayed this question on a pie graph because East Coast has such a high total sales - taking up over half of the graph - and it is easy for readers to locate the answer. 

Which week has the most orders?

Attribute: Week
Metric: Orders

(Click to Enlarge)

All the attributes and metrics listed were used in the process of answering this question. The graph tells us that the week of "4/17/2011" holds the most orders in comparison to the other weeks, at a value of 4789.

We decided to show this data through a different style of pie graph, which appears more similar to a wheel. Because the values are close to each other, it will be difficult to find the largest section of the pie if we used the traditional pie graph. This graph portrays the data more closely than a standard pie graph.  This graph creates ease when locating the week with the highest orders, in this case, week of "4/17/2011". 

Which season code held the most sales?

Attribute: Season Code

Metric: Total Sales

(Click to Enlarge)

The attribute "season code" and the metric "total sales" gave us insight in determining the answer. Evidently through the pie graph, we are able to easily figure out which season code held the most sales. This is possible because the biggest section of the traditional pie graph represents this data. This obvious and quick data gathering contributed to our decision to revert back to the traditional pie graph as a means to visually show our results.

According to the graph, the "All" season code displayed the most sales. 

Which store-type generates the most and least sales?

Attributes: Store Type
Metric: Total Sales

(Click to Enlarge)

For this question we chose to portray our data on a pie graph because it displays the data clearly and is simple to analyze. We are analyzing two sections of the pie graph: the biggest and smallest section. The biggest section (top graph) represents the store type that generates the highest sales, which in this case is "E-commerce" whereas the smallest section (bottom graph) represents the store type that generates the least sales, which is "Strip Mall". 

















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