# talhaid/airbnb-tableau-dashboard architecture

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

- Interactive diagram: https://gitdiagram.com/talhaid/airbnb-tableau-dashboard
- Repository: https://github.com/talhaid/airbnb-tableau-dashboard

## Overview

##### Project type and purpose (from file tree + README)
This repo is **not a codebase** in the traditional sense; it’s a **BI / analytics visualization project** centered around a **Tableau Packaged Workbook**:

- **`Airbnb Full Project.twbx`** → a Tableau “packaged workbook” that typically contains:
- the workbook (`.twb`) definition (dashboards, worksheets, calculations, parameters)
- embedded data extracts (`.hyper` / legacy `.tde`) or embedded source files (CSV/Excel) if included
- images/assets used in the workbook
- **README** describes the business goal: an **interactive dashboard** on Seattle Airbnb data to support **pricing strategy, revenue optimization, and booking decisions** via:
- By ZIP code
- time series revenue trends
- price vs bedroom count
- filters + calculated fields

##### What the file structure implies architecturally
Because the repo contains essentially a single `.twbx` plus a README:
- The **Tableau workbook is the system**.
- The “components” are mostly **inside** the TWBX: data connections, extract(s), calculations, sheets, dashboards, and published destination (Tableau Public).

##### README-derived architectural signals
- **Map Visualization** → Geographic dimension by ZIP code
- **Dashboard Filters** → interactive controls impacting queries and views
- **Time Series Analysis** → date dimension driving revenue trend calculations
- **Calculated Fields** → Tableau semantic layer logic (e.g., AVG price, revenue aggregates, seasonal slices)
- **Tableau Public** → publishing / hosting layer for consumers

##### End Users / Stakeholders
- Hosts, analysts, decision makers (consumers of dashboard)

##### Distribution / Hosting
- **Tableau Public** (or Tableau Server if that’s what you used—README says Public)

##### Visualization Application
- **Tableau Workbook (TWBX)** as the application container

##### Dashboard Layer
- “Seattle Airbnb Data Dashboard” (the assembled dashboard)
- Interactive objects: filters, parameters, actions (if any)

##### Worksheet Layer (Views)
- “Avg Price by Zip Code (Map)”
- “Revenue Over Time (Time Series)”
- any supporting sheets (KPIs, legends, tooltips sheets)

##### Semantic/Logic Layer
- Calculated fields (e.g., Avg Price, Revenue, Availability metrics)
- Date logic for seasonality (if implemented)
- Aggregation level definitions (ZIP, bedroom, date)

##### Data Model Layer (Tableau Data Source)
- logical tables / relationships (if using Tableau Relationships)
- joins/unions (if using physical layer)
- extracted vs live connection mode

##### Storage / Data Source
- “Seattle Airbnb dataset”
- As:
- **Embedded extract inside TWBX** (common) *or*
- **External file/db** (if connected live)

##### Refresh / Update Mechanism (if relevant)
- Manual refresh (Tableau Desktop republish)
- Scheduled refresh (less likely on Tableau Public, but can be approximated)

##### Build/Publish flow (authoring lifecycle)
- Data Source → Tableau Desktop authoring → TWBX → Publish to Tableau Public

##### Runtime interaction flow (viewer lifecycle)
- User → Tableau Public dashboard → filter selections trigger queries/aggregations → worksheets update → dashboard renders updated visuals

Filter actions explicitly:
- Filters/parameters → affect **data queries** and **calculated fields** → update charts/map/time series

##### Architectural patterns / principles used
For Tableau dashboards, the key “architecture” patterns are:

- **Layered analytics architecture**
- Source → model → logic → views → dashboard → consumers
- **Semantic layer inside Tableau**
- calculated fields + aggregation rules are part of your “business logic”
- **Interactive query-driven rendering**
- user interactions drive recomputation of aggregates/marks

##### Relevant technologies and their roles
Technology labels directly on components:
- Tableau Public (hosting)
- Tableau Desktop (authoring tool—if used to create TWBX)
- TWBX (packaging format)
- Data extract type if known (`.hyper`)
- /Geo (ZIP code geocoding in Tableau)

To make it principal-engineer grade and unambiguous:

##### Labels
- Use precise names: “Avg Price by Zip (Worksheet)”, “Revenue Trend (Worksheet)”

##### Users (view + interact)

A top lane for “Authoring/Publishing”:
- Tableau Desktop → creates/updates TWBX → publishes to Tableau Public

## Diagram (Mermaid)

