01 Mar 2011
DQ vs. BI

A long-time IT professional friend of mine and I recently had a very interesting discussion about the merits of different technologies. He works in the business intelligence (BI) space for a major financial institution and, as part of his job, has to oversee the implementation of different BI tools for his organization. In this post, I want to relay the crux of that conversation because it relates to organizations’ IT procurement priorities.
For any company in any economy, resources are scarce. There are limitations to even what cash-laden organizations such as Microsoft and Google can do. So, when faced with decisions related to data management, does one set of tools make sense for an organization?
Organizational Data Maturity Model
In his excellent book The Data Asset, Tony Fisher lays out the following model for organizational data maturity:

The model underpins his book and, in essence, can be summarized as follows: Organizations cannot leapfrog stages. Undisciplined organizations need to become reactive before progressing to proactive and governed states.
So, returning to the conversation with my friend, is DQ or BI more important to an organization? The answer, of course, is that it depends on the state in which the organization finds itself.
For example, consider Company X, an undisciplined organization barely able to keep the lights on. Data management is nonexistent and duplicate, incomplete, or inaccurate records make even basic reporting and operations difficult–if not impossible. As a result, a BI tool may yield insights into employee, customer, and/or vendor behavior. But will those insights be accurate? Doubtful. In this case, a DQ tool makes a great deal more sense. Clean up data and begin to instill a culture of data governance before getting all fancy with OLAP cubes.
Now, let’s look at Company Y, a proactive organization with very few data-oriented issues. While not perfect, master records are maintained quite judiciously and, unlike Company X, basic reporting is a breeze. Few people internally ever doubt the accuracy of reports and analyses. As such, it is ready for a BI tool. To be sure, a DQ tool couldn’t hurt, but Company Y is ready to take the next step.
Simon Says
Don’t look at the merits of BI and DQ tools in isolation. The state of your organization’s data management is an incredibly important factor in making the decision about which tools to deploy–and when. Further, resist the temptation (often driven by senior executives) to go with “quick fix” sexy BI tools when your organization isn’t ready. Yes, they are capable of producing interactive charts, reports, and dashboards. But that’s not the right question. Rather, are all of these potentially useful given the state of your organization and its data? Remember that better access to–and charts containing–bad data aren’t as useful as limited access to pure data.
DQ tools may not have the sizzle of their BI counterparts. However, if they are purchased, implemented, and utilized effectively throughout the organization, they sure will make BI tools more potent when you get there. The best organizations have a method to buying and implementing different tools.
Feedback
What say you?


March 22nd, 2011 at 2:22 pm
Interesting article. I think that Today’s Business Intelligence & Analytics software capability is light-years ahead of the semantic quality and structure of the data.
This is because transaction data is a by-product of the order entry system, designed to ship orders on time; not to build a clean data base for strategic management.
This is one of the main reasons why some BI implementations fail. It’s common to see state of the art Business Intelligence software that cannot deliver strategic direction or analysis until armies of analysts download the data into spreadsheets, manipulate, fix and structure the data manually, for hours or days at a time.
In my experience, even after years and millions of dollars spent in BI deployment, Marketing and Sales organizations feel like they are drowning in an ocean of data and yet thirsty for the Strategic Knowledge they need to do their job: beat the competition, increase market share, revenue and profit.
Regards, Bill
March 31st, 2011 at 8:05 am
[...] article on the MIKE 2.0 blog yesterday, asking whether a company should first invest in tools for data quality or business intelligence. He approaches the issue from the perspective of DataFlux President Tony Fisher’s data maturity [...]
May 31st, 2011 at 9:49 pm
Great article. In my line of work I often find companies looking for the whole truth and nothing but the truth, but they forget they are working with poor quality data. Garbage in is garbage out.
June 16th, 2011 at 10:54 pm
I understand the message – if you have a genuine DQ problem, invest in a DQ solution first – not a BI quick-fix. I believe a parallel approach rather than an either/or approach usually works better.
The BI tool used on poor quality data will help to highlight issues and provide incentive to get it fixed. The use of a BI tool in a poor data quality environment can work – it just needs more analytical support and understanding and must be used and distributed more narrowly, than if it is working on good quality data. So you get less bang for the buck but you do get something.
Business people will never work in an information vacuum – if the information can be reasonably got at they will do it – warts and all.
September 9th, 2011 at 1:08 am
[...] Are the problems due to human factors, such as lack of training or bad judgment? Are they due to a lack of reliable data? Or is the data reliable, but [...]