Data Model

Entity Mapping

Entity	Source	Description	Count
CREDIT_CARD_HOLDER	Excel
CREDIT_CARD	Excel
STATEMENT	Excel
TRANSACTION	Excel

Analytical Data Model (ADM, aka "Star Schema")

erDiagram
    FactTransaction {
        id DWH_ID
        money AmountUSD
        code OriginalCurrency
    }

    DimCreditCard {
        str Number
        code Type "Visa, Mastercard, etc."
        str Holder 
    }

    DimCategory {
        code CategoryCode "Clothing, Travel, etc."
    }

    DimCalendar {
        date Date
    }

    DimMerchant {
        str Name
        str City
        int ZipCode
        code Country
    }

    FactTransaction }o--|| DimCreditCard: refs
    FactTransaction }o--|| DimCategory: refs
    FactTransaction }o--|| DimCalendar: PurchaseDate
    FactTransaction }o--|| DimMerchant: refs