2002-04-16 12:12:42



Sample HTML Report from Retail case study
 Print

Description
This is a sample HTML Report to demonstrate the abilities of DataScope ^1a href="http://www.cygron.com/DSReporterModule.phtml"^2Reporter Module^1/a^2. Created from the ^1a href="http://www.cygron.com/CaseStudies/CaseStudies.html"^2Retail logistics case study^1/a^2.
Chart sets
 Go top

Introduction
Description
This application performs an analysis of typical sales transaction data.^1br^2 Separate chartsets perform sub-analysis. These are:^1br^2 Market basket Analysis: Analysis of products bought, finding best selling product pairs.
Charts
Sample of the input database

Market basket analysis
Description
This chartset shows the products purchased by the customers who have spend more than $1000 in total.
Charts
num. transactions for top spenders
Cross-sell opportunities
top spenders vs rest
Transactions for given customer

num. transactions for top spenders

Description
Spending patterns among customers who have spent more than $1000 in total. Ladies bags are the most frequently bought product (also the most expensive - bar width shows avg cost) Household items, Ladies shoes and cosmetics (lower priced items) are also frequently bought.


Columns
Division: Transaction - Products
Height: [record count]
Proportion: Transaction - Amount (Real), Average

Filter
top spending customer transactions - Selected

Categories
Ladies Cosmetic
Ladies Wear
Ladies Bag
Ladies Shoes
Mans Shoes
Sports

Ordering
DivisionDefault

Natural Language Description
The discrete category Sports has a small height value relative to the other categories concerning the [record count]. There is 1 big jump among the different categories concerning the height value calculated from [record count]. By this jump the categories can be divided into 2 groups. The number of categories in the groups: 1, 5. The discrete category Ladies Bag has an outstanding proportion value relative to the other categories concerning the numeric column "Transaction - Amount". There is 1 big jump among the different categories concerning the proportion value calculated from numeric column "Transaction - Amount". By this jump the categories can be divided into 2 groups. The number of categories in the groups: 5, 1.
top spenders vs rest

Description
Bars with a high proportion of red show products where the top spenders buy a high amount


Columns
X-division: Transaction - Products
Y-division: top spending customer transactions
Height: [record count]

X Division
Ladies Cosmetic
Ladies Wear
Mans Wear
Household items
Childrens Shoes
Ladies Bag
Ladies Shoes
Childrens Clothes
Mans Shoes
Sports

Y Division
Unselected
Selected

Ordering
X-divisionDefault
Y-divisionDefault

Natural Language Description
There is a weak relation between these two columns: X: "Transaction - Products", Y: "top spending customer transactions", i.e. from the category of a record by the first column, you probably do not conclude the category of the record by the second column.
Cross-sell opportunities

Description
Pairs of products bought by same customer. The tallest bars show the best cross-sell opportunities This chart is best viewed maximized (note: this is not every product pair, but the most popular product for each customers plotted against all other pruchases by same customer)


Columns
X-division: xsell1
Z-division: xsell2
Height: xsell count2 (Real), Average
Color: selected product count (Real), Average

Filter
xsell exclude - Selected

X Division
Childrens Clothes
Childrens Shoes
Household items
Ladies Bag
Ladies Cosmetic
Ladies Shoes
Ladies Wear
Mans Shoes
Mans Wear

Z Division
Childrens Shoes
Household items
Ladies Bag
Ladies Cosmetic
Ladies Shoes
Ladies Wear
Mans Shoes
Mans Wear
Sports

Colors
909
346.2173913043478

Ordering
X DivisionDefault
Z DivisionDefault

Natural Language Description
There is a weak relation between these two columns: X: "xsell1", Z: "xsell2", filtered by: "xsell exclude": "Selected", i.e. from the category of a record by the first column, you probably do not conclude the category of the record by the second column.
Transactions for given customer

Description
Transaction history for the selected customer. To change the selected customer click on the customer ID in the dashboard. (Note: You only need supply the rightmost 5 digits of the customer ID)


