scroll

Customer Name

Partner Name

We enabled Sapphire Food's to significantly decrease time-to-action by 43%, leveraging the power of Amazon Redshift and Amazon QuickSight to centralize and visualize their data

Challenge

INDUSTRY OVERVIEW

Sapphire Foods is one of the largest restaurant operators in the Indian subcontinent operating over 400 KFC, Pizza Hut and Taco Bell restaurants

The architecture in place, while currently serving well, is not in line with the rapid growth in data volume. They want to eliminate manually generated MIS reports and design automated, interactive decision boards to make full utilization of the huge dataset they possess and make informed decisions by dedicated analysis.

CHALLENGE

They wanted eliminate manually generated MIS reports and design automated, interactive decision boards that reduce the time to truth and improve actionability

Gaps in the current system:

  • Reports are manually generated, and they take quite longer to generate
  • User role specific automated triggers to get rapid insights and stay ahead of any anomalies
  • No single source of truth as the same KPIs are being captured across multiple reports

They wanted to cut costs and time spent to manually process the data and reduce the time to truth for taking informed decisions

The customer sought Ganit's help to create automated, interactive decision boards to track the KPIs and understand the trends and patterns for improving the actionability

Why were we brought in?

Ganit has made a significant dent in various industries using data science and analysis. Ganit partners with clients to translate their data into a tangible, insightful plan of action that delivers on a measurable impact to the clients’ topline & bottom-line growth.

Our approach

Methodology

Ganit proposed Sapphire to shift to AWS Quicksight for all their reporting needs to reduce the processing time and enhance the user experience by providing interactive dashboards

Data from all store POS systems is migrated every 15 minutes to the on prem central Headquarter SQL Server database.

The data from SQL server is migrated using batch jobs daily to AWS S3. The data is further cleaned and processed before loading to AWS Redshift.

There are various materialized data. The views are refreshed daily and connected to various QuickSight dashboards. The dashboards are used to calculate, track, and assess sales performance and other KPIs at monthly, weekly and daily levels.

An automated pipeline to deploy glue jobs & materialized views are developed in combination with AWS code commit & lambda functions.

Automated reports over email are configured on a weekly basis.

Technical Solution

Data from all Sapphire store POS systems is migrated every 15 minutes to the on prem central Headquarter SQL Server database. The data from SQL server is migrated using batch jobs daily to AWS S3. The data is further cleaned and processed before loading to AWS Redshift.

There are various materialized data. The views are refreshed daily and connected to various QuickSight dashboards. The dashboards are used to calculate, track, and assess sales performance and other KPIs at monthly, weekly and daily levels.

An automated pipeline to deploy glue jobs & materialized views are developed in combination with AWS code commit & lambda functions. Automated reports over email are configured on a weekly basis.

Features of the tool

  • Faster decision making; to cut overall costs and time spent.
  • Refined data is centrally located in the data warehouse.

A valuable difference

Impact

  • Automation has reduced the time to action and in taking strategic decisions
  • Combined cross-function KPIs, leading to higher cost savings through the prompt decision making
  • Automation of over 50+ reports that are consumed daily
  • 3 hours reduction in time taken for processing and loading of 1 TB of data
Success stories

See the impact that we make on our
cross-industry client base.

Top