About the Dataset
The TripAdvisor dataset contains reviews and ratings for various hotels across different continents. This dataset includes details such as user reviews, hotel ratings, traveler types, periods of stay, and more.
Data Transformation and Visualization
After loading the CSV file into Power BI, it was observed that the ratings were in whole numbers. To correct this, the data was transformed to display ratings as decimal numbers. Specifically, values like 45 and 35 were converted to 4.5 and 3.5 by editing the data directly in Power BI. The changes were then saved and applied.
Power BI Dashboard Overview
I have created a Power BI dashboard to visualize and analyze this dataset. The dashboard provides insights into various aspects of hotel reviews and user demographics. Here are some key features and analysis included in the dashboard:
Total Users by Continent:
Dynamic Radial Bar Chart to visualize the distribution of users across different continents.
Traveler Type:
Analysis of traveler types including couples, families, friends, business, and solo travelers.
Hotel Star Ratings:
Bar chart showing the count of hotels by star ratings, ranging from 3-star to 5-star hotels.
Users by Period of Stay:
Donut chart representing the distribution of users based on their period of stay throughout the year.
Hotels by Reviews:
Bar chart displaying the hotels with the highest number of reviews, highlighting popular hotels like Marriott’s Grand Chateau, Hilton Grand Vacations, and Excalibur Hotel & Casino.
Overall Statistics:
Total Hotels: 21
Average Score: 4.12
This dashboard provides a comprehensive and interactive way to explore and analyze hotel reviews on TripAdvisor, offering valuable insights into user preferences and hotel performance.
