Build an Extensible Data Warehouse Foundation

Data warehouse implementation is a costly and complex undertaking, and can end up not serving the business' needs appropriately.
Too heavy a focus on technology creates a data warehouse that isn’t sustainable and ends up with poor adoption.
Emerging data sources and technologies add complexity to how the appropriate data is made available to business users.

Our Advice

Critical Insight

A data warehouse is a project; but successful data warehousing is a program. An effective data warehouse requires planning beyond the technology implementation.
Governance, not technology needs to be the core support system for enabling a data warehouse program.
Understand business processes at the operational, tactical, and ad hoc levels to ensure a fit-for-purpose DW is built.

Impact and Result

Leverage an approach that focuses on constructing a data warehouse foundation that is able to address a combination of operational, tactical, and ad hoc business needs.
Invest time and effort to put together pre-project governance to inform and provide guidance to your data warehouse implementation.
Develop “Rosetta Stone” views of your data assets to facilitate data modeling.
Select the most suitable architecture pattern to ensure the data warehouse is “built right” at the very beginning.

Build an Extensible Data Warehouse Foundation Research & Tools

Start here – read the Executive Brief

Read our concise Executive Brief to find out why the data warehouse is becoming an important tool for driving business value, review Info-Tech’s methodology, and understand the four ways we can support you in completing this project.

Build an Extensible Data Warehouse Foundation – Executive Brief

1. Prepare for the data warehouse foundation project

Begin the data warehouse foundation by defining the project and governance teams, as well as reviewing supporting data management practices.

2. Establish the business drivers and data warehouse strategy

Using the business activities as a guide, develop a data model, data architecture, and technology plan for a data warehouse foundation.

3. Plan for data warehouse governance

Start developing a data warehouse program by defining how users will interact with the new data warehouse environment.

Member Testimonials

After each Info-Tech experience, we ask our members to quantify the real-time savings, monetary impact, and project improvements our research helped them achieve. See our top member experiences for this blueprint and what our clients have to say.

9.2/10

Overall Impact

$17,570

Average $ Saved

Average Days Saved

Client

Experience

Impact

$ Saved

Days Saved

Testimonial

Tonkin & Taylor Limited

Guided Implementation

9/10

N/A

Great experience, very insightful it was a helpful session!

Katz Media Corporation

Guided Implementation

9/10

N/A

Best part was collaborating with Usman and Alessandra to build a functional reporting database. Worst part was how limiting MS Access can be.

Niagara Health System

Guided Implementation

9/10

$5,000

Sunflower Bank

Guided Implementation

10/10

N/A

Pivot Advisors

Guided Implementation

9/10

$30,140

All very positive. Have more questions as time allows.

Ansa McAl

Guided Implementation

4/10

$68,000

100

Highlighted key concerns that we need to address and provide very useful information to help us determine the way forward. Looking forward to the ... Read More

Dark Fibre Africa

Guided Implementation

10/10

N/A

The best part was the advices and worse part was time limit. The time was not enough to cover everything.

Load More Testimonials

About Info-Tech

Info-Tech Research Group is the world’s fastest-growing information technology research and advisory company, proudly serving over 30,000 IT professionals.

We produce unbiased and highly relevant research to help CIOs and IT leaders make strategic, timely, and well-informed decisions. We partner closely with IT teams to provide everything they need, from actionable tools to analyst guidance, ensuring they deliver measurable results for their organizations.

What Is a Blueprint?

A blueprint is designed to be a roadmap, containing a methodology and the tools and templates you need to solve your IT problems.

Each blueprint can be accompanied by a Guided Implementation that provides you access to our world-class analysts to help you get through the project.

Authors

Daniel Ko

Kolade Odetoyinbo

Contributors

Chris Debo, Senior Manager, Schneider Downs & Co., Inc.
Jaison Dominic, Lead Architect, Enterprise Data Warehouse, Moffitt Cancer Center
Liselle Ramcharan, Project Manager, TD Insurance
Randy Piscione, Enterprise Data Architect, BMO Financial Group
Sree Pulapaka, Director of Enterprise Business Innovation and Analytics, Metropolitan Washington Airports Authority
1 anonymous contributor