Migration & Analytics
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.
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.
<h5>AWS Service used</h5> AWS EC2, AWS S3, AWS Redshift, AWS QuickSight, Microsoft PowerBI
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: