BT

Agile Business Intelligence

by Mark Levison on Jun 17, 2008 |

Scott Ambler, author of Refactoring Databases: Evolutionary Database Design, writing for Cutter IT Journal has written about how Agile methods can be adapted for Data Warehousing and Business Intelligence systems. Scott and his co-authors are writing for an audience who's users are suffering from large centrally designed systems.

In Scott's opinion mainstream Data Warehousing projects often fall short of user's expectations:

End users commonly complain that the delivered BI capability does not keep
pace with rapidly evolving business requirements and that the BI development team does not engage effectively with the user community. Requirements are collected at the beginning of the process, then the BI development team defines an architecture, general design, and detailed design based on the initial understanding of the requirements. The BI team often recognizes that user involvement is important through these development phases, but this involvement is very limited once the project starts.

Beyond the adoption of an Agile approach Scott has a few other key recommendations:

  • Apply Agile Data techniques: Evolutionary data modelling, Database refactoring, Database regression testing, Continuous Database Integration and Reuse of existing datamodels.
  • Recognize the Limits of a "Single Version of the Truth":
    • It is important to recognize that there can be several truths and to identify those truths, .... The driving principle should not be purity of the definition but the timely delivery of important business value.

  • Adopt SOA and Web 2.0 Strategies: consider the Data Federation and Enterprise architectural integration patterns to reduce the Total Cost of Ownership.
  • Adopt a Lean Data Governance Strategy: Use business-driven project pipelines, Implement flexible architectures and Set risk-based milestones.

To read more visit the free download of the Cutter IT Journal and enter the promotion code BUSINESSINTELLIGENCE.

Hello stranger!

You need to Register an InfoQ account or to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2013 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT