Visitors Edition
Already a member? Sign In.

Need help? Our Trial Membership program will get you help on any IT project you're working on. You'll get access to our research, tools, advice and project help.

Start Trial Membership Learn More

Membership Help?

Want to learn more about our membership options, pricing, or to get a product demo? Get in touch with one of our reps using an option below.

I Want Help with a Membership Live Chat

Build a Data Warehouse on a Solid Foundation

Evaluate the need for a data warehouse and plan the project.

More Details
  • Print
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
Build-a-data-warehouse-on-a-solid-foundation---sb
Download the Storyboard Overview

Your Challenge

  • Poor planning is the root of all failed data warehouse projects.
  • Project overruns are primarily a function of underestimating the importance and complexity of developing the data requirements and inadequate staffing.
  • Successful warehousing strategies start with business focused requirements, the right team, and a sound project plan.

Our Advice

Critical Insight
  • Data warehousing (DW) is a business discipline, not an IT infrastructure project.
  • The value of a DW consists in providing decision makers timely and accurate views of the business.
  • DW architecture design and data modeling starts with understanding the information requirements of business users.
Impact and Result
  • Assess organizational readiness and develop a game plan that prepares the organization for success.
  • Establish justifiable business goals and a realistic implementation roadmap that enables early business value.
  • Define the correct DW requirements and tailor your reporting/analysis needs to avoid overbuilding.

Get to Action

  1. Build a data warehouse plan and strategy

    Avoid over-engineering the data warehouse.

  2. Assess the readiness of the organization for a DW

    Ensure that the right people, processes, and technology are in place.

  3. Craft a sound business plan

    Start with a realistic scope based on clear business justification.

Related Solution Sets

Deliver the BI Tools and Information Needed by Management

Navigate the BI maze, and find a straight path to the solution that fits your needs.

Move From Chaos to a Realistic Data Integration Strategy

Find a balance between a hopelessly tangled web of integration structures and expensive, impractical utopia.

Overcome the Barriers to Good Requirements Management

In the recipe for good requirements management, IT adds the special sauce.

Optimize the BI Program for a Better ROI

Squeeze more juice from the fruits of your BI labor.

Tags

data warehouse, data warehousing, data model, data models, data modeling, data mart

Related Content


Get the Complete Storyboard

See how all the steps you need to take come together, with tools and advice to help with each task on your list.

BONUS Get access to up to 5 additional free downloads

Download Now
Evaluate the need for a data warehouse and plan the project.

Solution Road Map

Other Solution Sets in Business Intelligence & Analytics

  1. Develop a BI Strategy
    Business Intelligence is about insight, not technology.
  2. Deliver the BI Tools and Information Needed by Management
    Navigate the BI maze, and find a straight path to the solution that fits your needs.
  3. Vendor Landscape: Enterprise BI
    Before you can make the right data-driven decisions, you need to select the right BI vendor.
  4. Vendor Landscape: Mid-Market BI
    Enabling business users to make intelligent business decisions.
  5. Build a Data Warehouse on a Solid Foundation
    Evaluate the need for a data warehouse and plan the project.
  6. Execute the BI Implementation while Avoiding Common Pitfalls
    The BI implementation has set sail; make sure end users are all on board.
  7. Optimize the BI Program for a Better ROI
    Squeeze more juice from the fruits of your BI labor.
  8. Formulate a Social Analytics Strategy
    Decide when to do more than merely follow yourself on Twitter.
  9. Decide Whether Microsoft Business Intelligence 2012 Fits the Bill
    Microsoft Business Intelligence 2012 focuses on self-serve BI.
View the full Solution Road Map