1 2 Previous Next

Qlik Healthcare User Group

17 Posts authored by: Joe Warbington

2018-07-12 09_13_17-Fighting the Opioid Epidemic with the Right People and the Right Tools.png


Cara Martino MSN, RN - Enterprise Business Intelligence Manager at Jefferson Health


"Part of the reason why I joined Jefferson Health—and why I eventually transitioned over to the Business Intelligence Team—was the ability to effect change through data. As an ICU nurse, I was able to help a few patients each day, but with this job we have the ability to impact all the lives seen at Jefferson. For the opioid crisis, it was important for data and analytics to have a seat at the table to try and combat something this difficult."


"Qlik Sense has made a monumental difference in the way we track prescriptions by patient. Using the data aggregated in the platform, we have a way to see overall ordering trends. This includes a sheet to display patients with two or more prescriptions in a thirty-day period. Once we select an individual patient, we identify who gets prescriptions from multiple providers versus who has one provider ordering all of them. We even know exactly what they're on, like Methadone or Oxycontin. If one patient is identified to have multiple prescriptions, we can quickly follow up with providers to understand why."


"It’s not just that we have insights—we’re actually acting on them. Thanks to the platform we’ve built, we can work directly with our EHR vendor to calculate things like morphine equivalent daily dose (MEDD). I can see what the MEDD is for any particular patient at the touch of a button. Not every clinician truly understands MEDD or what the recommended dose is, so we are working to put instructions within the system about the calculation along with recommendations.


Fighting the opioid crisis isn't only the responsibility of the ordering clinician, but they do play an important role. Today, because we can show patients who are on opioids within the system and what their MEDD is, anyone who opens that chart can intervene with that patient's prescription if necessary. "

Learn how Jefferson Health is using Qlik Sense and Epic to fight the opioid epidemic with data insights:

Fighting the Opioid Epidemic with the Right People and the Right Tools

Qlik DataMarket Topical Packages: Healthcare Provider Performance and Remuneration


Qlik DataMarket now offers 2 new topical data packages. The CMS Cost Reports and the Consumer Assessment of Healthcare Providers and Systems.


These latest additions to the Qlik DataMarket product offering allow customers to analyze and understand how payments for the same procedure can vary across specialties and regions. They also provide insights into how consumers view their experiences while undergoing various procedures.The two new products are based off the wealth of data that the Center for Medicare and Medicaid Services (CMS) makes available about healthcare providers in the United States.


CMS Cost Reports

ScreenShot_CMS Cost Report - front page.png


Healthcare providers participating in the Medicare program are obligated to report on various parts of their operation; facility characteristics, utilization, costs and charges by cost center and so on. Qlik DataMarket now wraps these Hospital Cost Reports up in data models, and alongside these models, our customers get a sample application that highlights some of the data available. This allows the users to better understand the various potential uses of the data.


Among the various questions that can be teased out of the CMS Cost Reports data are:


  1. What are the total submitted charges for any given procedure in the US, and what is the average submitted charge per state or city?
  2. If the same kind of procedure is performed by different specialties, then how does the average payment amount from Medicare differ by specialty?
  3. How much does a standardized visit to a doctor cost, based on location? How big a part of that does the Medicare/Medicaid program cover?
  4. How much does the healthcare provider need to write off from his charges to remain in the Medicare program? What is the reduction in the number of procedures needed to remain at the same level of revenue?
  5. What is the number of beneficiaries per procedure or volume of procedures by specialty and location?

This is just a sample of the questions and insights delivered by CMS Cost Reports package.

Consumer Assessment of Healthcare Providers and Systems
ScreenShot_State and National Level COmparion of HCAHS Survey Results.png

The Consumer Assessment of Healthcare Providers and Systems (CAHPS) is a series of patient surveys where consumers of healthcare services rate the quality of service provided. The Agency for Healthcare Research and Quality governs CAHPS. Among the topics covered in CAHPS are Hospitalization are: star ratings, communication ratings, environment, effectiveness of care, willingness to recommend, and other quality metrics that impact the experience from admission to discharge. The data applies to:

  1. Nearly 7,000 Dialysis facilities with about 119,000 dialysis stations.
  2. Over 10,000 Home Healthcare Agencies
  3. 4,600 Hospitals


All in all, the data comes packaged up in 13 data files and 3 sample applications that provide insights into what questions and answers can be teased out of the data.


Typically this data is hard to find and difficult to integrate into existing data models. However, we curate the data for you and make sure that all diseases and treatments, geo-dimensions and healthcare providers have been identified and that the appropriate unique identifiers have been associated with each. For example, each type of procedure is coded with the HCSPC code (Healthcare Common Procedure Coding System).


