Solutions

We solve challenges. It’s what we do. And when we see a consistent challenge, our engineers get to work on building solutions for our customers.

Healthcare
Snowflake Optimization

Healthcare
Solutions & Accelerators

FHIR Data Loader
Ampr
Aloha
Looking Glass

FHIR Data Loader
Accelerator

HEALTHCARE ACCELERATOR

FHIR Data Loader

The Challenge for Healthcare Data

Healthcare data allows data teams to unlock new capabilities in providing better patient outcomes. Fast Healthcare Interoperability Resources (FHIR) is the latest standard of healthcare data. Because FHIR resources have been designed to be both human- and machine-readable, they can be difficult to map. As a result, feeding data into upstream data models is a challenge, as is data extraction. Making FHIR data easier to load and transform into a fully structured format allows teams to extract value and deliver business outcomes faster.

The FHIR Data Loader Solution

Hakkoda’s FHIR Data Loader removes the complexities of getting FHIR data business ready, with a low code solution that makes it easy for healthcare teams to build pipelines for loading FHIR data into Snowflake. Here’s how it works:
1

Load Continuously

With FHIR Data Loader, you can load continuously. Connect directly to FHIR servers with selected APIs, and Flatten FHIR resources in Snowflake.
2

Scale Business Ready Insights

The FHIR Data Loader’s low code architecture removes the complexities of manual coding processing, helping healthcare teams scale business ready insights.
3

Future Proof Data Pipelines

Your team is able to quickly future-proof clinical data pipelines. Once loaded, the FHIR bundle can be easily unpacked, regardless of resource structure, and easily converted into a structured format for analytics processing.
70% of healthcare executives believe that interoperability and seamless data sharing are essential to successfully delivering value-based care
- Healthcare Financial Management Association, 2018

Ampr
Solution

HEALTHCARE DATA INTEGRATION

Ampr

Mapping healthcare data can be tedious, so we’ve trained machines to do it while giving you complete visibility and control.

Hakkoda’s ML Classification engine is trained on large healthcare data sets and processes data through three layers of machine learning.

Ampr addresses key healthcare use cases

1

Save Thousands of Hours

Manually integrating complex healthcare data sets can take hundreds or thousands of hours and leads to costly errors.

Our solution applies three layers of machine learning to accelerate integration and reduce time-consuming manual work.

2

Dynamic Patient 360

Ampr stitches together your numerous data sources into a single patient view.

Intelligently interpreting relationships between interactions, patients, and physicians, providers gain a 360-degree view of each patient that adapts as your systems change.

3

Mergers & Acquisitions

Realizing the value of an acquisition requires integrating its data. Unfortunately, it is a messy and time-consuming process, especially in healthcare.

Ampr brings the power of machine learning to integration, lowering cost and increasing speed and accuracy.

4

Modernizing Data Sharing

Sharing data internally, between organizations, and the Center for Medicaid and Medicare Services (CMS) is a big challenge.

Ampr and Snowflake simplify it. Snowflake enables secure, compliant data sharing, and Ampr maps the shares to your data sets.

Aloha
Accelerator

HEALTHCARE ACCELERATOR

Long Inpatient Care Stays Drive High Costs and Poor Patient Outcomes

In the U.S., hospital inpatient care is one-third of all healthcare expenditures, accounting for 35 million stays a year with an average length of stay (LOS) of 4.5 days and a cost $13,600 per day. Consequently, even a small reduction in LOS can account for millions of dollars in annual savings across a health system. Shorter lengths of stay can also benefit patients, decreasing the risk of hospital-acquired conditions, such as pressure injuries and infections.

The Aloha Solution - ‘Appropriate Length of Hospital Admissions’

Aloha is a modern data science tool that helps clinicians efficiently allocate hospital beds to those who need them most. Aloha flags a patient if they are anticipated to experience an avoidable hospital day during their inpatient encounter. Flagging an avoidable day allows healthcare providers to transfer the patient to a new facility for the same or better care, send the patient home in a more timely manner, and open a bed for someone else.

Aloha works by gathering clinical and demographic data and then training an ML model to work on data hosted in a Python/ Snowpark/ Snowflake system. This ML model is implemented in real-time systems, allowing healthcare providers to better manage patients that are already in the hospital and provide more individualized care.

The final information lives in an Electronic Medical Records (EMR) system, with the ability to:

1

Create Real-Time Flagging

Create real-time flagging that complements a patient’s care processes.

This will ensure operational excellence by improving patient outcomes and patient satisfaction.

2

Efficient Bed Allocation

Improve the quality of your care through deliberate bed allocation, managed weekend discharges, and insight into unwarranted variation by department.

This will Increase revenue and optimize the cost of patient care.

3

Reduce Annual Spend

Finding key indicators for the causes of longer lengths of stays, and identifying unwarranted variation within and between hospitals saving on annual spend.

This will help healthcare institutions allocate their resources (from nurses and healthcare personnel to medication and hospital beds)

Looking Glass
Accelerator

HEALTHCARE PRICING TRANSPARENCY

Looking Glass

To ensure price transparency in the Centers to Medicare and Medicaid Services (CMS), healthcare providers need to make pricing publicly available. However, how can you do this for large, semi-structured data sets?

Although Snowflake has amazing support for storing structured files, large price transparency files often exceed the supported size. Our solution is Looking Glass, an accelerator designed to restructure large price transparency files in a fully structured reusable model.

Looking Glass addresses key healthcare needs

1

Efficient Resource Use

Looking Glass doesn’t require excessive infrastructure and only consumes resources while a new file is being restructured to ensure customers only pay for resources they are using.

2

Improves Speed

The reusable model accelerates the consumption of the semi-structures price transparency by providing a consistent model for flattening data according to CMS guidelines.

3

A Practical Solution

This accelerator is cloud-provider agnostic, meaning it lives on the same cloud platform as your external stage and restructures files into a size supported by Snowflake.

4

Meeting Healthcare Goals

Looking Glass’ end goal is to enable consumers to best meet their needs by providing tools and support that helps them comply with price transparency while maintaining costs.

Snowflake Optimization
Solutions & Accelerators

HakkodaRM
THE POWER OF THE CLOUD​

HakkodaRM

HakkodaRM is a resource monitoring and observability service built for Snowflake customers.

You can use it to monitor your compute and storage resources, optimize resource utilization, and discover insights to run your Snowflake environment smoothly.

HakkodaRM can detect anomalies in your environments and takes action.

HakkodaRM compliments Snowflake’s credit quota

1

Time-Series Warehouse Monitor

HakkodaRM learns from historical data and automatically detects when your warehouse is about to go over its credit limit. It also accounts for seasonality and trends, ensuring credit usage spikes don’t catch you off guard.

2

Inefficient & Slow Query Detection

Get notified if daily queries take longer than expected. See which queries could benefit from a technical deep dive to transform them to run more efficiently.

Optimize your Snowflake compute and credit usage by improving the quality of the SQL you use every day.

3

Task & Stream Transparency

Get alerts if tasks are missed or falling behind. Learn why your tasks aren’t running correctly or efficiently.

Visualize all your metrics with PowerBI or Tableau.

4

Interactive Alerts

Save time. Respond to alerts in Slack, Teams, email, or ServiceNow, without logging into Snowflake.

Need help? Hakkoda engineers are on-call to assist you based on your subscription level.

Ready to learn more?

Speak with one of our experts.