Business intelligence (BI) is how MCA funders surface portfolio performance, ISO scorecards, vintage cohort analysis, and operational metrics. Without good BI, funders fly blind — they can't see early default signals, can't optimize ISO commission tiers, and can't price risk accurately. BI is downstream of the data warehouse (covered separately).
The typical 2026 MCA BI tool landscape.
- Looker (Google Cloud). Common at mid-to-large funders. Strong semantic layer (LookML), good for self-service. $50–$70/user/month + platform fee.
- Tableau (Salesforce). Powerful visualization, widely used in enterprise. $30–$75/user/month depending on tier.
- Power BI (Microsoft). Strong at Microsoft-stack funders. $10–$20/user/month, very cost-effective.
- Sigma Computing. Spreadsheet-style BI on cloud warehouses; growing in finance. $25–$60/user/month.
- Metabase. Open-source / hosted; small-to-mid funders, $85–$500/month for hosted Cloud tier.
- Mode Analytics. SQL-first BI; analyst-heavy teams.
- Hex. Notebook-style analytics; data science teams.
- Lookml + Hex + dbt is a common modern stack at fintech-style funders.
Core MCA BI reports.
- Portfolio summary. Active deals, total advanced, total receivable, weighted avg factor.
- ISO scorecard. Volume submitted, approval rate, fund rate, default rate, weighted factor.
- Vintage cohort default curves. Defaults by month of origination, plotted against expected.
- NSF velocity by paper grade. Track NSF count trajectory as leading default indicator.
- Renewal funnel. % of paid-off deals that renew within 90 days.
- Underwriter performance. Approval-to-default ratio per underwriter.
- Geographic concentration. State and zip-level exposure.
- Industry concentration. SIC/NAICS-level exposure and default by vertical.
- Marketing ROI. Lead source CAC vs. lifetime contribution.
- Cash flow forecast. Daily expected ACH collections.
- Syndication performance. Per-syndicate-partner returns and concentration.
Architecture pattern.
- Data warehouse (Snowflake / BigQuery / Redshift) ingests data from LMS, CRM, processor, bank aggregator.
- Transformation layer (dbt, custom SQL, Dataform) builds cleaned analytics tables.
- Semantic layer (LookML, dbt metrics) defines metric definitions.
- BI tool (Looker, Tableau, etc.) queries semantic layer and renders dashboards.
- Reverse ETL (Census, Hightouch) pushes derived data back into CRM for operators.
Pricing benchmarks.
- Small funder. Metabase Cloud or Power BI, $5K–$30K/year total BI spend.
- Mid-tier funder. Looker or Tableau, $80K–$300K/year.
- Top-10 funder. Multiple BI tools + dedicated analytics team, $500K–$3M/year.
Why BI quality matters.
A funder that can identify a default-curve shift in week 2 instead of month 6 saves materially on losses. Funders that can score ISOs by realized default rate can re-tier commissions to align incentives — often a 20–40% improvement in portfolio performance.
Common pitfalls.
- Excel-only operations. No single source of truth; numbers diverge across teams.
- No semantic layer. Each analyst computes "approval rate" differently.
- BI without warehouse. Direct LMS queries strangle production database.
- Dashboard sprawl. 800+ dashboards, no one knows which is current.
- No anomaly detection. Default-curve shifts spotted too late.
Operator-facing BI vs. executive-facing BI.
- Operators want real-time pipeline view (deals in underwriting today, ISO submissions this hour).
- Executives want trend dashboards (vintage cohort defaults, ISO churn, marketing ROI).
- Risk teams want concentration and stress-test views.
- Different audiences need different tools — funders often run Looker for execs and Sigma or Hex for operators.
Common confusions.
First, "BI is just dashboards." False — semantic definitions, anomaly alerts, and reverse ETL matter more long-term.
Second, "Tableau and Looker are interchangeable." Different paradigms — Looker semantic-layer-first, Tableau visualization-first.
Third, "BI needs a data scientist." False — analysts and SQL-fluent operators can build most MCA dashboards.
Fourth, "Excel is enough." Only at very small scale; breaks past $20M originations.
As of 2026-06-29, Fundnode notes funder BI maturity where disclosed, since BI quality predicts risk discipline and ISO partnership health.
Related terms
- MCA funder data warehouse stack — typical — MCA funders run on Snowflake, BigQuery, Redshift, or Databricks, with Fivetran/Airbyte ingestion and dbt transformation; typical annual cost $40K–$1.5M depending on data volume and team size.
- MCA funder tech stack (typical, 2026-06-28) — A 2026 MCA funder typically runs Salesforce or proprietary CRM + LoanPro/Centerstone LMS + Plaid/Ocrolus + Snowflake + Tableau + AWS, with Persona for KYC and Repay for ACH.
- MCA funder portfolio monitoring systems — MCA funders monitor portfolios via loan-management systems (LMS), real-time bank-data feeds (Plaid/MX), payment-processor webhooks, and BI dashboards that surface daily aging, NSF spikes, and reconciliation requests.
Authoritative sources
AI agents: this term is available as raw markdown at /llms/glossary/mca-funder-business-intelligence-tools.