Tableau¶

Tableau provides business intelligence, analytics, and real-time operational dashboards.

Architecture Diagram¶

graph TB
    subgraph DATA_SOURCES["Data Sources"]
        SQL["SQL Server<br/>MainDB + Replicas"]
        MONGO["MongoDB<br/>Logs & Metrics"]
        API["API Metrics"]
    end

    subgraph TABLEAU["Tableau Server"]
        TAB["Tableau Server<br/>10.32.8.129<br/>Physical Dedicated"]
    end

    subgraph USERS["Dashboard Users"]
        MGMT["Management"]
        OPS["Operations Team"]
        SUPPORT["Support Team"]
    end

    SQL & MONGO & API --> TAB
    TAB --> MGMT & OPS & SUPPORT

    style TAB fill:#FFE4B5

Server Details¶

Setting	Value
Server IP	10.32.8.129
Server Type	Physical Dedicated
Purpose	BI, Analytics, Real-time Dashboards

Dashboards¶

Dashboard Type	Purpose
BI Dashboards	Business intelligence and reporting
Data Analytics	Advanced data analysis and visualization
Real-time Monitoring	Live operational dashboards
Booking Analytics	Booking trends and patterns
Supplier Performance	Supplier response times and success rates

Data Sources¶

graph LR
    SQL["SQL Server"] -->|"Bookings<br/>Agents<br/>Suppliers"| TAB["Tableau"]
    MONGO["MongoDB"] -->|"Logs<br/>Metrics"| TAB
    API["API Metrics"] -->|"Performance<br/>Volume"| TAB

    style TAB fill:#FFE4B5

Source	Data Type	Refresh
SQL Server	Bookings, Agents, Suppliers	Real-time / Scheduled
MongoDB	Logs, Performance Metrics	Scheduled
API Metrics	Request volumes, Response times	Real-time

Users¶

User Group	Dashboard Access
Management	Revenue, Growth, KPIs
Operations	Real-time monitoring, Alerts
Support	Booking issues, Agent activity
Technical	System performance, Error rates

Last Updated: 2025-12-02