Q: What kind of data are you pulling in using Qlik?
A: We have pulled in eight years of patient history into multiple QlikView apps. Northeast GA Health System receives over 800,000 hospital visits a year and roughly 300 Emergency Department visits per day. We struggled previously because four years ago we were generating reports built by our IT department (painstakingly) over the course of 20 years. The problem with those reports is that with thousands to choose from: people couldn't find the ones they wanted. Even if they found a report with the right input parameters there was no way to know what criteria was being used on the back end. That leads to a room full of people each holding a different report!
Q: So that’s where the consumption of data caused an issue?
A: Exactly. Once we started using Qlik, we had access to all the data at once and we were able to reset charts or filter them as needed when people would ask follow-up questions, imagine that! What’s really cool is that previously we only knew what the standard reports told us but now we can actually start debunking myths.
For example, let’s say we wanted to look at the efficiency of treatment for Emergency Department patients. Previously, we would have static reports generated at different intervals but now we have the tools to look deeper at various factors: length of stay, time from waiting room to bed, time to completion of lab work, etc. Once we have those figures we can start to put the puzzle together of how we are performing based on patient feedback and comparing these figures to our retention rate. This has given us the ability to positively adjust our staffing based on the peak times that we see patients entering the ER. We can be predictive as opposed to being reactive. It’s knowledge through useful action.
Honestly: when you don’t have analytics, the rest is just hearsay.
I want to thank Dalton for taking the time to chat with us about Northeast GA Health System. For more helpful tips and tricks on visualizing all of your organization’s data, check out his blog: Qlik Dork.