Data Warehouse can wait- Start with Data-Marts

Very often we find organizations spending a lot of time planning and less time executing. So is the case with long gestation projects like Datawarehouse. Most often, requirements keep changing, business challenges are also dynamic.

Here’s an interesting article on how enterprises must start with data marts and get some quick-wins before they move to large scale DW projects:

An Enterprise Data Warehouse is a long term commitment: There are many imperatives (or foundations), which are key for a Data Warehouse. The examples of these imperatives are foundation or conformed dimensions, fine-grained granular data, comprehensive star-schemas etc…These elements need high level of readiness and investments to build these foundations. These foundations (though great for data marts as well) can be compromised for initial set of Data-marts.

Business Learning– Initial set of data-marts will provide great learning, less on the IT side and more on the business side. Here are the set of learnings from business side:

  • Creating business themes
  • Building Data-Mart Business Requirements
  • Building Dimensional Model
  • Testing of Data-Mart
  • Taking business decisions around the extraction and transformation
  • Generating the information out of the Data-Mart through end-user tools (like reporting and analytics application)

Examples of IT Learnings:

  • Extraction, Transformation and Loading design
  • Processing Load Management
  • Handling Data Explosion (data goes up exponentially as you add sparse fields- where most of the records are blank)
  • Change Management (end-to-end impact analysis if you make a change in the Data Mart Model)

Show-case for sponsors: A successful Data-Mart makes sponsorship of a Data Warehouse much easier.

Quick-hit: A Data-mart is a quick hit and gives earlier gratification.

Non-Disruptive: It does not take away the attention of an organization from other big things


0 Responses to “Data Warehouse can wait- Start with Data-Marts”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

At Cequity, we believe customer intelligence will be the biggest competitive advantage enterprises will have in the next decade or two. Successful enterprises of tomorrow will be the ones who can organize and leverage this information at speed to optimize their marketing performance, increase accountability, improve profit and deliver growth. Cequity insights will bring to you trends and insights in this area and it’s our way of sharing best practices so as to help you accelerate this culture and thinking in your organization.
July 2008
« Jun   Aug »

Blog Stats

  • 21,687 hits

%d bloggers like this: