• Home
• Products & Solutions
• Business Intelligence
• Datawarehouse Lifecycle

Datawarehouse Lifecycle

The simple, but critical principle, that all data moves through life-cycle stages is key to improving data management. By understanding how data is used and how long it must be retained, companies can develop a strategy to map usage patterns to the optimal storage media, thereby minimising the total cost of storing data over its life cycle. Without the ability to manage relational data effectively, relative to its use and storage requirements, runaway database growth will result in increased operational costs, poor performance, and limited availability for the applications that rely on these databases.

A successful datawarehouse is built in discrete phases. You can engage Avnet Client Solutions for all phases or a selection of phases, for example, partner with Avnet Client Solutions for Analysis through to Design and use internal resources to develop the remaining phases. Business Intelligence. Business Intelligence.

Here is a typical timeframe for a datawarehouse lifecycle.

• Analysis and Scope
  2-10 days of effort
  Scope for the Design Stage is defined
• Design Stage
  Can range between 10 to 40 days
  Typical Design could be 20 days
• Build and System Testing Stage (Phase 1)
  Typical build effort will be a given factor of the Design effort
• UAT Stage Phase 1
  Typically 20-40% of Build effort
• Reporting Stage (Phase 1)
  Dependant on the number of reports and their complexity