A company that sells books online has three regional shipping centers. Each shipping center uses a different computer system to enter and process orders. The company wants to identify the most efficient computer system and to use that computer system at each shipping center. You can use this data to demonstrate combining data from different sources, as in Chapter 8 of Getting Started.
A team at the shipping center in the central region collects data on orders and arrivals.
|Order||The date and time that a customer places an order.|
|Arrival||The date and time that a customer receives an order.|
|Status||On time indicates that the book shipment was received on time. Back order indicates that the book cannot be shipped yet because it is not currently in stock. Late indicates that the book shipment was received six or more days after the order was placed.|
|Distance||The distance from the shipping center to the delivery location.|