Our Client (a research IT group at a midsized pharma company) was tasked with creating project dashboards for preclinical research scientists. Due to the fast-paced nature of R&D projects the dashboards needed to be updated at frequent but unpredictable intervals. Various (and changing) sources had to be queried to generate a live project report. In addition to that, scientists required a robust search capability to be included in all live reports.
After realizing that available tools required constant IT support at the data query / column selection / filtering level, our Client decided to look for new, less support-hungry tools that might already be in use in other data-intensive industries such as insurance, consumer marketing, or online sales. They identified Sisense Prism as a data aggregation and reporting solution. Sisense Prism includes a fast reporting database that responds to complex queries in seconds. It fit a number of "must have" criteria but didn't have chemical intelligence - there was no way to represent chemical structures or to search by substructure.
Integration and De-customization of Data Workflows
Saber Informatics was asked to implement chemical intelligence capabilities in project dashboards and to integrate Sisense Prism as a data aggregation / visualization platform with data workflow / data pipelining tools that our Client already had in place.
We integrated industry-leading ChemAxon tools into Sisense dashboards to add chemical structure drawing and search capabilities to dashboards. Thanks to both vendors' clean webservices APIs, the integration followed well-defined patterns. Project report dashboards remained scalable while maintaining their original UI look and feel.
We also integrated Pipeline Pilot into Sisense as an external live data post-processing webservice, adding to Sisense the ability to display webport-like apps. Our Client now can add Pipeline Pilot with its fantastic data processing capabilities to Sisense Prism which already has a performance-tuned data repository and a powerful visualization UI. The sisense-pipelinepilot widget is available to the community as open-source code under the MIT license.
As a result of this project, our Client (a research IT group) was able to deliver measurably better and faster data analytics tools to scientists while actually spending less effort on the minutia of dashboarding or performance tuning.
