Visualizing data – Tableau Software

I spent the day in San Francisco attending the Tableau 8 Roadshow event.

Tableau is an amazing piece of software that helps you link to data in various forms – SQL databases, Excel spreadsheets, Google analytics, and many, many more – and use that information to create stunning visualizations. It’s insanely easy to use, and quite frankly is one of the most impressive pieces of software I’ve ever used to present data in an easy to understand manner.

Tableau

Read more

Data visualization and dashboards

A wise colleague of mine once told me that lots of people collect data, but few people know what to do with it. I didn’t understand what he was talking about at the time, but I’ve come to have a better understanding over the years. It basically boils down to the difficulty that many of us experience when it comes to the best way to handle information. Our brains do some amazing things, but fail to “see” things when the perspective is all wrong.

Data surrounds us. It’s in everything we do, from the bank statements we receive in our personal life to the mountains of data collected by every healthcare institution. Regardless of the data collected, there are basically three things that can be done with it. Data can be ignored, it can be archived or it can be used. Unfortunately only one of those three things is truly useful; using it. Many people chose to ignore or archive data not because the information isn’t valuable, but because they are overwhelmed with the amount of information they receive and the way that the information is presented.

Read more

Quick hit: approaches for standardized healthcare data

When my brother, Rob and I get together it often brings our wives to tears with boredom as we often get deeply engrossed in long conversations about computers, software and technology in general. Super Bowl weekend was no different. Rob and I started talking about strategies for connecting various pharmacy systems to other hospital systems … Read more

More thoughts on standardization

I’ve mentioned this before several times on this blog, but feel like I have to say it yet again; we need to start standardizing certain things about health information technology. The lack of standardization reared its ugly head at me again last week when our Pyxis med stations kept dropping medications off of patient’s active profiles. It appeared to always be the same drug, IV ketorolac. It took me a while to figure out the problem, but it turns out that Pyxis and our pharmacy system don’t agree on certain basic elements of time. Go figure.

Read more

Quick Hit – Time to change the way healthcare information is disseminated

I spend a fair amount of time reading various medical, pharmacy and technology journals. Why? That’s a very good question. I was taught in pharmacy school that you need to read a host of journals every week to stay up to date on current trends for the betterment of your knowledge base and the patients you care for. So like any self-respecting pharmacist that’s what I’ve been doing for the past 13 years.

With that said, my view of the medical literature is starting to change. The information in journals today is out of date by the time it’s published. This is especially true when it comes to any journal articles related to technology. A recent conversation with a friend and colleague verified this when he mentioned that much of his research findings could take as long as a year to grace the pages of a journal. That’s just plain crazy. If advancing technology has taught us one thing it’s that no one should have to wait a year to become better informed.

Read more

What we need is a system-neutral data structure for healthcare

During a web browsing session the other day I came across a very interesting blog post by Louis Gray titled “The Future: Operating System And Application-Neutral Data”. I enjoy reading Louis’ posts because I think he has a great vision for the future of personal computing, data, and “the cloud”

The blog speaks specifically to the ownership of personal data versus allowing companies to sit on it and possibly hold it hostage secondary to a lack of compatibility with other systems. The information you throw onto the internet defines who and what you are, more now than ever before, and you need to be able to move it around anytime from anywhere.

Read more

Cool Technology for Pharmacy

Pandora Data Systems (PDS) is a company that, in the past, has designed software solutions to take information from automated dispensing cabinets (ADCs) like Pyxis, store it, manipulated it, run queries against it and produce reports that allow pharmacy departments to view medication usage trends; including trends to identify diversion.PDS now appears to be expanding … Read more

Getting pharmacists to lay down their 3×5 cards

The decentralized pharmacy model brings with it the opportunity for pharmacists to be an integral part of the medical team. This includes following teams of healthcare provides, physicians, nurses, respiratory therapists, etc, on morning rounds. And like all good little pharmacists we like to be prepared with as much information as possible about the patient. Several methods for collecting data have been developed over the years, including the all time favorite; the 3×5 index card. The problem with this system is obvious; it’s prone to human error. Taking information from one source and transcribing it somewhere else simply increases the chance for error. In addition, the information may be inaccurate as things can change rapidly with hospitalized patients, especially in areas like the ICU.

Read more