Bob Lambert
Mar 21 2012
The Data Quality Challenge, In Pictures
by Bob Lambert
Data quality in most large organizations is commonly known to be rather lacking. Most would argue that things haven't gotten much better since this 2007 Accenture study found that "Managers Say the Majority of Information Obtained for Their Work Is Useless". To some, quotes like that are shocking, but if you think about how information is processed in most Fortune 1000 sized organizations it is surprising that data available to managers is as good as it is. These slides have been useful in my efforts to explain the persistence of data quality problems (click on the pictures for a larger view):
Tagged: Data Management, Data Quality
Jan 22 2012
A QlikView QuickStart: first steps for learning QlikView desktop
by Bob Lambert
QlikTech’s QlikView reporting and analysis tool is among a new class of Business Intelligence (BI) software tools. As Ben Harden reported in a recent blog post, BI vendors like SAP, Microsoft, and IBM have traditionally sold “to the IT enterprise, but companies like QlikTech and Tableau are targeting the business and bypassing IT. Their tools are quicker to stand up, more intuitive and don’t need the configuration, support, and hardware that the bigger players require.”
A Quick Overview
At first look QlikView is fairly accessible to those experienced with BI tools. A “.qvw” QlikView file contains three classes of user-facing components: a script-based data integration language that runs when the user requests a “reload”, a data modeling component that looks deceptively like a relational data modeling tool, and a familiar array of data visualizations: graphics, charts, lists, etc.
Dec 11 2011
Double test efficiency and build app dev culture at no charge
by Bob Lambert
What if you could double the efficiency of your software testing process, and substantially reduce errors found during the test, deployment, and maintenance phases, without purchasing any tool or method? The November 28 InformationWeek offers just that in a reprint of a recent Dr. Dobbs article on formal inspections by Capers Jones and Olivier Bonsignour. They call formal inspections the “defect removal tool of choice” and back up their claim with lots of hard evidence, but I think they are still selling short.
Nov 21 2011
Data Quality 3: No More Data Corruption Excuses!
by Bob Lambert
I’ve recently posted a couple of articles at this site on data quality, this is the final one in a series of three. Previous posts presented these ideas:
- Yes, there is a business case for improving data quality, and we’ve got business value examples. If you look for real money where you anecdotally know there are data quality problems, you’ll likely find it in high costs of data correction and rework, and savings related to business process improvements that reliable data enables.
- There are distinct things an organization can do to reap benefits of improved data management and data quality. (1) Get started in the first place, (2) find the tangible benefits, (3) cross the departmental silos that exist in every large organization, and (4) promote sound data management practices.
- Impacts of poor data quality can seem abstract in a large organization. They aren’t for a small business owner. Say you have a carpet cleaning business. What if you knew 10% of your customer bills were wrong, but you weren’t sure by how much or in which direction? First you’d panic. Then you’d rush to fix the problem.
Tagged: Data Management, Data Quality
Nov 11 2011
Data management success means overcoming key challenges
by Bob Lambert
In my experience there are a few consistent themes that emerge in data management and data governance work. Despite diversity of industry, culture and size, our clients face four common challenges in efforts to establish effective data management.
To paraphrase the DAMA Guide to the Data Management Body of Knowledge (DMBOK), data management means understanding enterprise data needs; collecting, storing, and protecting data, continually improving data quality, maintaining data security, and maximizing effective use and value of data assets.
Challenge #1: Get started
Categories
Popular Tags
Disclaimer
The words and opinions expressed here are those of each article's respective author, and do not necessarily represent the views of CapTech Ventures.