Great Results. Happy Clients

The company routes more than a million transactions a day to a mix of payment gateways to give the highest ROI to its clients. Building a 360 view to see all the aspects of their customers was a challenge. Analyzing conversion rates through cohort analysis was taking too much time. Additionally, their existing solutions were consuming too many data warehouse compute resources.

Leveraging the Looker, Dataco conducted an audit of the company’s architecture, and identified the objects using the most resources, their most-used dashboards, and their current caching policies. Dataco designed and implemented a plan to reduce the company’s overall Bi tool and data warehouse costs, optimized their data group usage, and created reporting to track customer behavior & company KPIs.

With an ever-growing number of clinics joining the company’s network, analyzing their data to improve the efficiency of how clinical trials are performed became critical. The more efficient they are, the faster possibly life-changing drugs can reach the public. Their biggest challenge resides in using live data to make real-time decisions.

Leveraging BigQuery, DBT, and Looker, Dataco helped the company create models that transform data from different sources and aggregate it to provide up-to-date, live analysis. Additionally, snapshot policies created by Dataco allow the company to query historical data and get information about the business for any day in the past.

Outdated formats and legacy systems were a hurdle when building a comprehensive view of a patient’s adherence to their medical programs. Medical appointment follow-ups and real-time reporting to pharmaceutical companies were inaccurate and time-consuming. 80% of the company’s activities were living in the company’s physical servers with no backups in the cloud, putting at risk the patients’ data protection. Historical customer data was not centralized, preventing the company from predicting trends, identifying opportunities, and keeping up with itsby migrating data competitors.

Dataco conducted an analysis of the company’s existing system to determine the ideal data stack that met its unique needs. Data produced by physicians, healthcare programs, customer service systems, and internal departments were modeled, configured, and ingested in a cloud-based warehouse. Once in the cloud, data was transformed and prepared for consumption in a modern BI tool. This provided the company with a comprehensive tool to view KPI performance, assess the success of their programs, and ensure a superior experience for their customers.