Business Analyst Articles: Business Analysis & Systems Analysis

» April 2014 (4)
» March 2014 (7)
» February 2014 (6)
» January 2014 (6)
» December 2013 (7)
» November 2013 (4)
» October 2013 (5)
» September 2013 (6)
» August 2013 (8)
» July 2013 (8)
» June 2013 (7)
» May 2013 (8)
» April 2013 (8)
» March 2013 (4)
» February 2013 (6)
» January 2013 (6)
» December 2012 (5)
» November 2012 (7)
» October 2012 (6)
» September 2012 (6)
» August 2012 (5)
» July 2012 (9)
» June 2012 (5)
» May 2012 (9)
» April 2012 (7)
» March 2012 (7)
» February 2012 (5)
» January 2012 (7)
» December 2011 (6)
» November 2011 (6)
» October 2011 (8)
» September 2011 (6)
» August 2011 (8)
» July 2011 (7)
» June 2011 (7)
» May 2011 (5)
» April 2011 (8)
» March 2011 (6)
» February 2011 (5)
» January 2011 (6)
» December 2010 (5)
» November 2010 (9)
» October 2010 (5)
» September 2010 (6)
» August 2010 (8)
» July 2010 (6)
» June 2010 (6)
» May 2010 (10)
» April 2010 (5)
» March 2010 (8)
» February 2010 (7)
» January 2010 (7)
» December 2009 (7)
» November 2009 (7)
» October 2009 (6)
» September 2009 (8)
» August 2009 (10)
» July 2009 (9)
» June 2009 (5)
» May 2009 (10)
» April 2009 (5)
» March 2009 (12)
» February 2009 (8)
» January 2009 (6)
» December 2008 (9)
» November 2008 (8)
» October 2008 (9)
» September 2008 (4)
» August 2008 (6)
» July 2008 (8)
» June 2008 (17)
» May 2008 (12)
» April 2008 (7)
» March 2008 (21)
» February 2008 (16)
» January 2008 (13)
» December 2007 (9)
» November 2007 (25)
» October 2007 (2)
» September 2007 (23)
» August 2007 (12)
» July 2007 (11)
» June 2007 (7)
» May 2007 (6)
» April 2007 (9)
» March 2007 (5)
» February 2007 (3)
» January 2007 (2)
Articles and White Papers
Sunday, October 07, 2012
4187 Views 1 Comments 1 members voted Article Rating

Data Analysis for  Business Analysts: Data  Modeling in an Agile TeamWhen ModernAnalyst asked me to write an article on Agile Data Modeling, I suggested that Scott Ambler would be the best person to write an article on Agile Data, but he was already scheduled to write for the issue! So, I spent some time at Enterprise Data World, a conference held in Tampa, Florida, informally polling the data management professionals there about their experiences with Agile.  There were a wide variety of opinions, both positive and negative; everyone was happy to share opinions. Some basic themes emerged regarding the areas where data modeling provides a valuable tool to the Agile team: extensibility, flexibility, and stability. I looked back at the Agile Manifesto[1], it seemed to me that these themes speak directly to three of the twelve principals:

Welcome changing requirements, even late in
development. Agile processes harness change for
the customer's competitive advantage.

Agile processes promote sustainable development.
The sponsors, developers, and users should be able
to maintain a constant pace indefinitely.

Continuous attention to technical excellence
and good design enhances agility.

One of the most significant characteristics of an Agile engagement is that technical and business professionals work collaboratively to grow the system. The team agrees upon the goals for the project, as well as the order in which the requirements will be addressed on each of the sprints. They meet daily to discuss next steps, and balance the value provided in each sprint against the development cost and the business needs. At least one team member should have the role of “data advocate”; a person who wears the data hat  and focuses on articulating requirements that need to be assessed using data management best practices in a way that addresses both the business and technical audience.

This article assumes a basic understanding of the agile method [2] and data management terminology [3].

