1 2 3 Previous Next

Qlik Healthcare User Group

61 posts

No stopping the innovation happening at Jefferson Healthcare! Read Cara Martino's, MSN, RN interview with Healthcare Informatics.

How BI Tools Are Helping Jefferson Health Battle the Opioid Crisis

Helping clinical leaders identify prescribing patterns across the health system

Business intelligence data_0.jpg



Making health system changes to address the opioid crisis is challenging if you don’t have actionable data about prescribing patterns. With guidance from their chief medical officer, the business intelligence team at Jefferson Health in Philadelphia took advantage of the recent enterprise EHR implementation to create dashboards highlighting potential prescribing issues. Internal EHR development teams have already made changes to address the issues they found.


In a recent interview, Cara Martino, enterprise business intelligence manager at 14-hospital Jefferson Health, said that Jefferson was one of the first health systems to implement its Epic EHR and Qlik Sense at the same time. Many organizations that go live on Epic use Crystal Reporting, she said. “It was the combination of the two that allowed us to do this project,” she added. Before going live on Epic and using this new BI tool, Jefferson clinicians used a bunch of disparate systems for ambulatory, inpatient and emergency department physicians. “We weren’t able to aggregate the data,” she recalled...


Continued at https://www.healthcare-informatics.com/article/ehr/how-bi-tools-are-helping-jefferson-health-battle-opioid-crisis

My colleague and director of healthcare industry solutions for Europe, Middle East, and Africa, Sean Price, visited the NHS recently. He chatted with Mark Singleton - the head of BI at NHS WWL - about their journey with QlikView and their real-time predictive emergency department app.


2018-09-13 12_46_57-Window.png

- - - - - - - - - - - - - - -

WWL’s Mark Singleton on using data to slash NHS waiting times


Patient data is often sought by healthcare organisations to improve the services and care that citizens receive, but Wrightington Wigan and Leigh NHS Foundation Trust (WWL) has taken a step back and looked at its operations to see if there are ways it can better use the information it already has to make efficiency savings and improve its quality of care.


Mark Singleton, the organisation’s head of business intelligence and acting associate director of IM&T, explains that WWL is often referred to as a data-driven organisation – and this goes back to some of the groundwork it put in place back in 2012. It was then that WWL put together a voluntary ‘Quality Champions’ programme for all staff – from finance managers to cleaners to management. The programme was aimed at empowering staff to make service improvements, including modules on how to use information to monitor changes for the short-term and long-term and ensure they are successful.


After six years, the organisation has had 365 employees go through the programme and it has helped to initiate 200 projects that are aimed at improving the organisation’s operations. These include reducing cancellations for pre-operations, safe discharging and human factors and incident reporting.


One of the main takeaways from the initiative is that more data was needed on how improvements could be made and how this could be monitored.


Success and failure when using Qlik

Coinciding with the programme, the NHS offered trusts help with service line reporting – to show which areas were making a profit and which areas were making a loss.


“It was based on [software provider] Qlik’s QlikView product, but the first few projects using this – including the service line reporting – weren’t particularly successful,” Singleton explains.


It wasn’t until a few years later that the trust finally managed to use QlikView effectively; it developed a finance app using QlikView which was aimed at reducing the need for an accountant to produce an A3 paper for each budget holder and explain to them what their budget looked like.


“We have hundreds of different budget holders so it was a bit of an impossible task. It was taking up all their time and they weren’t able to look at anything strategic,” says Singleton.


With the QlikView app, budget holders can log in to see their monthly budgets, and can drill down to invoices, staffing costs and income.


“It was a very visual way for non-finance people to engage with data and it was the first project that really changed the organisation’s perception of information,” Singleton explains.


This led to other departments wanting to use QlikView for clinical information, and ultimately led to the organisation having nearly 30 Qlik applications that support the way it operates in different ways.


“One of the targets in the NHS is when you go to the GP and they may refer you for a hip replacement. If you are referred to one of our hospitals, we have 18 weeks from referral to ensure the patient is treated. So we built an app to monitor our performance on that national target,” he says.


Prior to the app, WWL was struggling to meet the national target with a backlog of patients; now, according to Singleton, it is the “seventh or eighth best in the country around referral to treatment target”.


Meanwhile, the A&E department has a real-time forecasting app to predict how many people are going to be coming throughout the day; this helps the A&E to be as prepared as it can.


But while Singleton says that QlikView has helped the organisation to check how its performing against national targets, he says it is more of a static dashboard with limited interaction. This is why the organisation also recently purchased Qlik’s QlikSense product to complement QlikView.


“Qlik Sense would enable apps that have gathered data for the last few years to then ask questions such as ‘how many ambulances do we have arriving from care homes between 11pm and 7am, and how many come from Wigan and from outside of Wigan?’. This can help us to decide whether there is an opportunity of putting telehealth in our care homes,” he says.


QlikSense also provides the opportunity for employees to see data on their devices – enabling them to walk around wards or be available in the A&E department.


Another use case of Qlik’s software is a ward application which will appear on a large touch screen in WWL’s A&E department, executive offices and surgical theatres. This will replace the paper charts that nurses had to print off with specific information about the department.


“We’ve developed a Qlik app to provide just that; it will free up time for nurses so they don’t have to maintain and print off paper charts, but it’s also pulling in information from a range of our systems including HR, clinical, incident and risks and infections. This will harmonise all of the information and bring it into one place, making it far more conclusive,” he says.


The next step for the organisation is to introduce cloud computing as part of its IT environment. Currently, WWL has in-house infrastructure but it is working on a project to use Microsoft Azure to help set up a single version of the truth, enabling different providers in the health system to share data more effectively. The organisation wants to continue to be referenced as a data-driven NHS trust – and this seems like the logical next step.

Qlik now offers a selection of pre-built Healthcare applications, including data models and visualizations. 

These apps, which accelerate the time to value, can be expanded and customized as needed to quickly meet organizational demands. Embed them in workflows within your EHR and business systems to drive change at the point of care.

In addition, Qlik can blend publicly available data from third-party sources, enabling benchmarking against your peer organizations.

Check out all the details on the Aug 23 webinar here: http://go.qlik.com/ESG-18-Q3-DM-ESG-HC-Accelerator-Touch-2_Reg-LP.html

(Watch the full screen version here: https://www.youtube.com/watch?v=T3hUqrNKzfI )

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/



Filter Blog

By date:
By tag: