Database

What report service/software does your pharmacy use?

I wrote about Pandora back in December 2009. It was a great piece of software back in the day. I remember a time when nearly everyone in pharmacy that used Pyxis ADC’s to control their medication distribution at nursing units also used Pandora to generate reports, look at data, and detect controlled substance diversion. The two […]

Posted in | | Leave a response

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 […]

Posted in | | 2 Responses

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 […]

Posted in | | 1 Response

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 […]

Posted in , | | 1 Response

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 […]

Posted in , , | | 4 Responses

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 […]

Posted in , | | 1 Response

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 […]

Posted in , | | 6 Responses

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 […]

Posted in , | | 1 Response

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. […]

Posted in | | 6 Responses

Sum(1) ..how could something so simple be so frustrating

This time of year always comes with a lot of requests for medication usage data from the Pharmacy Clinical Coordinator. This year has been no exception. The most recent request was for a report identifying all medications in the pharmacy drug master that were used less than ten times in 2008. Seemed simple enough. Right.

Posted in | | Leave a response