CASE ASSIGNMENT

The US Superstore Excel file has 23 columns (as listed in Exhibit 2) and 9,994 transaction lines that provide the data for order to cash information related to US Superstore's revenue. The file has two additional worksheets that include returns and sales staff and their regional responsibilities. Appendix A provides a data hierarchy of US Superstore's database and a summary of basic database terminology. A full list of all US Superstore dataset variables, as shown in Exhibit 2 and demonstrated by the first-row data entry:

EXHIBIT 2 US Superstore Dataset Variables Dataset Variable Example Dataset Variable Example Row ID Number Order ID Number CA-2013-152156 Order Date 1 1/9/2013 Ship Date 11/12/2013 Ship Mode Second Class Customer ID CG-12520 Customer Name Claire Gute Segment Consumer Country United States City Henderson State Kentucky Postal Code 42420 Region South Product ID FUR-BO-10001798 Category Furniture Product Name Bush Somerset Collection Bookcase Sub-Category Bookcases Quantity 2 Sales 261.96 Date Paid 2/15/2012 Discount 0 Cash Receipts 1250.00 Payment due date 1/23/2011