How deepakns021/hospitality-analytics-dashboard works
This repository is a Power BI hospitality analytics product: an analyst explores customer feedback, pricing, and regional performance in an interactive report backed by the Excel dataset. The documented workflow prepares the data in Power Query, defines DAX measures, and presents results across three report pages with shared slicers. The README describes the model and report capabilities, but no source excerpts expose the PBIX internals, so links between these documented stages are shown only at that level.
Main entry points: dashboard.pbix DAX measures · reviews_and_feedback.xlsx Customer dataset
Components 9
Data preparation
- Customer dataset
data/reviews_and_feedback.xlsx - Power Query prep
dashboard.pbix
Analytics model
- DAX measures
dashboard.pbix
Interactive report
- Executive overview
dashboard.pbix - Review analytics
dashboard.pbix - Pricing and regional
dashboard.pbix - Shared slicers
dashboard.pbix
Other components
- Analyst
- Power BI Desktop
Connections 10
- Analyst → Power BI Desktop: opens report
- Power BI Desktop → Executive overview: renders
- Customer dataset → Power Query prep: loads data
- Power Query prep → DAX measures: prepares model data
- DAX measures → Executive overview: supplies metrics
- DAX measures → Review analytics: supplies metrics
- DAX measures → Pricing and regional: supplies metrics
- Shared slicers → Executive overview: filters
- Shared slicers → Review analytics: filters
- Shared slicers → Pricing and regional: filters