Business Analyst Intern, OYO Hotels and Homes Pvt. Ltd.

• Fetched & analyzed the live property level booking data of 5 countries using R & SQL.
• Predicted and Dashboarded Channel wise Key Business Metrics (SRN, URN, GMV_USD, % Occupancy, ARR & RevPAR) on Hub level for Channel Performance Analysis.
• Tabulated real-time DoD key Business Metrics on Hub, Channel & Property level for enhanced data visibility & Revenue Performance Management.
• Exposure: R (Basics), Python, SQL, Google Sheets, Google Sheets API Handling

Please find the report here:

<aside> 📌 Enter Full Screen mode for better readability.

</aside>

https://docs.google.com/presentation/d/1MZGJFaEW4p4Db3v1kKVjIFTI-b2op35651NddGAjiwI/edit?usp=sharing