To get you started quickly, reach out to your account manager for a demonstration of the applications. You will be able to rapidly integrate your own data with these applications for unique insights.


Learn more about Qlik DataMarket

NEW: On-demand recording of demo now available! View the Qlik Cerner SMART Analytics Adapter demo


As a Cerner client, you enjoy a data-rich, powerful, open EHR. What would you think if you could extend this robust system by embedding analytics directly within the clinician workflow?

Qlik Cerner SMART Analytics Adapter.png

Well, now you can. Qlik has developed the SMART Analytics Adapter – an API that lets you embed Qlik Sense Analytics dashboards right within Cerner Millennium. No toggling, no separate log in. Dashboards and apps incorporating more than just EMR data available within a patient chart.

So what does access to analytics within the EHR workflow do for clinicians?

  • Informs decision making, enabling improved outcomes.
  • Speeds decision making, having information seamlessly available.
  • Focuses decision making, efficiently using clinician time.

And this access does not compromise privacy or security. The SMART Analytics Adapter receives context from the user’s interaction within Millennium and allows the opening of dashboards, filtered by Millennium-defined authentication rights, to reflect the same patient set or details that were being viewed in the medical record.

This solution was featured at CHC in Kansas City the week of October 9th. We joined the Cerner Code Developer program and continue to work closely with Cerner to enhance and validate the SMART Analytics Adapter. This technology leverages the SMARTonFHIR and the Cerner Ignite APIs.

How do we get started or learn more:

If you didn't get a chance to visit with us at CHC and would like to learn more, please email Joe Warbington (Joe.Warbington@qlik.com). Joe will share the technical requirements and use cases already deployed by joint Qlik/Cerner customers.

Additionally, join us for a live demo and Q&A on Nov 8th: Qlik Healthcare Demo Day - The SMART Analytics Adapter

We are pleased to have this solution validated by Cerner and featured prominently at CHC. Reach out today and get a conversation started on how your organization can offer embedded analytics to your clinical users.

Additional details attached available for Cerner clients in the private Qlik Cerner Group. Request access here: Cerner Developers Group

Qlik Cerner SMART Analytics Adapter screen.png

Integrating Qlik within Cerner allowed Children’s Hospital of Pittsburgh of UPMC to cut inefficiencies and standardize care processes.


Read more: http://global.qlik.com/us/blog/posts/mark-bilotta/customer-spotlight-24-hours-to-5-minutes-with-qlik



Do you use Cerner? Join our private Cerner Dev Group here to get access to documentation and learn about our new partnership: Cerner Developers Group.


Miss the recent news? We launched a new development with Cerner called the Qlik SMART Analytics Adapter, which allows you to embed Qlik in Cerner workflows using the SMARTonFHIR platform.

Hurricane season is unfortunately upon us. Just as Hurricane Harvey brought and continues to bring dangerous health concerns to people in Texas (see my previous post on Hurricane Harvey analytics), Hurricane Irma is threatening people and our health systems throughout Florida, Puerto Rico, and the region.

Rather than simply provide screenshots, I recorded the Qlik Sense + Qlik GeoAnalytics app in action and posted to YouTube so that you can see how quickly location intelligence and data visualizations can be used to help understand the impact and provide critical information. Over 56 million people are within the danger zones and that includes over 400 hospitals in Florida and Puerto Rico.

As always, be safe! If you think this type of analysis could help your hospital or communities, please reach out. We're happy to share everything.

-- Joe

Additional screenshots:

Here's the latest for Hurricane Harvey and hospitals that are within the danger zones. There are 752 hospitals that may be impacted or receive additional patient volumes depending on their location within the path of the storm.


2017-08-26 14_15_07-Hurricane season 2017-08-26 - Hospitals within danger zone _ Sheets - Qlik Sense.png


By choosing the >90% class of danger, we find 32 hospitals that are the most impacted. Most are in Corpus Christi, including our good friends at Driscoll Children's. We hope everything is safe and continues to be safe during the torrential rainfall.