Columns
X-value: Transaction - Date (Real)
Y-value: Transaction - Amount (Real)
Color: Transaction - Products

Filter
selected customer flag - true

Categories
Ladies Cosmetic
Ladies Wear
Mans Wear
Household items
Childrens Shoes
Ladies Bag
Ladies Shoes
Childrens Clothes
Mans Shoes
Sports

Ordering
X-valueDefault
Y-valueDefault

Natural Language Description
There is no relation between the displayed parts of the columns "Transaction - Date" and "Transaction - Amount". There are no n/a values in the displayed parts of the colums. The records cannot be grouped by the values of the numeric column assigned to axes in the chart.
Sample of the input database
 Go top

Description
Sample of the input database (joining of two tables: transactions and demographics)

Transaction - Products Customer - Age Transaction - MembershipNo Customer - Children Customer - PostalCode Customer - Sector Code Transaction - Amount Transaction - Date Customer - Education Customer - Locality Customer - MaritalStatus Customer - Nationality Customer - ResidenceOwnership Customer - Occupation Customer - ResidenceType Customer - ResidentialStatus Customer - Sex Transaction - Branch
Ladies Cosmetic 21 45-0101-9912-202073 0 532071 53 80.58 2001-05-13 University Seranggon/Thompson D US Company Owned Manager 4-Room Flat EP F Orchard
Ladies Cosmetic 22 45-0101-9912-201335 2 301330 30 140.56 2001-09-21 University Newton/Bt.Timah/Clementi M JP Rental Manager Condominium EP F Tampines
Ladies Cosmetic 27 44-0202-9912-202060 2 222066 22 137.22 2001-09-21 Diploma Orchard/Tanglin/Holland M JP Rental Admin Exec 4-Room Flat PR F Orchard
Ladies Cosmetic 35 45-0101-9912-201802 2 451808 45 22.51 2001-02-04 University East Coast M SGP Self Owned Engineer Condominium Citizen M Orchard
Ladies Cosmetic 36 45-0101-9912-202039 0 382033 38 137.82 2001-09-21 University Balestier/MacPherson/Geylang S HK Rental Engineer Semi Detached EP F Orchard
Ladies Cosmetic 37 45-0101-9912-202570 0 102572 10 62.88 2001-04-10 University City & South West S JP Family Owned Self Employed 4-Room Flat PR M Orchard
Ladies Cosmetic 52 44-0202-9912-202244 0 532247 53 187.28 2001-11-28 University Seranggon/Thompson M MY Rental General Exec Bungalow EP F Orchard
Ladies Cosmetic 55 44-0202-9912-202120 2 532120 53 127.55 2001-08-19 Diploma Seranggon/Thompson M SGP Self Owned Manager Bungalow Citizen F Tampines
Ladies Wear 25 44-0202-9912-202199 0 642196 64 5.42 2001-01-02 University West & North S MY Company Owned Engineer Condominium EP M Scotts
Ladies Wear 30 44-0202-9912-202398 0 642396 64 101.35 2001-07-16 Diploma West & North S JP Family Owned Engineer Condominium EP M Katong
Ladies Wear 33 44-0202-9912-201908 0 231905 23 190.72 2001-11-29 Diploma Orchard/Tanglin/Holland D US Rental Self Employed Terrace EP F Orchard
Ladies Wear 36 45-0101-9912-202086 0 642087 64 57.44 2001-04-09 University West & North S HK Family Owned General Exec 4-Room Flat EP F Scotts
Ladies Wear 37 44-0202-9912-201256 0 601259 60 62.79 2001-04-10 Diploma West & North S US Self Owned Engineer Condominium PR M Scotts
Ladies Wear 37 45-0101-9912-201843 0 761842 76 151.66 2001-09-23 University West & North D THAI Self Owned Admin Exec 4-Room Flat PR F Scotts
Ladies Wear 38 45-0101-9912-201301 0 791309 79 126.70 2001-08-19 Diploma West & North M SGP Self Owned Admin Exec Terrace Citizen F Scotts
Ladies Wear 44 44-0202-9912-202154 0 352157 35 19.65 2001-02-04 University Balestier/MacPherson/Geylang D SGP Self Owned Engineer Semi Detached Citizen F Katong
Ladies Wear 56 45-0101-9912-201342 2 581343 58 178.72 2001-11-27 Diploma Newton/Bt.Timah/Clementi W PHI Rental Engineer Terrace EP F Scotts
Mans Wear 21 44-0202-9912-201561 0 231564 23 125.99 2001-12-15 University Orchard/Tanglin/Holland S JP Self Owned General Exec Semi Detached PR F Orchard
Mans Wear 21 45-0101-9912-202529 0 602521 60 139.18 2001-09-21 Diploma West & North S JP Company Owned General Exec Condominium EP F Orchard
Mans Wear 23 45-0101-9912-201948 0 641940 64 129.99 2001-12-20 Diploma West & North M JP Self Owned Manager Bungalow PR F Orchard
Mans Wear 24 45-0101-9912-201724 0 791723 79 16.09 2001-02-03 University West & North S JP Rental Self Employed Bungalow PR F Tampines
Mans Wear 29 45-0101-9912-201300 2 601304 60 73.53 2001-05-12 University West & North M SGP Self Owned Self Employed Condominium Citizen M Tampines
Mans Wear 32 45-0101-9912-202484 3 222481 22 113.88 2001-07-17 University Orchard/Tanglin/Holland D JP Rental Self Employed Semi Detached EP F Scotts
Mans Wear 33 44-0202-9912-202209 2 532205 53 34.41 2001-03-06 University Seranggon/Thompson D JP Rental General Exec Bungalow PR F Orchard
Mans Wear 35 44-0202-9912-202027 1 582027 58 172.09 2001-10-26 Diploma Newton/Bt.Timah/Clementi M PHI Self Owned Engineer Terrace PR M Orchard
Mans Wear 37 45-0101-9912-202177 2 232176 23 76.74 2001-05-12 Diploma Orchard/Tanglin/Holland M JP Rental General Exec 4-Room Flat EP M Orchard
Mans Wear 39 45-0101-9912-201467 1 101463 10 113.45 2001-07-17 University City & South West M JP Self Owned Engineer 4-Room Flat PR F Orchard
Mans Wear 48 45-0101-9912-201882 0 601888 60 58.99 2001-04-09 Diploma West & North S THAI Self Owned Admin Exec 4-Room Flat Citizen F Orchard
Mans Wear 56 44-0202-9912-201710 0 761712 76 99.42 2001-06-15 University West & North S AUS Company Owned Manager 4-Room Flat EP F Tampines
Mans Wear 60 45-0101-9912-202338 4 352335 35 116.68 2001-07-18 University Balestier/MacPherson/Geylang M SGP Self Owned Manager Terrace Citizen M Tampines
Household items 33 45-0101-9912-201972 2 601977 60 136.27 2001-08-21 Diploma West & North M JP Rental Manager Semi Detached PR F Scotts
Household items 34 45-0101-9912-201716 2 101718 10 129.24 2001-08-20 University City & South West M JP Rental General Exec 4-Room Flat EP M Katong
Household items 37 44-0202-9912-202554 3 792559 79 148.61 2001-09-23 University West & North M SGP Self Owned Manager Bungalow Citizen F Katong
Household items 44 45-0101-9912-202611 0 382614 38 2.54 2001-01-01 University Balestier/MacPherson/Geylang S JP Rental Self Employed 4-Room Flat PR F Katong
Childrens Shoes 21 44-0202-9912-201317 0 221315 22 154.32 2001-09-23 Diploma Orchard/Tanglin/Holland S THAI Family Owned Manager Bungalow EP F Katong
Childrens Shoes 21 45-0101-9912-201848 0 581846 58 115.64 2001-07-18 University Newton/Bt.Timah/Clementi S SGP Self Owned Engineer Bungalow Citizen M Orchard
Childrens Shoes 25 45-0101-9912-201675 1 531670 53 119.60 2001-08-18 University Seranggon/Thompson M JP Rental Self Employed Bungalow PR F Tampines
Childrens Shoes 26 44-0202-9912-201885 0 231882 23 123.50 2001-08-19 Diploma Orchard/Tanglin/Holland S SGP Self Owned Engineer 4-Room Flat Citizen F Scotts
Childrens Shoes 28 45-0101-9912-202236 0 392230 39 102.90 2001-07-16 University Balestier/MacPherson/Geylang S AUS Self Owned Manager Condominium Citizen F Orchard
Childrens Shoes 32 44-0202-9912-201458 2 581459 58 61.32 2001-04-10 University Newton/Bt.Timah/Clementi M SGP Self Owned Engineer 4-Room Flat Citizen F Tampines
Childrens Shoes 35 44-0202-9912-201506 4 401506 40 28.38 2001-03-05 Diploma Balestier/MacPherson/Geylang M THAI Rental Manager 4-Room Flat EP F Orchard
Childrens Shoes 36 45-0101-9912-201344 1 231346 23 46.79 2001-04-08 University Orchard/Tanglin/Holland D JP Company Owned Manager 4-Room Flat PR F Tampines
Childrens Shoes 36 45-0101-9912-202086 0 642087 64 51.05 2001-04-08 University West & North S HK Family Owned General Exec 4-Room Flat EP F Tampines
Childrens Shoes 37 45-0101-9912-202212 0 582212 58 20.71 2001-02-04 Diploma Newton/Bt.Timah/Clementi M SGP Self Owned Admin Exec Terrace Citizen F Tampines
Childrens Shoes 44 44-0202-9912-201233 1 351234 35 29.80 2001-03-05 Diploma Balestier/MacPherson/Geylang M JP Self Owned Manager 4-Room Flat PR F Tampines
Childrens Shoes 50 45-0101-9912-201490 0 391490 39 9.77 2001-01-02 University Balestier/MacPherson/Geylang M AUS Rental General Exec Semi Detached PR F Tampines
Childrens Shoes 53 45-0101-9912-202081 2 582088 58 9.77 2001-01-02 University Newton/Bt.Timah/Clementi W HK Self Owned Manager Condominium Citizen F Tampines
Childrens Shoes 54 45-0101-9912-202080 1 222088 22 109.28 2001-07-17 University Orchard/Tanglin/Holland M MY Self Owned Engineer Terrace PR F Tampines
Ladies Bag 23 45-0101-9912-202208 2 302208 30 140.61 2001-09-21 University Newton/Bt.Timah/Clementi M US Self Owned Manager 4-Room Flat PR F Scotts
Ladies Bag 24 45-0101-9912-202188 1 762187 76 999.99 2001-06-15 University West & North M US Family Owned General Exec 4-Room Flat PR F Katong
Ladies Bag 26 44-0202-9912-202261 4 222263 22 64.29 2001-04-10 University Orchard/Tanglin/Holland M US Self Owned Manager Condominium PR F Scotts
Ladies Bag 35 45-0101-9912-201802 2 451808 45 119.55 2001-08-18 University East Coast M SGP Self Owned Engineer Condominium Citizen M Scotts
Ladies Bag 36 44-0202-9912-201996 0 101999 10 160.82 2001-10-24 Diploma City & South West S JP Self Owned Engineer Semi Detached PR F Scotts
Ladies Bag 36 45-0101-9912-201344 1 231346 23 101.61 2001-07-16 University Orchard/Tanglin/Holland D JP Company Owned Manager 4-Room Flat PR F Tampines
Ladies Bag 37 44-0202-9912-201981 0 831981 83 250.00 2001-07-16 University West & North S US Company Owned Manager Condominium PR F Katong
Ladies Bag 55 44-0202-9912-201954 0 641954 64 127.36 2001-08-19 University West & North S SGP Self Owned Engineer Bungalow Citizen F Tampines
Ladies Bag 60 44-0202-9912-202435 2 352437 35 87.32 2001-06-14 Diploma Balestier/MacPherson/Geylang M THAI Company Owned General Exec Condominium EP M Scotts
Ladies Shoes 26 44-0202-9912-201660 0 221665 22 47.07 2001-04-08 Diploma Orchard/Tanglin/Holland M SGP Self Owned Self Employed Terrace Citizen F Tampines
Ladies Shoes 31 44-0202-9912-201609 0 641603 64 48.46 2001-04-08 University West & North M JP Rental Engineer 4-Room Flat PR F Orchard
Ladies Shoes 35 44-0202-9912-201286 0 381283 38 150.25 2001-09-23 University Balestier/MacPherson/Geylang S JP Company Owned Self Employed Condominium PR F Tampines
Ladies Shoes 36 45-0101-9912-202086 0 642087 64 113.20 2001-07-17 University West & North S HK Family Owned General Exec 4-Room Flat EP F Tampines
Ladies Shoes 37 44-0202-9912-201256 0 601259 60 129.87 2001-08-20 Diploma West & North S US Self Owned Engineer Condominium PR M Orchard
Ladies Shoes 37 45-0101-9912-202177 2 232176 23 70.94 2001-05-11 Diploma Orchard/Tanglin/Holland M JP Rental General Exec 4-Room Flat EP M Orchard
Ladies Shoes 44 45-0101-9912-202456 0 762459 76 98.07 2001-06-15 University West & North D SGP Self Owned Admin Exec Semi Detached Citizen F Tampines
Ladies Shoes 51 44-0202-9912-201358 1 791355 79 116.71 2001-07-18 University West & North W SGP Self Owned General Exec 4-Room Flat Citizen F Orchard
Ladies Shoes 51 44-0202-9912-202036 1 382038 38 113.52 2001-07-17 University Balestier/MacPherson/Geylang D MY Self Owned Self Employed Bungalow PR F Orchard
Childrens Clothes 21 45-0101-9912-201848 0 581846 58 84.99 2001-06-13 University Newton/Bt.Timah/Clementi S SGP Self Owned Engineer Bungalow Citizen M Scotts
Childrens Clothes 23 44-0202-9912-202025 0 222028 22 187.14 2001-11-28 University Orchard/Tanglin/Holland S PHI Self Owned Engineer Bungalow PR F Scotts
Childrens Clothes 33 44-0202-9912-202209 2 532205 53 171.86 2001-10-26 University Seranggon/Thompson D JP Rental General Exec Bungalow PR F Scotts
Childrens Clothes 34 44-0202-9912-202444 0 532443 53 140.24 2001-09-21 University Seranggon/Thompson S JP Rental Manager Bungalow EP F Tampines
Childrens Clothes 34 45-0101-9912-201716 2 101718 10 156.08 2001-10-24 University City & South West M JP Rental General Exec 4-Room Flat EP M Scotts
Childrens Clothes 36 44-0202-9912-202020 0 392027 39 13.32 2001-02-03 Diploma Balestier/MacPherson/Geylang S JP Self Owned Manager 4-Room Flat PR F Scotts
Childrens Clothes 37 45-0101-9912-202177 2 232176 23 94.04 2001-06-15 Diploma Orchard/Tanglin/Holland M JP Rental General Exec 4-Room Flat EP M Katong
Childrens Clothes 37 45-0101-9912-202212 0 582212 58 80.81 2001-05-13 Diploma Newton/Bt.Timah/Clementi M SGP Self Owned Admin Exec Terrace Citizen F Katong
Childrens Clothes 38 44-0202-9912-202159 1 302157 30 165.74 2001-10-25 University Newton/Bt.Timah/Clementi D SGP Self Owned Admin Exec 4-Room Flat Citizen M Katong
Childrens Clothes 43 44-0202-9912-202028 1 352023 35 69.49 2001-05-11 Diploma Balestier/MacPherson/Geylang D JP Company Owned Manager 4-Room Flat EP M Katong
Childrens Clothes 48 45-0101-9912-202040 3 602041 60 74.77 2001-05-12 Diploma West & North D SGP Self Owned Engineer Semi Detached Citizen F Scotts
Mans Shoes 24 44-0202-9912-202403 0 352406 35 132.48 2001-08-20 Diploma Balestier/MacPherson/Geylang S SGP Self Owned Manager Semi Detached Citizen M Tampines
Mans Shoes 33 44-0202-9912-201545 0 221544 22 84.14 2001-06-13 University Orchard/Tanglin/Holland D JP Self Owned Self Employed Condominium Citizen F Scotts
Mans Shoes 33 44-0202-9912-202231 1 382234 38 39.07 2001-03-07 University Balestier/MacPherson/Geylang M MY Family Owned Engineer 4-Room Flat PR F Katong
Mans Shoes 37 45-0101-9912-202177 2 232176 23 100.83 2001-07-16 Diploma Orchard/Tanglin/Holland M JP Rental General Exec 4-Room Flat EP M Scotts
Mans Shoes 39 45-0101-9912-201898 0 221894 22 54.16 2001-04-09 Diploma Orchard/Tanglin/Holland D THAI Rental Manager Condominium PR F Katong
Mans Shoes 54 45-0101-9912-202080 1 222088 22 125.93 2001-08-19 University Orchard/Tanglin/Holland M MY Self Owned Engineer Terrace PR F Orchard
Sports 30 45-0101-9912-201521 4 231527 23 108.25 2001-07-17 University Orchard/Tanglin/Holland M SGP Self Owned Manager Condominium Citizen M Tampines
Sports 35 44-0202-9912-201286 0 381283 38 169.04 2001-10-25 University Balestier/MacPherson/Geylang S JP Company Owned Self Employed Condominium PR F Orchard
Sports 35 45-0101-9912-201601 0 761606 76 59.56 2001-04-10 University West & North S THAI Self Owned Engineer Bungalow Citizen F Orchard
Sports 36 44-0202-9912-202222 3 792228 79 12.99 2001-01-01 Diploma West & North M PHI Rental Manager 4-Room Flat EP M Orchard
Sports 37 44-0202-9912-202554 3 792559 79 191.54 2001-12-29 University West & North M SGP Self Owned Manager Bungalow Citizen F Orchard
Sports 37 45-0101-9912-202177 2 232176 23 96.48 2001-06-15 Diploma Orchard/Tanglin/Holland M JP Rental General Exec 4-Room Flat EP M Orchard
Sports 54 45-0101-9912-201943 0 401949 40 131.88 2001-08-20 University Balestier/MacPherson/Geylang S MY Family Owned Manager Terrace PR M Orchard

