This organization facilitates the alliances of approximately 4,000 U.S. hospitals and health systems, and more than 175,000 other providers and organizations in the medical equipment supply chain industry. With integrated data and analytics, quality improvement collaboratives, supply chain solutions, consulting and other services, the company facilitates better patient care and outcomes at a lower cost.
The healthcare organization was looking for a way to better manage and control access to their data assets. Specifically, they required a solution to manage field, table, and dataset descriptions—both globally and across all projects—at any level of specific granularity, and in a transparent manner.
In addition, they needed to ensure that an administrator could apply access controls to individuals and groups across any level of the data warehouse. Agosto’s expertise with Google Cloud Platform (GCP) and Analytics/IoT/Big Data workloads was instrumental in helping the client achieve these goals.
According to a Forbes report, two of the highest concerns for CTOs in adopting cloud environments are cost and data governance. Managing data warehouse metadata and access is especially cumbersome for the client due to its high volume of data assets and consumers.
Since the client is handling highly sensitive Protected Health Information (PHI) data, and has internal and external facing consumers who require accurate and up-to-date pricing information, these complexities are even further compounded.
From the Business Application Research Center, “data governance includes the people, processes, and technologies needed to manage and protect the company’s data assets in order to guarantee generally understandable, correct, complete, trustworthy, secure, and discoverable corporate data.”
Agosto began by conducting a remote workshop with the client to create detailed requirements that would support its analytics initiatives within its complex supply chain.
These requirements included:
Agosto provided the client with a centralized data access and metadata management system. This solution allows an administrator to leverage the simplicity of Google Sheets to update and tag BigQuery data assets with metadata, and control access at any level of the data hierarchy. Previously, these processes were manual and significantly time-consuming. They were also difficult to track and manage access.
Today, BigQuery metadata and access management is accomplished with an easy-to-use Google Sheet that is automatically updated on a nightly basis, ensuring the metadata and access are current.
Agosto used the following technical expertise in Google Cloud Platform to solve this challenge:
As a result of the solution, the client has greatly increased visibility and control of its high volumes of data. In addition, they were able to demonstrate to leadership a quicker, scalable way to build an analytics solution that other business areas can adopt and implement as well.