I cleaned and structured raw scraped hotel review data into a clear analysis-ready dataset. The process included organizing review text, ratings, dates and sources, preparing the file for sentiment classification, topic grouping, theme analysis and final reporting.
Services:
Data Cleaning, Customer Review Analysis, Sentiment Analysis, Excel Reporting
Tools:
Excel, AI-assisted review classification, Google Maps / Tripadvisor / Booking review data
0
4
Overview
I analyzed 1,906 raw customer reviews to identify what customers complain about and which areas the business should improve first.
Key Deliverables:
Theme & Sentiment Classification: Grouped text reviews into 13 key business themes and calculated the number of negative, neutral, and positive mentions for each category.
Data Visualization: Created charts showing the exact distribution of sentiment and a breakdown of negative reviews by volume to highlight the main operational priorities.
Priority Action Plan: Provided a structured table with recommended fixes and estimated business impact for every analyzed theme.
Business Value This report simplifies large amounts of text into clear charts and tables, allowing management to see their top operational risks and immediately prioritize maintenance and cleanliness updates.