Difference between revisions of "2012T2 Team Chm: Project Design"
Jump to navigation
Jump to search
(→UI) |
|||
(201 intermediate revisions by 4 users not shown) | |||
Line 5: | Line 5: | ||
− | <div style="text-align: | + | <center><div style="text-align: center;"><span style="font-family: 'Trebuchet MS'; font-size: 48pt; letter-spacing:-0.1em; line-height:80%; color:black;"> [[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%" | | | style="border-bottom:2px solid #2d2d2d; border-top:2px solid #2d2d2d; background:none;" width="2%" | | ||
− | | 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=" | + | | 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%" | | | style="border-bottom:2px solid #2d2d2d; border-top:2px solid #2d2d2d; background:none;" width="2%" | | ||
− | | 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=" | + | | 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%" | | | style="border-bottom:2px solid #2d2d2d; border-top:2px solid #2d2d2d; background:none;" width="2%" | | ||
− | | style="padding:0 .3em;font-face:Verdana; background-color:#2d2d2d; font-size:110%; border-bottom:2px solid #2d2d2d; border-top:2px solid #2d2d2d; | + | | 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%" | | | style="border-bottom:2px solid #2d2d2d; border-top:2px solid #2d2d2d; background:none;" width="2%" | | ||
− | | 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=" | + | | 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%" | | | style="border-bottom:2px solid #2d2d2d; border-top:2px solid #2d2d2d; background:none;" width="2%" | | ||
− | | 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=" | + | | 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%" | | | style="border-bottom:2px solid #2d2d2d; border-top:2px solid #2d2d2d; background:none;" width="2%" | | ||
− | | 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: # | + | | 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%" | | ||
+ | |||
+ | | 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>]] | ||
+ | | ||
+ | [[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;"| | ||
+ | ''' <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;"| | ||
+ | ''' <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 | ||
+ | |- | ||
− | = | + | ! 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=" | + | !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]] | ||
− | |||
− | |||
− | |||
|- | |- | ||
|- | |- | ||
!rowspan="1" | Manage wish list | !rowspan="1" | Manage wish list | ||
− | | <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>''' | + | | <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>''' | + | | <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>''' | + | |<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>''' | + | |<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>''' | + | | <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>''' | + | |<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>''' | + | |<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>''' | + | |<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>''' | + | |<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=" | + | !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]] | ||
|} | |} | ||
− | == | + | ==Magento Framework & ER Diagram == |
− | '' | + | <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> | |
− | + | [[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 | ||
{| 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 | + | *'''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 |
− | + | ||
|- | |- | ||
! 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
Home | Team & Stakeholders | Project Definition | Project Design | Project Management | Progress Summary | Learning Outcomes | Photos |
Contents
Project Scope
For more detailed information regarding the various project tasks, please click [here]
Old Use Cases
- Version 1
- Version 2
UI
Work Process Flow
Magento Framework & ER Diagram
Magento Framework
Magento EAV Database Diagram
Click here for a better view of the database
Server Architecture & Resources
Team Chm would like to thank and reference the following people, resources for the invaluable feedback/information given in this project:
Requirements | Resources/References Description |
---|---|
System Architecture |
|
Development |
|
Project Management | |
Training Materials |
|
Communication |
|
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 | - |
|
|
|
|
|
Cost | - | Free version available | Free version available | Free version available | Free | Free |
Reporting Tool | Basic Reporting Tool |
|
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. | - |
|