A Lesson on Dormant Data

Janus films reduxby Angela Guess

Jill Dyche recently discussed the topic of dormant data and how best to handle it. Writing from personal experience, Dyche begins, “Recently the chair of a data governance council at a bank asked for my thoughts on how to handle dormant data… My client didn’t want his staff spending time defining data that no one was using… I asked my client a series of questions about the data. Why was it loaded onto the data warehouse in the first place? Did it map to critical business requirements? Who’d requested it? What business processes did it support? How latent was it? Ultimately after some discussion I recommended that my client pull the data from the data warehouse and archive it. Then we’d sit back and await the backlash.”

Dyche continues, “A risky move? You bet. I compare this strategy to the one used in the Aristophanes play “Lysistrata.” As you’ll remember from high school English, in Lysistrata the women of Greece decide en masse to withhold sex from their husbands until there’s an end to the Peloponnesian War. This was the ultimate power play and gave the term “cease fire” a whole new meaning. A week later my client received an e-mail from a data analyst in the finance department inquiring about the missing data. It seemed as if this analyst used the data to create quarterly top line measure reports for the CFO. She’d just returned from a three-month sabbatical and wondered what had happened to her tables.”

Dyche concludes, “This conversation resulted in the addition of two new guiding principles for the data governance council: (1) Usage of the data on the warehouse would be regularly monitored. (2) Data unused for a period of four months or longer would be archived unless the data steward requested an exception. These new guiding principles invited a new level of – dare I say – intimacy with less-visible data by data stewards who had until then been focused on high-profile or heavily-queried tables. But just because the data wasn’t widely used didn’t mean it wasn’t beholden to the standard policy-making and oversight processes established by the data governance council. The lesson? Sometimes you’ve got to take something away to recognize its real value. Just ask those randy Greeks!”

Creative Commons License photo credit: swanksalot

Related Posts Plugin for WordPress, Blogger...

Leave a Reply

Your email address will not be published. Required fields are marked *

Add video comment