Site Analysis Worksheet

August 1999

Microsoft Corporation

Introduction

This worksheet provides an outline of the information you need to gather and record when analyzing a site, designing a solution to the customer’s business problem, implementing the solution, and recording the lessons learned during the process.

Analyzing a Site

A site analysis should examine the following:

The Business Problem

Describe the business problem the customer is attempting to solve with the new solution, including the following information:

Component Describe…
Existing solution
  • The customer’s method of conducting business before deploying the current solution.

  • The business problem the customer was trying to solve with the current solution.

  • How the current solution changed or impacted the customer’s business.

  • Any problems the customer is having with the current solution.
Goals for a new system
  • The business problem the customer is hoping to solve with a new solution.

  • The customer’s performance goals for a new solution.

  • The customer’s return on investment goals for the new solution.

The Project

What is the customer trying to accomplish? This section lists the information needed to understand the scope of the customer’s project.

Component Describe…
Vision
  • The customer’s vision for the project.
Scope
  • The goals and scope of each phase of the project. (The business problem might indicate follow-on projects after this particular deployment.)

  • The systems with which the new solution has to be integrated.

  • The technical issues that must be addressed for each phase of the project.
Timeline
  • A proposed schedule for each phase.
Resources
  • Project resources needed to implement the new solution on the proposed schedule (for example, two people working full-time for three months).
Organizational processes
  • New or changed organizational processes required by the new solution (for example, additional staff required to develop or run the system; training; additional or changed processes in areas related to the new solution, such as inventory or purchasing).

  • Create process diagrams to contrast the old and new processes.

Functional Requirements

Describe the functions the site needs to perform.

System Requirements

Describe the system requirements for the new solution. This should include the following:

Performance

Describe how you plan to measure the system and monitor performance.

Component Describe…
Monitoring
  • The ways in which the customer plans to monitor systems (including usage/load, concurrency, redundancy, and so forth).

  • The resources the customer needs to monitor systems.
Measurement, estimating
  • Performance measurement or estimation tools the customer is using.

  • The resources the customer uses to measure or estimate performance.

  • How frequently the customer measures performance.
Use of data
  • How the customer is using data to fine-tune application, system, processes, and so forth.

Proposed Solution

When you have gathered sufficient information to design a solution, outline each component of your design.

Component Describe…
Strategy
  • Hardware specifications.

  • Software and services, and why they were chosen.

  • Any third-party technologies and services to be used, and why they were chosen.

  • Any Microsoft Solution Providers to be used, and their role and contribution to the solution.

  • Anything else critical to the strategy employed to design this solution.
Architecture
  • The system architecture (logical, physical, network architecture, and so forth). Include a diagram.

  • The application architecture (event sequence charts, user authentication, and other details). Include a diagram.

  • The data architecture (data models, database schemas, and so forth). Include a diagram, if possible.
Optimal system settings
  • Optimal hardware, software, services, or system settings for the new solution, if known.
Security
  • Network security (ways in which users connect, such as SSL, IPC_SEC; how and who can access resources; and so forth). Include a diagram, if possible.

  • Application security (security on software and services, user authentication and authorization processes, membership and other directory schemas, and so forth). Include a diagram, if possible.

  • Data security (database security, file/share security, authorization and authentication, data integrity, and so forth).  Include a diagram, if possible.

  • Specific Microsoft® Site Server, Microsoft® Windows NT®, and Microsoft® SQL Server™ features to be used.
Data access
  • How data is to be stored.

  • Processes used to transfer, update, and validate data.

  • Processes for accessing data, and who (system, users) has access to data.
Integration with existing systems
  • Systems with which the solution must be integrated.

  • How connectivity and accessibility is to be provided to those system(s) (such as components, third-party software, services, and so forth).
Recommendations for future enhancements
  • Recommendations for related functionality that is not included in this implementation (if any).

Implementation

Following implementation, record the following information about the process:

Component Describe…
Solution providers
  • Any Microsoft Solution Providers who assisted with the implementation (who they were, what their contribution was, and what services they performed).

  • Why you used a particular solution provider (if any).
Tools and technologies
  • Tools and technologies used to implement the solution, why they were chosen.
Code components
  • Any critical code components utilized by the system (ASP, COM components, Stored Procedures, OPP, CIP, and other custom APIs), and how they work in your application.

  • Third-party components used in the application (if any).
Configuration
  • Configuration details for the hardware, services, and software.

  • Server configuration (Microsoft SQL Server, Site Server, IIS, Windows NT, or others).

  • Security configurations for the server, software, services, and system.
Operational processes
  • New operational processes and systems (for example, new systems or processes put in place to manage the proposed system).
User interface components
  • User interface components created to help operate the system (if any).

Lessons Learned

Record the following information about the lessons learned during the site analysis and implementation:

Component Describe…
Technical challenges
  • Any technical challenges in the design or implementation of the solution.

  • How you addressed those issues.
Performance
  • Learning experiences in regards to measuring, monitoring, or estimating performance.
Tips and tricks
  • Any tips and tricks learned during this implementation.
Recommendations
  • Any recommendations based on this implementation.

Appendices

Add appendices that might be relevant to the implementation, such as the following:

Information in this document, including URL and other Internet web site references, is subject to change without notice.  The entire risk of the use or the results of the use of this resource kit remains with the user.  This resource kit is not supported and is provided as is without warranty of any kind, either express or implied.  The example companies, organizations, products, people and events depicted herein are fictitious.  No association with any real company, organization, product, person or event is intended or should be inferred.  Complying with all applicable copyright laws is the responsibility of the user.  Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document.  Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

© 1999-2000 Microsoft Corporation.  All rights reserved.

Microsoft, Windows, and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in the U.S.A. and/or other countries/regions.

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.