Premium Content

Access "Applying agile methods to data warehouse projects"

Jim Gallo Published: 16 Nov 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 (ODSs).  Business Intelligence... Access >>>

Access TechTarget
Premium Content for Free.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

What's Inside

    • The hype vs. the reality of big data by Barry Devlin

      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.

More Premium Content Accessible For Free