1 2 3 4 Previous Next

Qlik Healthcare User Group

58 posts

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

OnDemand Recording


More Details on LACE Index for readmission risk scoring:  Qlik Healthcare Demo Day - Readmissions

Two of the applications I highlighted during the Preventing Readmissions webinar on 3/22/2018 are available to explore here:

  1. Hospital Readmissions – https://demos.qlik.com/qliksense/HospitalReadmissions?industry=Healthcare
  2. Diabetes Discovery – https://demos.qlik.com/qliksense/DiabetesDiscovery?industry=Healthcare

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


I’m seeking help trying to create a Flag Field to catch add-on laboratory tests and have provided attached Excel workbook and QVW consisting of ER orders for a single day. 


By definition each ER patient is assigned a unique Accession number and 1 or more lab tests can be ordered. An add-on test is defined as any unique Accession with 2 or more tests where 1 or more of the tests has a Order Time Stamp 10 minutes greater than the “minimum” Order Time  Stamp.  By way of example in the image below the “Minimum” timestamp for this accession is 9:30 AM and the “DiffAuto” test was ordered 19 minutes after the original order so a the new “TestAddOn” flag field would be “True” or = 1.


The data set I am using is large so, optimizing the creation of this Test Add-on Flag withing the script is important.  Suggestions would be appreciated.




This blog post is related to the overall General Hospital project and will be used to post links to examples, tricks and training related to Data Modeling using the General Hospital data set.


Training Videos:

Dalton Ruer

General Hospital

Posted by Dalton Ruer Nov 13, 2017

General_Hospital_Qlik_Healthcare_Solutions_Logo_1.jpgHave you ever had to continually generate fake data sets that you could use to perform training with, do workshops with, do demo applications from or use as examples when learning new features/functions/visuals?


Well that's pretty much the life of the Qlik Healthcare Solution Architect team. So we decided to solve that problem for me and any others that may face the same issue.


We utilized a combination of data generated by Mockaroo as well as other data sources to form the base files of a fictitious health system we are calling General Hospital.


The goal of the project is to grow this to include many other resources that surround it like additional data sets, workshops, and applications.


How can you play along? Glad you asked.


Want to see a walkthrough video of everything and how this can be used? Watch this session on the Qlik General Hospital: Qlik Technical Thursday - November.


If you want to practice your Data Modeling skills you will want to download the base CSV files. Click here to get the base CSV data set:


If you want to have some example code that pulls the base CSV files and implements various data modeling techniques to see one approach we have prepared a QlikView and a Qlik Sense solution you can download:

Click here to get the QlikView application that will load the base CSV files and create Layer 2 versions of the tables.

Click here to get the Qlik Sense application that will load the base CSV files and create Layer 2 versions of the tables.


If you want to skip the data modeling step and jump right into visualizing by using the layer 2 data, we have prepared both a CSV and QVD version of the data for you:

Click here to get the Layer 2 CSV files.

Click here to get the Layer 2 QVD files.


But wait there's more! We have already built very basic load scripts for you to load the Layer 2 QVD data files in both QlikView and Qlik Sense if you want to start there:

Click here to get the QlikView application that will load the Layer 2 QVD files.

Click here to get the Qlik Sense application that will load the Layer 2 QVD files.


But wait thanks to marmentrout5 we now have a SQL Server BAK file with the data so you can play in SQL Server environment.

Click here to to get the General Hospital data set in a SQL Server BAK file


Applications: As we create applications that utilize this data we will make them available here:

On Demand Application Generation - Click here to get access to the General Hospital ODAG application samples that were used as part of the March 15, 2018 webinar.


Just because we love you ... we have also created several image files that you can download to utilize for your own resources.

Click here to get the base General Hospital image

Click here to get the General Hospital Logo image

Click here to get an image of the General Hospital data model

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!


Qlik Accelerate is a Qlik Consulting service that delivers pre-built applications designed and built by industry experts for real-life business scenarios. Once your data is loaded, the application can be ready to use and scaled to your business. Qlik Healthcare Accelerators are designed to help you accelerate time to value by enabling near real-time analytics of your operational, clinical and financial performance, so you can quickly react and make changes to improve health outcomes and net margin.


Our Healthcare Accelerators have been pre-built by a team of experts, and are based on best practices with other customers and industry-proven data models.  The applications are delivered with defined KPI’s and analytics, ready to accept your data from whatever EMR system you are running.  You can use the applications as is, or the Qlik Consulting Services team can further customize it, based on your own unique needs and requirements.


Recording (56 min)

Fast Track to Awesome Apps

Qlik Accelerate - Qlik Snippet


2016-09-21 17_44_54-Qlik Consulting_Qlik Accelerate_Healthcare.pptx - PowerPoint.jpg

2016-09-21 17_47_10-Qlik Consulting_Qlik Accelerate_Healthcare_Data Sheet.pdf - Adobe Acrobat Reader.jpg

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

Filter Blog

By date:
By tag: