Categorized under: Industry Specific, Pharmaceutical
Scientists must register new assays, schedule the experiments, and upload the assay results into a centralized database for further analysis and decision-making. At every stage of the process scientists must manually move data between opaque data silos and people. Thousands of hours of their time are spent manipulating information and waiting for the results of collaborative processes:
- Results are delayed for days while IT creates proper database structures.
- At least 20% of chemists’ time is spent coordinating limited slots for assays.
- Assays are re-run unnecessarily - there is no reliable access to results from prior experiments.
- Results emailed from external research partners are cut and pasted from one spreadsheet to another for further analysis, wasting time that could be used to perform more assays.
Cambridge Semantics’ Solution
Cambridge Semantics' Anzo suite of products allows data to move freely between internal and external research scientists and supporting systems. The Anzo Data Collaboration Server is the backbone, allowing data to be extracted from spreadsheets, downloaded to a central database, viewed in an end-user-friendly Web front-end, reused in other spreadsheets, etc. The data is now available in real-time to the entire research community whenever and in whatever application they feel most comfortable using.
- Results from spreadsheets (regardless of format) are downloaded in real-time to a central database.
- Assays are registered via a self-service Web front end in seconds with no cutting, pasting, rekeying and most importantly, no human intervention.
- Results from prior experiments are automatically uploaded into scientists’ spreadsheets preventing rework and saving valuable set up time.
- The team coordinator has a consolidated view of all assay requests which are then sorted according to priority and displayed in real-time in a Web front-end showing technicians the next compounds to process for a particular assay.
Data Collaboration is the key. Once the data is liberated from traditional application silos, it can be moved, combined, manipulated, reformatted, viewed, shared and reused in the medium that best suits any user. Any authorized user can access the data sets exposed through the Anzo Data Collaboration server. Data sets can be searched or queried by their contents or concepts which describe their contents, making data discovery simple and straightforward. Cambridge Semantics’ Anzo for Excel liberates and integrates data from and to spreadsheets. The Anzo Data Collaboration server organizes the data in such a way that the end user never has to worry about where any data set resides or where it originated or what it means. It is simply there when they need to access it in the form that best suits them, making it simple to reuse.