This project is part of data analytics bootcamp at codebasics
Atliq Grands, a well-established entity in India's hotel industry, is currently facing competition and a decline in revenue. To address these issues,the management team has chosen to leverage data and strategic insights. Lacking internal data expertise,they have enlisted external assistance to analyze the situation,provide actionable insights, and devise effective strategies for customer retention and revenue growth.
The goal of this project is to conduct a comprehensive analysis of the hotel domain using Python. By employing data-driven insights and strategic recommendations, my aim is to empower Atliq Grands to make informed decisions and regain a competitive edge in the industry.
- Data Cleaning- Handling missing values and outliers.
- Data Transformation - Added occupancy% columns.
- Insights generation-key questions answered
- calculating average occupaancy rate by room type and city.
- Identifying occupancy rate on weekdays and weekends.
- Analyzing revenue generated per city.
- Analyzing monthly revenue trends.
- Assessing revenue by booking platforms.
- Python Programming: Enhancing proficiency in Python for data analysis,cleaning ,transforamtion and visualization.
- Data Viusualization: Leveraged Matplotlib library for creating charts and bars.
- Pandas Fundamentals: creating various dataframes,group by functions,concate and merging,hanling NA values,read csv files etc.