HeaderSIS.jpg

Difference between revisions of "2012T2 Team Chm: Project Design"

From IS480
Jump to navigation Jump to search
 
(201 intermediate revisions by 4 users not shown)
Line 5: Line 5:
  
  
<div style="text-align: left;"><span style="font-family: 'Verdana'; font-size: 33pt; letter-spacing:-0.1em; line-height:80%; color:black; text-transform:uppercase">&nbsp;Project Design</span></div><br>
+
<center><div style="text-align: center;"><span style="font-family: 'Trebuchet MS'; font-size: 48pt; letter-spacing:-0.1em; line-height:80%; color:black;">&nbsp;[[Image:chmlogo.jpg|75px]]  "because there is no <span style="font-size: 64pt; font-family:'Times New Roman'">I</span> in the team"</span></div><br></center>
  
 
<div style="border-bottom: #ffffff solid 12px; padding: 0px 0px 0px 0px;">
 
<div style="border-bottom: #ffffff solid 12px; padding: 0px 0px 0px 0px;">
Line 14: Line 14:
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
  
| style="padding:0 .3em;font-face:Verdana;  font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; background-color:#ffffff; " width="12%" | [[2012T2 Team Chm: Team & Stakeholders |<font color=" #2d2d2d">Team & Stakeholders</font>]]
+
| style="padding:0 .3em;font-face:Verdana;  font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; background-color:#ffffff; " width="11%" | [[2012T2 Team Chm: Team & Stakeholders |<font color=" #2d2d2d">Team & Stakeholders</font>]]
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
  
| style="padding:0 .3em;font-face:Verdana;  font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; background-color:#ffffff; " width="12%" | [[2012T2 Team Chm: Project Definition |<font color=" #2d2d2d">Project Definition</font>]]
+
| style="padding:0 .3em;font-face:Verdana;  font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; background-color:#ffffff; " width="11%" | [[2012T2 Team Chm: Project Definition |<font color=" #2d2d2d">Project Definition</font>]]
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
  
| style="padding:0 .3em;font-face:Verdana; background-color:#2d2d2d; font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; color:#2d2d2d" width="12%" | [[2012T2 Team Chm: Project Design |<font color=" #ffffff">Project Design</font>]]
+
| style="padding:0 .3em;font-face:Verdana; background-color:#2d2d2d; font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; color:#000000" width="11%" | [[2012T2 Team Chm: Project Design |<font color=" #ffffff">Project Design</font>]]
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
  
| style="padding:0.3em;font-face:Verdana; font-size:110%; background-color:#ffffff;  border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; color:#000000" width="12%" | [[2012T2 Team Chm: Project Management |<font color=" #2d2d2d">Project Management</font>]]
+
| style="padding:0.3em;font-face:Verdana; font-size:110%; background-color:#ffffff;  border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; color:#000000" width="11%" | [[2012T2 Team Chm: Project Management |<font color=" #2d2d2d">Project Management</font>]]
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
  
| style="padding:0 .3em;font-face:Verdana; background-color:#ffffff; font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d;  text-align:center; color:#000000" width="12%" | [[2012T2 Team Chm: Progress Summary |<font color=" #2d2d2d">Progress Summary</font>]]
+
| style="padding:0 .3em;font-face:Verdana; background-color:#ffffff; font-size:110%; border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d;  text-align:center; color:#000000" width="11%" | [[2012T2 Team Chm: Progress Summary |<font color=" #2d2d2d">Progress Summary</font>]]
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
 
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
  
| style="padding:0.3em;font-face:Verdana; font-size:110%; background-color:#ffffff;  border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; color: #000000" width="12%" | [[2012T2 Team Chm: Learning Outcomes |<font color=" #2d2d2d ">Learning Outcomes</font>]]
+
| style="padding:0.3em;font-face:Verdana; font-size:110%; background-color:#ffffff;  border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; color: #2d2d2d" width="11%" | [[2012T2 Team Chm: Learning Outcomes |<font color=" #2d2d2d ">Learning Outcomes</font>]]
 +
| style="border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; background:none;" width="2%" | &nbsp;
 +
 
 +
