Group07 Proposal

Overview

Proposal

Report

Poster

Application

All Projects

Project Background

Introduce the project background. Talk about QVC and its business.

Project Motivation

Why do we want to do this project using this data set?

Project Objectives

What do we aim to achieve in this project, and what objectives should we meet to fulfill the aim?

Project Scope

What do we want to do with this data set?

Dataset Overview

Datasets are extracted from http://ibit.temple.edu/analytics/can-small-independent-pharmacies-compete-with-the-big-chains/
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

Deliverables are: R Shiny web application, research paper, poster, presentation and artifacts

Schedule

Project schedule