Project Plan Connected Appliances Analytics Dashboard The Capstone - PowerPoint PPT Presentation

Project Plan Connected Appliances Analytics Dashboard The Capstone Experience Team Whirlpool Derrick Neier Jim Solce Zach Taylor Joe Tuohey Department of Computer Science and Engineering Michigan State University Fall 2012 From Students… …to Professionals

Project Overview • Collect information from existing customer and appliance databases • Store this information in a database • Provide a web-based application for searching customer data, examining static dashboards, and creating custom reports from this data • Allow for role-based security managed through administrator functions The Capstone Experience Team Whirlpool Project Plan 2

Functional Specifications • Analytics Dashboard  Connected Appliances Information  Consumer Data • Used For  Predictive Analytics  Customer Service  Marketing and Sales The Capstone Experience Team Whirlpool Project Plan 3

Design Specifications • Role based functionality  Administration o Management of system users and permissions  Customer Service o Ability to lookup customer information through various search options  Analytics o Static dashboards for different appliances and custom ad- hoc report generation The Capstone Experience Team Whirlpool Project Plan 4

Screen Mockup: Login Screen The Capstone Experience Team Whirlpool Project Plan 5

Screen Mockup: Admin User Search The Capstone Experience Team Whirlpool Project Plan 6

Screen Mockup: Account Manager The Capstone Experience Team Whirlpool Project Plan 7

Screen Mockup: Account Lookup The Capstone Experience Team Whirlpool Project Plan 8

Screen Mockup: Lookup Results The Capstone Experience Team Whirlpool Project Plan 9

Screen Mockup: Connected Dashboard The Capstone Experience Team Whirlpool Project Plan 10

Screen Mockup: Custom Reports The Capstone Experience Team Whirlpool Project Plan 11

Technical Specifications • Create JSON listener and parser for incoming JSON feed coming from appliances • Create CRM listener and parser for incoming .CSV feed coming from customer data • Store JSON and .CSV information in databases • Create web interface to generate Excel or .PDF reports from information in the databases • Also have web dashboard to view new data entering the databases The Capstone Experience Team Whirlpool Project Plan 12

System Architecture Configuration File User Database Parser for Customer Data Primary Database Internet Front End Existing Backend Parser for Appliance Data Configuration File The Capstone Experience Team Whirlpool Project Plan 13

System Architecture: Web Interface Modify User User Search Admin Home Index Customer Data Search CSR Home Forgot Password Analytics Home About Appliance Dashboards Custom Analytics The Capstone Experience Team Whirlpool Project Plan 14

System Components • Hardware Platforms  Linux server hosting website and database  Client computer o Desktop o Laptop o Mobile • Software Platforms / Technologies  Apache web server  MySQL database  HTML and PHP for website The Capstone Experience Team Whirlpool Project Plan 15

Testing • Functional testing  Unit testing of components  Integration testing  System testing through use cases • Non-functional testing  Accessibility testing using WAVE  Performance testing within predefined specifications  Security testing against cross-site scripting and SQL injection The Capstone Experience Team Whirlpool Project Plan 16

Risks • How do we utilize JSON?  None of the team has worked with this notation before  Working with the client to obtain example feeds • How do we manage two parsers inserting into the same DB?  Programs will parse data in two formats and place in a SQL database  Planning to obtain example data and begin development early • How do we program a background service?  The team lacks experience programming for this purpose  Begin lightweight prototyping of rudimentary tasks • How do we minimize feature creep?  This project could easily grow outside of the capabilities of the team  Communicating with the client to define scope and reduce creep The Capstone Experience Team Whirlpool Project Plan 17