Project Plan Dealer Improvement Recommender System The Capstone - - PowerPoint PPT Presentation

▶
project plan
SMART_READER_LITE
LIVE PREVIEW

Project Plan Dealer Improvement Recommender System The Capstone - - PowerPoint PPT Presentation

Jul 19, 2023 266 likes •490 views

Project Plan Dealer Improvement Recommender System The Capstone Experience Team Urban Science Ty Jones Ben Mastay Collin Myers Department of Computer Science and Engineering Michigan State University Spring 2014 From Students to

slide-1
SLIDE 1

From Students… …to Professionals

The Capstone Experience

Project Plan

Dealer Improvement Recommender System

Team Urban Science

Ty Jones Ben Mastay Collin Myers Department of Computer Science and Engineering Michigan State University Spring 2014

slide-2
SLIDE 2

Project Overview

  • Dealer consulting services of Urban Science use a

“Logic Tree”

  • A hierarchal web of goals, Key Performance Indicators

(KPIs), causes, and suggestions for dealerships

  • Our project: provide a complete system to model

the logic tree, visualize it, modify it, and pass the updated tree to consultants in the field

  • Outlook: Eventually our system may be expanded

to track the effectiveness of situational recommendations and facilitate quantitative refinements to the model

The Capstone Experience Team Urban Science Project Plan 2

slide-3
SLIDE 3

Project Overview

  • Four main interconnected components:
  • Backend SQL database modeling the Logic Tree
  • Application server facilitating communication

between web client, database, and iPad client

  • Web client allowing U.S. to visualize and refine the

model

  • Extension to existing iPad app allowing on-site

consultants to make use of the updated logic tree

The Capstone Experience Team Urban Science Project Plan 3

slide-4
SLIDE 4

Functional Specifications

  • Web client:
  • Display a useful visualization of the model
  • Provide functions to create new and edit existing

KPIs, causes, and recommendations

  • Provide the ability to create new and edit existing

weighted relationships between KPIs, causes, etc.

  • Users should provide login information
  • Changes to the model should be audited
  • Saved changes must be reflected in database

The Capstone Experience Team Urban Science Project Plan 4

slide-5
SLIDE 5

Functional Specifications

  • iPad App:
  • For on-site use at dealerships by consultants
  • “Bolt-on” extension to existing (last semester’s) app
  • Reflect changes to model in the app
  • Reflect weights on relationships in the suggestions

provided to the user

  • Take input of KPI data extant in the current app and

produce suggestions

The Capstone Experience Team Urban Science Project Plan 5

slide-6
SLIDE 6

Functional Specifications

  • Backend SQL Database:
  • Models the Logic Tree and the relational weights

between components

  • Maintains a record of changes
  • Application Server
  • Provides controlled access (user authentication) to

the SQL database

The Capstone Experience Team Urban Science Project Plan 6

slide-7
SLIDE 7

Design Specifications

  • Web Client
  • Visualization of the Logic Tree
  • Allow for editing
  • User Authentication
  • Editing history
  • iPad App
  • Extend the current Dealer Assistant App to provide

access to the Logic Tree for suggestions

  • Use KPI as an input

The Capstone Experience Team Urban Science Project Plan 7

slide-8
SLIDE 8

Screen Mockup: Login

The Capstone Experience Team Urban Science Project Plan 8

slide-9
SLIDE 9

Screen Mockup: Control Panel

The Capstone Experience Team Urban Science Project Plan 9

slide-10
SLIDE 10

Screen Mockup: Node Details

The Capstone Experience Team Urban Science Project Plan 10

slide-11
SLIDE 11

Screen Mockup: Edit Node

The Capstone Experience Team Urban Science Project Plan 11

slide-12
SLIDE 12

Screen Mockup: Add New Node

The Capstone Experience Team Urban Science Project Plan 12

slide-13
SLIDE 13

Screen Mockup: Add New Node

The Capstone Experience Team Urban Science Project Plan 13

slide-14
SLIDE 14

Screen Mockup: Add New Node

The Capstone Experience Team Urban Science Project Plan 14

slide-15
SLIDE 15

Screen Mockup: Category View

The Capstone Experience Team Urban Science Project Plan 15

slide-16
SLIDE 16

Screen Mockup: Category View

The Capstone Experience Team Urban Science Project Plan 16

slide-17
SLIDE 17

Technical Specifications

  • Web Client – “Logic Tree Editor”
  • Written in C#.NET using ASP.NET MVC
  • Access database using Entity Framework
  • Data visualization using D3.js JavaScript library
  • Source code managed by Visual Studio Online
  • iPad App Extension
  • RESTful Web API to access app server
  • Written in Objective-C
  • Source code managed by git
  • App Server
  • Microsoft Azure Windows Server
  • Database
  • Microsoft SQL 2012 database

The Capstone Experience Team Urban Science Project Plan 17

slide-18
SLIDE 18

System Architecture

The Capstone Experience Team Urban Science Project Plan 18

slide-19
SLIDE 19

System Components

  • Hardware Platforms
  • Apple iPad
  • Software Platforms / Technologies
  • ASP.NET MVC
  • Azure Windows Server
  • Microsoft SQL Database
  • Entity Framework
  • RESTful Web API

The Capstone Experience Team Urban Science Project Plan 19

slide-20
SLIDE 20

Testing

  • Web client
  • Unit testing C#/JavaScript code
  • iPad Extension
  • Suggestion comparison to the Logic Tree
  • Usability testing
  • Allow client to use the web client to assess its use

and workflow

The Capstone Experience Team Urban Science Project Plan 20

slide-21
SLIDE 21

Risks

  • Databases
  • Little to no experience with databases
  • Mitigation through C# framework to manage database

interaction (Entity Framework)

  • ASP.NET MVC
  • No experience with this technology
  • Mitigation through tutorials and client knowledge
  • RESTful Web Services
  • What exactly IS RESTful? How is it implemented?
  • Researching RESTful, tutorials, and using client

knowledge

The Capstone Experience Team Urban Science Project Plan 21

slide-22
SLIDE 22

Risks

  • Translation of Logic Tree
  • Need to translate the Logic Tree into a database

model

  • Working with client to solidify a schema that

accurately captures and represents the Logic Tree

The Capstone Experience Team Urban Science Project Plan 22