I wrote a blog post for Qlik Branch (the Qlik Developer Community) on how to build your own wellness/activity tracker app using your personal health data from your Apple iPhone, Apple Watch, and various home monitoring devices. Enjoy!

FULL BLOG LINK with helpful images: https://branch-blog.qlik.com/apple-healthkit-a-delicious-qlik-recipe-d61167e7ab89

Date: May 2, 2012
Time: 2:00PM - 3:00PM EST / 11:00AM - 12:00PM PST
Duration: 1 hour

Healthcare organizations are facing a tidal wave of data and have a real urgency to find cost effective, high-value ways to derive value from this data to improve care and reduce costs.

Informatica and Qlikview offer just the solution – enabling powerful, easy-to-use analytics against trustworthy data to answer key business and clinical questions such as…Who are my primary patients or members? What is the relationship between my patients and their providers? To whom are my providers referring my patients? What are the household relationships between my members or patients so that I can increase revenue?

Join Informatica’s Chief Healthcare Strategist, Richard Cramer, and QlikView’s Healthcare Director, Tracy Behar, to discuss how to overcome data challenges to better understand your customers, service providers, and the relationships between them to improve service quality, increase revenue and create business agility.

In this interactive webinar you will learn:

• Why relationships are so important to understanding your business
• How to fix unreliable, conflicting or poorly managed data to makes relationships easier to manage
• How analysis and reporting can be achieved at the physician, organization and service line level

Register here: http://tinyurl.com/7zfzj94

Check out our new Qlik Sense app featured in the Qlik Gallery:

🏥 Unlock transformative insights in healthcare using Qlik Sense with AnyChart's extensions: Decomposition Tree, Gantt Chart, Combo Chart, Sunburst Chart, and Timeline Chart. Dive deep into metrics like admissions, patient counts, and treatment costs. Perform root cause analysis or ad-hoc explorations with ease. Maintain clear, actionable visibility of doctor-patient timelines and track each patient's journey with insightful precision.

Check out the app in the Qlik Gallery:
👉 https://community.qlik.com/t5/Explore-Qlik-Gallery/Healthcare-Dashboard-Oncology/ba-p/2458556

Using Qlik GeoAnalytics and a few open-source tools, you can create engaging visualizations tied to your data such as this. Ever wondered how else the number X-rays and MRI scans received at hospitals can be visualised? Just a simple click and you can find out what individual body parts had the most scans!

The GeoAnalytics team wrote up a tutorial on how to do things like this: https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Digitizing-floor-plans-for-use-in-Qlik-GeoAnalytics-QGA/ta-p/1489032

Data visualization helps to tell patient stories.

