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

▶

Sep 06, 2022 267 likes •448 views

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

SLIDE 1

From Students… …to Professionals

The Capstone Experience

Project Plan

Connected Appliances Analytics Dashboard

Team Whirlpool

Derrick Neier Jim Solce Zach Taylor Joe Tuohey Department of Computer Science and Engineering Michigan State University Fall 2012

SLIDE 2

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

SLIDE 3

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

SLIDE 4

Design Specifications

Role based functionality
Administration
Management of system users and permissions
Customer Service
Ability to lookup customer information through various

search options

Analytics
Static dashboards for different appliances and custom ad-

hoc report generation

The Capstone Experience Team Whirlpool Project Plan 4

SLIDE 5

Screen Mockup: Login Screen

The Capstone Experience Team Whirlpool Project Plan 5

SLIDE 6

Screen Mockup: Admin User Search

The Capstone Experience Team Whirlpool Project Plan 6

SLIDE 7

Screen Mockup: Account Manager

The Capstone Experience Team Whirlpool Project Plan 7

SLIDE 8

Screen Mockup: Account Lookup

The Capstone Experience Team Whirlpool Project Plan 8

SLIDE 9

Screen Mockup: Lookup Results

The Capstone Experience Team Whirlpool Project Plan 9

SLIDE 10

Screen Mockup: Connected Dashboard

The Capstone Experience Team Whirlpool Project Plan 10

SLIDE 11

Screen Mockup: Custom Reports

The Capstone Experience Team Whirlpool Project Plan 11

SLIDE 12

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

SLIDE 13

System Architecture

The Capstone Experience Team Whirlpool Project Plan 13

Existing Backend Parser for Customer Data Parser for Appliance Data Configuration File Configuration File Primary Database User Database Internet Front End

SLIDE 14

System Architecture: Web Interface

The Capstone Experience 14 Team Whirlpool Project Plan

Index About Forgot Password Admin Home CSR Home Analytics Home Customer Data Search Modify User User Search Custom Analytics Appliance Dashboards

SLIDE 15

System Components

Hardware Platforms
Linux server hosting website and database
Client computer
Desktop
Laptop
Mobile
Software Platforms / Technologies
Apache web server
MySQL database
HTML and PHP for website

The Capstone Experience Team Whirlpool Project Plan 15

SLIDE 16

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

SLIDE 17

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