Enterprise Group, Ltd. (EGL) Build Approach
Automated Assessment

 

This automated assessment is designed to help you make a choice between a top-down or bottom-up approach. While both approaches are valid, the proper choice is dependent upon the unique characteristics of your organization. The most important factors are non-technical ones, such as politics and the business pain you are addressing with your system.

A "green light" in the EGL build approach automated assessment is not a guarantee of success. This automated assessment is intended only as an aid in evaluating the build approach methods as they relate to your site, and is no substitute for a live, on-site evaluation by an experienced business intelligence professional.

To use this automated assessment:
Select an answer to each question. For each answer, the EGL build approach automated assessment will display a graphic indicator of green, yellow or red for each build method. Comments are also included for some choices.

When you have selected all the answers, click on the "Process my data" button to calculate your total score. If you change an answer, be sure to click on the"Process my data" button again.

Copyright © 2000, Enterprise Group, Ltd. All rights reserved.

    Approach
    Top Down Bottom Up
Annual Sales
Purpose: Primarily used as a "rule of thumb" sizing device for vendors. It allows them to get a quick handle on how best to fit into a business of your size. Smaller organizations should focus on low cost platforms and tools, and stick to very tight scopes for their initial phases.
Not Applicable
Over $50 B
$5 - 15 B
$1 - 5 B
$500m - 1 B
$10 m - 500m
$25m - 100m
$1m - 25m
<$1m
       
Business Driver (What is the driving need for the project?)
Purpose: To establish the baseline for political will in the organization for this project. Very valuable data point for all parties. If this is a strategically driven project, it ensures longer lasting political will. Tactical drivers are much more susceptible to loss due to changing internal and external business conditions.  
Not Applicable
Strategic
Tactical
Both
   
   
   
   
       
Timeline
Purpose: Although it may seem self evident, the timeline of the project functions as the primary gating factor when making most technological and scope decisions. Also a very big factor in making build/buy decisions, especially with regard to human resources. This data point forms a direct linear relationship with budget.
Not Applicable
24 months or greater
12 - 24 months
6 - 12 months
3 - 6 months
1 - 3 months
   
   
       
Political Will (Level of organization willing to commit sustained resources)
Purpose: To identify specific roles and levels in the organization willing to commit to sustained commitment to the project. Very closely related to business driver and timeline. The higher the level of political will, the longer the window of opportunity for funding will remain open.
Not Applicable
Board of Directors
CEO
President
VP
Line of Business (LOB) Manager
Department Manager
Work Group
       
Political Will Sustainability Window (How long will it last?)
Purpose: The primary driver in establishing how long you really have to do this project. It doesn't really matter what the stated timeline is, the sustainability window actually determines time to delivery.
Not Applicable
24 months or greater
12 - 24 months
6 - 12 months
3 - 6 months
1 - 3 months
   
   
       
Sponsorship Level (Highest level willing to tie their career to success/failure)
Purpose: Establishes the bottom line on how far this project is going to go in the organization. If the project runs into trouble, or the usual unexpected delays or challenges arise, the sponsorship level will determine its fate. The higher the better, for making the project happen. This data point is inversely related to political exposure.
Not Applicable
CEO
President
VP
Line of Business (LOB) Manager
Department Manager
Work Group Leader
   
       
Budget - Design, Build & Implement (Labor, hardware, software, consulting) 
Purpose: Establishes the overall budget range for the project. Excellent gating point for vendors and tools. A $500K project is not going to need a $400K ETL tool. Entirely dependent on the scope of the project, for instance, a six terabyte data mart will require a $5-10M budget.
Not Applicable
>$10M
$5 - 10M
$2.5 - 5M
$1-2.5M
$500K - 1M
$100K - 500K
<$100K
       
Budget -- Year 1-3 Maintenance, Growth & Sustenance (Labor, hardware, software, consulting) (Percent of Design & Build Budget)    
Purpose: Establishes a couple of very important points right up front. One, how realistic has the budgeting process been up to now; and two, how long term has the thinking of management been with regard to this project? You will need 20-40%, on average, of the build price to maintain the system in its first year of operation. Your budget % for maintenance, growth & sustenance for years 2+ depend heavily on: utilization, growth and complexity of required changes.
Not Applicable
80% +
50 - 80%
30 - 50%
10 - 30%
1 - 10%
   
   
       
Commonality of Need (Diversity of groups in need of this solution)  
Purpose: Establishes the constituency base for the project. Also establishes the user scope. Related directly to level of business driver and level of political will and sponsorship. If all are high, then a data warehouse may be the proper end goal, with incremental data marts along the way.
Not Applicable
Very Diverse/Very Heterogeneous, All Units/Divisions
Diverse/Heterogeneous
Fairly Common/Shared Metrics, Views
Homogenous Metrics, Views
Single Group/Division
Multiple Workgroups
Workgroup
       
Number of Users   
Purpose: Establishes the baseline for calculating network loads, topology requirements and number of copies or "seats" of end user tools. As the project moves forward, you will need to break the users down into more detailed segments, i.e. analyst, manager, information resource consumer. Be very wary of small user bases. You need a wide user base to provide the ongoing political support to sustain your system through changes in personalities and leadership strategies.  
Not Applicable
1000+
500 - 1000
250 - 500
100 - 250
50 - 100
25 - 50
1 - 25
       
Level of Specific Pain   
Purpose: Primary driver gauge for the project. This point can change the actual reality of the project's context, even if other items are reflecting low support and funding. Conversely, If you are looking at low pain levels here, steer clear. Specific pain is defined as a business challenge that can be addressed with tabular data. 
Not Applicable
Extremely high - business survival at stake
High -- one of several #1 Priorities
Somewhat high - top 5 priority
Medium - top 10 priority
Low - top 25 priority
   
   
       
Continuity of Specific Pain 
Purpose: The same pain must be felt by all stakeholders, otherwise you will get no (removed "either") sponsorship, no resources and/or no utilization.
Not Applicable
Shared at all levels
Exists only at Executive level
Exists only at Manager level
Exists only at User level
Exists at Executive and Manager level
Exists at Manager and User level
Exists at Executive and User level
       
Scale of Pain
Purpose: Establishes the true scale of the project. Small-scale pain can only be mitigated by very high levels of political will and levels of influence. The "cross border" nature of an EDW project is the major challenge, so anything short of enterprise wide pain can lead to project-killing political challenges.
Not Applicable
Enterprise Wide
Division
LOB (Line of Business)
Geographic
Function
Department
Multiple Workgroups
Workgroup
       
Politics of Pain (Level of influence of pain owner)  
Purpose: Used to establish the real level of the political will in the organization. When it comes down to crunch time, the political pull of the pain owner will make or break the allocation of resources to the project. Closely linked to the following two metrics: politics and utilization. You need all three to be in the high range to be successful.   
Not Applicable
Top level, maximum influence
High level, high influence
High level, low influence
Medium level, high influence
Medium level, low influence
Low level, low influence
   
       
    If you change an answer, be sure to click on the"Process my data" button again.
   
   
 
Copyright © 2000, Enterprise Group, Ltd. All rights reserved.