Check out this video ( https://youtu.be/CBnaPbGGWfc ) of various Qlik implementations for Healthcare including statistical process control charts (SPC), Vizlib dashboards, Apple HealthKit, and NHS Command Centers.

#Qlik #QlikSense #HealthTech #analytics #dataviz

@vizlibmartin @danielgargiulo 

Having successfully used html within a text box, am now trying to use html within chart expression for a table.

any ideas?

... so that I can show a summary list of a person's health transactions

Sankey diagrams are a specific type of flow diagram, in which the width of the paths represent some quantity. These multidimensional visualizations help you to see flow and discover category relationships with a different perspective. If you were to ask me what my favorite visualization was, I'd most likely say: "The Sankey!"

Sankey diagrams show metric flows and category relationships. You can use a Sankey diagram to visualize relationship density and trends.

Use Cases for the Sankey Diagram

Use a Sankey diagram to visualize activity patterns such as:

• Flow: Patient admission and visit flow through your health system - where are patients coming from and where do they have encounters without our facilities and offices?
• Flow: Patient web activity on your patient portal - where are patients looking for information and where do they end up?
• Flow: Longitudinal risk scores for multiple visits - how do risk scores change with subsequent visits?
• Flow: ServiceNow ticket handoffs and SLA compliance (showcased by Nationwide Children's in Nov 2017) - which requests or departments pass tickets back and forth perhaps too much?
• Flow and Relationships: Care Pathways showing outcomes metric by various treatments or protocols - do patients receiving X have better outcomes than patients on Y?
• Relationships: readmissions by a variety of dimensions like county, hospital, condition, complexity, comorbidities, outcomes
• Relationships: Adherence by a variety of demographic and SDoH dimensions like sex, age, race, ethnicity, smoking status, language, support network, community, etc.
• What else have you seen or envision to be useful with a sankey? Please leave a comment here.

Data Requirements

To build a Sankey diagram, you need to have data that includes source and target categories (dimensions) and a metric that you are tracking between them. Luckily, with the Sankey diagrams, these can be completely different types of dimensions and hierarchies, or they can be source and (multiple) target(s) to visualize paths.

Think about it like this: you have one metric/measure of interest (like volume) and multiple dimensions to look at. In contrast to a scatter plot where you have one dimension and multiple metrics/measures.

How to Build/Download a Sankey Diagram

Qlik Sense

• Sankey Diagram for Qlik Sense - http://branch.qlik.com/#!/project/568aa0b06ed0f0f47a89d7f2
• Colorable Sankey - http://branch.qlik.com/#!/project/59f895c77b3744420b107829

QlikView

• QlikView Sankey Improved - http://branch.qlik.com/#!/project/57fce146e41f9c61570e6521

Examples

Howdy folks!  My name's Jeff Wu, and I'm a Solutions Architect here at QlikTech.  I joined QlikTech back in June of 2012 and prior to that was at Epic for six years serving as the Senior Application Director for the OpTime and Anesthesia applications.

Since joining I've gotten an opportunity to see what a lot of customers are doing with Qlikview and it has sparked my passion for better healthcare delivery and a desire to share my experiences in healthcare with others.

Today I'd like to talk about my favorite place in the hospital…

The Operating Room.

You're getting sleepy...

In my years as an implementer, I've gone live with Epic at over 50 individual hospitals; there really is no place like the ORs. With the ED a close second, there is no place in the hospital that is more critical to have operational efficiency from start to finish. According to a recent HIMSS article, the ORs are responsible for up to 60% of a hospital's revenue. On that note, the ORs can also account for more than 60% of a hospital's margin. This means that the most minor of problems in this area can have monumental effects on a hospital's operational effectiveness. First Case Late Starts, Delays, Add-on Cases, PACU time, patient transfers, etc. can all have very negative repercussions if not addressed in a timely fashion.

Take for example, the effect of one situation:

A surgeon is 15 minutes late to pre-op his first patient of the morning. The patient is scheduled for a basic laparoscopic cholecystectomy to treat gall stones. When she arrives, the surgeon speaks with the anesthesiologist, who is hesitant to go through with the procedure due to the patient's history of smoking, asthma, diabetes, and a recent bout of pneumonia. The surgeon is annoyed, but not wanting to lose her surgical slot, orders some STAT blood tests to check the patient's ability to undergo surgery. Upon return, it is confirmed that the patient is too sick to undergo the procedure. The case is cancelled.

What sort of revenue impact did this have? Well let's see. Due to the surgeon arriving late, the case was cancelled too late to actually make use of the room time. Both the surgeon and anesthesiologist lost the revenue that would be associated with performing the procedure. To insure speedy transitions, supplies for a surgery are laid out prior to a patients transfer into the OR--all those supplies are now wasted. Any pre-induction meds mixed specifically for that patient by the pharmacy or anesthesiologist are also wasted. What started as one small problem (surgeon arriving late) can develop into a significantly more complex problem. Now, you might think that this is a very rare occurrence that such an unfortunate series of events could happen, but I guarantee that if you talk to any surgical staff, this kind of thing has happened at least once in the past month, or more probably, the past week.

All of these combine for a massive loss to the hospital. Now, there are bound to be times when physicians are late; there are bound to be times when a patient forgot that they had to be NPO, but addressing what can happen will mitigate the financial impact of what inevitably will happen.

So how can we address this?

With data.

But not just any, or some, we need all of it.  All of it is the only way we can have an informed understanding of the situation and make an informed decision to correct it. As technology has progressed, sophisticated documentation systems have evolved to capture all the components that are necessary to address these problems. The next problem is that this data lies in disparate systems that have difficulty  communicating with each other. This was what I dealt with on a near daily basis in my time at Epic. Customers came to me with problems that they had the data to understand and correct but could not associate it meaningfully to make an informed decision. Take, for example, the very simple question every OR Director or Manager has to deal with:

Based on the number of add-on cases for the day, should I open an additional OR or pay my staff overtime?

This seems like a simple question, but what goes in to making an informed decision for an issue like this is extremely complicated. Factors such as the add-on procedures, to the staff on hand, to the cost of staff, average hours per stay, average time per procedure, even the day of the week can all impact whether the person in charge says yay or nay to something as simple as opening an additional OR. Additionally, this information is in multiple places besides the EMR. In my experiences prior to QlikView, OR Directors and managers were relegated to simply making gut checks on whether they thought a new OR was needed or whether paying staff overtime was sufficient, even though they had powerful systems and loads of data to look across to make a decision.

Here's where I get excited by QlikView. Because of QlikView's inherent powers to associate disparate sources of data, the previously difficult or impossible is now a logical first step.

This application takes into account EMR and Timelog data to help visualize information for decision making.

And we're just scratching the surface on what's possible.

Check out our upcoming marketing data sheet on ED and OR operational efficiency coming soon!

Up Next: A review of Meaningful Use Stage I and a foray into Meaningful Use Stage II

You may have seen, heard about, or even ridden the Qlik Core powered bike at any of many various events. Qlik Core and the fun bike experiment launched at Qonnections 2018, and the bikes have been making appearances and making people sweat in their business casual clothes ever since.

Some posts announcing and describing Qlik Core and the bikes:

• Introducing Qlik Core® - Beta
• Bike.qlik.com - The beauty of Qlik's Open Source with Qlik Core, Enigma.js, Picasso.js and Qdt-components
• Meet the New Kid on the Block, Qlik Core is here!
• You can also visit the main site and explore the resources at https://qlikcore.com

If you're interested in bike, just let us know. It's great for fundraisers and fitness challenges!

Now for a few random photos of the bike and participants. A few videos at the bottom.

Overview video of Qlik Core:

Introducing Qlik Core - YouTube

Qlik Core Bike in action video:

https://youtu.be/_ulTb2aYAxQ

Qlik Core Helicopter Game

 Qlik Fed SummitQlik Fed Summit

#QlikCore #QlikBike #QlikCoreBike #PiBike

Now more than ever, healthcare organizations are tasked with delivering better patient care. But for many reasons, including worker shortages, healthcare systems are having to improve efficiency and effectiveness with the same resources. A growing trend is to introduce an Internet of Things (IoT), artificial intelligence (AI), or machine learning (ML) solution to streamline staff workloads and address other common challenges. But these solutions can be expensive and risky if they fail to deliver. The many organizations that have decided the reward is worth pursuing are adopting creative solutions to mitigate the potential risk.

Read more.

I am looking to present to healthcare C-level leaders the value add of Qlik applications in the following departments: Cardiology, Radiology and Oncology.

Would you have predictive analytics experiences or KPIs that could be interesting to pitch to a CFO for example?

Where would you recommend me to search? 

That would be great if you can share experiences. Thanks.

Hospitals generate an enormous amount of data daily, which can be turned into actionable insights that can better operations, save costs and overall produce better patient outcomes. However, if the data is siloed or housed in various conflicting formats, it can be outdated, incorrect or valueless once accessed by its user.

Read more.

** Prerequisite – Install Qlik Sense REST Connector **

1) Get guid from SharePoint list (Maybe your SP Administrator can provide this?)

•    Navigate to the aspx page that contains the list:

     Example page: http://sharepoint/company/home/folder/project/new/newer/_formats/001/default.aspx

• Click on the Site Contents link

• Click on Settings

• Doesn’t matter if you actually have permission to the object the Access Denied page has the information you need! Look at the URL and search the string from RIGHT to LEFT and find the first instance of the word “List” and copy everything from that point to the end of the URL. 

Example url: http://sharepoint/company/home/folder/project/new/newer/_formats/001/AccessDenied.aspx?Source=http%3A%2F%2Fsharepoint%2Fcompany%2Fhome%2Ffolder%2Fproject%2Fnew%2Fnewer%2F_formats%2F001%2Flistedit%2Easpx%3FList%3DZY98XW76%252DVU54%252DTS32%252DRQ19%252DPO87NM65LK43

• The %3D in the url encoding just means the equal sign (=) so it can be ignored. Change all “%2D” to “-“ (I used notepad)

• Wrap the result in curly brackets and you have the List ID

Example GUID List ID = {ZY98XW76-VU54-TS32-RQ19-PO87NM65LK43}

2) How to view xml code of a list view

