Google Cloud Platform > 实例探究 > Why Counsyl Chose Looker to Unify Access to Data

Why Counsyl Chose Looker to Unify Access to Data

Google Cloud Platform Logo
公司规模
200-1,000
地区
  • America
国家
  • United States
产品
  • Looker
技术栈
  • Looker
  • CRM Software
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Productivity Improvements
技术
  • 分析与建模 - 预测分析
  • 分析与建模 - 实时分析
适用行业
  • 医疗保健和医院
适用功能
  • 离散制造
用例
  • 预测性维护
  • 过程控制与优化
服务
  • 数据科学服务
关于客户
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, 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'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.
运营影响
  • Looker has empowered Counsyl employees to radically streamline processes, increase revenues, and position the company for future growth.
  • The billing team uses Looker dashboards to manage their workflow, allowing them to optimize their daily routine and focus on the highest value-add processes.
  • The use of Looker spread organically to other groups throughout the company. Because Looker provides a single, reliable source of data, each department, team, and individual can view the information through a unique lens that provides just the right insights for the job at hand.
数量效益
  • 100+ users spend over 75k minutes every month using data
  • Over 300+ scheduled reports are sent to inboxes each month
  • Saved dozens of hours every month by moving the logic behind the finance team’s nested pivot tables, and unwieldy VLOOKUPS into Looker

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。