Contact & Support
Solutions

From Google Sheets to A Fully Scalable & Secure Clinical Data Warehouse with REHAB

66degrees Rebuilds Digible’s AI Marketing Platform’s Database on Google Cloud

For over 65 years, Rehabilitation Hospital of the Pacific (REHAB) has been dedicated to rebuilding lives and empowering patients to reach optimal health and independence. Serving over 11,000 patients every year, REHAB works with individuals, families, and communities by providing exemplary rehabilitation care services for those with physical and cognitive impairments in Hawaii and the Pacific.

  • all case studies

What we did

  • Data Migration
  • Cloud Optimization
  • Application Modernization
  • Cloud Security

The Challenge

REHAB used Google Sheets to track patient referrals from their partners, but actual admissions, discharge, and transfer (ADT) data was routed through an on-premise healthcare system that used the HL7 v2 data format: a highly complex, text-based data format that stores patient data in a complicated series of pipe and special-character delimited data points. REHAB had no way to connect their HL7 v2 data to their partner referrals and as a consequence, didn’t really understand which partners provided referrals that resulted in patient admissions. They needed a clinical data warehouse and interactive client dashboard that could be used to gain insight into the success of their outreach initiatives.

However, HL7 v2 messages can be difficult to work with, requiring specialized knowledge to restructure into a format that can be used for analysis. On top of that, because these messages contain patient data, REHAB had to make sure that whatever solution they chose for their data warehouse was secure and fully HIPAA compliant.

The Approach

With the Google Cloud Platform, security and compliance is a breeze. The fundamental components of the platform, including Google’s market-leading data warehouse BigQuery and ETL tools such as Google Dataflow, are HIPAA compliant and covered by a Business Associate Agreement. On top of that, Google Sheets, which can be connected to BigQuery via a native connector, is also HIPAA compliant, providing an easy-to-use and cost-effective tool to analyze and visualize data.

What really differentiates the Google Cloud Platform is that it offers specialized healthcare tools in the form of the Google Healthcare API, which acts as a storage mechanism as well as a data interface that quickly parses HL7 v2 messages into a JSON-based format. The JSON format is much easier to work with, and by partnering with Google for the alpha release of the Healthcare API, 66degrees was able to create a fully secured, managed Google Cloud Dataflow pipeline that automatically parses HL7 v2 messages and sends them to BigQuery for visualization and analysis in Google Sheets.

The Results

  • Completely secure & HIPAA compliant data pipeline
  • Data admissions processed in real time, sending easy-to-understand & analyzable data into a clinical data warehouse
  • Insight into the efficacy of the hospital’s outreach
  • Closer alignment with partners, helping effectively route patients to hospitals and clinics.

"66degrees has been a great asset in Digible's strategic move from AWS to Google Cloud. They guided us throughout the process and provided recommendations that helped alleviate technical debt and save us thousands of dollars long-term. We look forward to working with the 66degrees team again."

– Victor Dozal
Director of Engineering, Digible, Inc.

Case Studies

Read their success stories

Transformation towards better business analytics initiatives, powered by Google Cloud

Learn More

Transformation towards better business analytics initiatives, powered by Google Cloud

Learn More

Auto Insurance ML Pipeline: Doing More with On-Premise Data

Learn More

Auto Insurance ML Pipeline: Doing More with On-Premise Data

Learn More

Let’s Get You There

Google Cloud is where innovation happens. As a Google Cloud Premier Partner, 66degrees helps companies set a solid foundation and effectively leverage the platform’s leading-edge capabilities. It’s all about making your big ideas a reality. Connect with one of our cloud experts about modernizing your applications with Google Cloud to get started.

Get In Touch
Google Cloud Partner

Let's Get You There

With over a decade of premier partner status, 66degrees aligns with Google Cloud to ensure a seamless experience for our clients — from our shared vision to the way we organize our teams.

SUBSCRIBE TO INSIGHTS
SOLUTIONS
66degrees is a Google Cloud Premier Partner helping customers master security, infrastructure, app development, and team collaboration in the cloud.
CONTACT INFO
OFFICEs

600 West Van Buren Street, Suite 603 Chicago, IL, 60607

1125 17th St Suite 2550, Denver, CO 80202

Zona Franca Metropolitana, Edificio Administrativo Heredia Ulloa, 40104, Costa Rica

#447 Arjun Arcade
6th Main Jayachamrajendra Road, Vijayanagar 1st Stage, Mysuru, Karnataka 570017, India

66degrees is a Google Cloud Premier Partner helping customers master security, infrastructure, app development, and team collaboration in the cloud.
FOLLOW US
Linkedin Facebook Twitter Youtube
FOLLOW US
Linkedin Facebook Twitter Youtube
Copyright ©2023  66degrees. All rights reserved.
Cloud Security Cloud MigrationVelocity Engineering Application Development
Edge IoT SolutionsGoogle Cloud Anthos Solutions Application ModernizationSmart AnalyticsData Modernization

FinOps Managed Google Cloud Optimization Cloud Cost 

Google Workspace