Group07 Proposal
|
|
|
|
|
|
|
Introduce the project background. Talk about QVC and its business.
Why do we want to do this project using this data set?
What do we aim to achieve in this project, and what objectives should we meet to fulfill the aim?
What do we want to do with this data set?
Datasets are extracted from http://ibit.temple.edu/analytics/can-small-independent-pharmacies-compete-with-the-big-chains/
All 6 data sets with 36 columns were in CSV format, total number of rows after joining data sets - 4,680,635 rows.
Metadata
|
Variable |
Description |
|
Sales_Order_Nbr |
Unique identifier for a given transaction |
|
Sales_Order_Line_Nbr |
Unique sub-identifier for a given transaction |
|
Package_Id |
ID code used to identify a specific box or package |
|
Order_Dt |
Date the transaction was placed |
|
Party_Id |
Unique identifier for an individual or organization |
|
Order_Type_Cd |
Code used to the type of Order |
|
Shipping_Priority_Ind |
Indicator used to indicate if order will be fulfilled with prioritized shipping (e.g. Overnight) |
|
Total_Line_Amt |
Total amount owed for the specific order line |
|
Unit_Price_Amt |
Merchandise price for the specific line |
|
Line_Status_Cd |
Status of the specific order line (refer to status reference sheet) |
|
Line_Status_Dt |
Date the specific order line was set to the current status |
|
Product_Id |
Unique identifier for an item presented for purchase (e.g. The number seen on TV) |
|
Skn_Id |
Internal ID used for back office purposes |
|
Sku_Id |
Unique ID used to denote a Product's specifics (e.g. specific color and size) |
|
Color_Desc |
Description of the color |
|
Size_Desc |
Description of the size |
|
Shipped_Dt |
Date the order line was shipped (left QVC's warehouse) |
|
Source_Ship_Warehouse_Nbr |
Unique identifier denoting the warehouse where the product is shipped from |
|
Assigned_Dc_Id |
Distribution center assigned to order at time of creation |
|
Cancelled_Qty |
Number of units cancelled |
|
Ordered_Qty |
Number of units requested by customer |
|
Shipped_Qty |
Number of units shipped to customer |
|
Merchandise_Div_Desc |
Description of Merchandise Division |
|
Merchandise_Dept_Desc |
Description of Merchandise Department |
|
Carrier_Used_Tracking_Id |
ID used to denote a unique package shipment |
|
Shipment_Status_Dt |
The most recent date of the shipment's status |
|
Pickup_Dt |
Date the package was picked up by the carrier from QVC |
|
Scheduled_Delivery_Dt |
Date the package is believed to arrive |
|
Rescheduled_Delivery_Dt |
Revised date the package is believed to arrive |
|
Package_Scan_Dttm |
Date the last time the package was scanned along its journey |
|
Package_Cnt |
Number of packages associated with a specific order line |
|
Actual_Total_Package_Qty |
Number of packages associated with a specific order line (post any consolidation) |
|
Delivery_Confirmation_Dt |
Date the package was delivered to the consumer |
|
SHIP_TO_CITY |
City the package was delivered to |
|
SHIP_TO_STATE |
State the package was delivered to |
|
SHIP_TO_ZIP |
Zip Code the package was delivered to |
Deliverables are: R Shiny web application, research paper, poster, presentation and artifacts
Project schedule
