Project Plan IT Metrics Repository The Capstone Experience Team - PowerPoint PPT Presentation

Project Plan IT Metrics Repository The Capstone Experience Team Meijer Anthony Cromarti David Culham Bobak Shahidehpour Department of Computer Science and Engineering Michigan State University Spring 2013 From Students… …to Professionals

Project Overview • Metrics - standard of measurement  Provides insight on performance compared to… o Industry standards o Company goals • Provide Meijer’s IT with a means of storing and accessing customizable sets of data The Capstone Experience Team Meijer Project Plan 2

Functional Specifications • Ability to create and view metrics  Create and select metrics  Calculate metrics based on existing metrics • Generate graph or report  across various time dimensions • Provide metric goals • Store historical values  Up to ten years The Capstone Experience Team Meijer Project Plan 3

Design Specifications • User login page • Create page  Create a new metric, attribute or data • Select page  List of metrics and attributes  Start year/period and end year/period • Generate Report  Shows the metric graph and table The Capstone Experience Team Meijer Project Plan 4

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

Screen Mockup: Select Metric The Capstone Experience Team Meijer Project Plan 6

Screen Mockup: Create Metric The Capstone Experience Team Meijer Project Plan 7

Screen Mockup: Report The Capstone Experience Team Meijer Project Plan 8

Technical Specifications • System Architecture • System Components • Environments  Development  Production • Database Schema The Capstone Experience Team Meijer Project Plan 9

System Architecture • .NET web application user interface  Desktop, laptop, mobile • Internet Information Services  Application web service • Server containing a SQL Server 2012 database  Reporting Services The Capstone Experience Team Meijer Project Plan 10

System Architecture The Capstone Experience Team Meijer Project Plan 11

System Components • Hardware Platforms  Desktop or Laptop  Mobile Device  Server • Software Platforms / Technologies  .NET Framework using Visual Studio 2012 o C#.Net (server-side) o ASP.Net, javascript (client-side) o Data Access Layer (Entity Framework)  Internet Information Services  SQL Server 2012 o Reporting Services The Capstone Experience Team Meijer Project Plan 12

Application Architecture Client Server The Capstone Experience Team Meijer Project Plan 13

Development Environment • Application implemented on local machines  Visual Studio 2012, .Net Framework • Internet Information Services  Resides on local machine • Commit code changes  Team Foundation Server 2012 The Capstone Experience Team Meijer Project Plan 14

Development Environment • SQL Server Management Studio  Access and Manage data on server • Reporting Services  Developed in Visual Studio 2012  Deployed onto report server The Capstone Experience Team Meijer Project Plan 15

Production Environment • Application deployed as web service  Internet Information Services (IIS) located on server • Code files reside in IIS directory structure • SQL Server 2012 database • Report Server  Resides in SQL Server  Stores all reports The Capstone Experience Team Meijer Project Plan 16

Database Schema The Capstone Experience Team Meijer Project Plan 17

Testing • Determine possible user scenarios  Three different roles • Test application under each scenario  Different browsers  Different devices • Verify data is stored and received correctly • Test user role security The Capstone Experience Team Meijer Project Plan 18

Risks • Provide mobile-device compatibility  Application should be accessible and formatted for mobile use  Mitigation: Research methods on mobile compatibility • SQL Server Reporting Services (SSRS)  SSRS to graph metrics  Mitigation: Research information on SSRS • Database Schema  Provide an efficient database structure  Mitigation: Normalize the database The Capstone Experience Team Meijer Project Plan 19