For the past several weeks I’ve been reading furiously and working like a dog doing my day job, while also trying to come up to speed on Qlik Sense as quickly as I can. Today everything seemed to come together so well I felt like I just had to share. My first project in Qlik Sense involved trying to replicate as much of the functionality of our Emergency Department Dashboard as I could. If you’ve ever been to an Emergency Department you probably dread going not just because you are in a crisis but there is often a fear that you’ll “be waiting forever to be seen.”
So one of the major metrics used to evaluate Emergency Departments is the time it takes to get the patient into a bed. An arrival to bed time of 15 minutes means it took 15 minutes from the time the patient arrived in the ED until they were taken to a bed. That 15 minutes would include the time to register you when you walked in the door, find out what you believe is wrong with you, determine the severity of your condition and find a location to put you. Naturally it only made sense for me to begin visualizing this “Door to Bed” metric with Qlik Sense and then work up from there.
This week one of the really fascinating articles I read was an interview with David McCandless about his new book “Knowledge is Beautiful.” His previous work was titled “Information is Beautiful” so naturally the interviewer was asking him questions about the difference between “information” and “knowledge.” He responded with “… what I’ve discovered through my work is that data is granular, information is clusters and bites of something more structured; and knowledge is something deeper and richer, more interconnected and complex.” In the article David shared additionally that in the first book he had shared singular visualizations, but in his new book he couldn’t stop at one graphic because he wanted to answer all the key questions and address all the aspects of a given subject so that it would knowledge.
On the dashboard for this new Qlik Sense application I already displayed the simple “Median Minutes from Door to Bed.” While a critical piece of the puzzle it’s only a very small part of the bigger picture and would be considered “information.” Like David I wanted to go deeper. I chose to begin my exploration with a scatter plot that would show the Median Minutes to Bed across the Number of Arrivals and the Day of the Week and this is what I came up with.
Looked really neat but as I began selecting various Months I realized what I was displaying was very misleading. The information was totally correct but I happen to know that our busiest day of the week by far is Monday. Yet because I had chosen a month that happened to have more Wednesday’s, Thursday’s and Friday’s the total number of arrivals for those days was greater. It’s only logical that if the ED is really busy the time to get you into a bed would be greater right? But total number of arrivals over the course of a month doesn’t really equate to busy when the number of those days of the week can vary. Rats!
Here is one of the beauties that I’ve already discovered with Qlik Sense … it’s so easy to drag and drop or choose a different metric that it was nothing for me to choose “Average # of Arrivals” instead of “Total # of Arrivals” so that the chart could depict the “busy” aspect of the knowledge I was trying to visualize and as I was hoping a clear pattern emerged. Something that wouldn’t necessarily jump off the page if I had chosen a pivot table to show the raw data. There is a clear correlation between how busy the ED is and how long it takes to bed patients.
When I removed the date filter another interesting thing jumped out at me. Or I suppose in this case it would be more fitting to say something disappeared … Friday.