Template catalog · 173+ models

Don't start from a blank canvas. Start from a warehouse.

Every template is a complete, validated data model — entities, attributes, keys, PII tags, SCDs, and relationships already wired. Open a fully-populated ERD and generate DDL plus a dbt project in one click. 173+ models in the catalog; 27 representative picks below.

Kimball

Star schemas with conformed dimensions and fact grains for analytics. Built for BI tools, semantic layers, and metric-store integration.

templates

Data Vault 2.0

Hubs, links, and satellites with hash keys for enterprise warehouses. Designed for parallel loads, full source-of-truth lineage, and SCD by construction.

templates

3NF

Normalized relational models that mirror source-system schemas. Faithful to OLTP / ERP / EHR transactional structures for landing and replay.

templates

Kimball

Star schemas for analytics

Star schemas with conformed dimensions and fact grains for analytics. Built for BI tools, semantic layers, and metric-store integration.

in catalog

KimballBanking
Core Banking Analytics
Retail banking analytics covering customer accounts, ledger transactions, daily balance snapshots, loan lifecycle, and card authorizations.
14
entities
132
attributes
18
relationships
Show details
What's inside
Transaction-grain ledger fact with conformed customer/account/branch dimensions
Daily account-balance snapshot fact (semi-additive, regulatory-ready)
Accumulating loan-lifecycle snapshot from origination to payoff
Card authorization fact with merchant + fraud-flag attributes
Masking strategy on tax ID, account number, and KYC fields
Subject areas
transactionsbalanceslendingconformed_dimensions
Compliance / regulatory
PCI-DSSSOXGLBA
KimballSaaS
SaaS Subscription Analytics
B2B SaaS analytics: subscriptions, usage events, billing, and conversion. SCD2 customer + plan dimensions with metered usage rollups.
12
entities
98
attributes
14
relationships
Show details
What's inside
Usage event fact at API-call grain with derived monthly rollups
SCD2 customer dimension for plan-change history
Accumulating subscription-lifecycle snapshot
MRR / ARR / churn metric-ready model with cohort grain
Invoice line fact derived from usage rollup + plan unit price
Subject areas
subscriptionsusagebillingconformed_dimensions
KimballHealthcare
Healthcare Claims Analytics
Provider-side healthcare claims analytics: member enrollments, medical and Rx claims, diagnoses, providers, and procedures.
16
entities
145
attributes
22
relationships
Show details
What's inside
Claim-line-grain medical + Rx fact tables
Diagnosis + procedure code dimensions (ICD-10, CPT)
Member enrollment-span fact with eligibility periods
PHI separation with masking on member name, DOB, SSN
Conformed provider dimension across medical/Rx claims
Subject areas
medical_claimsrx_claimsenrollmentconformed_dimensions
Compliance / regulatory
HIPAAHITRUST
KimballRetail
Retail & E-commerce Analytics
End-to-end retail analytics: orders, line items, products with variants, inventory by warehouse, returns, and marketing attribution.
18
entities
160
attributes
24
relationships
Show details
What's inside
Order-line-grain sales fact with product + variant dimensions
Daily inventory-snapshot fact per SKU / warehouse
Returns fact linked back to original order line
Customer SCD2 dimension capturing loyalty tier history
Marketing attribution channel + campaign dimensions
Subject areas
salesinventoryreturnsmarketing
KimballInsurance
P&C Insurance Analytics
Property & casualty insurance analytics: policies, premiums, claims, losses, reserves, and reinsurance cessions.
15
entities
138
attributes
20
relationships
Show details
What's inside
Written / earned premium fact at policy-month grain
Loss claim accumulating snapshot from FNOL to closure
Reserve estimate fact by valuation date
Conformed policy / coverage / peril / insured dimensions
Reinsurance cession bridge for ceded premium and recoveries
Subject areas
policiespremiumsclaimsreserves
Compliance / regulatory
SOXNAIC
KimballMarketing
Marketing & Web Analytics
Multi-touch marketing and web analytics: sessions, page views, campaigns, conversions, and attribution across paid, organic, and owned channels.
13
entities
105
attributes
16
relationships
Show details
What's inside
Session-grain web fact with page-view detail fact
Campaign + channel + source/medium dimensions (UTM-aware)
Conversion event fact with goal-completion attribution
Multi-touch attribution bridge fact (first / last / linear / time-decay)
Cohort-ready visitor dimension with SCD2 acquisition channel
Subject areas
sessionspage_viewsconversionsattribution
KimballCapital Markets
Capital Markets Trading
Trading desk analytics: orders, executions, positions, settlement, P&L, and corporate actions across equities and fixed income.
17
entities
152
attributes
23
relationships
Show details
What's inside
Order + execution facts at tick grain with venue + counterparty dims
EOD position snapshot fact with P&L decomposition
Settlement / failed-trade accumulating snapshot
Corporate actions dimension (dividends, splits, M&A) and price adjustments
Instrument SCD2 dimension capturing reference-data history
Subject areas
orderspositionssettlementreference_data
Compliance / regulatory
SOXMiFID IIReg-SCI
KimballBanking · Lending
Mortgage Lending Analytics
Mortgage origination through servicing: applications, underwriting, funding, escrow, delinquency, and HMDA reporting.
14
entities
128
attributes
19
relationships
Show details
What's inside
Application accumulating snapshot from inquiry to closing
Loan-month servicing fact with delinquency bucket dim
Escrow disbursement + insurance / tax event facts
HMDA-ready borrower dimension with protected-class attributes
Foreclosure pipeline accumulating snapshot
Subject areas
originationservicingdelinquencyhmda_reporting
Compliance / regulatory
HMDATILA / RESPACFPB
KimballBanking · Compliance
AML / KYC Monitoring
Anti-money-laundering and KYC analytics: customer due diligence, transaction monitoring, alerts, case management, and SAR filings.
13
entities
118
attributes
17
relationships
Show details
What's inside
Transaction-monitoring alert fact with rule + scenario dimensions
Case-lifecycle accumulating snapshot from alert to SAR / dismissal
Sanctions / watchlist screening hit fact
KYC refresh-due dimension for CDD periodic review
Beneficial-owner bridge for complex entity relationships
Subject areas
screeningalertscasessar_filings
Compliance / regulatory
BSAFinCENOFACFATF
KimballSales · CRM
Sales Pipeline Analytics
Sales pipeline analytics modelled on the CRM funnel: leads, opportunities, stage transitions, forecasts, and rep activity.
12
entities
96
attributes
15
relationships
Show details
What's inside
Opportunity accumulating snapshot through stage history
Daily pipeline snapshot for weighted forecast and slippage
Lead → opportunity conversion fact with attribution
Activity fact (calls / emails / meetings) per rep + opportunity
Quota-attainment monthly snapshot per rep
Subject areas
leadsopportunitiesforecastactivity
KimballRetail · Supply Chain
Inventory Analytics
Multi-location inventory analytics: daily on-hand snapshot, receipts, shipments, transfers, and stock-out events.
11
entities
88
attributes
13
relationships
Show details
What's inside
Daily inventory-snapshot fact per SKU / location
Receipt + shipment + transfer movement facts
Stock-out event fact with lost-sale dollar estimate
ABC / XYZ classification dimension for stocking policy
Cycle-count adjustment fact for shrinkage analysis
Subject areas
on_handmovementsstockouts
KimballHospitality
Hospitality / Hotel Analytics
Hotel revenue and operations analytics: reservations, stays, ADR / RevPAR, channels, and ancillary spend.
13
entities
102
attributes
16
relationships
Show details
What's inside
Stay-night-grain fact for ADR / RevPAR / occupancy
Reservation booking accumulating snapshot
Channel mix + rate plan dimensions
Ancillary spend fact (F&B, spa, parking) per stay
Loyalty member SCD2 dimension capturing tier history
Subject areas
staysreservationsancillaryloyalty
KimballAsset Management
Investment Management Analytics (Aladdin-style)
Buy-side risk, performance, and compliance analytics modeled on the BlackRock Aladdin (BRS AM) capability set: IBOR/ABOR snapshots, VaR and attribution, financing, ESG, and guideline monitoring over conformed investment dimensions.
39
entities
349
attributes
90
relationships
Show details
What's inside
IBOR position + ABOR holding daily snapshot facts that reconcile
Risk marts: exposures, greeks/duration sensitivities, VaR with component contributions, stress
Performance: returns, Brinson + multi-factor attribution, GIPS composite returns
Financing marts: securities lending, collateral inventory, margin calls
Portfolio ESG / carbon snapshot and pre/post-trade compliance breaches
Subject areas
positionstrading_and_cashfinancingriskperformanceesgcompliance
Compliance / regulatory
MiFID IIDodd-FrankEMIRSOXGIPSSFDR

