Disclaimer: Independent educational project. Not affiliated with JPMorgan Chase. Built by Kaushal Khodifad. Data from public sources; figures are estimates.return to portfolio
Disclaimer: Independent educational project. Not affiliated with JPMorgan Chase.
SilverInternal
99.8

Merchant & MCC Dimension

merchant_mcc_dim · Merchant

Conformed merchant dimension with 4-digit MCC, category description, risk tier, and card-not-present flag.

Owner
Merchant D&A
SLA / freshness
Weekly
Rows
~500
Backing table
atlas.merchants

Data contract

3 fields
fieldtypesensitivityquality ruleallowed rolespurpose
mcctext-4-digitall-
risk_tiertext-in (low, medium, high)all-
is_card_not_presentboolean-not nullall-

Lineage

Merchant & MCC DimensionCard Transactions (Gold)Enrich with merchant + MCC attributes
entitlement-scoped preview ·
preview asmasked
No rows returned for this entitlement context.

↑ Independent educational project by Kaushal Khodifad. JPMorgan Chase is a real company in the card data & analytics space; this design and the underlying prototype were built by Kaushal as a portfolio study. Not affiliated with, endorsed by, or representative of JPMorgan Chase's actual product. Data is from public sources. Figures are estimates.

Return to portfolioOpen the live demo