Get Instant Access
to This Blueprint

Data Business Intelligence icon

Build a Data Warehouse

Business insights come from both structured and unstructured data.

  • Relational data warehouses, although reliable, centralized repositories for corporate data, were not built to handle the speed and volume of data and analytics today.
  • IT is under immense pressure from business units to provide technology that will yield greater agility and insight.
  • While some organizations are benefitting from modernization technologies, the majority of IT departments are unfamiliar with the technologies and have not yet defined clear use cases.

Our Advice

Critical Insight

  • The vast majority of your corporate data is not being properly leveraged. Modernize the data warehouse to get value from the 80% of unstructured data that goes unused.
  • Avoid rip and replace. Develop a future state that complements your existing data warehouse with emerging technologies.
  • Be flexible in your roadmap. Create an implementation roadmap that’s incremental and adapts to changing business priorities.

Impact and Result

  • Establish both the business and IT perspectives of today’s data warehouse environment.
  • Explore the art-of-the-possible. Don’t get stuck trying to gather technical requirements from business users who don’t know what they don’t know. Use Info-Tech’s interview guide to discuss the pains of the current environment, and more importantly, where stakeholders want to be in the future.
  • Build an internal knowledgebase with respect to emerging technologies. The technology landscape is constantly shifting and often difficult for IT staff to keep track of. Use Info-Tech’s Data Warehouse Modernization Technology Education Deck to ensure that IT is able to appropriately match the right tools to the business’ use cases.
  • Create a compelling business case to secure investment and support.

Build a Data Warehouse Research & Tools

Start here – read the Executive Brief

Read our concise Executive Brief to find out why you should be looking to modernize the relational data warehouse, review Info-Tech’s framework for identifying modernization opportunities, and understand the four ways we can support you in completing this project.

1. Assess the current data warehouse environment

Review the business’ perception and architecture of the current 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.


Overall Impact


Average $ Saved


Average Days Saved




$ Saved

Days Saved

Central California Alliance for Health

Guided Implementation





Guided Implementation




Learning about MS Synaps and getting direction on building our Data warehouse.

Festival Foods, Inc.

Guided Implementation




Platte River Power Authority

Guided Implementation




Dirk did a great job of emphasizing the fact that this is a program, not a project and that it will require extensive, on-going business unit invol... Read More


Guided Implementation




Workshop: Build a Data Warehouse

Workshops offer an easy way to accelerate your project. If you are unable to do the project yourself, and a Guided Implementation isn't enough, we offer low-cost delivery of our project workshops. We take you through every phase of your project and ensure that you have a roadmap in place to complete your project successfully.

Module 1: Assess the Current Data Warehouse Environment

The Purpose

  • Discuss the general project overview for data warehouse modernization.
  • Establish the business and IT perspectives of the current state.

Key Benefits Achieved

  • Holistic understanding of the current data warehouse.
  • Business user engagement from the start of the project.




Review data warehouse project history.

  • Data warehouse maturity assessment

Evaluate data warehouse maturity.


Draw architecture diagrams.


Review supporting data management practices.

  • Data architecture diagrams

Module 2: Explore Business Opportunities

The Purpose

  • Conduct a user workshop session to elicit the most pressing needs of business stakeholders.

Key Benefits Achieved

  • Modernization technology selection is directly informed by business drivers.
  • In-depth IT understanding of the business pains and opportunities.




Review general trends and drivers in your industry.

  • Business ideas for modernization

Identify primary business frustrations, opportunities, and risks.


Identify business processes to target for modernization.


Capture business ideas for the future state.

  • Defined strategic direction for data warehouse modernization

Module 3: Review the Technology Landscape

The Purpose

  • Educate IT staff on the most common technologies for data warehouse modernization.

Key Benefits Achieved

  • Improved ability for IT to match technology with business ideas.




Appoint Modernization Advisors.

  • Modernization Advisors identified

Hold an open education and discussion forum for modernization technologies.

  • Modernization technology education deck

Module 4: Define Modernization Solutions

The Purpose

  • Consolidate business ideas into modernization initiatives.

Key Benefits Achieved

  • Refinement of the strategic direction for data warehouse modernization.




Match business ideas to technology solutions.

  • Identified strategic direction for data warehouse modernization

Group similar ideas to create modernization initiatives.

  • Defined modernization initiatives

Create future-state architecture diagrams.

  • Future-state architecture for data warehouse

Module 5: Establish a Modernization Roadmap

The Purpose

  • Validate and build out initiatives with business users.
  • Define benefits and costs to establish ROI.
  • Identify enablers and barriers to modernization.

Key Benefits Achieved

  • Completion of materials for a compelling business case and roadmap.




Validate use cases with business users.

  • Validated modernization initiatives

Define initiative benefits.


Identify enablers and barriers to modernization.


Define preliminary activities for initiatives.


Evaluate initiative costs.

  • Data warehouse modernization roadmap

Determine overall ROI.

Build a Data Warehouse preview picture

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.


Overall Impact

Average $ Saved

Average Days Saved

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.

Read what our members are saying

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.

Need Extra Help?
Speak With An Analyst

Get the help you need in this 3-phase advisory process. You'll receive 6 touchpoints with our researchers, all included in your membership.

Guided Implementation 1: Assess the current data warehouse environment
  • Call 1: Discuss Info-Tech’s approach to modernization and the importance of business input
  • Call 2: Review business user survey results and discuss how to define the current state from an IT perspective

Guided Implementation 2: Define modernization drivers
  • Call 1: Review IT’s current state assessment and discuss conducting business user workshops/interviews
  • Call 2: Review modernization ideas from the business; create approach for building internal IT knowledge for modernization technology

Guided Implementation 3: Create the modernization future state
  • Call 1: Match modernization technologies to business ideas and discuss future state diagrams
  • Call 2: Review finalized initiatives, discuss costs/benefits, and build modernization roadmap


Daniel Ko

Kolade Odetoyinbo


  • Debora Bielecki, Partner, Bielecki & Associates
  • Devon Wright, CEO, Turnstyle Solutions
Visit our IT Cost Optimization Center
Over 100 analysts waiting to take your call right now: 1-519-432-3550 x2019