Category Archives: 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… Read More »

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… 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… 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… 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.… Read More »

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.