Filter
Sample records - Selected

Natural Language Description
The columns displayed on the Data Sheet are: Transaction - MembershipNo Type: string. Column is an identifier. There is no n/a among 1009 records. Transaction - Products Type: discrete. Column is an identifier. Number of categories: 10 Customer - Age Type: numeric. Without decimal There is no n/a among 1009 records. Customer - Children Type: numeric. Without decimal There is no n/a among 1009 records. Customer - PostalCode Type: numeric. Without decimal There is no n/a among 1009 records. Customer - Sector Code Type: numeric. Without decimal There is no n/a among 1009 records. Transaction - Amount Type: numeric. With 2 decimals There is no n/a among 1009 records. Transaction - Date Type: date. There is no n/a among 1009 records. Customer - Education Type: discrete. Number of categories: 2 Customer - Locality Type: discrete. Number of categories: 7 Customer - MaritalStatus Type: discrete. Number of categories: 4 Customer - Nationality Type: discrete. Number of categories: 8 Customer - ResidenceOwnership Type: discrete. Number of categories: 4 Customer - Occupation Type: discrete. Number of categories: 5 Customer - ResidenceType Type: discrete. Number of categories: 5 Customer - ResidentialStatus Type: discrete. Number of categories: 3 Customer - Sex Type: discrete. Number of categories: 2 Transaction - Branch Type: discrete. Number of categories: 4