{"id":1342,"slug":"research-brief-dashboards-smb-june-2026","title":"Research brief: dashboards for SMBs — what's worth showing, and when an embedded one earns its keep (June 2026)","kind":"reference","scope":"business","status":"current","audiences":["kevin","smb-owner","candid-team"],"topics":["editorial-discipline","self-service-adoption","dashboards","bi-tools-landscape","embedded-analytics","decision-linked-metrics"],"reference_body":"**Status:** Synthesised June 2026. Fourth brief in the SMB-advice quartet with [[research-brief-customer-facing-calculators-smb-june-2026]], [[research-brief-data-driven-tools-smb-june-2026]], and [[research-brief-client-portals-smb-june-2026]].\n\n## TL;DR\n\nA dashboard is the **surfacing layer** that moves data from \"queryable but ignored\" to \"informs daily decisions\" — *if* it is actually used. The honest evidence says most of that promised value never lands:\n\n- **Independent analyst data** puts BI/dashboard adoption at only ~**25-30% of employees** ([[barc-eckerson-25pct-bi-adoption-2022]], [[gartner-30pct-bi-adoption]]) and has for over a decade.\n- **SMB-specific BI dashboard adoption is far lower** — Software Advice put it at **5% of 243 SMBs** ([[software-advice-5pct-smb-bi-dashboard-243-sample]]).\n- The viral **\"60-70% of dashboards go unused (Gartner)\"** statistic is **vendor folklore — could not be traced to any named Gartner report** ([[60-70pct-dashboards-untraceable-vendor-folklore]]). Use BARC ~25% / Gartner ~30% adoption figures instead.\n- The **\"72% of users regularly abandon dashboards for spreadsheets\"** stat is Luzmo's **vendor-run survey of ~200 SaaS/product leaders** ([[luzmo-72pct-vendor-survey-dashboards-2025]]), not independent research. Same with **Logi Analytics 45% BI usage** ([[logi-analytics-45pct-bi-usage-vendor]]).\n\n## The two decision tracks\n\n**INTERNAL dashboards** are worth it when there is a *recurring, owned decision tied to a metric with a threshold* — cash flow, DSO, job-cost variance, utilization, at-risk customers. They are **not** worth it as a \"single source of truth\" wall of vanity metrics nobody opens after launch.\n\n- Tied to a named owner + named decision + named threshold ([[rule-qualify-every-metric-with-decision-and-threshold]], [[what-would-i-do-if-it-moved-test]]).\n- Default to the cheapest BI tool that fits the stack: M365 → Power BI Pro ([[power-bi-pricing-april-2025]]); Google/marketing data → free Looker Studio ([[looker-studio-per-project-trap]]); SQL-comfortable / future-embedding → Metabase ([[metabase-pricing-tiers-2026]]). ([[rule-for-internal-default-cheapest-tool-that-fits-stack]]).\n- Budget ~20-30% of build effort annually for maintenance ([[rule-budget-20-30pct-annual-maintenance-from-day-one]]).\n\n**CUSTOMER-FACING dashboards (especially embedded in the website)** earn their keep in a narrow band: recurring clients + frequently-updating data-rich results + retention/differentiation lever + support deflection ([[customer-facing-dashboard-three-conditions-narrow-band]]). Most SMBs delivering periodic results to a handful of clients should send a scheduled PDF or shared reporting link — see [[agencyanalytics-static-reports-still-dominant]] and [[rule-for-customer-facing-default-to-pdf-or-link-first]].\n\n- 20+ client tenants or analytics-as-product? Evaluate an embedded-analytics platform (Luzmo / Explo / Cube / Embeddable — [[luzmo-explo-cube-embedded-pricing]]) **before** a custom build.\n- Custom-embedded is justified only when analytics is core differentiation AND ≥1-2 engineers will own it permanently. 3-year TCO ~$300K-$630K with ~20-30% annual maintenance ([[custom-embedded-3-year-tco-300-630k-vendor]]).\n\n## Source-incentive meta-finding\n\nThe dashboard literature is overwhelmingly vendor-published (Microsoft, Salesforce/Tableau, Google, Metabase, Luzmo, Explo, Cube, Logi Analytics, Sisense). Retention / churn / ROI claims (e.g., \"31% retention increase,\" \"27% churn drop\") are vendor-sourced — treat as marketing, not evidence. See [[caveats-dashboards-vendor-marketing-base]].\n\n## The article\n\nThe publication-ready prose draft lives at [[article-when-is-a-dashboard-worth-it-for-your-business]] (Candid /writing/ candidate, SMB audience).","rationale_body":"Fourth brief in the June 2026 SMB-advice quartet. Heart of the brief: the BARC/Gartner adoption stagnation data unmasks the vendor \"dashboards transform decisions\" framing; the decision-linked-metric discipline is the practical antidote.","metadata":null,"links":{"outgoing":[{"slug":"research-brief-customer-facing-calculators-smb-june-2026","title":"Research brief: customer-facing calculators & tools for SMBs — the honest case (June 2026)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"research-brief-data-driven-tools-smb-june-2026","title":"Research brief: live data and data-driven tools for SMBs — when it's an edge, when it's overkill (June 2026)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"research-brief-client-portals-smb-june-2026","title":"Research brief: client portals for SMBs — the honest case (June 2026)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"dashboard-vs-static-report-definition","title":"Dashboard vs static report: dashboard is live + queryable + interactive; report is a point-in-time snapshot for documentation / compliance / shared \"version of truth\"","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"internal-vs-customer-facing-dashboards","title":"Internal operational vs customer-facing dashboards — different metrics, different success criteria, different audiences","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"dashboard-sits-on-capture-layer-data-quality-determines-trust","title":"Dashboards sit on top of a capture layer (DB / warehouse / SaaS APIs / spreadsheets); data quality below the surface determines trust — abandonment frequently stems from numbers that don't reconcile, not from the visualization","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"refresh-cadence-real-time-vs-daily","title":"Refresh cadence: real-time matters for operational exception use (logistics ETAs, manufacturing downtime); daily suits most SMB KPIs; refresh frequency drives cost (Power BI Pro 8/day vs Premium Per User 48/day)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"barc-eckerson-25pct-bi-adoption-2022","title":"BARC / Eckerson Group (March 2022, 214 D&A leaders surveyed Nov-Dec 2021) — BI/analytics adoption at 25% of employees on average; \"stuck around 20% for many years\" per Eckerson","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"gartner-30pct-bi-adoption","title":"Gartner — \"pervasive business intelligence remains elusive, with BI and analytics adoption at about 30% of all employees\" (doc 3753469, Howson & Sallam)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"software-advice-5pct-smb-bi-dashboard-243-sample","title":"Software Advice (online survey of 243 US business owners/managers) — 5% of SMBs report using a BI dashboard to analyze data; Excel/Google Sheets dominate at 65%","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"60-70pct-dashboards-untraceable-vendor-folklore","title":"CORRECTION: the viral \"60-70% (or 60-80%) of dashboards go unused (Gartner)\" stat cannot be traced to any named Gartner report — vendor folklore","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"luzmo-72pct-vendor-survey-dashboards-2025","title":"\"72% of users regularly abandon dashboards for spreadsheets\" — Luzmo vendor-run *State of Dashboards 2025* survey of ~200 SaaS/product leaders; \"Dashboards: Dead, Dying or Evolving?\"","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"logi-analytics-45pct-bi-usage-vendor","title":"\"Only 45% of people with access to BI tools actually use them\" — traces to Logi Analytics (BI vendor) report, not independent research","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"construction-job-cost-dashboards-weekly","title":"Construction: weekly job-cost dashboards (labor variance, committed vs actual materials, change orders, billing vs % complete, backlog) catch margin erosion before month-end financials arrive","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"professional-services-dso-dashboards","title":"Professional services: DSO (Days Sales Outstanding) dashboards with aging buckets + at-risk-customer flags; 30-45 days is a common \"good\" benchmark; rising DSO is an early cash-flow warning","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"manufacturing-oee-80-20-pm-target","title":"Manufacturing internal dashboards: OEE, MTBF/MTTR, PM compliance, planned-vs-reactive ratio (world-class target ~80/20)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"cross-industry-internal-dashboard-use-cases-roundup","title":"Cross-industry internal dashboards round-up: e-commerce (conversion, inventory turns, CAC), healthcare (occupancy, readmissions), logistics (on-time, exceptions), SaaS (activation, churn, NRR), hospitality (occupancy, no-shows)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"customer-facing-dashboard-use-cases-real-examples","title":"Customer-facing dashboard use cases (real examples): agencies (client results), in-product analytics (Shopify, Strava, Zendesk), logistics tracking portals (FourKites, Shippeo, project44)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"agencyanalytics-static-reports-still-dominant","title":"AgencyAnalytics benchmark — a majority of agencies still send static reports to clients while relying on live dashboards internally; live unfinal numbers invite client misinterpretation","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"customer-facing-dashboard-three-conditions-narrow-band","title":"Customer-facing embedded dashboard earns its keep in a NARROW BAND: recurring clients + frequently-updating data-rich results + retention/differentiation lever + support deflection","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"power-bi-pricing-april-2025","title":"Power BI pricing (April 2025): Pro $14/user/mo, Premium Per User $24/user/mo (both raised from $10/$20); Fabric F2 ~$262/mo to F64 ~$5,000/mo (viewers no per-user); Embedded A1 ~$735/mo","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"looker-studio-per-project-trap","title":"Looker Studio: free tier widely used; Looker Studio Pro $9/user/Google-Cloud-PROJECT/month (per-project detail materially inflates agency costs); separate Looker (Google Cloud core) $35K-60K+/yr","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"tableau-pricing-tiers-2026","title":"Tableau pricing (2026): Cloud Standard Viewer $15 / Explorer $42 / Creator $75 per user/mo (annual); Enterprise $35/$70/$115; embedded/OEM year-1 floor reportedly $60K-150K","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"metabase-pricing-tiers-2026","title":"Metabase pricing (2026): Open Source free (AGPL v3 self-host); Cloud Starter $100/mo (5 users included, +$6/user); Pro $575/mo (10 users, +$12/user; white-label + embedded + RLS + SSO); Enterprise from ~$20K/yr","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"luzmo-explo-cube-embedded-pricing","title":"Embedded-analytics platforms (2026): Luzmo $995-3,100/mo embedded plans; Explo $795/Growth, $2,195/Pro; Cube Core open-source + Cube Cloud consumption; Embeddable still in beta","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"custom-embedded-3-year-tco-300-630k-vendor","title":"Custom-embedded 3-year TCO converges on $300K-$630K (multiple, mostly vendor sources) with 20-30% annual maintenance; hidden costs are multi-tenancy/RLS, performance at scale, perpetual maintenance","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"used-vs-vanity-dashboard-criteria","title":"Five criteria separating a used dashboard from a vanity one: built for daily user / every metric tied to decision+threshold / embedded in existing workflow / trusted / few metrics (~5-7 per view)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"what-would-i-do-if-it-moved-test","title":"The \"what would I do if this number doubled or halved tomorrow?\" test — if no action follows, it's vanity","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"dashboard-rot-schema-drift-maintenance","title":"Dashboard rot: data sources change schemas, metric definitions drift across departments, organizational attention wanes; custom/embedded builds carry the heaviest ~20-30%/yr maintenance burden","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"caveats-dashboards-vendor-marketing-base","title":"Caveats for the dashboards brief: pervasive BI/embedded-analytics vendor sourcing; the viral \"60-70%\" stat is folklore; SMB data thin; retention claims unproven","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"rule-qualify-every-metric-with-decision-and-threshold","title":"R1 — Before building any dashboard, qualify every proposed metric: named owner + named decision + action threshold; if it fails the \"what would I do if it moved?\" test, drop it","kind":"rule","scope":"business","link_type":"relates-to"},{"slug":"rule-for-internal-default-cheapest-tool-that-fits-stack","title":"R2 — For internal dashboards, default to the cheapest tool that fits the existing stack: Power BI Pro for M365 shops, free Looker Studio for Google/marketing data, Metabase for SQL-comfortable / future-embedding","kind":"rule","scope":"business","link_type":"relates-to"},{"slug":"rule-for-customer-facing-default-to-pdf-or-link-first","title":"R3 — For customer-facing reporting, default to the lightest delivery first: scheduled PDF or shared reporting link; embed only when the four-condition narrow band holds","kind":"rule","scope":"business","link_type":"relates-to"},{"slug":"rule-budget-20-30pct-annual-maintenance-from-day-one","title":"R4 — Budget 20-30% of build effort annually for maintenance from day one; assign a metric-definitions owner; audit quarterly and archive any dashboard unopened in 30+ days","kind":"rule","scope":"business","link_type":"relates-to"},{"slug":"rule-disregard-vendor-bi-stats-cite-barc-gartner-adoption","title":"R5 — Disregard vendor BI \"X% improvement\" / \"60-70% unused\" stats in client conversations; cite BARC (~25%) and Gartner (~30%) adoption baselines","kind":"rule","scope":"business","link_type":"relates-to"},{"slug":"article-when-is-a-dashboard-worth-it-for-your-business","title":"Article (draft): When is a dashboard worth it for your business? The honest case for internal and embedded dashboards in SMBs","kind":"reference","scope":"business","link_type":"relates-to"}],"incoming":[{"slug":"research-brief-interactive-tool-mechanisms-smb-june-2026","title":"Research brief: why interactive tools deepen a business's relationship with its audience — a mechanism-level research package (June 2026)","kind":"reference","scope":"business","link_type":"relates-to"},{"slug":"research-brief-information-asymmetry-decision-edge-june-2026","title":"Research notes (capture-layer): the affirmative, inward decision-edge case for data intelligence — information asymmetry applied to pricing, demand, risk, retention, targeting (June 2026)","kind":"research-notes","scope":"business","link_type":"relates-to"}]},"created_at":"2026-06-20T18:03:12.041Z","updated_at":"2026-06-20T18:03:12.041Z"}