As a data analyst, my job is to get people the information they need. Instead of just responding to each request separately, my goal is to create tools that allow users to ask and answer questions on their own. Part of this is out of laziness and not wanting to do the same thing over and over again, but it’s also because this gives my users direct and timely access to the information they need, when and where they need it.
I worked closely with my hospital’s Chief Quality Officer to develop our initial HAI dashboard. During one of our many meetings iterating dashboard design, he mentioned that what he really wanted to see was how this looked geographically. As an explanation, he drew a picture…
We’ve discussed Surgical Site Infections (SSIs) in quite some depth (pt 1, pt 2, pt 3). This is only one piece of the overall issue of Hospital-acquired Infections (HAIs). SSIs are an important type of HAI, but it’s equally important to stay on top of the other types of HAIs as well.
There are many data initiatives in the Tableau community, and I like to participate in them when I have time. As a professional in healthcare, one of my favorites is #projectHealthViz. Each month, Lindsay Betzendahl posts health-related data and invites the community to take a crack at visualizing it. The December data set ended up sparking a very interesting data journey for me, and I thought it might be useful to share the thought process I went through on this project.
I was incredibly honored to present my work at the December Tableau Healthcare User Group. I had a wonderful time, and received lots of great feedback. One of most common questions I got was on how I made my small multiple graphs.
Another metric we can use is the Cumulative Attributable Difference, or CAD. Whereas the SIR is the ratio between observed and expected infections, the CAD is the difference. We use the CAD to help allocate our limited infection prevention resources to the places that have the most need of improvement.
Last time, we started talking about ways to visualize Surgical Infection data. When I first presented this information to hospital and physician leadership, one of the main questions they had was how individual doctors compared to each other. This seemed like a great opportunity to demonstrate the power and flexibility of the SIR!