Category Archives: Business and Analytics

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

Data Discovery/Visualization using Qlikview for US Division of one of the World’s Largest Property Services Firms

Business Problem: Client wanted to present the key metrics on their properties, leases , property maintenance and performance records to the property owners and brokers in a form which is actionable as well as visually appealing. The nature of data for the dashboard presented a challenge , varying from structured databases to CSVs and XML sources. […]

Read More

Re-Platforming the Datawarehouse And BI Platform For a Global Semiconductor Manufacturer

Business Problem: The existing Datawarehouse and the BI platform was not scaling to the ever increasing data volumes and required to optimized or migrated to a newer platform Our Solution:  The work involved understanding the current data integration framework developed using custom PL-SQL scripts and effectively migrate (re-write as parallel jobs in DataStage). The existing Datawarehouse in Oracle […]

Read More