Software / Quality Exclusives

Software & Analysis: Seeing Value in Data

Data gathering systems can provide value beyond the original intent.


Pictured is a sample of a data chart showing the average number of cancellations by the day of the week. Source: PQ Systems

When I visit my doctor, there is a sign-in sheet in the waiting room. I write down my name, my doctor’s name, my arrival time and then I sit down. The sign-in sheet is used by the staff to look up my records and prepare for my visit with the doctor. Once I’m in the exam room, my name and arrival time are scratched out on the sign-in sheet.

The sign-in sheet is a small system. The intent of the system is to manage the order of serving patients and give the reception worker information for gathering records. This system stores very few pieces of data: the date, an arrival time, a patient name and a doctor name.

I don’t know what they do with these sheets. They may file them for historical reference, or they may throw them away. One thing is certain. There is more value to be gleaned from this data. Data offers more value than creators envision.

For example, they might discover which physician in their practice is the most visited doctor on Mondays. They might discover the times of day that patients are most likely to arrive on time or most likely to arrive late. They could learn about the busiest days of the week. Like many data gathering systems, this one can provide value beyond the original intent. Additional lessons to be learned include at least four.

Data collected for one purpose can be used for other purposes.

Access to underlying data becomes complex when large amounts of data are involved.

Gaining access to data being managed always involves some sort of friction.

Vendors and users often have conflicting needs for the data.

1. Data collected for one purpose can be used for other purposes.

A set of data collected, gathered and stored for one purpose will eventually be used for some other purpose. Most often this will be for questions asked of the data that follow this pattern: “I wonder how many….” or “I wonder how often…”

Beyond the sign-in sheet example, consider larger systems that are widely used. These can include customer relationship systems, enterprise resources planning systems, Web site analytics and e-mail management. Each of these systems has an original intent, as the sign-in sheet does, and each has large amounts of data available-data from which value might be extracted.

2. Access to underlying data becomes complex when large amounts of data are involved.

A common problem with these systems is access to the underlying data. For example, imagine an organization that uses a commercially available, off-the-shelf, contact management system. Typically, this system will provide some level of reporting on the data it manages. A standard set of reports is common. Some even offer limited customized reports.

The output is helpful, but almost always you will have questions which a fixed set of outputs cannot easily answer. You might be curious about the number of new contacts entered in the morning compared to the number of new contacts entered in the afternoon. Knowing this may provide value to help train workers or plan for staffing levels. However, getting at this answer may be difficult. The skills required to be an ordinary user of the system are not always sufficient to get answers to questions like this.

3. Gaining access to data being managed always involves some sort of friction.

For any data management system there is some amount of friction in gaining access to the data being managed. This friction can take many forms. Some common ones include: friction from lack of required skills; friction created by duplication of data; friction from technical barriers built into system; and point of view friction.

Many organizations, particularly smaller ones, simply do not have workers with the technical skills required to extract data from an application and then manipulate it for further analysis. A small firm that makes dentures will have employees skilled in the tools and techniques of denture making, but they may not have highly trained database or software development workers.

Often the skills deficit can be overcome with use of contract employees or consultants, technical support provided by the system vendor or through specialized employee training.

The common problem of data duplication works like this: most applications have features for exporting data. Since the application does not provide all the reporting options needed, data must be exported (moved) into a different application-one that is able to do the analysis.

This involves exporting the data, importing it into the other application and then analyzing it. It works great. The first few dozen times you do this everyone is happy. However, you soon realize that the steps of moving this data around are tedious.

As the requests for analysis increase, some worker is doing more and more of this data movement activity. The analysis of this data quickly becomes stale. That is, the analysis you did last month needs to be done each month. Or better yet, it needs to be done daily or even made available all the time-in real time. This is data duplication friction.

One way to address data duplication friction is to automate as many of the steps in the process as possible. For example, you might set up a script to export the data and set up another script to import the data into the analysis application. When you need the analysis, you run these two scripts and the work is easier.