Data Vault 2.0

Raw vaults at enterprise scale

Hubs, links, and satellites with hash keys for enterprise warehouses. Designed for parallel loads, full source-of-truth lineage, and SCD by construction.

in catalog

Data Vault 2.0CRM
Salesforce Customer 360
Multi-cloud Salesforce raw vault: Sales, Service, and Marketing Cloud unified with hubs, links, and satellites including effectivity tracking.
28
entities
220
attributes
36
relationships
Show details
What's inside
8 hubs: Account, Contact, Lead, Opportunity, Case, Campaign, Product, User
10 links including lead-conversion unit-of-work and case-status effectivity
10 satellites with full SCD-history descriptive attributes
Campaign Influence transactional link for multi-touch attribution
Hash keys + HASH_DIFF columns generated by the DDL layer
Subject areas
salesservicemarketing
Data Vault 2.0ERP · Finance
SAP S/4HANA Universal Journal
SAP S/4HANA universal-journal-aligned raw vault: ACDOCA, business partners, organizational hierarchy, and posting periods.
24
entities
195
attributes
31
relationships
Show details
What's inside
ACDOCA-aligned non-historized link for journal-entry txns
Business partner hub bridging customer / vendor / employee roles
Cost center + profit center + functional area hierarchy hubs
Fiscal calendar and posting-period reference satellites
Document-flow link for source-document traceability
Subject areas
journalbusiness_partnersorganizationcalendar
Compliance / regulatory
SOX
Data Vault 2.0Banking
Banking Enterprise Data Vault
Enterprise banking raw vault: customers, accounts, transactions, holdings, and party relationships at full source-of-truth grain.
26
entities
208
attributes
33
relationships
Show details
What's inside
Customer / account / transaction / product hubs with multi-source bks
Transaction non-historized link carrying amount + ledger entries
Holdings + position effectivity satellites for SCD
Party-relationship link for joint accounts and beneficiaries
BCBS-239-aware reference-data lineage built into satellite metadata
Subject areas
partiesaccountstransactionsholdings
Compliance / regulatory
BCBS-239SOX
Data Vault 2.0Healthcare
Healthcare Raw Vault (HIPAA)
HIPAA-aware healthcare raw vault: patients, encounters, providers, claims, observations, and clinical events.
25
entities
198
attributes
32
relationships
Show details
What's inside
Patient / provider / encounter / claim / observation hubs
FHIR-aligned reference satellites for code systems (LOINC, SNOMED, ICD-10)
PHI-masked descriptive satellites with classification metadata
Encounter-diagnosis transactional link with sequence ordering
Audit-aware load_date + record_source on every entity
Subject areas
patientsencountersprovidersobservations
Compliance / regulatory
HIPAAHL7 FHIR
Data Vault 2.0Telecom
Telecom Data Vault
Telco raw vault covering subscribers, services, network elements, and CDRs with high-volume non-historized links.
24
entities
190
attributes
30
relationships
Show details
What's inside
Subscriber / service / network-element / device hubs
CDR non-historized link sized for billions of records / day
Service activation accumulating link
Plan + tariff satellites with rate-plan effectivity
Number-portability link tracking MSISDN moves across providers
Subject areas
subscribersservicescdrnetwork
Data Vault 2.0Retail
Retail Customer-360 Vault
Retail customer-360 raw vault: cross-channel customers, orders, products, loyalty events, and marketing interactions.
23
entities
182
attributes
28
relationships
Show details
What's inside
Customer hub with multi-source bks (POS, ecom, CRM, loyalty)
Order + order-line transactional links carrying measures
Product hierarchy hubs (SKU / style / category)
Loyalty event non-historized link sized for high cardinality
Marketing-interaction link bridging email / push / SMS
Subject areas
customersordersproductsloyaltymarketing
Data Vault 2.0Asset Management
Investment Management EDW (Aladdin-style)
Aladdin-style (BRS AM) investment EDW as a raw vault: 26 hubs, 22 links, and 50+ satellites integrating security-master, OMS/EMS, custodian, accounting, risk, ESG, sec-lending, and repo sources into one auditable data language.
93
entities
649
attributes
99
relationships
Show details
What's inside
26 hubs across security, issuer, portfolio, account, trade, counterparty, sec-lending, repo, limits
Per-asset-class satellites (bond / equity / derivative / FX / fund) + analytics / ESG / price time-series
IBOR and ABOR measures modeled as two satellites on one position link
Non-historized trade link with fees + settlement-status satellites for TCA
Collateral, margin-call, sec-lending, repo, and risk-limit utilization links
Subject areas
hubslinksreference_satellitestimeseries_satellitestransaction_satellites
Compliance / regulatory
MiFID IIDodd-FrankEMIRSOXBasel IIISFDR

