Analytics Solution
For US Hotels
CLIENT & PROBLEM STATEMENT
- The client is a large Hotel Revenue Management Company.
- The underlying Hotel Clients were the US Hotel Franchisee comprising Hilton Marriott etc.
- Client wanted to replace manual MIS work and also provide insights on the reporting.
- They wanted to replace their manual reporting with an automated & smart solution.
APPROACH
- Integration of raw data and performing multiple transformation and mappings to create different reports.
- Customization and beautification of Reports.
- Send Email with NLP based insights as the data gets updated.
- Automating the whole process from integration to sending MIS as an email.
- Trend insights, performance insights, relationship insights based on different levels that gets generated automatically as the data is updated.
- The Client faced challenges integrating data from both their internal database (via CSV files) and external sources like OPERA.
- These datasets were combined based on room-nights and property locations. The manual process of generating management information system (MIS) reports was time-consuming and lacked real-time insights.
SOLUTION & OUTPUT
- The manual process of MIS was completely replaced by an automated solution on Cloud. G-Square installed its tool Narrator which now enables the Client to get automation of the MIS & Dashboarding for their various hotel property clients.
- The automated NLP based insights and analytics reports are sent through emails to the client twice a day.
- G-Square implemented their BI tool, Narrator, to automate the entire MIS process on the cloud.
- The solution provided real-time dashboarding and reporting for hotel property clients.
- High-velocity NLP-based insights and analytics reports were generated and sent to clients twice a day, significantly improving data integration and decision-making.