Case Studies

Custom Research and Newsletter Creation

Client
One of the leading Mobile Phone Manufacturer of the world
Purpose
Customized Research over the Industry and Newsletter Development

Tasks

Custom Research – Mobile Phone Industry in India
Meltdata conducted a comprehensive web based customized research of the Indian Mobile Phone Industry. Meltdata presented a summary of findings to the clients which were approved by the client for news letter creation as well as other internal purposes.

Newsletter Creation – Monthly Newsletter for end user customers
Meltdata used the customized research Information to ingratiate into a monthly e-newsletter for its existing and prospective consumers. Meltdata also helped the client in identifying the segments of prospective “Best – readers” and “Best-Consumers” for email blasting purpose of newsletter.
............................................................................................................................................................................................................................

Identifying the Investment Possibilities for a New Invention
Client
A leading Venture Capital firm
Purpose
Researching the Investment Scenario for a New Method of Production of White LEDs

Tasks
Custom Research – White LEDs Market Meltdata accessed the complete market for the newly invented technique for White- Led Production. This included research over Florescence Properties, Manufacturers, Development and Potentiality for the new Invention.

Economic Analysis – Investment Possibilities
Meltdata undertook the Qualitative and Quantitative analysis of econometrics of the New Invention that included the ROI generation, Cost Analysis, Loyality Analysis, Customer Analysis and Purchasing Behavior. Our research enabled the client to identify the profitability for the investment on this new technology.
............................................................................................................................................................................................................................

Development of full fledged automation tool
Client
A leading U.S Retail Client
Purpose
Development of an automation tool which would reduce the cost and resource over a repetitive task

Tasks
Program the Data file for automatic formatting, cleaning, calculations and validation of data. Meltdata assessed the raw data file and developed a” one click algorithm” for the client. Using this tool client was able to reduce the time by 20 folds. Also the resource utilization was reduced.

Database and OLAP Cube Development
A SQL database model was designed and programmed for the automatic updating of daily data. SQL Database was used to develop an OLAP cube with the capabilities to access data from remote server in the form of multidimensional relational cube. OLAP cube incorporated the features like possibility of customization of view of data as per requirement, user friendly interface, slicing, dicing, rolling, drilling down and rotating to any level of granular data possible. This significantly reduced the time taken, error possibility, resource utilization, quality of analysis done on data thus greatly improvise the quality of business decisions.

Automation of Power point report generation
A tool was developed with the capabilities to generate business reports at a user click. This greatly reduced the time and resource utilized in the above task. Also, it helped to focus more on the business actions to be taken. .
............................................................................................................................................................................................................................

Development of a Web Dashoard
Client
A leading courier services organization
Purpose
Development of a web interface to access real time information by multiple users from various sources in the business. Requirement was to have real time analysis of how the Business is operating

Tasks
Identification of Key performance indicators for the client’s business Development of design of dashboard according to the requirements of visualization of data with features like automatic updating of data into database, real time access of data from database, looking at the trends of key performance indicators and user friendly interface.. It also had the feature which automatically reports the areas in which action was required.

The dashboard was accessible through web thus helped them to secure their database from encroachment of database by limiting the accessibility of database. This tool greatly helped the client in quickly reviewing the business, constant monitoring of the status of various KPI’s and thus assisted in business decisions.
............................................................................................................................................................................................................................

Survey Design, Data Processing, and Statistical Analysis

Client
A leading Domestic Restaurant Chain
Purpose
Client needed to assess the Customer Satisfaction for its services.

Tasks
Extensive study of the drivers which leads to customer satisfaction was done. A Questionnaire was designed based on these drivers and launched online as well as on paper.

Once the collection of responses done, we incorporated various statistical techniques such as perceptual mapping, KANO modeling to identify the key drivers which results in maximum drive to customer satisfaction. Also we had generated significant insights like what are the key areas in which the client business is lacking as compared to their competitors. Our team also suggested the methods to be incorporated in the system to improve on those areas.

This greatly helped the client to identify the areas in which improvement is required. Thus it resulted in significant improvement in the brand image and customer satisfaction.