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 … Continue reading

Posted in Database | Tagged , | Leave a comment

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 … Continue reading

Posted in Database | Tagged | 2 Comments

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 … Continue reading

Posted in Database | Tagged , , , | 1 Comment

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 … Continue reading

Posted in Database, Pharmacy Informatics | Tagged , , | 1 Comment

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 … Continue reading

Posted in Database, Medication Safety, Pharmacy Informatics | Tagged , , , , | 4 Comments

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 … Continue reading

Posted in Database, Pharmacy Informatics | Tagged | 1 Comment

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 … Continue reading

Posted in Cloud Computing, Database | Tagged , , | 6 Comments

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 … Continue reading

Posted in Database, Pharmacy Informatics | Tagged , | 1 Comment

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 … Continue reading

Posted in Database | Tagged , , | 6 Comments

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. Continue reading

Posted in Database | Tagged , , , | Leave a comment