• Build URL: http://{0}/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={1}

          {0} – The URL to your site.  This could be the root web or a child site.

          {1} – The GUID for your list.

Example URL for viewing XML in browser:

http://sharepoint/company/home/folder/project/new/newer/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={ZY98XW76%252DVU54%252DTS32%252DRQ19%252DPO87NM65LK43}

• Copy and paste the new url into your favorite browser and you should see a page of XLM. If you can't view the XML in a browser you won't be able to view it in QLIK so make sure you can see the information before continuing.

3) Open your QlikSense application and create a new connection using the "Qlik Rest Connector".

4) Create new rest connection.

• Enter the url you created in step 2.
• Set the authentication and create a meaningful name (cnSharePointExampe)
• Fill out the remaining options as follows and test the connection

5) You can now load data (similar to any other data load process)

💥Bam! Meet Bullseye charts in Qlik Sense! 🎯

Qlik counted on us to provide its customers with "additional choices for building even more compelling visualizations," and we couldn't stop innovating 😎

⚡️ The March 2021 release of our Qlik extensions is out with the Bullseye chart — one of a kind in QS 💎 Also added, new great features for Gantt charts. All highlights here — see what's new.

🏆 Enjoy the new versions and hit the bull's-eye in data-driven decision making with Qlik and AnyChart.

What do you want to get next? Let us know!

At HIMSS 2022, one of the big topics of conversation was how to drive efficiency in healthcare without compromising the patient experience. Healthcare is human-centric, and the literal life-or-death situations faced by clinicians and patients every day means there’s little opportunity to experiment with new processes and technologies that could drive efficiency.  Any change needs to be simple to implement, work quickly and reliably, and produce results in order to be deemed a worthy investment.

Read more.

At the time, the 2009 HITECH Act and the introduction of the Meaningful Use program represented a momentous step in healthcare’s digital transformation. With billions of dollars in government investment and incentives in nearly two years’ time, over 77 percent of hospitals had reached Stage 3 of the Electronic Medical Record Adoption Model (EMRAM), or gone even further, pulling millions of data points into newly-established EMRs. 

Read more.