```mermaid
flowchart TD

%% =========================
%% External / Stakeholders
%% =========================
U["EndUsers/Stakeholders\n(Hosts,Analysts,DecisionMakers)"]:::external
TP["TableauPublic\n(Hosting/Distribution)"]:::external
TDESK["TableauDesktop\n(Authoring/Refresh/Publish)"]:::tool

%% =========================
%% Tableau Workbook Container (TWBX)
%% =========================
subgraph "TableauWorkbookContainer (Packaged Workbook)"
  TWBX["TableauWorkbook (TWBX)\n\"Airbnb Full Project\""]:::tableau

  subgraph "DashboardLayer"
    DASH["SeattleAirbnbDataDashboard\n(Layout+Story)"]:::dash
    FILT["InteractiveControls\n(Filters/Parameters/Actions)"]:::interaction
  end

  subgraph "WorksheetLayer (Views)"
    W_MAP["AvgPriceByZipCode\n(MapWorksheet)"]:::sheet
    W_TS["RevenueOverTime\n(TimeSeriesWorksheet)"]:::sheet
    W_BED["PriceVsBedroomCount\n(Worksheet)"]:::sheet
    W_SUP["SupportingSheets\n(KPIs/Legends/Tooltips)"]:::sheet
  end

  subgraph "SemanticLogicLayer"
    CALC["CalculatedFields/Metrics\n(AvgPrice,Revenue,Availability,...)"]:::logic
    DATELOGIC["DateLogic\n(Trends/Seasonality/Slices)"]:::logic
    AGG["AggregationRules/LOD\n(ByZIP,ByDate,ByBedrooms)"]:::logic
  end

  subgraph "DataModelLayer (TableauDataSource)"
    DS["TableauDataSource\n(Relationships/Joins/Unions)\n(ExtractOrLiveSettings)"]:::model
  end

  subgraph "StorageDataSourceLayer"
    SRC[("SeattleAirbnbDataset\n(EmbeddedExtractOrExternalSource)\n(e.g., .hyper/CSV/Excel/DB)")]:::data
  end
end

DOC["ProjectDocumentation\n(Goals,RequiredViews,Interactivity)"]:::doc

%% =========================
%% Runtime (Viewer Lifecycle)
%% =========================
U -.->|"opens/uses"| TP
TP -->|"renders/serves"| DASH
U -.->|"selects_filters"| FILT
FILT -->|"drives_queries"| DS
DS -->|"applies_model"| CALC
CALC -->|"computes_metrics"| AGG
DATELOGIC -->|"time_slicing"| CALC

%% View updates (recompute -> worksheets -> dashboard)
DS -->|"returns_data"| W_MAP
DS -->|"returns_data"| W_TS
DS -->|"returns_data"| W_BED
DS -->|"returns_data"| W_SUP

CALC -->|"applies_to_marks"| W_MAP
CALC -->|"applies_to_marks"| W_TS
CALC -->|"applies_to_marks"| W_BED
CALC -->|"applies_to_marks"| W_SUP

W_MAP -->|"composes"| DASH
W_TS -->|"composes"| DASH
W_BED -->|"composes"| DASH
W_SUP -->|"supports"| DASH

%% =========================
%% Authoring / Publish Lifecycle
%% =========================
SRC -->|"connect/extract"| DS
TDESK -->|"authors"| TWBX
DS -->|"data_connection"| TWBX
CALC -->|"defined_in"| TWBX
W_MAP -->|"built_in"| TWBX
W_TS -->|"built_in"| TWBX
W_BED -->|"built_in"| TWBX
DASH -->|"assembled_in"| TWBX
TDESK -->|"publish"| TP
TWBX -->|"package/deploy"| TP

%% Documentation influence
DOC -.->|"requirements"| DASH
DOC -.->|"required_views"| W_MAP
DOC -.->|"required_views"| W_TS
DOC -.->|"required_views"| W_BED

%% =========================
%% Click Events (component_mapping)
%% =========================
click TWBX "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click DASH "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click FILT "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click W_MAP "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click W_TS "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click W_BED "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click W_SUP "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click CALC "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click DATELOGIC "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click AGG "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click DS "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click SRC "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/Airbnb Full Project.twbx"
click DOC "https://github.com/talhaid/airbnb-tableau-dashboard/blob/main/README.md"

%% =========================
%% Styles
%% =========================
classDef external fill:#ECEFF4,stroke:#4C566A,stroke-width:1.5px,color:#2E3440;
classDef tool fill:#E5E9F0,stroke:#5E81AC,stroke-width:1.5px,color:#2E3440;

classDef tableau fill:#D6EFFF,stroke:#2B6CB0,stroke-width:2px,color:#102A43;
classDef dash fill:#BEE3F8,stroke:#2C5282,stroke-width:2px,color:#102A43;
classDef sheet fill:#C3DAFE,stroke:#2B6CB0,stroke-width:1.5px,color:#102A43;

classDef interaction fill:#FEEBC8,stroke:#C05621,stroke-width:2px,color:#7B341E;
classDef logic fill:#E9D8FD,stroke:#6B46C1,stroke-width:1.5px,color:#2D1B69;
classDef model fill:#D3F9D8,stroke:#2F855A,stroke-width:1.5px,color:#102A43;
classDef data fill:#B7F5C6,stroke:#2F855A,stroke-width:2px,color:#0B3D2E;

classDef doc fill:#FFF3BF,stroke:#B7791F,stroke-width:1.5px,color:#5C3D0E;
```
