creating stunning data analytics dashboard using php and flex
TRANSCRIPT
©All rights reserved. Zend Technologies, Inc.
Creating a stunning data analytic dashboard using PHP and Flex
Kevin Schroeder
Technology Evangelist
Zend Technologies
©All rights reserved. Zend Technologies, Inc.
About Kevin
Past: Programming/Sys Admin
Current: Technology Evangelist/Author/Composer
@kpschrade
©All rights reserved. Zend Technologies, Inc.
Problems
• How do we create a dashboard for an e-commerce application?
• What data is interesting?
• What data do we need now?
• What data can wait?
• Is a database the best choice?
• What are other options?
©All rights reserved. Zend Technologies, Inc.
Solutions
• Message queues are nice for quick, transient, serialized objects
• Databases are nice for persistent structured data
• Job queues are nice to batch data processing that might overwhelm the dash board
• Use what is best for individual features(but don’t go crazy)
©All rights reserved. Zend Technologies, Inc.
Data Retrieval
• Delayed traffic reports (1-2 seconds)
• Immediate sales notification
• Delayed product sales (~10 seconds)
©All rights reserved. Zend Technologies, Inc.
Pieces
• Magento An observer that hooks in with
• each page request (traffic monitoring)
• end of the sale cycle (sale notices and product summary)
• Job Queue Process traffic
• Retrieves data from a message queue and summarizes it into a DB table
Process sales• Retrieves sales data from a message queue and includes it in
a summary DB table
©All rights reserved. Zend Technologies, Inc.
Pieces (con’t)
• ActiveMQ (using Stomp) Queues: traffic, sale, sale summary
• Flex Traffic View – gets data from a service call
Sale View – gets data from the message queue
Product Sales Summary View – gets data from a service call
• Service Calls Traffic summary – retrieves data DB summary table
Product summary – retrieves data DB summary table
©All rights reserved. Zend Technologies, Inc.
Traffic Architecture
ApplicationTraffic Logger Queue
Process New Traffic
JobDatabase Service
CallDashboard Application
©All rights reserved. Zend Technologies, Inc.
Sale Architecture
Application Sale Queue
Dashboard Application
©All rights reserved. Zend Technologies, Inc.
Sale Summary Architecture
ApplicationSale
Logger Queue
Process New Sale Items Job
Database Service Call
Dashboard Application
©All rights reserved. Zend Technologies, Inc.
Demo
©All rights reserved. Zend Technologies, Inc.
Follow us! Zend Technologies
http://twitter.com/zend
http://twitter.com/kpschrade (me!)