C & R Associates is one of the UK’s leading Market Research agencies providing variety of market research services such as mystery shopping surveys, customer insight surveys, employee surveys, reporting and benchmarking to public & housing sector.
C & R turned to InfoAxon to streamline its survey data collection, aggregation and analysis process and provide its end-customers superior customer service through an online self-service BI portal with market research insights and benchmarking information.

Customer Name : C & R Associates Ltd

Industry: Market Research

Geography: United Kingdom

Business Need: C & R used to collect huge data from online and offline surveys as part of its marketing research assignments, across the board. The response data was then manually collected, aggregated, analyzed and reported using simple Office Productivity tools such as MS Word, Excel etc.

As the company grew in size and added more customers, C & R found it difficult to quickly service the customers and scale the business quickly. Moreover the customers were demanding better insights from their survey data in form of visual dashboards, rich reports and analysis with appealing visualization delivered as a self-service online.

C & R started looking for a central BI Solution to:

• Increase the productivity of its staff by providing them automated tools to quickly collect, aggregate, analyze and create appealing reports for its customers
• Offer an online self-service to its customers to help them access survey data in form of rich insights and benchmark their survey results across the industry.

Solution Title : Market Research Insights Solution

Solution Summary : InfoAxon leveraged its open source BI integration capabilities to provide an integrated business intelligence (BI) solution to help C & R research staff and customers with automated tools to analyze the survey data to gain meaningful Insights.

The BI solution consisted of:

• ETL processes to help C & R’s staff capture and aggregate survey data from various sources both online & offline in an automated manner.
• A central Data Warehouse with generic Data Model to manage multiple survey data types and survey data and to be able to compare results across different runs of the survey and across the industry.
• An Online Portal for C & R’s customers to provide self-service BI capabilities to analyze their survey data and get Insights in form of:
  • KPI driven Dashboards
  • Dimensional Data Analysis (OLAP Analysis)
  • Advanced Reports
  • Rich Data Visualization