6202009

1
PROFESSOR  Dr. Hsinchun Chen 

• Yulei (Gavin) Zhang
• Yan (Mandy) Dang
• Chang Heon Lee (Heon)

Spring, 2007
2
Agenda
1. Why Smart Gift Card?
2. Market Analysis
3. Business Model
4. System Architecture
5. APIs Data Mining
6. Novelty
7. System Screenshots
8. Tools
2
3
1. Why Smart Gift Card?
The number of customers buying gift cards is
increasing.
Source COMDATA Payment Innovation (2007)
4
1. Why Smart Gift Card?
Market Analysis
For Buyers
For Sellers
5
2. Market Analysis

• Statistical Analysis Data Mining
• Weekly/Monthly transaction analysis
• Market share by category and brand
• Price Analysis (based on category and brand)
• Average actual price and selling price
• Average discount rate
• Market share
• Active Seller Hot Item Analysis
• Associate network used to identify active sellers
  with their items
• Find top sellers in a certain brand
• Popular items
• Topic (Brand) Analysis
• SOMs used to find an interesting brand pattern
  information

6
3. Business Model

• Advertising Opportunity (80 Revenue)
• Partnership with EBay and others
• Membership Fee (20 Revenue)
• Monthly membership fee 2
• Annual membership fee 10
• Extend our service to other products

7
4. System Architecture
Tomcat Server
MS SQL Server 2000
JSP

• APIs
• EBay APIs
• Google Map APIs

Smart Gift Card DB
Smart Gift Card Interface
8
5. APIs Data Mining
APIs
Data Mining
Visualization
9
6. Novelty
10
7. System Screenshots
Main function page
Link to each function
11
Market Analysis whole market analysis
Click to see the exact amount
12
Market Analysis market share analysis
Click to see the exact amount
13
Market Analysis category analysis
Choose a category
14
Market Analysis brand analysis
Choose a brand
15
Market Analysis emerging topics

• Hot Topics during April 8 April 15, 2007

• Hot Topics during April 16 April 22, 2007

16
Analysis for Buyers search
Go to the original EBay item page
17
Analysis for Buyers Price Analysis
18
Analysis for Buyers hot item analysis

• Each circle in the graph represents an active
  item in the database.
• The label of the circle is the item title.
• The bigger the circle and the label of circle,
  the hotter the item.
• Items are clustered together based on the brand
  information.

• Hot Topics during April 15 April 22, 2007

• Hot Topics during April 22 April 29, 2007

19
Analysis for Sellers top sellers analysis
20
Analysis for Sellers active sellers analysis

• Each circle in the graph represents an item in
  the database.
• The label of the circle is the item title.
• The bigger the circle and the label of circle,
  the hotter the item.
• Each blue up-triangle represents a seller.
• Items from the same sellers connect together.
• Only the sellers who are selling more than two
  items are shown in the graph.

• Active Sellers during April 15 April 22, 2007

• Active Sellers during April 22 April 29, 2007

21
8. Tools

• APIs
• EBay API
• http//developer.ebay.com/
• Google Map API
• http//code.google.com/apis/maps/index.html
• Programming Software NetBeans
• Download NetBeans IDE J2SE SDK
• http//download.netbeans.org/netbeans/6.0/final/

22

• Self-Organizing Map
• We used the multi-level self-organizing map
  algorithm developed by AI Lab at the University
  of Arizona.
• Association Network
• NetDraw
• http//www.analytictech.com/downloadnd.htm

node data "ID", num "10 Gift Card off REGIS
SALON (SALON SERVICES) E" 2 "10 iTunes Gift
Certificate exp 9/2008" 2 "10 STARBUCKS gift
CARD CERTIFICATE" 3 "10 Target Gift
Card" 3 "10.00 iTunes Music Gift Card - Free
Shipping" 2 "100 Best Buy Gift Card" 15 "100
Gap Gift Card - FREE Shipping" 9
Tie data FROM TO "Strength" "Home Depot Gift
Card 500." "100 Home Depot Gift Card Accepted
Nationwide" 1 " 250 Best Buy GiftCard Gift
Card Gift Certifica" "25 Best Buy Gift Card for
Store or Online!" 1 "50 Bed Bath Beyond Gift
Card - FREE SHIPPING!" "200 Cost Plus World
Market Gift Card 4 Jewelry Be" 1 "500.00 Best
Buy gift certificate" "15 Best Buy Gift Card
Free Shipping" 1 "25 Best Buy Gift Card for
Store or Online!" "15 Best Buy Gift Card Free
Shipping" 1 "Bath and Body Works 25 Gift
Card" "200 Cost Plus World Market Gift Card 4
Jewelry Be" 1
NetDraw file format example
23

• Applet Based Graphing and Charting
• jPOWERED.com
• http//www.jpowered.com/
• It offers advanced graphing and charting
  functionality for Java Applet, Servlet, CSS,
  JavaScript PHP.
• It has free trial version and license version
  from 195 to 4,945.
• Download at
• http//www.jpowered.com/downloads.htm

24
Example code
archive"Linegraph.jar" width"330"
height"260" Chart - Please Wait." value"000060" value"FFFFFF" name"data1series1" value"82000" name"data2series1" value"60000" name"data3series1" value"35000"
value"65000" name"autoscale" value"false" name"chartScale" value"10000" name"chartStartY" value"0" name"legend" value"true" name"legendfont" value"Arial,N,10" ARAM name"title" value"Value of
Sales-1,-1Arial,B,145555FF" name"xtitle" value"2004-1,-1Aria
l,B,125555FF" value"Arial,N,10" value"Arial,N,10" value"January" name"label2" value"February" AM name"label3" value"March" AM name"label4" value"April"
value"December"
25
Thanks!?