Data to Decision automation with Customised BI Dashboard for Hotel Consulting Company
Client , a hospitality consulting firm based in Bangalore offers specialized services to Hotel Owners / Investors across the Asia Pacific region. The firm has been advising, assisting and nurturing a vast portfolio of clients in its two decade existence.
A team of hoteliers with combined experience of 120 years across varied hospitality verticals provides focused, empathetic and innovative approach to its customers.However lacked in providing a holistic view of the asset to its customer due to absence of accurate usable data.
When the client came to Revnomix they had a specific requirement to develop Custom Business Intelligence (BI) platform .For the client to deliver their Scope it is important to have control on the data . Our Goal was to design and develop state of the art Business Intelligence platform for the Client to assist them in Asset Management .The client should be in a position to explain the hotel owner his hotel’s profitability ,performance and position.
The lack of appropriate Data & Standardization on System Set Up resulted in Complex data condition proved to be a hindrance in capturing systematic data.
Multiple Systems, Reports & Data Sources affecting the consolidation & Correlation.
Since the client had no access to the hotel Systems, we have to use the Hotel Generated MIS data sheets presented in Excel.
The excel workbooks were processed using ETL programs developed in Python to convert them into BI consumable format.
The data from DRR, P&L, Rate Shop and STR were consolidated into one database.
The Power BI is used to develop the Visual Analytics
The solution was completely custom built for the client.
The reporting is completely designed on Power BI
The App feature of Power BI is used for distribution of solutions
There are 5 different modules custom developed
The team at Revnomix Solutions have deonstrated both ingenuity and determination in their efforts to develop bespoke BI Tools for us. Going forward, we look forward to their continued support in sustaining and upgrading these tools in the years to come.
