Building Making It Happen
Establishing Making-it-Happen as ‘Formal & Measurable’ Business Discipline
  Sign-in         Register
    
   Data Warehouse Project Definition Data Warehouse Business Requirements Gathering Phase  

Execution-MiH Encyclopedia  →   Enterprise Intelligence  →  SECTION -  Data-Warehouse/Mart  →  CHAPTER -  Data Warehouse Project Plan- Work Break-Down Structure  → 

Data Warehouse Project Initiation Phase

Data warehouse project initiation is the stage, where the first level assessment of the Data Warehouse scope, cost and time estimate is done. This is mainly achieved by prioritizing the business themes for Data-Warehouse.

Establish Project Structure & Management

After the sponsorship for initiation phase, one will establish project management structure. This will setup the ground not only for the initiation phase, but also for the whole project. The teams and roles established now will presumably stay with the project till the end.

Conduct Project Team Kick-Off & Planning

You may not have all the people at this stage, who will be working on this project. However, the key people should be in place by now. You will be getting all the people in a room, and share the following:

  • Proposed high level project plan and milestones.
  • Proposed project scope
  • Proposed project measures of success
  • Proposed project management structure
  • Role and responsibilities
  • Next steps

TIP- I have used the word 'proposed'. It is important that all the above imperatives of the project are co-created and co-owned. Therefore, the data warehouse champion will be creating a draft of the proposed measures, communication framework, structure etc, and take the feedback from the project team before firming it up.

TIP- Nothing which is created (structure, communication framework, roles and responsibilities...) is cast in stone. Given the unknowns with the initiatives, one may keep on adapting given the new situations.

Develop Project Communication Plan

This will be developed by the project team. This is not different from what you will do for any genre of projects. This will include:

  • The status reports, their table of contents, frequency and audience.
  • The meetings and conference calls for review- Agenda, participants, frequency and audience for the minutes of the meetings.
  • Communication plan regarding the general community (for example sharing the progress with the community in general)

Develop Program to Measure Success

You will firm-up the measures of success (some of which you might have done and shared with the sponsors during project definition phase). Some of the measures of success are:

  • Data Warehouse performance and response time
  • Number of users
  • Increase in the productivity
  • Accuracy of information
  • Reduction in costs
  • Increase of revenue

Develop Process to Manage Scope

This is an important step, and needs most re-enforcement with the stakeholders. As mentioned in the Data Warehouse has unique challenges, the scope is fluid and needs strong leadership to manage. The challenge is on the following counts:

  • The change in the requirements: Data Warehouse requirement in a way mirrors that way we manage our business. The information needed today may not be important tomorrow. As the business problems change, so do the information needs.
  • The change in the level of detail around the requirements: Most of the information requirements start with 'what is happening?’ which means a summary information along with management MIS. However, soon it gets changed into the 'why is it happening?' which means more sophisticated analysis and drill down to detailed/transactional level information.
  • Beyond the business problems, there can be a change in the strategy. An important business theme may not be important anymore as an organization changes the business strategy around distribution (say).

NOTE- Every change in the business strategy does not result in the change in the business theme of a data warehouse.

TIP- There can be various ways in managing the scope. It includes

  • Getting a commitment from the stakeholders
  • Robust change management process
  • Escalation process
 

   Data Warehouse Project Definition Data Warehouse Business Requirements Gathering Phase  
 
All Topics in: "Data Warehouse Project Plan- Work Break-Down Structure" Chapter
 Data Warehouse Project Definition →  Data Warehouse Project Initiation Phase →  Data Warehouse Business Requirements Gathering Phase →  Data Warehouse Modeling and Analyze Phase →  Data Warehouse Design Phase →  OLAP + Data Warehouse Design Phase →  Physical Database Design and Implementation → 
 

Was this page helpful?
If you like it ? share it !
Digg
Digg
Reddit
Reddit
Del.icio.us
Delicious
Google
Google
Live
Live
Facebook
Facebook
Slashdot
Slashdot
Netscape
Netscape
Technorati
Technorati
Stumbleupon
Stumbleupon
Spurl
Spurl
Furl
Furl
Blogmarks
Blogmarks
Yahoo
Yahoo
Plugim
Plugim
Squidoo
Squidoo
BlinkBits
BlinkBits
 
CONTENT ZONE
Data-Warehouse/Mart

Featured Pages
Data Group Master
Implementing Conformed Dimensions
Documenting data-integration system
OLAP Data Allocation Analysis

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
BI Competency Centre- Strategize Phase
ROLAP- Relational OLAP architecture
MDM-CDI Hub
Integrate stand-alone BI