ban 202 project

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.

WRITE MY PAPER

Comments

Leave a Reply