2017-08-26 14_20_27-Hurricane season 2017-08-26 - Hurricane Harvey - Hospitals within danger zone (1.png


Here are the contact numbers in case you have loved ones that might be in those hospitals:


2017-08-26 14_20_09-Hurricane season 2017-08-26 - Hurricane Harvey - Hospitals within danger zone (1.png


Be safe! If you think this type of analysis could help your hospital or communities, please reach out. Happy to share everything.


Technically - this is using NOAA data for the hurricane path, hospital location data, and the capable functions within the new Qlik GeoAnalytics. !


Don't forget - if you're a CHIME member, you can get a great deal on Qlik Sense and Qlik GeoAnalytics until the end of September: https://chimecentral.org/qlik-healthcare/

Identifying patients with type 2 diabetes - a chronic, progressive condition that affects more than 29 million Americans and 415 million people globally - and those at risk for diabetes, is a first step in closing care gaps and improving the health of a population.


Do you have a 360-degree view of patients available at your fingertips, to help you meet quality metrics and improve care? You might think that’s information you’d find in your electronic health record (EHR) system. But we know there is more information about patients than just the data that gets stored in the EHR when they get sick or have an annual visit. These are called Social Determinants of Health (SDoH) and they include risk factors that might never be captured by clinicians – things such as credit score, access to quality food, and where you live or work in relation to your closest clinic or hospital...


My article is continued here with live demos and a video of the Qlik Healthcare Diabetes Discovery app: http://global.qlik.com/us/blog/posts/joe-warbington/discoveries-in-population-health . Please provide any feedback there. Thanks!


2017-06-22 13_21_12-Diabetes Discovery - Risks Analyzer _ Sheets - Qlik Sense.png


2017-06-22 13_17_03-Discoveries in Population Health _ Qlik.png

Here's a great little around the world tour of some of the integration points Qlik has with Cloudera - the leader in Hadoop datalakes.


Are you using Hadoop or comparable technologies in your healthcare organization? What are you using it for? We used it most recently for the Zika outbreak in collaboration with the University of Texas (link).


Technologies showcased include: Cloudera, Hadoop, Solr, Impala, Kafka, Kuda, Python/R, D3.js, Parquet, and SSO. Using Qlik APIs and Qlik Branch for visualizations.


(Click the YouTube button to view full screen)


Want to browse these demos on your own? Check out the Qlik Cloudera Integration and Demo Site: http://cloudera.qlik.com/



Prove that your healthcare organization has built an innovative app that has improved care, reduced costs, or increased population health.

Awarded after Qonnections (it was so packed, we didn't have time to review there)


Directions and Rules:

  • Please fill out the simple slide template attached, and include as much information as possible.
  • Must be a Qlik customer within healthcare.
  • You can submit as many entries as you’d like, though your organization can only win one prize.
  • Need not be present at Qonnections to win. Open to all customers!
  • Slides are due by Thursday May 25th.
  • Email slides (see attached template) to Joe.Warbington@qlik.com



Top 3 winners as decided after Qonnections will receive a free half-day workshop with our Healthcare Solutions Architects to empower your team on a topic/product of your choice. We’re happy to tune the engagement and schedule as desired.


Good luck!


Improving Healthcare with Analytics

The Essentials to Creating a Data-Driven Organization

Webinar Hosted by HIMSS

Thursday, September 8, 2016

2:00 PM ET/11:00 AM PT

2016-08-26 14_29_35-Improving Healthcare with Analytics_ The Essentials to Creating a Data-Driven Or.png


Countless healthcare systems and providers have embarked on a transformative journey with analytics. The ultimate aim is to foster an information-driven culture, where healthcare workers from nurses to executives make decisions based on timely, accurate information from any device in any location.


How do successful health systems transform their internal culture and processes to reflect the various demands of patients, stakeholders, and clinicians while also ensuring safety and profitability?


Join Qlik and John Martin, Sr. Director of Enterprise Analytics and Reporting at The Children's Hospital of Philadelphia, as they discuss the essential elements to create a data-driven organization and ensure value generation from analytics investments.


Topics covered will include:


  • Why providers are democratizing data to empower clinicians and staff
  • Tips to address the cultural shift towards data-driven decisions
  • How to unlock further value from your analytics investments


Featured Speakers

Joe Warbington
Healthcare Market Development Director

Charlotte Davies
Healthcare Consultant


John Martin
Director of Enterprise Analytics
The Children’s Hospital of Philadelphia

Learn more about our speakers


This webinar has been approved by HIMSS for up to 1 contact hour of continuing education credit toward renewal of the CPHIMS credential.

Register today to get a calendar invite and the recording, even if you can't make it.


2016-08-26 14_33_43-Social Image 1.jpg - Windows Photo Viewer.png

Customer Spotlight: Expanding the Toolbox | Qlik

Rochester Regional Health utilizes Qlik to make better use of their Epic data.


By Mark Bilotta on August 9, 2016

5 min read


Are you looking to get more out of your Epic data? We have just the thing for you: anon-demand webinar featuring a live demo by Qlik’s Joe Warbington and Eric Pennington, former Epic Cogito staff.


If you’ve been reading these Customer Spotlights in the past, you know the importance of fully understanding the patient journey. It’s well established that a more complete understanding of patient encounters, outcomes and costs and their interrelation leads to best practices. In turn, it allows each hospital or care facility to run more efficiently by reducing length of stay, avoiding preventable readmissions, and refining protocols for patients with chronic conditions.


Enter Rochester Regional Health...

Whose story rings true to many of these examples. As a newly formed health system, Rochester Regional Health (Rochester, NY) found itself using a variety of disparate systems -- Crystal Reports from Epic Systems and SQL-based extracts and reports that were dumped into Excel files – to extract and report data.  The health system’s director of Business Intelligence, David Meintel, knew that a single, integrated solution was required, a solution that was compatible with Epic.




Continued on the Qlik Blog here: Customer Spotlight: Expanding the Toolbox | Qlik

I'm inviting all of you to connect with me to experience some of our favorite healthcare apps in Qlik Sense Cloud (learn more about it).

QlikSenseCloud healthcare apps.png

Would you like a free invite with access to the apps? Drop me a line: joe.warbington@qlik.com 


Here's a peek at the apps you'll be able to explore when you connect with me on Qlik Sense Cloud:

2016-05-26 19_01_05-Qlik Cloud Hub.png

Qlik Guided Tour: Hidden Insights in Healthcare Data - YouTube


With Qlik, you can discover the whole story that lives within your healthcare data. By bringing together all of your data (even from previously siloed systems), Qlik lets you discover new insights that can improve the efficiency and efficacy of your business – and provide better treatment to patients.


Find out more on the value of Qlik in Healthcare: http://healthcare.qlik.com


Log in to build upon the Patient Costing & Clinical Variation app: http://sense-demo.qlik.com/details/patientcosting


Nick Scartz, Chief Analytics Officer at Adventist, was recently interviewed by CIO Magazine:

Healthcare Analytics: Early days for many, significant progress for some. 



Recent surveys seem to suggest that the hype of analytics is overhanging reality by a significant margin. However, it's early days yet, and there are pockets of excellence, such as Adventist Health System in Florida, that are making significant progress.


Healthcare has been identified as a sector that could benefit greatly from the use of advanced analytics, especially in the area of clinical outcomes improvement. Use cases such as readmissions reduction and population health analytics are high on the priority list of senior executives looking to navigate the transition to value-based care.


Yet, recent studies indicate that something is holding back the sector from realizing the full potential of analytics. A study by Health leaders Media on population health management indicated that while a full 69 percent of study participants were “fully committed” or are running pilots, many of them were in early stages of formulating strategies and making appropriate investments.


A similar study by HIMSS Analytics and BI vendor Qlik found that most healthcare providers were struggling with end-use adoption.  The study further suggested that healthcare providers are barely scratching the surface when it comes to unlocking the inherent value of their clinical data. According to John Hoyt, EVP of HIMSS Analytics, “BI benefits are in quality improvements and driving out waste…and often, improving quality reduces unnecessary cost.” “While analytics is front and center in healthcare, maturity can vary by solution areas – driven in large part by local and regional pressures,” says David Bolton, Global Director of Healthcare Industry Solutions for Qlik.


So is it really a gloomy picture today for healthcare analytics?



READ MORE ON THE ARTICLE PUBLISHED HERE: Healthcare Analytics: Early days for many, significant progress for some.

In an article entitled Which Vendors Lead the Healthcare Big Data Analytics Market? author Jennifer Bresnick on November 19, 2015 details some of the fragmentation in the market for not only electronic health record systems but also healthcare analytics.

I usually cringe at colorful pie charts, and I'm hoping Jennifer will allow me to help her out next round with Qlik Sense. The pie charts in her article are sorted incorrectly and colored all willy-nilly.

So, I quickly scraped the data and built the charts in Qlik Cloud in a matter of a few minutes, leading to your choice of three visualizations that I believe better convey the market share leaders in inpatient EHRs.

First up, the pie chart:

Secondly, a personal favorite, the tree map:

Finally and perhaps most easily consumable, the ever capable bar chart:

Which one is your favorite? Leave a note in the comments.

Always willing to help out Jennifer and HealthcareIT Analytics team! It's only a few minutes to get beautiful, interactive, and easy to consume visualizations. Feel free to embed those in your site!

Everything is powered by Qlik Sense. Try it here free, for Mac, PC, Linux, iPad, Android, Kindle, Microsoft Surface, Palm Pilot, Commodore 64, etc. (Note: I haven't personally tested most of these systems.)

Originally posted on LinkedIn: Inpatient EHR Vendor Selection - Pick Your Favorite Visualization

Filter Blog

By date:
By tag: