E-Commerce Dashboard

1
E-Commerce Dashboard

• By Wilson Tsang
• HungJu Tze
• Thesis Supervisor Professor Mark S. Fox

2
Overview

• Introduction
• Analysis
• Design
• Implementation
• Future Development
• Conclusion

3
Background
Industry Generated Revenue (US )
Automobile 350 billion
E-Commerce 300 billion
Energy 223 billion
Telecommunication 270 billion

• The growth of e-Commerce activities has been
  phenomenal and is expected to increase even
  further

4
Motivation

• While a classic website could survive with 95
  availability, an E-Commerce solution could hardly
  last with a few hour of downtime in a week
• Accurate measurement of e-Commerce Websites
  performance is needed in order to make
  E-retailers profitable

5
Thesis Objectives

• The E-Commerce dashboard is developed to do
  performance measurements
• This will enable e-retailer to
• Review strategies
• Spot abnormal state of website immediately
• Restructuring their operations with trading
  partners
• Become profitable and viable

6
Industrial Partner

• Novator.com is the E-commerce solution provider
• FTD.com is a website which sells flowers and
  gifts on the internet
• E-commerce dashboard will be developed for both
  of them to measure performance of the website

7
Existing Solution
8
Problems with Existing Solution

• Poor structure of content
• Information is not organized
• Interpretation is needed to understand the
  information
• The key performance indicators (KPIs) offered is
  insufficient for the E-Commerce situation

9
Requirements

• Provide an intuitive interface by using EID
  (Ecological Interface Design) technique
• Provide an interface that the user can spot any
  abnormal state in the E-Commerce quickly
• Develop new KPIs based on the nature of
  E-Commerce environment to enhance the measurement
  of business performance

10
Work Domain Analysis

• Define system boundary
• Construct the system model
• Derive information requirement from the system
  model

11
Key Performance Indicators

• Visitor
• Order
• Revenue
• Conversion rate
• Average order value
• Average time spent
• Shopping carts abandon
• Customer visit frequency
• Popular product

12
Prototype Design
13
User Evaluation of Prototype

• Too much information shown.
• Historical data should be added as a frame of
  reference.
• More gadgets can be shown instead of tables.

14
New KPIs

• Customer order frequency
• Most accessed product
• Most purchased product

15
Final Design
16
Implementation I

• Java and XML technology is chosen
• Java is
• Portable
• Object oriented
• Easy to learn

17
Implementation II

• Functionalities
• Reads required data from XML file
• Processes data and transforms data into relevant
  information
• Generates tables and graphs to display
  information in HTML form

18
Future Development

• Ticktack Bar
• Measuring Product Brand Value

19
Conclusion

• Lack of performance measurement of e-Commerce
  Website often translates into lost revenues and
  customers
• E-Commerce Dashboard will enable E-Retailer gain
  better understanding of their e-Commerce strategy
  and gain more profit

20
Thanks for your attention!

• Questions???