Menu Icon Close
CASE STUDY

BluePi Helped a Leading F&B Client Migrate to AWS Redshift

The Client

The client provides world-class catering and support services, including extensive Facility Management expertise to its clients, in a wide variety of sectors and market places.

Business Problem:

Given their scale of operations, the client’s data team had to do a lot of analytics and reporting, on a daily basis. There was a considerable amount of manual effort involved in taking a daily dump from SAP, uploading the data on Excel, processing and presenting them in the form of specific reports to the middle management. In addition to being time-consuming, the reports were not crisp enough or flexible enough as well. Their Middle Management team wanted crisp reports with neat visualizations, providing better insights.

BluePi’s Solution:

    1. BluePi migrated their entire data from SAP HANA to AWS Redshift
    2. Built robust reports with crisp visualizations using PowerBI.

Technologies Involved:

AWS EC2, AWS S3, AWS Redshift, AWS QuickSight, Microsoft PowerBI

Process:

    1. Understand use cases and define dimensional model
    2. Extract data from SAP HANA – including data already there, along with data being added daily
    3. Transform data into the right dimensional model
    4. Load the dimensional model data onto AWS Redshift
    5. Aggregate data and create reports with visualizations
    6. Support the testing process carried out by the client

case study image

Reports Built:

One of the main uses cases was for the procurement team which wanted to generate a report of Purchase Requisitions (PRs) for which Purchase Orders (POs) haven’t been raised yet. This had to be segmented across the following dimensions: Region, Site, Type, Date, Reason and Age. BluePi automated the entire process, ensuring that these dimensions were captured and presented in the form of relevant visualizations like the ones below:

f&b2 image

Value Added:

    1. BluePi Eliminated the manual effort involved and drastically reduced the time invested by skilled resources in creating these reports
    2. The visualizations were way better, which enabled Middle Management to derive better insights
    3. The reports are now available on request, while earlier, they had to wait for the daily reports
    4. Sharing the reports across the organization and setting up custom dash boards are a whole lot easier

The client was happy with the end-to-end service provided by BluePi and wanted to replicate the success in creating such reports and visualizations for other Business Units as well.

Company
F&B
Location
India
Segment
Catering
Solution
Migration & Analytics

Invest in better
solutions today

Contact Us