| style="padding:0.3em;font-face:Verdana; font-size:110%; background-color:#ffffff;  border-bottom:2px solid  #2d2d2d; border-top:2px solid  #2d2d2d; text-align:center; color: #2d2d2d" width="11%" | [[2012T2 Team Chm: Photos |<font color=" #2d2d2d ">  Photos  </font>]]
 
|}
 
|}
  
Line 35: Line 38:
 
<div style="border-right: #ffffff solid 12px; padding: 0px 0px 0px 0px;">
 
<div style="border-right: #ffffff solid 12px; padding: 0px 0px 0px 0px;">
  
 +
<br>
 +
 +
<big><p style="text-align: left; font-size: 150%;"><center>
 +
[[IS480_Team_wiki:_2012T2_Team_Chm_MidTerm_Wiki|<font color="#000000" face=""><ins>''' MID-TERM WIKI'''</ins></font>]]   
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
[[IS480_Team_wiki:_2012T2_Team_Chm_Final_Wiki|<font color="#000000" face=""><ins>''' FINAL WIKI'''</ins></font>]]
 +
 +
</center></p></big>
 +
 +
== Project Scope ==
 +
 +
<p>
 +
For more detailed information regarding the various project tasks, please click [[https://docs.google.com/spreadsheet/ccc?key=0AgEVT7COZGKGdDA5cFlXVEMxZVY3Qjc4R29kbnRlTkE#gid=2  here]]
 +
</p>
 +
 +
{| class="wikitable" style="text-align: center; height:50px"
 +
|+
 +
|-
 +
! scope="col"  width="50"| Sceenshots
 +
! scope="col"  width="150"| Feature
 +
! scope="col" width="400" | Description
 +
|-
 +
 +
!scope="row" colspan="3" style="background-color:#000000; text-align: left;"|
 +
'''&nbsp;<font color="#FFFFFF">Core Features</font>'''
 +
|-
 +
 +
! scope="row" |[[Image:CheckOutCart.gif|100px]]
 +
|style="text-align: center;"|'''Checkout Cart'''
 +
|style="text-align: left;"|
 +
*User can checkout products that he has selected
 +
*User can see the Purchase summary of the products he has selected and the coupons he can use
 +
*User is shown confirmation message after purchase of products
 +
|-
 +
 +
! scope="row" |[[Image:coupon.gif|100px]]
 +
|style="text-align: center;"|'''Manage Coupons'''
 +
|style="text-align: left;"|
 +
*User can view the coupon(s) he currently has
 +
*User can use the coupon(s) on products he wishes to purchase
 +
|-
 +
 +
! scope="row" |[[Image:Profiles.jpg|100px]]
 +
|style="text-align: center;"|'''Manage Profiles'''
 +
|style="text-align: left;"|
 +
*User can view his profile and his friend's profiles
 +
*User can edit his own profile
 +
|-
 +
 +
! scope="row" |[[Image:Campaigns.png|100px]]
 +
|style="text-align: center;"|'''Manage Campaigns'''
 +
|style="text-align: left;"|
 +
*Marketing Professionals can view Campaigns they have created
 +
*Marketing Professionals can create Campaigns
 +
*Marketing Professionals can design Campaigns
 +
|-
 +
 +
! scope="row" |[[Image:Hook.jpg|100px]]
 +
|style="text-align: center;"|'''Manage Hooks'''
 +
|style="text-align: left;"|
 +
*Marketing Professionals can create hooks
 +
*Marketing Professionals can design coupon hooks
 +
*Marketing Professionals can design social messages hooks
 +
*Marketing Professionals can view hooks available
 +
|-
 +
 +
! scope="row" |[[Image:Insight.jpg|150px]]
 +
|style="text-align: center;"|'''Manage Insights'''
 +
|style="text-align: left;"|
 +
*Marketing Professionals can choose data source Transaction Records/Campaign data for analysis
 +
*Marketing Professionals can choose the chart type
 +
*Marketing Professionals can view graph created by the analysis
 +
|-
 +
 +
!scope="row" colspan="3" style="background-color:#000000; text-align: left;"|
 +
'''&nbsp;<font color="#FFFFFF">Good-to-Have Features'''</font>
 +
|-
 +
 +
! scope="row" |[[Image:Couponstack.jpg|100px]]
 +
|style="text-align: center;"|'''Ranking of Campaigns/Coupons/Hooks' Revenues'''
 +
|style="text-align: left;"|
 +
*Marketing Professionals can see coupons/hooks popularity in the campaigns and its according revenues
 +
|-
 +
 +
! scope="row" |[[Image:Wish-list1.png|100px]]
 +
|style="text-align: center;"|'''Manage Wishlist'''
 +
|style="text-align: left;"|
 +
*User can view his own wishlist
 +
*User can view his friend's wishlist
 +
*User can add products into his wishlist
 +
*User can share wishlist on Facebook
 +
|-
 +
 +
! scope="row" |[[Image:Drilling-down-into-keywords.jpg|100px]]
 +
|style="text-align: center;"|'''Recursive Drilldown'''
 +
|style="text-align: left;"|
 +
*Marketing Professionals can drill down/up Charts by clicking on a particular part of the chart
 +
|-
  
 +
! scope="row" |[[Image:Optimization.png|100px]]
 +
|style="text-align: center;"|'''Coupon Optimization'''
 +
|style="text-align: left;"|
 +
*Consumers can now see which coupons are best used on which products when they purchase items
 +
|-
  
===<div style="font-family:'Century Gothic'; font-size:20px; background: #2d2d2d; padding:14px; font-weight:bold; line-height:0.1em;"><font color = "white">Learning Outcomes</font></div>===
+
! scope="row" |[[Image:Annotate.gif|150px]]
 +
|style="text-align: center;"|'''Diagram Annotations'''
 +
|style="text-align: left;"|
 +
*Marketing Professionals can now add Annotations to Diagrams
 +
|-
  
 +
|}
  
 +
<b>Old Use Cases</b>
 +
*Version 1
 +
:*[https://wiki.smu.edu.sg/w/is480/images/8/8f/Consumer_Use_Case.PNG Consumer Use Cases]
 +
:*[https://wiki.smu.edu.sg/w/is480/images/3/34/Marketing_Professional_Use_Case_2.png Marketing Professional Use Cases]
 +
*Version 2
 +
:*[https://wiki.smu.edu.sg/w/is480/images/0/08/Corefunctions2.jpg Project Use Cases]
  
 
== UI ==
 
== UI ==
  
  {| class="wikitable"
+
<gallery caption="Consumer UI Thumbnails" heights="150px" widths="226px">
 +
Image:ChmHomePage1.png | 1. Home Page
 +
Image:ChmProductPage1.png | 2. Product Page
 +
Image:ChmCheckoutPage1.png | 3. CheckOut Page
 +
Image:ChmPurchaseSummary1.png | 4. Purchase Summary
 +
Image:ChmPurchaseSummary2.png | 5. Purchase Summary 2
 +
Image:ChmViewCoupons1.png | 6. View Coupons
 +
Image:ChmViewProfilePage1.png | 7. View Profile Page
 +
Image:ChmViewWishlist1.png | 9. View Wish list
 +
</gallery>
 +
 
 +
<gallery caption="Marketing Professionals UI Thumbnails" heights="150px" widths="226px">
 +
Image:BI_HomePage.png | 10. View BI Home Page
 +
Image:BI_Campaign.png | 11. View All Campaigns
 +
Image:BI_CreateCampaign.png | 12. Create Campaign
 +
Image:BI_DesignCampaign.png | 13. Design Campaign
 +
Image:BI_Hooks.png | 14. View Hook
 +
Image:BI_CreateCouponHook.png | 15. Create Coupon Hook
 +
Image:BI_CreateSocialHook.png | 16. Create Social Message Hook
 +
Image:BI_DesignCouponHook.png | 17. Design Coupon Hook
 +
Image:BI_DesignSocialHook.png | 18. Design Social Message Hook
 +
Image:BI_ChooseData.png | 19. Choose Data Source
 +
Image:BI_CampaignData.png | 20. Campaign Data
 +
Image:BI_TransactionRecords.png | 21. Transaction Records
 +
Image:BI_SocialHookData.png | 22. Choose Graph Type
 +
Image:BI_ViewGraph.png | 23. View Graph
 +
Image:BI_Drilldown.png | 24. Drill-down Interactivity
 +
Image:BI_Quantification.png | 25. Social Influence Quantification Display
 +
</gallery>
 +
 
 +
<br />
 +
[https://wiki.smu.edu.sg/is480/2012T2_Team_Chm:_Project_Design_UI_Archive Old UI Thumbnails]
 +
<br />
 +
  <!-- {| class="wikitable"
 
| <center>'''Use Cases''' </center>
 
| <center>'''Use Cases''' </center>
 
| <center>'''S/N'''</center>
 
| <center>'''S/N'''</center>
Line 73: Line 223:
 
|-
 
|-
 
|-
 
|-
!rowspan="2" | Manage Profiles
+
!rowspan="1" | Manage Profiles
 
| <center>'''7'''</center>
 
| <center>'''7'''</center>
 
| View Profile Page || [[https://www.dropbox.com/s/fueleij66i097f5/ProfilePage_Consumer.pptx link]]  
 
| View Profile Page || [[https://www.dropbox.com/s/fueleij66i097f5/ProfilePage_Consumer.pptx link]]  
|-
 
|<center>'''8''' </center>
 
| Create Profile Page || Pending
 
 
|-
 
|-
 
|-
 
|-
 
!rowspan="1" | Manage wish list
 
!rowspan="1" | Manage wish list
| <center>'''18'''</center>
+
| <center>'''9'''</center>
 
| View Wish List || [[https://www.dropbox.com/s/ahsdvs4wqjfxaoc/Wishlist%20Page.pdf link]]
 
| View Wish List || [[https://www.dropbox.com/s/ahsdvs4wqjfxaoc/Wishlist%20Page.pdf link]]
 
|-
 
|-
Line 88: Line 235:
 
|-
 
|-
 
!rowspan="1" | View BI HomePage
 
!rowspan="1" | View BI HomePage
| <center>'''9'''</center>
+
| <center>'''10'''</center>
 
| View BI HomePage || [[https://www.dropbox.com/s/i7hy141bo5mlovp/BI%20HomePage%20%281%29.pdf link]]  
 
| View BI HomePage || [[https://www.dropbox.com/s/i7hy141bo5mlovp/BI%20HomePage%20%281%29.pdf link]]  
 
|-
 
|-
 
|-
 
|-
 
!rowspan="3" | Manage Campaigns  
 
!rowspan="3" | Manage Campaigns  
| <center>'''10'''</center>
+
| <center>'''11'''</center>
 
| View All Campaigns || [[https://www.dropbox.com/s/4xqrx123lf4zs2c/Create%20Campaign.pdf link]]
 
| View All Campaigns || [[https://www.dropbox.com/s/4xqrx123lf4zs2c/Create%20Campaign.pdf link]]
 
|-  
 
|-  
|<center>'''11''' </center>
+
|<center>'''12''' </center>
 
| Create Campaign || [[https://www.dropbox.com/s/144jb3t7tykv3qp/Create%20Campaign2.pdf link]]
 
| Create Campaign || [[https://www.dropbox.com/s/144jb3t7tykv3qp/Create%20Campaign2.pdf link]]
 
|-  
 
|-  
|<center>'''12''' </center>
+
|<center>'''13''' </center>
 
| Design Campaign || [[https://www.dropbox.com/s/jtst16xwxaeplog/Edit%20Campaign.pdf link]]
 
| Design Campaign || [[https://www.dropbox.com/s/jtst16xwxaeplog/Edit%20Campaign.pdf link]]
 
|-
 
|-
 
|-
 
|-
 
!rowspan="5" | Manage Hook
 
!rowspan="5" | Manage Hook
| <center>'''13'''</center>
+
| <center>'''14'''</center>
 
| View Hook|| [[https://www.dropbox.com/s/aqp1r5z8vu0xfrj/View%20List%20of%20Hooks.pdf link]]
 
| View Hook|| [[https://www.dropbox.com/s/aqp1r5z8vu0xfrj/View%20List%20of%20Hooks.pdf link]]
 
|-  
 
|-  
|<center>'''14''' </center>
+
|<center>'''15''' </center>
 
| Create Coupon Hook || [[https://www.dropbox.com/s/l8ml4k6nn9e76oa/Create%20Coupon%20Hook.pdf link]]
 
| Create Coupon Hook || [[https://www.dropbox.com/s/l8ml4k6nn9e76oa/Create%20Coupon%20Hook.pdf link]]
 
|-
 
|-
|<center>'''15''' </center>
+
|<center>'''16''' </center>
 
| Create Social Message Hook || [[https://www.dropbox.com/s/2x83js0ky0qjr6d/Create%20Social%20Message%20Hook.pdf link]]
 
| Create Social Message Hook || [[https://www.dropbox.com/s/2x83js0ky0qjr6d/Create%20Social%20Message%20Hook.pdf link]]
 
|-
 
|-
|<center>'''16''' </center>
+
|<center>'''17''' </center>
 
| Design Coupon Hook || [[https://www.dropbox.com/s/0smdh7hmj1ykumv/Design%20Coupon%20Hook.pdf link]]
 
| Design Coupon Hook || [[https://www.dropbox.com/s/0smdh7hmj1ykumv/Design%20Coupon%20Hook.pdf link]]
 
|-
 
|-
|<center>'''17''' </center>
+
|<center>'''18''' </center>
 
| Design Social Message Hook || [[https://www.dropbox.com/s/mogukefwk89t0pw/Design%20Social%20Messages%20Hook.pdf link]]
 
| Design Social Message Hook || [[https://www.dropbox.com/s/mogukefwk89t0pw/Design%20Social%20Messages%20Hook.pdf link]]
 
|-
 
|-
 
|-
 
|-
!rowspan="5" | Manage Insights
+
!rowspan="6" | Manage Insights
 
| <center>'''19'''</center>
 
| <center>'''19'''</center>
 
| Choose Data Source || [[https://www.dropbox.com/s/6q7mhv6q22c3tt3/ChooseDataSource.pdf link]]
 
| Choose Data Source || [[https://www.dropbox.com/s/6q7mhv6q22c3tt3/ChooseDataSource.pdf link]]
Line 136: Line 283:
 
| View Graph || [[https://www.dropbox.com/s/fgmt0fsj3rrl61a/ViewGraph.pdf link]]
 
| View Graph || [[https://www.dropbox.com/s/fgmt0fsj3rrl61a/ViewGraph.pdf link]]
 
|-
 
|-
 +
|<center>'''24''' </center>
 +
| View Campaign Results || [[https://www.dropbox.com/s/9hqapry3hgupgxk/end%20Campaign.pdf link]]
 
|-
 
|-
 +
|-
 +
|} -->
 +
 +
[https://www.dropbox.com/s/0zsbus0pz7noo4y/Chm_UI_Scenarios.pdf Business Scenario Writeup]
 +
 +
== Work Process Flow ==
 +
 +
{|
 +
| [[Image: ConsumerProcessFlow1.png|500px]]
 +
| [[Image: BIProcessFlow.png|500px]]
 +
|}
 +
 +
{|
 +
| [[Image: CouponProcess.png|500px]]
 +
| [[Image: CreateCampaignProcess.png|500px]]
 +
|}
 +
 +
{|
 +
| [[Image: WishListProcess.png|500px]]
 +
| [[Image: CreateHooks.png|500px]]
 
|}
 
|}
  
== Diagrams ==
+
==Magento Framework & ER Diagram ==
''Coming Soon!''
+
<p><font size="3"> '''Magento Framework''' </font></p>
 +
[[Image:MagentoFramework1.png]]
 +
<br><br>
 +
<p><font size="3"> '''Magento EAV Database Diagram''' </font></p>
 +
Click [https://www.dropbox.com/s/udrbdmeic3tfcie/MobisupermarketERDiagram.png here] for a better view of the database
 +
 
 +
[[Image:Magentodatabase2.png]]
 +
 
 +
<!-- [[Image:Consumer.png]] -->
 +
 
 +
== Server Architecture & Resources ==
 
<br />
 
<br />
 
+
<p>Team Chm would like to thank and reference the following people, resources for the invaluable feedback/information given in this project:</p>
== Resources ==
+
[[Image:Serverarchitecture.png|thumb|500x500px|Server Architecture Layers]]
<p>Team Chm would like to thank the following people, resources for the invaluable feedback/information given in this project;</p>
 
 
{| class="wikitable" style="text-align: left; height:200px"
 
{| class="wikitable" style="text-align: left; height:200px"
 
|+  
 
|+  
Line 158: Line 336:
 
! scope="row" style="background: #C0C0C0"| Development
 
! scope="row" style="background: #C0C0C0"| Development
 
||
 
||
*'''Development Environment:''' [http://www.mamp.info/en/index.html/ MAMPServer] [http://www.wampserver.com/en/ WAMPServer], [http://netbeans.org/ Netbeans], [http://tortoisesvn.net/ Subversion]
+
*'''Development Environment:''' [http://www.mamp.info/en/index.html/ MAMPServer] [http://www.wampserver.com/en/ WAMPServer],[http://tortoisesvn.net/ Subversion]
*'''Back-end Development:'''  
+
*'''Back-end Development:''' [http://www.php.net/ PHP], [http://jquery.com/ jquery], [http://d3js.org/ d3]
*'''Front-end Development:'''  
+
*'''Front-end Development:'''CSS3, HTML5
*'''Graphic Design:'''
+
 
 
|-
 
|-
 
! scope="row" style="background: #C0C0C0"| Project Management
 
! scope="row" style="background: #C0C0C0"| Project Management
Line 172: Line 350:
 
*'''On-line Resources:'''
 
*'''On-line Resources:'''
 
**[http://developers.facebook.com Facebook Developers]
 
**[http://developers.facebook.com Facebook Developers]
 +
**[http://www.thetoolbox.cc/ The Toolbox]
 
**[https://docs.google.com/spreadsheet/ccc?key=0AgEVT7COZGKGdG1NYi01a1FMQ3RNVWdMZnc0eUpSQUE#gid=0 More helpful links...]
 
**[https://docs.google.com/spreadsheet/ccc?key=0AgEVT7COZGKGdG1NYi01a1FMQ3RNVWdMZnc0eUpSQUE#gid=0 More helpful links...]
  
Line 183: Line 362:
 
*Invaluable feedback from Client (Prof Shim) and Project Supervisor
 
*Invaluable feedback from Client (Prof Shim) and Project Supervisor
 
*Users' time required to also provide feedback during acceptance testing.
 
*Users' time required to also provide feedback during acceptance testing.
 +
 +
|-
 +
! scope="row" style="background: #C0C0C0"| Wiki Page
 +
||
 +
*[https://wiki.smu.edu.sg/is480/IS480_Team_wiki:_2012T1_Timber_Werkz Timber Werks]
 +
 +
|-
 +
! scope="row" style="background: #C0C0C0"| Magento Code Structure
 +
||
 +
*[https://wiki.smu.edu.sg/w/is480/images/f/f5/EAV_runthrough.pdf EAV Database Summary done by Max]
 +
*[https://wiki.smu.edu.sg/w/is480/images/2/2c/MagentoLearningCurve.pdf Steps to understand Magento code structure done by Max]
 +
|}
 +
 +
== BI Tool Offerings ==
 +
 +
d3.js (the one that is highlighted) is the intending framework that we are currently using for our BI section.
 +
 +
{| class="wikitable" style="text-align: center; height:50px;"
 +
|+
 +
|-
 +
 +
! scope="col"  width="200" style=background-color:#000000| <font color="#FFFFFF">Features Required</font>
 +
! scope="col"  width="200" style=background-color:#000000| <font color="#FFFFFF">Magento</font>
 +
! scope="col" width="200" style=background-color:#000000| <font color="#FFFFFF">Pentaho</font>
 +
! scope="col" width="200" style=background-color:#000000| <font color="#FFFFFF">Highcharts</font>
 +
! scope="col" width="200" style=background-color:#000000| <font color="#FFFFFF">BIRT</font>
 +
! scope="col" width="200" style=background-color:#000000| <font color="#FFFFFF">OpenReports</font>
 +
! scope="col" width="200" style=background-color:#000000| <font color="#FFFFFF">d3.js</font>
 +
|-
 +
 +
! scope="row" | '''Ease of Integration'''
 +
|style="text-align: center;"| -
 +
|style="text-align: left;"|
 +
*Intermediate -Advanced
 +
*Java-based whereas Magento is PHP-based
 +
|style="text-align: left;"|
 +
*Intermediate
 +
*JavaScript-based
 +
|style="text-align: left;"|
 +
*Advanced
 +
*Java-based
 +
|style="text-align: left;" |
 +
*Intermediate
 +
*Web-based service via API
 +
|style="text-align: left;" style="background: #FFFF00"|
 +
*Intermediate
 +
*Javascript-based
 +
 +
|-
 +
 +
! scope="row" | '''Cost'''
 +
|style="text-align: center;"| -
 +
|style="text-align: left;"| Free version available
 +
|style="text-align: left;"| Free version available
 +
|style="text-align: left;"| Free version available
 +
|style="text-align: left;"| Free
 +
|style="text-align: left;" style="background: #FFFF00"| Free
 +
 +
|-
 +
 +
! scope="row" | '''Reporting Tool'''
 +
|style="text-align: center;"|Basic Reporting Tool
 +
|style="text-align: left;"|
 +
*Standalone desktop application, not available as an Eclipse plug-in
 +
*Not user-friendly
 +
|style="text-align: left;"| None
 +
|style="text-align: left;"| High learning curve
 +
|style="text-align: left;"| Report Generation and scheduling capabilities
 +
|style="text-align: left;" style="background: #FFFF00"| High Learning Curve
 +
 +
|-
 +
 +
! scope="row" | '''DrillDown'''
 +
|style="text-align: center;"| -
 +
|style="text-align: left;"| Able to drill down
 +
|style="text-align: left;"| None
 +
|style="text-align: left;"| Able to drill down
 +
|style="text-align: left;"| -
 +
|style="text-align: left;" style="background: #FFFF00"|Able to drill down
 +
 +
|-
 +
 +
! scope="row" | '''Exporting Features'''
 +
|style="text-align: center;"| -
 +
|style="text-align: left;"| PDF, Excel Document
 +
|style="text-align: left;"| Export to raster or vector image
 +
|style="text-align: left;"| PDF, Excel Document
 +
|style="text-align: left;"| PDF, HTML, CSV, XLS, RTF, image
 +
|style="text-align: left;" style="background: #FFFF00"| PDF, HTML, CSV, XLS, RTF, image
 +
 +
|-
 +
 +
! scope="row" | '''Visualization'''
 +
|style="text-align: center;"|Basic Graph
 +
|style="text-align: left;"| Charting is very difficult for end-users
 +
|style="text-align: left;"| Numerous chart types and many of them can be combined into one chart
 +
|style="text-align: left;"| Web 2.0 style report and visualisations. Rich, highly interactive and navigable Java reports with formatting, graphic and conditional display options.
 +
|style="text-align: left;"| -
 +
|style="text-align: left;" style="background: #FFFF00"|
 +
*Well documented
 +
*High visualisation tool
 +
*Low level Framework which enables developers to gain full control of the data visualisation
 +
 
|}
 
|}

Latest revision as of 12:25, 19 April 2013


 Chmlogo.jpg "because there is no I in the team"

Home   Team & Stakeholders   Project Definition   Project Design   Project Management   Progress Summary   Learning Outcomes   Photos


MID-TERM WIKI            FINAL WIKI

Project Scope

For more detailed information regarding the various project tasks, please click [here]

Sceenshots Feature Description

 Core Features

CheckOutCart.gif Checkout Cart
  • User can checkout products that he has selected
  • User can see the Purchase summary of the products he has selected and the coupons he can use
  • User is shown confirmation message after purchase of products
Coupon.gif Manage Coupons
  • User can view the coupon(s) he currently has
  • User can use the coupon(s) on products he wishes to purchase
Profiles.jpg Manage Profiles
  • User can view his profile and his friend's profiles
  • User can edit his own profile
Campaigns.png Manage Campaigns
  • Marketing Professionals can view Campaigns they have created
  • Marketing Professionals can create Campaigns
  • Marketing Professionals can design Campaigns
Hook.jpg Manage Hooks
  • Marketing Professionals can create hooks
  • Marketing Professionals can design coupon hooks
  • Marketing Professionals can design social messages hooks
  • Marketing Professionals can view hooks available
Insight.jpg Manage Insights
  • Marketing Professionals can choose data source Transaction Records/Campaign data for analysis
  • Marketing Professionals can choose the chart type
  • Marketing Professionals can view graph created by the analysis

 Good-to-Have Features

Couponstack.jpg Ranking of Campaigns/Coupons/Hooks' Revenues
  • Marketing Professionals can see coupons/hooks popularity in the campaigns and its according revenues
Wish-list1.png Manage Wishlist
  • User can view his own wishlist
  • User can view his friend's wishlist
  • User can add products into his wishlist
  • User can share wishlist on Facebook
Drilling-down-into-keywords.jpg Recursive Drilldown
  • Marketing Professionals can drill down/up Charts by clicking on a particular part of the chart
Optimization.png Coupon Optimization
  • Consumers can now see which coupons are best used on which products when they purchase items
Annotate.gif Diagram Annotations
  • Marketing Professionals can now add Annotations to Diagrams

Old Use Cases

  • Version 1
  • Version 2

UI


Old UI Thumbnails

Business Scenario Writeup

Work Process Flow

ConsumerProcessFlow1.png BIProcessFlow.png
CouponProcess.png CreateCampaignProcess.png
WishListProcess.png CreateHooks.png

Magento Framework & ER Diagram

Magento Framework

MagentoFramework1.png

Magento EAV Database Diagram

Click here for a better view of the database

Magentodatabase2.png


Server Architecture & Resources


Team Chm would like to thank and reference the following people, resources for the invaluable feedback/information given in this project:

Server Architecture Layers
Requirements Resources/References Description
System Architecture
Development
Project Management
Training Materials
Communication
  • Facebook Page
  • Skype
  • Whatsapp
  • Email
  • Invaluable feedback from Client (Prof Shim) and Project Supervisor
  • Users' time required to also provide feedback during acceptance testing.
Wiki Page
Magento Code Structure

BI Tool Offerings

d3.js (the one that is highlighted) is the intending framework that we are currently using for our BI section.

Features Required Magento Pentaho Highcharts BIRT OpenReports d3.js
Ease of Integration -
  • Intermediate -Advanced
  • Java-based whereas Magento is PHP-based
  • Intermediate
  • JavaScript-based
  • Advanced
  • Java-based
  • Intermediate
  • Web-based service via API
  • Intermediate
  • Javascript-based
Cost - Free version available Free version available Free version available Free Free
Reporting Tool Basic Reporting Tool
  • Standalone desktop application, not available as an Eclipse plug-in
  • Not user-friendly
None High learning curve Report Generation and scheduling capabilities High Learning Curve
DrillDown - Able to drill down None Able to drill down - Able to drill down
Exporting Features - PDF, Excel Document Export to raster or vector image PDF, Excel Document PDF, HTML, CSV, XLS, RTF, image PDF, HTML, CSV, XLS, RTF, image
Visualization Basic Graph Charting is very difficult for end-users Numerous chart types and many of them can be combined into one chart Web 2.0 style report and visualisations. Rich, highly interactive and navigable Java reports with formatting, graphic and conditional display options. -
  • Well documented
  • High visualisation tool
  • Low level Framework which enables developers to gain full control of the data visualisation