Extensibility - Changing Requirements
As the data advocate, explain the risk or value associated with each data requirement-related decision.   Share these tips that I gleaned from my conversations with the team member wearing the data hat:

  • On projects that improve an existing system, the agile approach has the benefit of leveraging existing data architecture. One of the first tasks on an enhancement burn down list [4] should be to identify existing data design and architecture documentation!

  • Define terms that will eventually become part of the system taxonomy using a data model. This picture is a very concise way to document a large number of requirements and significantly reduce written text.

  • As the data requirements are discovered, capture the information directly in the data model. Use color or font in the model to designate the sprint in which an attribute, entity, or relationship will be implemented.

  • Include valid values, data sourcing characteristics in attribute notes and leverage the data model for mapping documentation.

  • Annotate the diagrams to highlight existing system limitations and inflexibility.  

  • Watch for primary key or relationship changes to existing structures. Tthey cause a ripple effect that needs to be reflected in the burn down list with additional impact analysis and test cases for each piece of code that uses them.

  • Explain the technical implications of returning multiple rows instead of a single row through screen and report design.

  • Team composition for an enhancement project can be more flexible, because much of the design decisions are a fait accompli; in some cases the data modeler can be an extended team member, called on an as-needed basis.  

Flexibility - Sustainable Development
Maintaining a constant pace is a goal; traditional system development life-cycle approaches typically have peaks and valleys as phase deliverables become due. One data modeling technique enables the slow build-out of detail: the conceptual model. The system logical data model can grow with each sprint; the conceptual model reinforces healthy organized growth. Without a conceptual model, agile projects are inhibited from graceful transitions between sprints by continual rework.

  • Include all potential requirements in the conceptual model in the very first sprint, but only build out the logical model detail by sprint as necessary.

  • Incorporate history requirements in the concept model to minimize impact to key structures.

  • Include internationalization and localization [5] requirements in the concept model for the same reason.

  • Remember to define a primary key and relationships for each major concept in order to provide the framework for the data design.

  • Use meta data to document policy decisions on data sourcing, appropriate usage, and security classification.

  • Recognize in the design, that data structures have a long life, and that compromises made in structural design will impact any future consumers of the data. DOCUMENT COMPROMISES in the data model.

Stability - Technical Excellence & Good Design
For a project team to succeed using the Agile method, each team member must share their practice knowledge, and be honest about their skills. Every development project has a data component, even if only reading and displaying information. The danger in an Agile project is to focus on development speed and budget constraints, at the expense of maintainability.

  • Identify data governance as new structures are created to establish clear responsibility for future change decisions.

  • Implement the maintenance of reference data before the master data to ensure business ownership of code sets.

  • Elevate requirements that establish or change architectural direction to management for review.

  • Follow all documented standards for coding, naming, change control and security. In most shops, they were developed to reduce business and technology risks.

These lists are only a small portion of the data management best practices that can be applied. Search out the data management professionals on your staff and see if you can identify even more.

If you are on an agile project,
what hat do you wear?

Related Data Webinar: Webinar: Got Big Data? How can you combine the Big Data with traditional enterprise data?

Scott Ambler -
Bill Lewis -

Author: "Loretta Mahon Smith, CCP, CBIP, CDMP, is President for the Data Management Association - National Capital Region, a member of the Board of Directors for DAMA International, and an ICCP Certification Counsel Member. She is a 25 year career Data Architect in the financial services industry."



[3] Mosley, Mark. The Dama Dictionary of Data Management. City: Technics Publications, LLC, 2008. ISBN: 0977140040



Rate this:


Posted on Thursday, October 11, 2012 9:55 AM by
Nice article. There's nothing more agile than re-using pre-defined data elements from an enterprise data model and data dictionary.
Only registered users may post comments.

Do you twitter?: If you want short updates on what's going on in the BA world and at, simply follow us on Twitter:

Featured Digital Library Resources 

Big Data Analytics for Dummies
Finally, a Big Data book written for business analysts, BI professionals, and data scientists!  Big Data Analytics for Dummies is a valuable resource that addresses the practical dilemmas surrounding Big Data...

A Buyer’s Guide to Customer Analytics
Discover the five crucial criteria of a customer analytics platform in A Buyer’s Guide to Customer Analytics now.

Free Analytics software: Alteryx Project Edition
Alteryx Project Edition provides you with a single solution that delivers the data blending, analytics, and sharing capabilities of Alteryx with just enough allowed runs of your workflow to solve one business problem or to complete one project.

The Business Analyst's Guide to Hadoop
Get started with Hadoop using this whitepaper, "The Business Analyst's Guide to Hadoop".

Copyright 2006-2013 by Modern Analyst Media LLC