技术
- 分析与建模 - 大数据分析
- 功能应用 - 企业资源规划系统 (ERP)
适用行业
- 医疗保健和医院
- 石油和天然气
适用功能
- 产品研发
- 质量保证
用例
- 实验自动化
- 租赁金融自动化
服务
- 云规划/设计/实施服务
- 测试与认证
关于客户
Vida Health 是一家总部位于旧金山的数字健康公司,成立于 2014 年。该公司通过雇主赞助的计划为患有糖尿病、肥胖和抑郁症等慢性病的个人提供个性化的虚拟护理。为了根据个人需求定制支持和资源,Vida Health 收集客户的病史、过去的保险索赔、实验室测试结果以及来自健身追踪器和数字秤等健康技术设备的日志数据。这些数据使 Vida Health 能够监控用户的进展,根据需要调整治疗计划,并让用户通过 Vida Health 移动应用程序了解结果。该公司的团队规模为 400 人,使用的数据堆栈包括 dbt Cloud、Fivetran Enterprise、Google Cloud、BigQuery 和 Looker。
挑战
Vida Health 是一家数字健康公司,其数据基础设施面临着挑战。该公司收集客户的病史、过去的保险索赔、实验室测试结果以及来自健康技术设备的日志数据的数据,以提供个性化的虚拟护理。然而,他们使用 Python 脚本和 cron 作业在 BigQuery 中加载和转换数据的定制解决方案不可扩展,并且在数据量激增时经常失败。该管道的记录很少,只有数据团队中的少数人了解,导致出现问题时报告停机时间为 2-3 天。该公司最近将其数据工程、数据科学和数据分析职能整合到一个团队中,旨在改善协作。然而,现有的数据基础设施不够可靠或易于访问,无法为客户提供最佳服务,也无法实现在不到六个月内吸引十多个新客户的目标。
解决方案
Vida Health 实施 Fivetran 和 dbt Cloud 来改造其数据基础设施。 Fivetran 用于将来自多个来源的所有 SaaS 应用程序和专有受保护健康信息 (PHI) 的数据集中到一个真实来源仓库中。这提供了内置的自动化和安全性,在处理健康数据时尤其重要。该公司现在使用 Fivetran 将来自 148 个不同连接器的数据集中到一个 BigQuery 中。使用 Fivetran 将数据加载到 BigQuery 后,团队使用 dbt Cloud 将旧管道代码重构为模块化 SQL 查询,以便更轻松地读取、重用和维护。 dbt Cloud 使临床研究、产品和数据团队的 Vida Health 员工能够访问数据转换过程,使他们能够共享知识、提高数据洞察和产品的精确度并加快行动速度。该公司现在使用 dbt Cloud 和 Fivetran 的内置功能来防止可能导致管道停机的问题,并确保在发生事件时快速恢复。
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
Case Study
Taking Oil and Gas Exploration to the Next Level
DownUnder GeoSolutions (DUG) wanted to increase computing performance by 5 to 10 times to improve seismic processing. The solution must build on current architecture software investments without sacrificing existing software and scale computing without scaling IT infrastructure costs.
Case Study
Remote Wellhead Monitoring
Each wellhead was equipped with various sensors and meters that needed to be monitored and controlled from a central HMI, often miles away from the assets in the field. Redundant solar and wind generators were installed at each wellhead to support the electrical needs of the pumpstations, temperature meters, cameras, and cellular modules. In addition to asset management and remote control capabilities, data logging for remote surveillance and alarm notifications was a key demand from the customer. Terra Ferma’s solution needed to be power efficient, reliable, and capable of supporting high-bandwidth data-feeds. They needed a multi-link cellular connection to a central server that sustained reliable and redundant monitoring and control of flow meters, temperature sensors, power supply, and event-logging; including video and image files. This open-standard network needed to interface with the existing SCADA and proprietary network management software.
Case Study
Refinery Saves Over $700,000 with Smart Wireless
One of the largest petroleum refineries in the world is equipped to refine various types of crude oil and manufacture various grades of fuel from motor gasoline to Aviation Turbine Fuel. Due to wear and tear, eight hydrogen valves in each refinery were leaking, and each cost $1800 per ton of hydrogen vented. The plant also had leakage on nearly 30 flare control hydrocarbon valves. The refinery wanted a continuous, online monitoring system that could catch leaks early, minimize hydrogen and hydrocarbon production losses, and improve safety for maintenance.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.