I designed this interactive Customer Feedback Dashboard using Microsoft Power BI to help hospitality managers understand guest satisfaction trends and make informed service improvements.
This dashboard consolidates data into an engaging one-page report, making it easy for non-technical users to explore feedback patterns, Net Promoter Scores, and customer behavior with just a few clicks.
🎯 Project Objective
To visualize and analyze guest satisfaction data from a luxury hotel chain and provide quick insights into:
- Overall service ratings
- Purpose of visit breakdown
- Gender distribution
- NPS score and categories
- Source of information and marketing reach
- Feedback across various departments
🧠 Key Skills & Tools Used
- Microsoft Power BI
- DAX (Data Analysis Expressions)
- Data modeling and relationships
- Drill-downs and slicers
- Custom visual formatting and layout design
- UX/UI dashboard layout for non-technical users
📊 Dashboard Highlights
✅ Overall Rating & NPS
- Displayed an average rating of 3.6/5.0
- Calculated Net Promoter Score (NPS): 9.75
- Visual breakdown of Promoters, Passives, and Detractors
✅ Purpose of Visit & Gender Analysis
- Business trips dominate with 42.5% of visits
- Nearly even gender split analyzed through donut charts
✅ Feedback by Area
- Highest satisfaction in Staff interactions (14.6K responses)
- Lowest satisfaction in Restaurant services (9.5K responses)
✅ Marketing Source Analysis
- Most common source of information: Organizations
- Other sources: Hotel booking sites, word of mouth, search engine
✅ Trend Visualization
- Time-series trend of how visitors learned about the hotel over 30+ days
💡 Insights Gained
- Staff satisfaction is a strong area; restaurant service needs improvement
- Organizations and word-of-mouth remain powerful marketing channels
- Male and female travelers show consistent feedback trends
- Business travelers form the largest customer base
🌐 What This Project Shows
This dashboard demonstrates my ability to:
- Clean and structure real-world customer feedback data
- Build dynamic and visually engaging reports
- Translate complex feedback into clear, strategic insights
- Design dashboards for real-time decision-making