flowchart TD
    subgraph ClientLayer["Client Layer (Browser Runtime)"]
        A["User Upload (.xlsx / .csv)"] --> B["IFileParser (SheetJS Engine)"]
        B --> C["Resilient Normalizer & Header Mapper"]
        C --> D["Domain Entities (NormalizedOrder[])"]
        D --> E["IStorageService (IndexedDB Cache)"]
    end

subgraph ServiceLayer["Domain & Service Layer (IoC Container)"]
    E --> F["Dependency Injection Container"]
    F --> G1["ExecutiveService"]
    F --> G2["FinanceService"]
    F --> G3["InventoryService"]
    F --> G4["OperationsService"]
    F --> G5["MarketingService"]
    F --> G6["CreativeService"]
    F --> G7["AdminDataQualityService"]
    F --> G8["CompareService"]
end

subgraph PresentationLayer["Presentation Layer (Obsidian UI)"]
    G1 & G2 & G3 & G4 & G5 & G6 & G7 & G8 --> H["React Context Providers"]
    H --> I["Departmental View Controllers"]
    I --> J["Interactive Visualizations & Drill-Downs"]
end

flowchart LR
    A["Raw Workbook Buffer"] --> B["Workbook Sheet Discovery"]
    B --> C["Header Fuzzy Normalization"]
    C --> D["Value Sanitization & Type Coercion"]
    D --> E["Compound Bundle Splitting"]
    E --> F["Flag & Anomaly Tagging"]
    F --> G["NormalizedOrder Schema"]

subgraph NormalizationLogic["Transformation Rules"]
    C -.- C1["Case & whitespace agnostic regex matching"]
    D -.- D1["Excel serial date to ISO UTC conversion"]
    E -.- E1["Extracts individual bottles from Discovery/Trio sets"]
    F -.- F1["Identifies $0 test orders, missing emails, spike quantities"]
end

sequenceDiagram
    autonumber
    actor User as Operator
    participant UI as Dashboard UI
    participant Parser as File Parser (SheetJS)
    participant Normalizer as Schema Normalizer
    participant Storage as IndexedDB Storage
    participant DI as IoC Container
    participant Services as Domain Services

User->>UI: Selects .xlsx / .csv file
UI->>Parser: Passes ArrayBuffer
Parser->>Normalizer: Streams raw sheet records
Normalizer->>Normalizer: Resolves dynamic column mappings
Normalizer->>Normalizer: Extracts category yields & anomalies
Normalizer-->>Storage: Persists NormalizedDataset
Normalizer-->>DI: Injects Active Dataset State
DI->>Services: Trigger reactive metric calculation
Services-->>UI: Dispatches aggregated view models
UI-->>User: Renders Obsidian dashboards with 0ms server latency

classDiagram
    class IFileParser {
        <<interface>>
        +parse(file: File): PromiseNormalizedOrder[]
    }

class IStorageService {
    &lt;&lt;interface&gt;&gt;
    +saveDataset(dataset: Dataset): Promise~void~
    +getDatasets(): Promise~Dataset[]~
    +deleteDataset(id: string): Promise~void~
}

class ServiceContainer {
    +financeService: FinanceService
    +executiveService: ExecutiveService
    +inventoryService: InventoryService
    +operationsService: OperationsService
    +marketingService: MarketingService
    +creativeService: CreativeService
    +adminService: AdminDataQualityService
    +compareService: CompareService
}

class DataProvider {
    +activeDataset: Dataset
    +filteredOrders: NormalizedOrder[]
    +setFilter(filter: FilterState): void
}

ServiceContainer --&gt; FinanceService
ServiceContainer --&gt; ExecutiveService
ServiceContainer --&gt; InventoryService
ServiceContainer --&gt; OperationsService
ServiceContainer --&gt; MarketingService
DataProvider ..&gt; ServiceContainer : Consumes via Context
IFileParser &lt;|.. XlsxParser
IStorageService &lt;|.. IndexedDbStorage

flowchart TD
    subgraph GitRepository["Git Repository"]
        A["Push to main branch"] --> B["GitHub Actions Triggered"]
    end

subgraph CIWorkflow["CI / CD Pipeline"]
    B --> C["Setup Node.js Runtime"]
    C --> D["npm ci (Deterministic Dependency Tree)"]
    D --> E["tsc --noEmit (Type Integrity Validation)"]
    E --> F["vite build (Production Minification)"]
    F --> G["Upload Artifact (dist/)"]
end

subgraph HostingInfrastructure["Edge Hosting"]
    G --> H["Deploy to GitHub Pages Environment"]
    H --> I["Public Release (HTTPS / Global CDN)"]
end