We offer a range of services right from Business Intelligence to Remote services. In today’s world, where time is money, we are proud of the fact that we always rise up to the various business challenges in a timely & cost effective manner. 

Quick Service Restaurants
Pharmaceutical Business Intelligence
NutriGenomics Data Warehouse
Manufacturing & Supply Chain Data Warehouse
Lifesciences Quality and Regulatory Compliance Reporting
Dunkin's Brands

Quick Service Restaurants(QSR) Data Warehouse


The following is a case study of the Data Warehouse implementation at a leading Quick Service Restaurant (QSR) Company that is a leader in the breakfast category.

Business Need

The Company had multiple Point of Sale (POS) data capture environments that provided only 45 days of detail transactional history for reporting and analytic purposes. Additional data was available at aggregated levels that were not really helpful.

There was no ability to correlate between transactional detail and Franchisee reporting and to validate if the numbers are correct to articulate Loss Prevention.

The time to deliver any meaningful reporting to executives was time consuming and cumbersome and in some cases after the need had passed.

Business Value

The Business Intelligence System has helped The Company in the following manner:

  • Evaluate Coupon redemptions by store by product.
  • Evaluate How purchases are paid for and what products do they mostly sell.
  • Compare Franchisee reporting with POS transactional detail to aid in Loss Prevention.
  • Evaluate performance of a multi-brand model for a given store location.
  • Evaluate new product performance in test markets.
  • Develop Forecast Models.
  • Establish Budget criterion.
  • Aid in overall Corporate Performance evaluation.
  • Evaluate Same Store Sales Year over Year.
  • Evaluate Average Ticket across a store over time.
  • Evaluate Average Customer Count across a store over time.
  • Evaluate buying patterns at a half hour interval by store to aid Field Sales coordinate with Franchisee on staffing and product logistics.
  Follow Mercury on Follow wearemercury on Twitter