Database Reference
In-Depth Information
Yo u r customer is the manager of shipping for a fictitious global wholesaler. The key metrics for
the organization are shipping volumes and returns. The manager is looking for any exceptional
data to be able to quickly react to trends.
When looking at different warehouses at the country level, the manager wants to see
whether any countries are not meeting service expectations by limiting returns to less than 1.1
percent of all items shipped. If a country exceeds 1.5 percent returns to shipped items, this is a
cause for concern.
In reviewing the types of items that are shipped, the manager also wants to look for an
exceptionally large percentage of return reasons that are a result of the warehouse.
Finally, the manager wants to look for trends between the expected and actual shipping vol-
umes. Figure 2.1 shows the completed dashboard.
Figure 2.1
Completed shipping dashboard
This dashboard will look at three measures that are important to the manager: returned item to
items shipped ratio, number of returns, and shipping volumes.
The three data containers used in this report are a map, a pie chart, and a combination chart.
After the items are added to the page, the queries will be developed.
After the queries are created, the data items will be added to the containers and formatted to
match the expectations of the manager.
No drill capabilities will be added at this time. After the other reports are developed, the
interactions will be added to improve the analytical aids.
