Gartner Research

Solution Path for Planning and Implementing the Logical Data Warehouse

Published: 17 May 2017

ID: G00320563

Analyst(s): Henry Cook

Summary

Technical professionals implementing the logical data warehouse can maximize their effectiveness and the business benefit delivered by explicitly integrating three analytics development styles: the classic data warehouse, agile with data virtualization, and the data lake.

Table Of Contents

Problem Statement

Solution Path Diagram

What You Need to Know

Solution Path

  • Step 1: Initiate Phase or Project
    • Planning
    • Platform Sizing and Cost Estimation
    • Establish Architectural Principles
  • Step 2/DW: Data Warehouse Stream
    • Design the Architecture and Then the Physical System
    • Document "As Is" System
    • Design To-Be Architecture
    • Data Modelling and Metadata
    • Develop the Data Model
    • Assess Data Warehouse Automation
    • Evaluate a Cloud-First Approach
    • Evaluate Open-Source Software
    • Metadata: Business Glossary and Technical Metadata
    • Put Data Quality Measures in Place
    • Information Governance
    • Formalize MDM for Critical Business Data
    • Automate DW Testing
    • Data Ingest Design
    • Migration vs. Greenfield
    • Report Suite Design
    • Establish or Grow DW Platform
    • Develop and Deploy the DW
    • The Initial Load Strategy
  • Step 2/DV: Data Virtualization, Agile Development and Self-Service Stream
    • Agile Data Marts and Sandboxes
    • Data Virtualization
    • Forward Planning for Virtualization
    • Establish or Grow Agile and Self-Service Platforms
  • Step 2/DL: Data Lake Stream
    • Design the Data Lake Architecture
    • Data Acquisition
    • Discovery and Development of Insight
    • Data Lake Optimization and Governance
    • Data Lake Analytics Consumption
    • Provision the Data Lake
    • Secure the Data Lake
    • Cloud Adoption
  • Step 3: Wrap Up the Development Cycle
    • Change Control
    • Monitoring and Administration
    • Capacity Planning and Workload Management
    • Evaluate New Technology Options for the Next Cycle
  • Summary, Matching Requirements in Development Cycles
  • Detailed Descriptions of the LDW Components
  • Details on Requirements-Gathering and Business Case
    • Gather and Prioritize Requirements
    • Align Business Strategy
    • Form the IT and Business Team
    • Develop or Firm Up the Business Case
    • Project or Phase Initiation and Kick-Off Workshop

Gartner Recommended Reading

©2020 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Become a client

Learn how to access this content as a Gartner client.