Author Archives: Site Admin

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

Predictive Cash Flow For US -Based Healthcare Providers And Practitioners

Business Problem: The Financial Officers of the Healthcare providers have insufficient information to understand the reasons for unpredictable long revenue cycle. Our Solution: The work done was to predict the cash flow from claim reimbursements  for healthcare providers using  historical data. The predictions made were How much money can be expected? When is the money […]

Read More