Another way to address data duplication is by creating a data warehouse at some scheduled time, say every night at midnight. This warehouse might be a copy of all the data in the host system that has been transformed to make it more amenable to further analysis by other applications. Using this approach removes one part of the tedious work of moving data around, but not all of it.

Solutions to the data duplication problem can be brittle. One change in the source data, one change in the data requested or one change in the way the analysis software imports data, and you find yourself back at the solution that always works-manual intervention.

Perhaps the best solution to data duplication friction is to use an application that can analyze the data in native form, bypassing the need for these brittle, duct tape solutions that string one system together with another.

This leads to the most difficult friction problem to overcome-technical barriers built into the application. There are many ways to store data. Programs store data in text files, in binary files, in different databases and in various proprietary formats. The developers of these programs balance competing needs in deciding how to store their data. They think about speed, efficiency, accessibility, security, cost and many other issues.

In the end, as a user of the application, you often do not have a say in these decisions. But they do have an impact on your ability to extract value from the data being stored.

4. Vendors and users often have conflicting needs for the data.

An application vendor and an application user often have conflicting needs for the data being stored and managed. The vendor wants to keep the data safe from loss or damage. The user wants full and free access to the data. The vendor may need to use complex storage techniques to gain efficiency. The user wants simple, easy-to-access and easy-to-understand data.

An ideal situation is where the application stores data in a well-known database with meaningful and understandable table names and column names. However, not all application vendors use this approach. In some cases, they may use a standard database, but they obscure the table and column names to make external eyes less likely to see and thereby use the data.


What does all this mean as you make decisions about what applications to use and how to use them?

See data as a resource from which business value can be extracted. Develop a culture in your organization that understands the value in data being collected. Encourage an inquisitive view of all data that is being captured.

Become the owner of your data. You might be putting your data into an e-commerce system, a resource planning system or a customer relationship system. In any case, you must see your organization as the owner of the data.

If the applications you are using create friction in gaining access to this data-in other words if they have become the owner of the data-you may want to approach the vendor to resolve this problem or even consider abandoning the vendor in favor of one that allows you to get to your data easily.

When there are large amounts of data flowing into known data sets on a regular basis, continue to ask the question “what business value can we extract from that?”

Seek applications that are open and have easy access to their underlying data.

Seek applications that analyze data-in place-from standard data sources.

As organizations’ collection and analysis of data becomes more complex, that data becomes increasingly useful, but perhaps at the same time, harder to get to. Understanding its value from the outset will help these organizations plan the ways in which the data will continue to be useful long after its original purpose has been exhausted. 

Tech Tips

Data gathering systems, this one can provide value beyond the original intent. Additional lessons to be learned include:

Data collected for one purpose can be used for other purposes.

Access to underlying data becomes complex when large amounts of data are involved.

Gaining access to data being managed always involves some sort of friction.

Vendors and users often have conflicting needs for the data.

Did you enjoy this article? Click here to subscribe to Quality Magazine. 

Recent Articles by Steve Daum

You must login or register in order to post a comment.




Karen Spencer, Clinkenbeard's quality manager, discusses what makes the plant stand out, advice for other plants, and looks to the future.
More Podcasts

Quality Magazine


2015 May

The May 2015 edition of Quality Magazine includes articles on cloud technologies, depth gages, ISO 9001, digital inspection and cool new products.

Table Of Contents Subscribe

Topics to Talk About

What topics would you like to see Quality cover more?
View Results Poll Archive

Clear Seas Research

qcast_ClearSeas_logo.gifWith access to over one million professionals and more than 60 industry-specific publications,Clear Seas Research offers relevant insights from those who know your industry best. Let us customize a market research solution that exceeds your marketing goals.


Facebook2015_40 twitter_40px.png  youtube_40px.pnglinkedin_40px.png