WWCE Data Portal

This is Stephen Perl's submission for the Last Starfighter contest at WWCE. This is a pitch to implement a rest-based API and web based application to visualize and report WWCE advisor performance metrics.

Transcript

1. WWCE DATA PORTAL STEPHEN PERL - LSM
2. WWCE DATA PORTAL MEET JANE ▸ Jane is a games advisor at CCNA. ▸ Jane was given CSAT targets for the year. ▸ Jane wants to know what her performance is on a weekly basis. ▸ So…
3. WWCE DATA PORTAL MEET JOE ▸ Jane asks her manager Joe how she did last week on Monday. ▸ The hot potato is then passed to Joe who must go Tableau to see how Jane is doing.
4. WWCE DATA PORTAL MEET TABLEAU ▸ When he has time, Joe spends fifteen minutes loading up the manager detail dashboard from Tableau server. ▸ He then exports the information he needs for Jane into an Excel document.
5. WWCE DATA PORTAL MEET OUTLOOK ▸ Joe then sends the static excel document to Jane on Thursday. ▸ Three days after her initial request Jane is able to finally see how she performed last week.
6. WWCE DATA PORTAL WHAT CAN WE DO BETTER? ▸ Improve data availability by giving Advisors direct access to information. ▸ Reduce the number of static files propagating throughout WWCE, reducing the number of data inconsistencies. ▸ Reduce the cycle time and amount of work required to tell Jane how she’s doing. ▸ Reduce the cost associated with providing information to WWCE stakeholders by publishing via a REST API rather than purchasing Tableau licenses.
7. WWCE DATA PORTAL WHAT IS THE WWCE DATA PORTAL? ▸ A REST-based API for Dojo ▸ A web-based application for Data Visualization and Reporting ▸ A cost avoidance strategy for Tableau Licenses
8. WWCE DATA PORTAL REST-BASED API ▸ A RESTful API is a set of functions that developers can use to perform requests and receive responses (data) via HTTP protocol (a URL / endpoint). ▸ This allows us to easily interface between the Dojo Data Warehouse and a web- based application. ▸ This means we can provide data and information directly to advisors.
9. WWCE DATA PORTAL WHAT IS THE BENEFIT TO WWCE? ▸ Data Availability - Advisors do not have direct access to their performance metrics and must go through a TM. ▸ Value - Tableau Licenses cost $800-$1000 per user. It would cost $560,000 - $700,000 to provide agents tableau access. The data portal was created with open source software and requires no licenses for user access. ▸ Streamlining - TM’s must to manually pull data for each agent. The WWCE data portal can reduce the effort from minutes/ hours per person to seconds.
10. WWCE DATA PORTAL WANT TO KNOW MORE? ▸ Try the working prototype: http://172.99.77.13/advisors ▸ Check out my code: https://github.com/shperl/starfighter ▸ Private repository, so hit me up: sperl@ea.com for access.
11. WWCE DATA PORTAL TECHNOLOGIES USED IN PROOF OF CONCEPT ▸ Docker / Carina — A container and container management system used to wrap up software into a complete filesystem containing everything you need to run the application — code, runtime, system tools, etc. ▸ Flask — A BSD licensed micro web framework written in python based on the Werkzeug toolkit and Jinja2 template engine. ▸ Boostrap — An HTML, CSS, and Javascript framework used for creating / styling websites and applications. ▸ jQuery — a fast and small JavaScript library used for event handling, document traversal, and manipulation. ▸ D3.js & C3.js — A set of JavaScript libraries used for producing dynamic, interactive data visualizations in web browsers using SVG, HTML5, and CSS standards. ▸ Nginx — A web server acting as a reverse proxy server for HTTP, HTTPS, TCP, etc. as well as Load Balancer and HTTP Cache. ▸ Git / Github — A distributed version control system responsible for keeping track of changes to content/ code and a mechanism for sharing that content with others.