• Marketplace

  • Find DW Basics products & services on
    DM Review Marketplace

• Channel Resources

  Articles from this Site

  • Dazed and Confused - Product Roadmaps, Upgrades and Migrations: BI and DW Trends, 8 for '08

  • Assessments - A Mandatory BI/DW Pit Stop

  • Can anyone share some experience as to how to test a data warehouse?

  • When is it better to have normalized data to create data marts and when is it better to have dimensional data?

  • ICICI Bank Standardizes on Informatica

  • More Articles from this Site

  White Papers

  • Spend Data Warehouse on Steroids

  • An Architected Approach to Integrated Information

  • KALIDO Business Modeling

  • Data Warehouse Lifecycle Management

  • Data Warehousing Ensuring Data Integrity

  • More White Papers

  Books

  • The Enterprise Data Warehouse: Planning, Building, and Implementation

  • Enterprise One to One: Tools for Competing in the Interactive Age

  • Data Warehousing Advice for Managers

  • The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses

  • 90 Days to the Data Mart

  • More Books

FREE DM Review Site Registration!

Sign-up today and access DM Review on the Web! Your FREE registration entitles you to: FREE email newsletters FREE access to all DM Review content FREE access to web seminars, resource portals, our white paper library and more!     Publisher reserves the right to serve qualified requesters only.

DW Basics Channel

Channel Sponsored by

Data warehouses are often at the heart of the strategic reporting systems used to help manage and control the business. The function of the data warehouse is to consolidate and reconcile information from across disparate business units and IT systems and provide a context for reporting on and analyzing:

• Corporate performance management
• Profitability
• Consolidated financials
• Compliance

As strategic as they are, enterprise data warehousing projects are highly complex and can be risky. Projects fail almost as much as they succeed, often because of long development cycles, poor information quality and an inability to adapt quickly to changing business conditions or requirements.

The purpose of this portal is to help data warehousing professionals keep the probability of success in their favor by staying abreast with the latest technology and best-practices topics, including:

• Data integration and reconciliation
• Data quality and master data management (MDM)
• Iterative delivery
• "Packaged" data warehousing applications
• Data warehouse performance
• Deployment and change management

This Data Warehousing Basics channel is brought to you by DM Review and Kalido - the leading provider of adaptive enterprise data warehousing and master data management software. It will be updated on a continual basis.

Articles

Essential Steps for the Integrated Enterprise Data Warehouse, Part 2

This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.

Essential Steps for the Integrated Enterprise Data Warehouse, Part 1

This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.

Data Warehousing and Business Intelligence is a Service-Oriented Architecture

This paper examines how data warehousing and business intelligence fit into a service-oriented architecture.

Time and Time Again: Managing Time in Relational Databases Part 16 - Physical Implementation of Version Pattern 1

This installment in our series begins to describe the physical implementation of versioning patterns.

Enterprise Data Warehouse Challenges

The enterprise data warehouse provides organizations with a single view of data across disparate business units and IT systems to assist management in making better-informed business decisions. Gaining buy-in is crucial, but there are some obstacles to overcome.

Columns

The Song Remains the Same - Data Shadows Systems Continue to be Pervasive for Reporting and Analytics: BI and DW Trends, 8 for ’08

BI may not be pervasive, but spreadsheets are.

Data Warehousing Meets Data Archiving in Information Lifecycle Management

Data warehousing without archiving is like a garage that a family has used for several generations.

The Role of Packaged BI Applications in Delivering Enterprise-Wide BI and DW

This column explores addressing the role of packaged BI applications in an enterprise BI/DW architecture.

Eight Best Practices in Dashboard Design

With the excesses of raw data all around us, the competitive advantage shifts to those with ordered actionable information.

Dazed and Confused - Product Roadmaps, Upgrades and Migrations: BI and DW Trends, 8 for ’08

Dazed and confused - such is the fate of the customers of Business Objects, Cognos and Hyperion as their respective acquirers decide how to shape future product lines.

Ask the Experts

Can anyone share some experience as to how to test a data warehouse?

When is it better to have normalized data to create data marts and when is it better to have dimensional data?

How do I convince my reluctant boss to begin work on a data warehouse?

Where is the best place for a BI application to reside?

How can I enhance the productivity of my fact table load?

White Papers

Spend Data Warehouse on Steroids

By Zycus

An Architected Approach to Integrated Information

By David Waddington

KALIDO Business Modeling

By Bruce Ottmann

Data Warehouse Lifecycle Management

By Cliff Longman

Data Warehousing Ensuring Data Integrity

By Cindy Maurer

Books

	The Enterprise Data Warehouse: Planning, Building, and Implementation By Eric Sperley
	Enterprise One to One: Tools for Competing in the Interactive Age By Don Peppers, Martha Rogers
	Data Warehousing Advice for Managers By Patricia L. Ferdinandi