BI/Data Warehousing

 PSC's Hybrid Approach

PSC’s Data Warehouse lifecycle methodology is a ‘hybrid’ approach that integrates the most relevant components of Agile and Traditional development methodologies into a Data Warehouse approach that has a proven track record of success. We incorporate the proven structure of a traditional lifecycle (such as the Planning. Initiation and Analysis/Design Phases) and apply agile concepts and methodologies to deliver a flexible and streamlined process that gives your complicated Data Warehouse project the structure and discipline required to ensure success.

 PSC's Methodology and Templates

 

The key components of our methodology and the associated templates are listed below:

 vs. Traditional Approaches

Traditional Data Warehouse methodologies/approaches are typically thought of as sequential and slow, but that is only true in the hands of a Project Manager and Technical lead that are inexperienced with Data Warehouse projects. Our approach ensures that proper data warehouse strategies and planning are completed so that we identify activities that can be run in parallel to reduce overall project timelines. Proper planning is a key component to ensure you truly know the level of effort, cost and timelines to successfully complete your data warehouse project.

 Planning / Initiation Phase

  • Project Charter
  • Project Scope
  • Project Plan
  • Project Resource Model
  • Communication Plan
  • Project Team Member Resource Plan
  • Project Budget Tracking
  • Team and Project Status Reports
  • Weekly Sponsor Milestone Update
  • Meeting Notes
  • Issues and Action Logs
  • Requirements Document
  • Requirements Traceability Matrix
  • End User Support Model/Service Level Agreements for BI projects
  • Project Change Request
  • Project Closeout

 Design/Development

  • Data Model Conceptual Design Document
  • Data Mapping Document (Source tables to target Data Warehouse tables)
  • Physical Database Design Document
  • ETL Architecture Conceptual Design Document
  • ETL Standards
  • Report Design Templates
  • Business Objects Universe (semantic layer) Design Standards and Guidelines
  • Database naming conventions
  • Capacity Planning and Sizing templates
  • Data Bus Conceptual Design (Conformed Dimensions)
  • User Interface and Security Requirements Template

 Testing/QA/Deployment

  • Data Layer Test Plans
  • BI/Reporting Layer Test Plans
  • Data Layer Deployment Plans
  • Reporting Layer Deployment Plans
  • Knowledge Transfer Documents
  • End User Training
©2010 People Services Center.  All rights reserved.  Phone:  402.715.5800  Customerservice@peopleservices.biz