- Lab 1 4 Part 2 Master The Data An Analysis Of Data Related To Dillard S Retail Sales Can Provide Some Of The Answers To 1 (93.68 KiB) Viewed 105 times
DEPARTMENT table: Attribute Description Sample values DEPT The Dillard's unique identifier for a collection of merchandise within a store format 0471, 0029 DEPT_DESC "Christian Dior”, “REBA" The name for a department collection (lowest level of the category hierarchy) of merchandise within a store format. DEPTDEC The first three digits of a department code, a way to classify departments at a higher level. 047X, 002X DEPTDEC_DESC 'BASICS', 'TREATMENT' Descriptive name representing the decade (middle level of the category hierarchy) to which a department belongs. DEPTCENT The first two digits of a department code, a way to classify departments at a higher level. 04XX, OOXX DEPTCENT_DESC The descriptive name of the century (top level of the category hierarchy). CHILDRENS, COSMETICS
SKU table: Attribute Description Sample values SKU 0557578, 6383039 Unique identifier for an item, identifies the item by size within a color and style for a particular vendor. DEPT The Dillard's unique identifier for a collection of merchandise within a store format. 0134, 0343 SKU_CLASS K51, 220 Three-character alpha/numeric classification code used to define the merchandise. Class requirements vary by department. SKU STYLE The Dillard's numeric identifier for a style of merchandise. 091923690, LBF41728 UPC A number provided by vendors to identify their product to the size level. 889448437421, 44212146767 COLOR Color of an item. BLACK, PINEBARK SKU_SIZE Size of an item. Product sizes are not standardized and issued by vendor 6, 085M BRAND_NAME The item's brand. Stride Rite, UNKNOWN CLASSIFICATION Category used to sort products into logical groups. Dress Shoe PACKSIZE Number that describes how many of the product come in a package 001, 002
SKU_STORE table: Attribute Description Sample values STORE The numerical identifier for a Dillard's store. 915, 701 SKU Unique identifier for an item, identifies the item by size within a color and style for a particular vendor. 4305296, 6137609 RETAIL The price of an item. 11.90, 45.15 COST The price charged by a vendor for an item. 8.51, 44.84 STORE table: Attribute Description Sample values STORE The numerical identifier for any type of Dillard's location. 767, 460 DIVISION The division to which a location is assigned for operational purposes. 07, 04 CITY The city where the store is located. IRVING, MOBILE STATE The state abbreviation where the store is located. MO, AL ZIP_CODE The 5-digit zip code of a store's address. 70601, 35801 ZIP_SECSEG The 4-digit code of a neighborhood within a specific zip code. 5052, 6474
Lab 1-4 Part 2 Objective Questions (@LO 1-1, 1-3, 1-4) OQ1. What tables and fields could address the question of the profit margin (sales price less cost) on each product (SKU) available for sale? OQ2. If you're interested in learning which product is sold most often at each store, which tables and fields would you consider? Page 47 Lab 1-4 Part 2 Analysis Questions (@LO 1-1, 1-3, 1-4) AQ1. You're trying to learn about where Dillard's stores are located to identify locations for the next additional store. Consider the STORE table. What questions could be asked about store location given data availability? AQ2. What questions would you have regarding data fields in the SKU table that could be used to help address the cost of shipping? What additional information would be helpful to address this question?