Difference between revisions of "Group07 Proposal"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 41: Line 41:
 
<div style="border-style: solid; border-width:0; background: #0099ff; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Project Scope</font></div>
 
<div style="border-style: solid; border-width:0; background: #0099ff; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Project Scope</font></div>
  
−
Our project consists of the following components:
+
What do we want to do with this data set?
−
# Data cleaning and preparation: We need to remove invalid records from the dataset. We also need to prepare the dataset in a way that allows the plotting of network graphs.
+
 
 
<br>
 
<br>
  
 
<div style="border-style: solid; border-width:0; background: #0099ff; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Dataset Overview</font></div>
 
<div style="border-style: solid; border-width:0; background: #0099ff; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Dataset Overview</font></div>
  
−
Describe the dataset
+
 
 +
Datasets are extracted from <b>http://ibit.temple.edu/analytics/can-small-independent-pharmacies-compete-with-the-big-chains/</b><br>
 +
<div style="
 +
Metadata <br>
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
|
 +
<b>Variable</b>
 +
||
 +
<b>Description</b>
 +
|-
 +
|
 +
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
 +
|-
 +
|}
 +
<!-- END OF DATA SOURCES--->
 +
 
  
 
<br>
 
<br>
Line 53: Line 246:
 
<div style="border-style: solid; border-width:0; background: #0099ff; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Deliverables</font></div>
 
<div style="border-style: solid; border-width:0; background: #0099ff; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #ffffff>Deliverables</font></div>
  
−
At the end of this project, we will submit the following deliverables:
+
Deliverables are: R Shiny web application, research paper, poster, presentation and artifacts
−
* R-Shiny web application of the visualization tool
 
−
* Research paper
 
−
* Project poster
 
−
* Project artifacts
 
  
 
<br>
 
<br>

Revision as of 18:03, 15 June 2018

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/
<div style=" 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


Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=Group07_Proposal&oldid=835’