Customer Name
Partner Name
Customer Name
Partner Name
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.
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:
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
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.
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.
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.
See the impact that we make on our
cross-industry client base.
Top