3NF

Operational source-system models

Normalized relational models that mirror source-system schemas. Faithful to OLTP / ERP / EHR transactional structures for landing and replay.

in catalog

3NFHealthcare
EHR Clinical Operations
Operational EHR data model: patients, encounters, providers, problems, medications, orders, and clinical observations.
22
entities
175
attributes
28
relationships
Show details
What's inside
Patient demographics + problem list + medication list tables
Encounter with admission / discharge events and disposition
Order / result tables linked through encounter and provider
Provider credential + facility + department reference tables
Audit columns with classification metadata for PHI
Subject areas
patientsencountersordersresults
Compliance / regulatory
HIPAAONC 21st Century Cures
3NFTelecom
Telecom OSS / BSS
Operational OSS / BSS source model: subscribers, products, services, billing accounts, CDRs, network inventory.
24
entities
188
attributes
30
relationships
Show details
What's inside
Subscriber + billing-account + service-instance entities
Product catalog with tariff / plan / addon hierarchy
Network-inventory tables: nodes, ports, circuits, IP allocations
CDR detail table with rated amount and bill-cycle linkage
Activation / suspension / termination workflow tables
Subject areas
subscribersproductsbillingnetwork_inventory
3NFRetail
E-commerce OLTP
E-commerce operational source model: customers, addresses, products, variants, carts, orders, payments, and shipments.
20
entities
158
attributes
26
relationships
Show details
What's inside
Customer + address + payment-method tables (PII-aware)
Product + variant + SKU + price-list hierarchy
Cart and cart-item with abandonment status
Order + order-item + shipment + return tables
Payment + refund tables linked to PSP transaction id
Subject areas
customerscatalogorderspayments
Compliance / regulatory
PCI-DSS
3NFERP
ERP Order Management
Operational order-management model: sales orders, deliveries, invoices, customers, products, and inventory commitments.
21
entities
168
attributes
28
relationships
Show details
What's inside
Sales order + sales-order-line tables with status workflow
Delivery + delivery-line linked to sales order line
Invoice + invoice-line tables with tax breakout
Inventory commitment table tying allocations to lines
Customer + ship-to + bill-to + sold-to organizational tables
Subject areas
sales_ordersdeliveriesinvoicescustomers
3NFCRM
Salesforce Core (Fivetran-style)
Faithful Fivetran / Airbyte-style landing replica of 16 core Salesforce objects with soft-delete-aware audit metadata.
16
entities
135
attributes
22
relationships
Show details
What's inside
Keeps native 18-char salesforce_id as business key
system_modstamp + is_deleted + audit-Id metadata on every table
Self-referential ParentId / ManagerId rendered by Id (no FK cycle)
Polymorphic WhoId / WhatId resolved to typed nullable FKs
Lower-snake-case column naming with no leading underscore
Subject areas
accountscontactsopportunitiescases
3NFHealthcare
Hospital ADT
Operational hospital admission / discharge / transfer model: encounters, bed assignments, attending providers, and clinical events.
19
entities
148
attributes
25
relationships
Show details
What's inside
Encounter table with admit / discharge timestamps and disposition
Bed assignment + transfer event tables per encounter
Attending / consulting / admitting provider link tables
Diagnosis (problem list, present-on-admission) tables
Procedure + observation tables linked through encounter id
Subject areas
encountersbed_assignmentsprovidersdiagnoses
Compliance / regulatory
HIPAAHL7 v2.x
3NFAsset Management
Investment Management Platform — IBOR/ABOR
Aladdin-style (BRS AM) enterprise investment model as a normalized operational schema — the target a client maps source systems onto: security master, IBOR/ABOR books, full trade lifecycle, financing, risk, performance, and compliance.
84
entities
785
attributes
212
relationships
Show details
What's inside
Security master with cross-identifier history + per-asset-class terms (bond / equity / derivative / FX / fund)
IBOR (positions, cash ladder, forecast, balances) and ABOR (holdings, tax lots, accruals) books of record
Full trade lifecycle: order → allocation → execution → trade (legs / fees / confirms / SSIs) → settlement
Counterparty credit: collateral (CSA / GMRA / GMSLA), margin calls, securities lending, repo
Risk (VaR + contributions, limits), performance + factor attribution, GIPS composites, restricted lists
Subject areas
security_masterfirm_and_portfolioiborabortradingcounterparty_creditriskperformancecompliance
Compliance / regulatory
MiFID IIDodd-FrankEMIRSOXBasel IIIGIPSSFDR

Your data warehouse is one conversation away.

Describe your domain, or open one of 170+ production-grade templates. ERDs, DDL, and a complete dbt project — generated in under a minute.

Get started Talk to us Browse templates

Don't start from a blank canvas. Start from a warehouse.

Star schemas for analytics

Core Banking Analytics

SaaS Subscription Analytics

Healthcare Claims Analytics

Retail & E-commerce Analytics

P&C Insurance Analytics

Marketing & Web Analytics

Capital Markets Trading

Mortgage Lending Analytics

AML / KYC Monitoring

Sales Pipeline Analytics

Inventory Analytics

Hospitality / Hotel Analytics

Investment Management Analytics (Aladdin-style)

Raw vaults at enterprise scale

Salesforce Customer 360

SAP S/4HANA Universal Journal

Banking Enterprise Data Vault

Healthcare Raw Vault (HIPAA)

Telecom Data Vault

Retail Customer-360 Vault

Investment Management EDW (Aladdin-style)

Operational source-system models

EHR Clinical Operations

Telecom OSS / BSS

E-commerce OLTP

ERP Order Management

Salesforce Core (Fivetran-style)

Hospital ADT

Investment Management Platform — IBOR/ABOR

Your data warehouse is one conversation away.