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.
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:
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.