January 2015

Sponsored by WhereScape

Download pdf

Three key ways in which data warehouse automation changes the design, development and ongoing maintenance of data warehouses and marts. First, how automation addresses the old conundrum of delivering consistent, quality data in the timeframe demanded by modern business needs. Second, how streamlining the overall process provides a single repository of metadata and integrated tooling to speed and simplify development. Third, how business and IT can truly collaborate in delivering business solutions. 

Abstract

A quiet evolution is underway. While media attention focuses on big data, the ongoing work of delivering business value through daily decision making support still continues through business intelligence and data warehousing efforts. The quiet but conspicuous evolution has been in the ease with which these projects proceed. The evolution has been data warehouse automation.

This paper explores three key ways in which data warehouse automation changes the design, development and ongoing maintenance of data warehouses and marts. First, we examine how automation addresses the old conundrum of delivering consistent, quality data in the timeframe demanded by modern business needs. Second, we explore how streamlining the overall process provides a single repository of metadata and integrated tooling to speed and simplify development. Third, we observe how business and IT can truly collaborate in delivering business solutions.

Using examples from three WhereScape clients, a large bank, a smaller credit union and a small, for-profit childcare organization, this paper offers a clear business and IT rationale for adopting data warehouse automation and shows its benefits across very different business types and sizes.