How erikroa/nova-customer-intelligence works
NovaCRM is a dbt customer-intelligence analytics project. Its documented workflow transforms CSV seed data through staging and core models into customer-success and revenue marts, which feed Looker Studio dashboards. The README documents the layer structure and model purposes; detailed SQL dependencies were not sampled, so links below show only documented or strongly domain-supported flows.
Main entry points: dim_account.sql Account dimension · fct_revenue.sql Revenue facts · seeds Raw CSV seeds · fct_tickets.sql Ticket facts
Components 22
Source data
- Raw CSV seeds
seeds
Staging models
- Stage accounts
models/staging/models/staging/stg_accounts.sql - Stage subscriptions
models/staging/models/staging/stg_subscriptions.sql - Stage invoices
models/staging/models/staging/stg_invoices.sql - Stage usage
models/staging/models/staging/stg_usage_events.sql - Stage tickets
models/staging/models/staging/stg_support_tickets.sql
Core models
- Account dimension
models/core/dim_account.sql - Product dimension
models/core/dim_product.sql - Date dimension
models/core/dim_date.sql - Revenue facts
models/core/fct_revenue.sql - Usage facts
models/core/fct_usage.sql - Ticket facts
models/core/fct_tickets.sql - Health scoring macro
macros/calculate_health_score.sql - Segment macro
macros/classify_segment.sql
Analytics outputs
- Customer health scores
models/marts/customer_health_scores.sql - Churn risk view
models/marts/churn_risk_view.sql - NRR summary
models/marts/nrr_summary.sql - Revenue cohorts
models/marts/revenue_cohort_analysis.sql - SLA adherence
models/marts/sla_adherence.sql
Other components
- Analytics user
- BigQuery
- Looker Studio
Connections 34
- Raw CSV seeds → Stage accounts: stages account data
- Raw CSV seeds → Stage subscriptions: stages subscription data
- Raw CSV seeds → Stage invoices: stages invoice data
- Raw CSV seeds → Stage usage: stages usage data
- Raw CSV seeds → Stage tickets: stages ticket data
- Stage accounts → Account dimension: profiles accounts
- Stage subscriptions → Account dimension: enriches accounts
- Stage tickets → Account dimension: enriches accounts
- Stage subscriptions → Product dimension: describes products
- Stage invoices → Revenue facts: supplies billing
- Stage subscriptions → Revenue facts: supplies MRR
- Account dimension → Revenue facts: keys revenue
- Date dimension → Revenue facts: dates revenue
- Stage usage → Usage facts: aggregates events
- Account dimension → Usage facts: keys usage
- Date dimension → Usage facts: dates usage
- Stage tickets → Ticket facts: enriches tickets
- Account dimension → Ticket facts: keys tickets
- Health scoring macro → Customer health scores: scores accounts
- Segment macro → Account dimension: classifies segments
- Account dimension → Customer health scores: scores accounts
- Usage facts → Customer health scores: measures engagement
- Ticket facts → Customer health scores: measures support
- Revenue facts → Customer health scores: measures revenue
- Account dimension → Churn risk view: flags risk
- Usage facts → Churn risk view: tracks usage trends
- Ticket facts → Churn risk view: tracks escalations
- Revenue facts → Churn risk view: tracks revenue
- Revenue facts → NRR summary: calculates retention
- Account dimension → Revenue cohorts: groups accounts
- Revenue facts → Revenue cohorts: measures retention
- Ticket facts → SLA adherence: measures adherence
- BigQuery → Looker Studio: serves mart data
- Analytics user → Looker Studio: views dashboards