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>
  
−
What do we want to do with this data set?
+
Our project consists of the following components:
−
 
+
# 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>
 
−
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 245: Line 53:
 
<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>
  
−
Deliverables are: R Shiny web application, research paper, poster, presentation and artifacts
+
At the end of this project, we will submit the following deliverables:
 +
* R-Shiny web application of the visualization tool
 +
* Research paper
 +
* Project poster
 +
* Project artifacts
  
 
<br>
 
<br>

Revision as of 18:02, 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

Our project consists of the following components:

  1. 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.


Dataset Overview

Describe the dataset


Deliverables

At the end of this project, we will submit the following deliverables:

  • R-Shiny web application of the visualization tool
  • Research paper
  • Project poster
  • Project artifacts


Schedule

Project schedule


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