Access your Pro+ Content below.
Applying agile methods to data warehouse projects
This article is part of the BI Trends + Strategies issue of Issue 1 January 2012
Rapidly gaining in popularity, the Agile approach to data warehousing solves many of the thorny problems typically associated with data warehouse development—most notably high costs, low user adoption, ever-changing business requirements and the inability to rapidly adapt as business conditions change. The Agile approach can be used to develop any analytical database, so let’s begin with two familiar definitions: A Data Warehouse (DW) is simply a database that contains integrated and homogenized information from one or more sources brought together to support analysis and reporting. These sources can be your internal online transactional processing (OLTP) systems such as finance, accounting, sales, marketing, payroll, supply chain, etc., or external sources such as supplier files, purchased marketing lists, Facebook, Twitter or census data, etc. In addition to the data warehouse, you may also be using additional types of databases for analysis and reporting. The most common types include data marts and operational data stores ...
Features in this issue
The air is thin at the top of the hype curve, so breathe deeply as we explore the reality of big data—and the changes it entails for BI and data warehousing systems.
Agile development processes can take a lot of the pain out of building data warehouses and enable project teams to deliver functionality, and business value, on a rolling basis.
News in this issue
A Virginia-based energy company is relying on advanced data visualization, geospatial data and visual analytics to stay a step ahead of thieves who’ve taken a shine to copper wire.