下载PDF
Why Counsyl Chose Looker to Unify Access to Data
技术
- 分析与建模 - 预测分析
- 分析与建模 - 实时分析
适用行业
- 医疗保健和医院
适用功能
- 离散制造
用例
- 预测性维护
- 过程控制与优化
服务
- 数据科学服务
挑战
Counsyl, a high-tech genetic testing company, was struggling with financial modeling and optimizing operational workflows. The finance and billing departments were particularly challenged with billing medical services to health insurance companies, which made predicting revenues and cash flows difficult. The company initially tried using their CRM software for reporting, but it wasn’t a good fit for their industry-specific requirements. As a result, the finance team had to manage multi-gigabyte Excel files with complex nested pivot tables and VLOOKUPS, which took hours every morning to manage and often resulted in frozen machines. Additionally, they had to pull developers and software engineers away from their work to get the raw data needed for their analysis.
关于客户
Counsyl is a genetic testing company that combines deep expertise in genetics and a sophisticated robotics platform to make DNA testing more broadly available and affordable. The company is committed to compassionate customer service, delivering test results to patients using straightforward, easy-to-understand language, along with one-on-one counseling, as needed. Counsyl has screened more than 700,000 patients to date through an automated lab that runs 24/7, evaluating lab samples for risk factors related to preconception, prenatal and hereditary cancer — including breast, ovarian, and colon. The company uses modern media technologies to help patients access, interpret, and understand the test results.
解决方案
Counsyl's data analysts chose Looker for its advanced analytics capabilities. They built a platform using Looker that helped accelerate revenues, empowered employees to manage their daily workflows, and eliminated time spent refreshing massive and complex Excel models. The first problem the analysts tackled was in finance. By moving the logic behind the finance team’s nested pivot tables, and unwieldy VLOOKUPS into Looker, the analysts were able to create a replica of the model that automatically updated every night and was ready for use as soon as coffee was brewed in the morning. This move saved dozens of hours every month and empowered the group to make improvements to the model with ease. On the operations front, Counsyl needed to build a window into where the team was spending time through their many touchpoints with patients, doctors, and insurance companies. By feeding the workqueue data into Looker, the team was able to visualize where they were spending the most of their time, discover bottlenecks in their operations, and eliminate redundancies in their flows.
运营影响
数量效益
相关案例.
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.
Case Study
Gas Pipeline Monitoring System for Hospitals
This system integrator focuses on providing centralized gas pipeline monitoring systems for hospitals. The service they provide makes it possible for hospitals to reduce both maintenance and labor costs. Since hospitals may not have an existing network suitable for this type of system, GPRS communication provides an easy and ready-to-use solution for remote, distributed monitoring systems System Requirements - GPRS communication - Seamless connection with SCADA software - Simple, front-end control capability - Expandable I/O channels - Combine AI, DI, and DO channels
Case Study
Driving Digital Transformations for Vitro Diagnostic Medical Devices
Diagnostic devices play a vital role in helping to improve healthcare delivery. In fact, an estimated 60 percent of the world’s medical decisions are made with support from in vitrodiagnostics (IVD) solutions, such as those provided by Roche Diagnostics, an industry leader. As the demand for medical diagnostic services grows rapidly in hospitals and clinics across China, so does the market for IVD solutions. In addition, the typically high cost of these diagnostic devices means that comprehensive post-sales services are needed. Wanteed to improve three portions of thr IVD:1. Remotely monitor and manage IVD devices as fixed assets.2. Optimizing device availability with predictive maintenance.3. Recommending the best IVD solution for a customer’s needs.
Case Study
HaemoCloud Global Blood Management System
1) Deliver a connected digital product system to protect and increase the differentiated value of Haemonetics blood and plasma solutions. 2) Improve patient outcomes by increasing the efficiency of blood supply flows. 3) Navigate and satisfy a complex web of global regulatory compliance requirements. 4) Reduce costly and labor-intensive maintenance procedures.
Case Study
Harnessing real-time data to give a holistic picture of patient health
Every day, vast quantities of data are collected about patients as they pass through health service organizations—from operational data such as treatment history and medications to physiological data captured by medical devices. The insights hidden within this treasure trove of data can be used to support more personalized treatments, more accurate diagnosis and more advanced preparative care. But since the information is generated faster than most organizations can consume it, unlocking the power of this big data can be a struggle. This type of predictive approach not only improves patient care—it also helps to reduce costs, because in the healthcare industry, prevention is almost always more cost-effective than treatment. However, collecting, analyzing and presenting these data-streams in a way that clinicians can easily understand can pose a significant technical challenge.