Advertisement

Blog Viewer

How we create data silos

By Dennis Tribble posted 12-31-2023 22:59

  

I recently reviewed a summary article entitled How are other systems breaking down data silos? 35 leaders share. What I found most interesting were the expressed notions of why data silos exist and what these leaders are doing about them. A lot (but not all) of the responses focused on infrastructure issues to get data to be consistent and shared more broadly. Several spoke of cultural changes being necessary to overcome those silos.

This caused me to think about our practice in health-system pharmacy, how we wind up with our own data silos, and how we get past them (or do not).

Pharmacy is, perhaps, unique in the acute care world in that we tend to operate on a variety of automated systems, each of which may look at the world in quite diverse ways. While an increasing amount of our data is winding up inside electronic medical record (EMR) systems, much of it still exists in technology that operates in parallel to those EMR systems, and to each other.

Further, even when systems are well-integrated, the way we wind up installing and using those systems often contributes to data that others might find useful being buried in inaccessible places or not being captured at all. The following questions relate to data to which we have legitimate access, and whose use is unconstrained by law, regulation, or professional standards.

  1. Are you data sparing or data greedy? In my experience, the time to have data is not when you discover you need it; by then you have failed to capture it for your use. You may be able to capture it moving forward, but that likely won’t meet an immediate need. When making decisions about configuration and use of automated systems, I am a fan of being data greedy. When given the choice, do you opt to capture more data or limit what you capture to what you think you currently need?
  2.        Do you see your data as an asset to be managed and maintained? I often encounter systems whose maintenance has languished. Part of this comes from our tendency to treat our automation installations as events rather than as ongoing responsibilities. Some of this is likely the tyranny of the urgent, but it amazes me how little effort sometimes goes into keeping data accurate, current, and consistent, even when there are tools available for that purpose.
  3.       When you install technology, how much do you consider use cases for the data the technology generates?  It has been my experience that we focus a lot of attention on getting data into our systems, but extraordinarily little attention on getting it back out. As the demand for analytical systems and artificial intelligence grows, we are likely to find that our early implementation decisions get in the way of back-end analysis of that data.
  4.       Does your staff understand how automation workflow and configuration decisions affect the quality and availability of data? In my experience, our staff tend to treat enterprise automation systems much as they treat their personal automation. They use it “my way.” The result is that those systems capture less usable data than they could simply because some users choose to use those systems in ways that hide that data value.

One of my favorite examples of this involves tracking the time and effort spent on managing medication expiration in automated dispensing cabinets. While most of these systems have functions to identify transactions related to managing expiration dating, I have seen several facilities in which the individuals performing that function have chosen to handle them differently, burying that data indecipherably in inventory transactions. I am certain that those who choose this path do so because it seems more efficient to them. In making that decision, however, they artificially constrain the usability of that data.

There are several reasons to use a system the way it was designed to be used; a key reason is that such use results in data that can be used analytically to measure and improve operational performance. Pharmacy leaders could therefore take the opportunity to educate their staff both on how systems are intended to be used and why (what data we will derive at what benefit when the system is used correctly). 

So, in my opinion, our systems exist in silos in large measure because we do not implement and manage our automated systems as data assets that could, and should, contribute to the larger ecosystem of health system data that drives both our operations and our strategy.

The thoughts of this blog are my own, and not necessarily those of my employer or of ASHP.

Dennis A. Tribble, PharmD, FASHP

Ormond Beach, FL

datdoc@aol.com


1 comment
28 views

Permalink

Comments

08-27-2024 16:55

This was a great, insightful read; thank you for sharing. Adding a few comments to your points.

  1. Are you data sparing or data greedy? In my experience, the time to have data is not when you discover you need it; by then you have failed to capture it for your use. You may be able to capture it moving forward, but that likely won’t meet an immediate need. When making decisions about configuration and use of automated systems, I am a fan of being data greedy. When given the choice, do you opt to capture more data or limit what you capture to what you think you currently need?
    • I, too, am a fan of more data, because the decision on which and how much of that data to use can certainly come later. The only consideration (when trying to get more data) is the time it takes to capture the data and whether it takes away from pharmacy productivity and morale. Sometimes it is difficult for the staff to understand why certain data points are important. Some get it, others don't, and many others don't care one way or another. The time spent in education as well as the time spent assessing whether the education yielded high quality data is encumbering itself. Your example of med expirations in ADCs also extends to documentation of interventions. tl;dr -- more data, but at what cost, and how do we forecast whether the effort will be 'worth it', especially at non-academic/teaching institutions where there is a scarcity or residents, students, and where most RPh/tech positions are hybrid roles managing multiple responsibilities?
  2. Do you see your data as an asset to be managed and maintained? I often encounter systems whose maintenance has languished. Part of this comes from our tendency to treat our automation installations as events rather than as ongoing responsibilities. Some of this is likely the tyranny of the urgent, but it amazes me how little effort sometimes goes into keeping data accurate, current, and consistent, even when there are tools available for that purpose.
    • Yes, and I think this is overlooked by not just pharmacy but any department that needs to install and keep utilizing a system. Some examples: ADC user list maintenance, daily workflow user/task maintenance, IV pump drug library updates, etc. Each time a new system is implemented, the management team (I would actually say the vendors' project implementation teams) need to templatize a "maintenance schedule".
    • I do think the complexity of the system factors in as well. Not all systems are intuitive, and there is again a cost for training (and retention of) personnel who become familiar with such systems.
  3. When you install technology, how much do you consider use cases for the data the technology generates?  It has been my experience that we focus a lot of attention on getting data into our systems, but extraordinarily little attention on getting it back out. As the demand for analytical systems and artificial intelligence grows, we are likely to find that our early implementation decisions get in the way of back-end analysis of that data.
    • Could you elaborate on the last sentence, perhaps with an example? Interesting point.
  4. Does your staff understand how automation workflow and configuration decisions affect the quality and availability of data? In my experience, our staff tend to treat enterprise automation systems much as they treat their personal automation. They use it “my way.” The result is that those systems capture less usable data than they could simply because some users choose to use those systems in ways that hide that data value.
    • Very much this. Going back to my comment on point 1, assessing the fidelity of data is a very time consuming process, yet crucial to having any meaningful analyses after all is captured and done. I have found that it is also important to audit the auditors. Once the (first) auditors become accustomed to an individual's way of inputting data, the drive to correct fades away over time, and the auditor's auditor needs to engage in some course correction at this point.