# deepakns021/hospitality-analytics-dashboard architecture

> Architecture diagram of the GitHub repository deepakns021/hospitality-analytics-dashboard, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-28). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/deepakns021/hospitality-analytics-dashboard
- Repository: https://github.com/deepakns021/hospitality-analytics-dashboard

## Overview

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`](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix) (DAX measures), [`data/reviews_and_feedback.xlsx`](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/data/reviews_and_feedback.xlsx) (Customer dataset)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_excel["Customer dataset"]
  node_powerquery["Power Query prep<br/>[dashboard.pbix]"]
end

subgraph group_model["Analytics model"]
  node_measures["DAX measures<br/>[dashboard.pbix]"]
end

subgraph group_report["Interactive report"]
  node_overview["Executive overview<br/>[dashboard.pbix]"]
  node_reviews["Review analytics<br/>[dashboard.pbix]"]
  node_regional["Pricing and regional<br/>[dashboard.pbix]"]
  node_slicers["Shared slicers<br/>[dashboard.pbix]"]
end

node_analyst(("Analyst"))
node_powerbi["Power BI Desktop"]

node_analyst -->|"opens report"| node_powerbi
node_powerbi -->|"renders"| node_overview
node_excel -->|"loads data"| node_powerquery
node_powerquery -->|"prepares model data"| node_measures
node_measures -->|"supplies metrics"| node_overview
node_measures -->|"supplies metrics"| node_reviews
node_measures -->|"supplies metrics"| node_regional
node_slicers -->|"filters"| node_overview
node_slicers -->|"filters"| node_reviews
node_slicers -->|"filters"| node_regional

click node_excel "https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/data/reviews_and_feedback.xlsx"
click node_powerquery "https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix"
click node_measures "https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix"
click node_overview "https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix"
click node_reviews "https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix"
click node_regional "https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix"
click node_slicers "https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_excel,node_powerquery toneBlue
class node_measures toneAmber
class node_overview,node_reviews,node_regional,node_slicers toneMint
class node_analyst,node_powerbi toneIndigo
```

## Components

### Data preparation

- [Customer dataset](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/data/reviews_and_feedback.xlsx): `data/reviews_and_feedback.xlsx`
- [Power Query prep](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix): `dashboard.pbix`

### Analytics model

- [DAX measures](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix): `dashboard.pbix`

### Interactive report

- [Executive overview](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix): `dashboard.pbix`
- [Review analytics](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix): `dashboard.pbix`
- [Pricing and regional](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix): `dashboard.pbix`
- [Shared slicers](https://github.com/deepakns021/hospitality-analytics-dashboard/blob/main/dashboard.pbix): `dashboard.pbix`

### Other components

- **Analyst**
- **Power BI Desktop**

## Connections

- 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