Sunday, October 7, 2012

Writing a Proper Data Warehousing Request for Proposal!

1. General Information for Vendors
§         Lists the Project Vision
§         Project timelines
§         Nature of contract
§         Scope
 Reasoning: Give an overview of project and format for the RFP process.
2. System Background
Description of the Technical Environment
a)      Description on the Client and Server specifications at the Ministry.
b)      Breakdown of  user types for the data warehouse:
User Types
(Examples Only)
Description
Number of Users
Novice User
Uses “canned” reports and queries.
x
Power User
Frequent user, edits reports, queries directly and builds cubes for multi-dimensional analysis.
x
c)      Software tools for the data warehouse:
·         ETL Tools
·         Report and Query Tools
·         Data Analysis
·         Data Visualization Tools
 Reasoning: Give an overview of the expected installation. Also specify points of particular
 interest.
3. System Requirements
  • List of General Requirements
→ Give an overview of the data warehouse environment.
 Reasoning: An overview of the rational for the data warehouse implementation.
  • Mandatory Requirements
a)      List if the software is Client/Server based or web-based. Described what functions are available via the Internet browser. Describe what plug-ins        (if any) are necessary for the client machines.
b)      State that the vendor must communicate with the Ministry’s database and applications. Ask the vendor how they propose to do this.
c)      The vendor must be committed to its products remaining compatible with future versions of Oracle. Ask the vendor to offer documents as evidence of commitment to this environment.
d)      The vendor’s system must enable the overall optimization of the Ministry’s environment:
I)        Ask for how the vendor’s system minimizes user response time while maximizing the use of system resources.
ii)       Ask the vendor to explain the system’s architecture for data selection, processing, formatting.
iii)     Ask for evidence that network traffic is minimized and how the need to process large data sets on the client is also minimized.
 Reasoning: Based on user interviews and technical review, these are the must  
 have features for the data warehouse installation.
  • Strongly Desired Features
Examples:
→ The vendor’s system must allow users to schedule reports.
→ Does your system permit users to schedule at a certain time
and date? Daily? Weekly? Based on an event?
Describe how scheduling is accomplished and the options for scheduling reports.
 Reasoning: Based on the requirements analysis, the items listed here are
 additional features that will be good to have but not mandatory.
  • Desired Features
Examples:
→ Does your system possess a redundant query control?
This feature returns a saved version of a report whenever an identical report has been executed earlier – the report, output format, and raw data all remain constant in the interim. Describe how this works in your system.
   What are the limits in terms of how far back reports are archived?
 Reasoning: Following the rational of “Strongly Desired Features” above, this
 section lists a lower desired set of requirements.
§         Product Profile
o         Product name
o         Product description
o         Current release level
o         Date current release level was available
o         Projected date for the next release candidate
o         Current products install base
o         Industry verticals of installation
o         Number of installations
o         Breakdown of installations/users
 Reasoning: Gauge vendor’s product specifications and maturity.
§         Consulting
o         Describe the level of involvement the consultants will have at each stage of the project.
o         What is the experience of the consultants?
o         Location of Consultants.
o         Please forward resumes of consultants.
 Reasoning: Evaluate experience and competency of the vendor’s team.
 Also enquire on the consultants’ geographic location, this will help evaluate
 possible response rate.
§         Business Partners
o               Ask the vendor to state which products are fully integrated to your solution.
o               Describe the interconnectivity and interface requirements.
Reasoning: Enquire what other products can integrate well with the solution, e.g. Crystal Reports, Cognos. Also, the vendor will state the ease at which integration can occur.
§         Full feature of the business intelligence solution and products
o               Ask what makes the product stand out.
Reasoning: This will give the vendor a chance to distinguish their products.
 Further business intelligence capabilities such as OLAP, Data mining can be evaluated.
§         Application areas
o               Describe the areas the solution supports i.e. budgeting, financial planning etc.
Reasoning: Evaluate which areas the data warehousing solution can serve.
The “Mandatory Features” section above will inform the vendor the area which are necessary for the Ministry. This section gives further information on the vendors solution and possible areas which the Ministry can use in the future.
§         Web-based and standalone clients
o               Query if the solution supports both web-based and standalone clients. Ask which functionality is not supported in both versions (i.e. what works in a standalone client and not web-based and vice versa)
Reasoning: The architecture is of a fundamental importance. This section will enquire if the vendor’s solution will match the Ministry requirements.
§         Pricing and Licensing Model
o               How much does the product cost, including initial training, support and consulting?
o                
Reasoning: Gauge the cost of the solution and other indirect costs.
§         System Installation and Tool Administration
Examples:
o               Please describe the platform and system requirements of your product.
o               For web-based clients, are there specific requirements on the type and version of browser that may be used (e. g. Netscape vs. Internet Explorer)?
o               Please describe the overall architecture of your product (e. g. Client/ Server, two-tier/ three-tier architecture, etc.), including how your product functions in a geographically distributed environment.
o               Please describe the steps involved in installing your product.
o               Please list the administrative functions that are included in your product (e. g. defining roles, backup/ recovery, etc.).
o               How do tool administrators detect when your product requires additional hardware or requires human intervention (e. g. to restart a process, etc.).
o               How often are major/ minor software upgrades available? How would we be notified of a new software release?
o               Please describe how standalone (I. e. non-web-based) clients are distributed to end-user desktops. How are software upgrades distributed to end-users?
o               Are there ways to make the upgrade process transparent to the end-users?
Reasoning: The above questions and statements will give further information on the vendor’s solution regarding the installation and administration of your product.
§         Security
o              How are end-users and administrators authenticated to your product?
o              How do end-users and administrators gain access to reports, data sets, etc. (e. g. via roles)?
o              Please fully describe how reports and data are protected from unauthorized users.  
o              Please describe how row-level access to the data is attained.
o              What level of encryption is used on passwords, data, reports, etc.?
o              How does the existence of a firewall change the security architecture?  
o              How does the web-based client differ in terms of security from the standalone client?
Reasoning: Questions on security must also pass the security criteria set by regulators or industry standards .
§         Performance and Scalability
o              Does the product supports a substantial increase in data size, frequency and complexity of end-user queries?
o              How is performance measured within your product?
Reasoning: Evaluation of how the product can scale to future expectations.

1 comments:

Anonymous said...

Hi there!

I recently came across your blog and have been enjoying reading through it. You have a great resource of information here for anyone who wants to learn about ETL tools, novice or beginner!

I was wondering if you would be interested in sharing your blog on Glipho? Glipho is a new social blogging network that aims to promote the writing of its users and help build their audiences. We are trying to establish a creative community at Glipho, and your blog is just what we are looking for.

As your blog is powered by Blogger, you can simply import all your old posts to Glipho without affecting your existing blog at all. You can use your Glipho account to connect to any other major social network accounts you may own, so you can spread your blog as far as possible. We also use our own social media accounts to promote your content.

If you're interested check out our website at http://glipho.com and have a look around. Please feel free to ask me any questions, and if you would like to receive an invite to set up an account.

Have a great day,

Teo



Glipho Limited
14 Suite 3 D
Docklands Business Centre
10-16 Tiller Road
London E14 8PX


(e): teo@glipho.com
(w): www.glipho.com

Post a Comment

newer post older post Home