Case Studies

Customer Data Analytics Tool – Boosting the CRM initiative

Client Profile
Our client is rated among the top five advertising agencies in India. They have a nationwide presence and service some of the biggest names in corporate India.

Business Need
Our client provides data analysis services to their customers. This includes capturing data coming in from dealers as well as from marketing surveys. Earlier our client used to build custom applications for each such activity. This was a time consuming process and with different applications running for the different brands, consolidation and analysis of data and cross – brand analysis was a tedious and time consuming task and often the results were not accurate.

The Solution
The consultants from Sysconnect developed a highly flexible Customer Data Analytics tool with dynamic excel based reporting. The salient features of this tool are –

• The end user can create forms and form elements dynamically
  
• The forms can be associated with a company and a brand
  
• Flexible reporting module where the user can select the parameters on basis of which the report is generated
  
• Reports can be generated across companies and brands.

The Benefits

• Forms can be created in minutes. This results in enormous time and cost savings.
  
• Faster time to market
  
• Instant and flexible analytics help the customer to get different perspectives on the data
  
• Cross brand analysis helps the customer in better brand comparison and customer preferences
  
• Excel reporting gives the customer to manipulate data outside the system to analyse the same for different scenarios
  

The Technology
User Interface – C#.Net
Database – MS SQL Server 2005

Back