Hotel Feedback Dashboard

Hello Connections,

I am Alkesh Mohandas excited to share my latest Hotel Guest Feedback Dashboard in Power BI.

Database is**** in Excel which I got from learn Excel Solutions You Tube Channel Objective of Dashboard:

1.  To give Overall rating of the customer feedback in the range of 1 to 5.
   

2.  Calculate **NPS** which ranges between 1 to 10 where 10 means highest and 1 means lowest.
   

*Net Promoter Score(NPS) means chance of referring hotel services by customers to others.

3.  NPS Rating Scale is stated in the header of Dashboard. **NPS is calculated by subtracting Promoter score % - Detractors score %**
   

4.  Calculate aggregate rating in feedback category for different services like Staff, Room, Restaurant and facility with rating in the range of 1 to 5 where 5 is highest rating.
   

Process includes

1. Importing data few transformations and cleaning in power query

2. Identifying & Creating Measures using DAX.

3. Validating all data

4. Creating Dashboard using appropriate Visualization.

Attachment : Link to Dashboard & Guiding Video for usage of Dashboard

Key Metrics and various Charts which I have shown for presenting Overall rating, NPS Score and other information are:

1. Guest Count and Overall Rating
2. Guage chart for NPS Score and clustered bar chart categorizing Guest aggregate count into NPS Scale. Out of Total 1948 Guest 926 – Promoters, 523 – Passives, 499 – Detractors.
3. Donut Chart categorizing customers count into Purpose of visit and Gender.
4. Clustered column chart for calculating aggregate category wise Feedback rating.
5. Clustered bar chart categorizing Guest aggregate count into information they got about Hotel services and ribbon chart showing the same Quarter wise.
6. If we are hovering mouse over the ribbon chart, we can get count of customers in each source Quarter wise and changes in each quarter.

Only slicer used in the Dashboard is for date but we can filter the report as per requirement by clicking on any of the visuals in dashboard.

Now I will click slicer and visual to show how others visuals respond to the selection.

1.  Date range is changed to 6 months instead of 3 years due to which overall rating changes.
   

2.  Selecting “Detractors” in Clustered bar chart for total NPS Category Rating we can see how other visuals react.
   

3. Selecting “business” in Purpose of visit of Guest donut Chart and “Female” in Gender donut Chart

4. Selecting “Internet Advertisement” in Clustered bar chart and Quarterly Ribbon Chart.

5. We can also adjust the slider in Quarterly Ribbon Chart if we have checks details of selected quarters