Category Archives: Case Studies

Integration of EIM platform metadata housed in the IBM InfoSphere Information Server (IIS) repository into Collibra DGC for a leading US Regional Bank

Client: A leading US Regional Bank Business Problem: IBM InfoSphere Information Server was the centralized technical metadata repository for the client, housing metadata generated by IIS and also loaded from other systems using third party solutions. They wanted to import all this technical metadata into their primary governance platform, Collibra Data Governance Center(DGC). Our Solution: […]

Read More

Enabling traceability of data from dashboard to system-of-record for a Multi-National Oil and Gas Corporation headquartered in the US

Client: A Multi-National Oil and Gas Corporation headquartered in the US Business Problem: The client had critical dashboards built on Tableau that connected to several of their enterprise data stores on SAP HANA, SQL server and other relational databases. It was important to understand the data lineage for each of the dashboard elements to its […]

Read More

Integration of metadata from data platforms to enable traceability of information on reports to system of record for a large US Healthcare Company

Client: A large US Healthcare company Business Problem: The client wanted to provide data lineage/traceability from their Cognos dashboards through to their systems-of-record. Solution: Lucid extended the Collibra metamodel to model the metadata pertaining to the BI metadata to support cubes and filters. Collibra Connect templates were developed to Extract metadata from IBM Cognos, pertaining […]

Read More

Formalizing management of business-specific reference data lists through Collibra DGC for a large US Healthcare Company

Client: A large US Healthcare company Business Problem: Critical data management processes such as business-specific reference list management were very manual and being handled through spreadsheets. This was prone to errors and delays sometimes leading to revenue loss. The client wanted to use Collibra DGC as the system of record for these reference lists and […]

Read More

Custom Workflow for Asset Bulk Upload in Information Governance Catalog (IGC)

Client: One of US’ leading health care companies that provide access to quality health care and innovative solutions for members. Business Problem: IBM Information Governance Catalog(IGC) was used as part of the client’s Data Governance effort. In IGC, a steward has to create catalog assets (terms & categories) individually and send for approval. Support for […]

Read More

Dashboard Prototyping for a US-based Retail Chain

Business Problem:  The client needed a dashboard to monitor the customer shopping behavior and  store performance in their retail stores Our Solution: The work involved development of a Dashboard prototype within a week, based on data provided in one transaction table. Three dashboards were required – one each for assessing customer, product and store performance. The prototype […]

Read More

Optimize Content Moderation for a US-based Leading Media Company

Business Problem: With increased usage of social media, moderating conversations and removing abusive input is becoming more demanding. A predictive model for automating the process of removing and blocking insulting content was needed Solution: A predictive model was built to identify insulting / abusive content in a conversation or twitter input, for automatic removal to optimize moderation […]

Read More

Predict Molecule Effectiveness for a US Pharma Major

Business Problem: The client required a model to predict biological activities of different molecules to ascertain their on- & off-target effectiveness Solution: After evaluating several statistical models, an ensemble of models based on Lasso Regression and SVMs in R. The key challenge was handling the huge datasets.Dimension Reduction Techniques were used to ensure that the test […]

Read More

Predict Campaign Effectiveness for a Leading US-based Marketing Firm

Business Problem: Analyze customer demography data to ensure effectiveness of  email marketing campaign Our Solution:  With the spread of Social networks, keeping Direct mail campaigns effective  and relevant has become very important. A huge history of direct mail responses were crunched to determine Who was likely to open a campaign email? Who would click on product […]

Read More