logo for information-management-architect.com
leftimage for information-management-architect.com

Enterprise Data Warehouse

Improve service with David Bowman’s information management guidelines for enterprise data warehouse

This site is designed for Information Technology professionals who need to improve service and want guidance and direction to help teams consistently produce error free results.

It provides information management guidelines for data warehouse architecture and technology.

What is a Data Warehouse Solution?

Data warehouse solutions are usually involved with some, or all of, the following:
  • Extracting data from operational source systems;
  • Transforming data as required to ensure consistency;
  • Loading data into a data warehouse or some form of storage optimized for efficient storage;
  • Extracting data from the data warehouse;
  • Loading departmental data marts optimized for reporting and analytics; and
  • Some form of reporting tool architecture e.g. universe design or some middle ware design to insulate users from the data warehouse
The following diagram depicts a typical data warehouse and business intelligence environment.

data warehouse architecture

Information is a valuable corporate asset and getting the right information, to the right people at the right time is a key management objective.

Achieving this objective requires robust technology and optimal data architecture based on industry best practices.

Data Warehouse Architecture
  • Should provide the architecture to store data at every step of the data warehousing and business intelligence process from the operational systems to the analytic applications; and
  • Should follow information management guidelines for data warehouse architecture
Data Integration Architecture
  • Should provide the architecture and processes to obtain data;
  • Should provide data integration processes e.g. extract, transform and load, change data capture and cleansing tools  support of data warehousing; and
  • Should follow information management guidelines for data integration architecture
Business Intelligence Architecture
  • Should provide the foundation for deriving business value from data warehouse assets;
  • Should facilitate whatever data analysis and reporting is required;
  • Might require a combination of technologies to support reporting and report distribution, business intelligence, and enterprise performance management; and
  • Should follow information management guidelines for business intelligence architecture
Technology and Tools
Enterprise Data Warehouse Guidelines
  • Should be designed as a central repository of detailed, historical, enterprise-wide information;
  • Should segment data warehouse components such as data integration, reporting or analysis;
  • Should ensure source systems should be the source for operational reporting;
  • Should consider operational data stores to provide a central integration of a given subject, such as customer, that feeds operational systems and feeds the warehouse; and
  • Should use data marts provide content specific data to a business area, aggregated above the detail in the warehouse and with less history.
Summary...

Information is a valuable corporate asset and getting the right information, to the right people at the right time is a key management objective.

Achieving this objective requires robust technology and optimal data architecture based on industry best practices.

This site provided information management guidelines for data warehouse architecture and technology.