Project Instructions
You are provided with the data set attached, and you are required to:
- Data Cleaning and Preprocessing using Excel- Handle missing values, duplicates, and outliers, standardize hotel names, room types, and booking channels.
- Data Analysis & Summary using Excel – Identify peak booking periods, analyze guest demographics and spending, and detect correlations between promotions and booking volume.
- Data Visualization & Dashboard using Power BI – Occupancy rates, revenue per room, guest satisfaction, and booking source performance (website, travel agents, OTAs).
- Business Report & Recommendations on Word document – Findings, challenges, and actionable recommendations.
- Presentation – 10-minute summary with key charts and recommendations.
Leave a Reply
You must be logged in to post a comment.