tech
Dashboard
Visual display of the key metrics that matter most. The instrument panel of the business.
Definition
A dashboard is a visual summary of the most important metrics - revenue, pipeline, cash, KPIs - in one view. Good dashboards are tight (5-8 metrics, not 50), trended (show direction, not just current), and aligned to decisions (every metric ties to an action). Common mistakes: too many metrics (dilutes attention), no trend lines (current-only is just a snapshot), beautiful but useless (looks great, doesn't drive behavior).
The three dashboards every US business needs
Tier one: executive dashboard (founder, CEO). 5 to 8 metrics covering financial health (cash, runway, monthly P&L), commercial health (MRR or pipeline, new customers, retention), and operational health (one to three key operational KPIs). Reviewed weekly minimum. Tier two: functional dashboards (sales, marketing, ops, finance). 8 to 15 metrics per function, more granular, owned by function lead. Reviewed weekly by function team. Tier three: operational dashboards (specific roles, specific processes). 10 to 30 metrics for daily operational decisions; reviewed daily by operators. Most US small businesses err in two directions: no dashboards at all (decisions made on gut), or too many dashboards diluted across hundreds of metrics. The discipline: start with one executive dashboard, add functional dashboards as functions mature, build operational dashboards only when daily decision velocity requires them.
Dashboard tool landscape for US small businesses
By complexity and budget. Spreadsheet-based: Google Sheets, Excel; free; manual refresh; appropriate for solo founders and very small teams. Native dashboards: HubSpot Dashboards, Salesforce Reports, Stripe Dashboard; included with existing SaaS; limited cross-system data; good for single-source views. SMB BI tools: Geckoboard, Klipfolio, Databox; 50 to 300 dollars per month; pre-built connectors to common SaaS; templates available. Mid-market BI: Looker Studio (free, owned by Google), Power BI (Microsoft, 10 to 25 per user per month), Tableau (75 plus per user); more sophisticated; require some technical setup. Modern data stack: Hex, Mode, Metabase, Sigma plus a data warehouse (BigQuery, Snowflake); 200 plus per month plus warehouse costs; for businesses with multiple data sources and analytical complexity. Most US small businesses under 50 employees should use Looker Studio (free, integrates with Google Workspace) or Databox (mid-priced, broader connector library).
Designing dashboards that drive action
Five design principles that separate useful from decorative dashboards. One, every metric must tie to a decision: if no one acts on a metric, it does not belong on the dashboard. Two, show trends, not just current values: a 30-day or 12-week trend line beside the current number tells you whether the direction is good. Three, use comparison anchors: current versus prior period, current versus target, current versus benchmark - the number alone is meaningless without context. Four, color-code with discipline: red/yellow/green should signal action thresholds, not arbitrary aesthetics. Five, organize for the question, not the data source: dashboards should answer specific questions ('How is the quarter tracking?') not just display data ('Here are all our metrics'). The test: can a viewer make a decision in 90 seconds based on the dashboard?
Maintaining dashboard hygiene
Dashboards decay without active maintenance. Common decay patterns: data sources break and metrics show zero or stale data; calculations drift from original definitions as data sources evolve; metrics that mattered last quarter no longer reflect current strategy; dashboards accumulate metrics over time and become cluttered. Maintenance practices: assign single owner per dashboard responsible for accuracy and relevance; review dashboards monthly and prune unused metrics; document metric definitions in a data dictionary so calculations stay consistent over time; investigate when metrics look wrong (data quality issues are often deeper than they appear); refresh dashboard layout annually as business priorities shift. Most US small businesses build dashboards once and never touch them; effective dashboards require ongoing care like any other operational asset.
FAQ
How many metrics should an executive dashboard have?
5 to 8 maximum, fitting on one screen without scrolling. Tier categorization helps: 1 to 2 ultra-critical metrics (cash, runway), 3 to 4 important metrics (revenue, pipeline, churn), 1 to 2 leading indicators (lead volume, conversion rate). Above 8 metrics, attention dilutes; founders skim instead of analyze. If you find yourself wanting more metrics on the executive dashboard, that signals need for functional dashboards (sales dashboard, marketing dashboard) rather than expanding the executive view. Discipline of compression forces clarity on what actually matters.
How often should I review my dashboard?
Frequency by tier. Executive dashboard: weekly minimum, ideally daily glance with deep review weekly. Functional dashboards: weekly during team meetings. Operational dashboards: daily for active operations. US small business founders who review dashboards monthly or less typically discover problems too late to address proactively; the value of dashboards is early detection. The 10-minute Monday morning dashboard review is one of the highest-leverage management practices for US founders. Build it into your calendar; protect the time.
What is the difference between a dashboard and a report?
Time orientation and use case. Dashboard: real-time or near-real-time view of current state; designed for ongoing monitoring; updated continuously. Report: snapshot at a specific point in time, often more detailed; designed for analysis, communication, or compliance; updated on a schedule (monthly, quarterly). Dashboards answer 'how are we doing right now?'; reports answer 'what happened in the last period and why?'. Most US small businesses need both - dashboards for operational management, reports for monthly close, board meetings, and investor updates. Different design principles apply to each.
Should I build dashboards myself or hire an analyst?
Build yourself for initial dashboards; hire when complexity exceeds your tools and time. Most US small business dashboards can be built by founder or operations lead in 4 to 20 hours per dashboard using no-code tools (Looker Studio, Databox, HubSpot native). Hire an analyst (50K to 150K US salary or 75 to 200 dollar per hour contractor) when: data sources exceed 5 systems requiring integration; analytical questions require SQL or statistical analysis; building infrastructure for ongoing analytics; or your time is more valuable spent on customer-facing work. Hybrid approach common: founder owns executive dashboard, analyst builds deeper functional dashboards.
What makes a dashboard fail?
Five common failure patterns. One, too many metrics: dilutes attention, no one acts on anything. Two, stale data: metrics show outdated information, trust erodes, dashboard gets ignored. Three, unclear calculations: metric definitions are ambiguous, different viewers interpret differently. Four, no action threshold: viewers see metrics but do not know when intervention is needed. Five, beautiful but disconnected from decisions: dashboards designed for aesthetic appeal rather than operational use. Avoid these by: limiting scope, automating data refresh, documenting calculations in data dictionary, defining action thresholds in red/yellow/green coloring, and pressure-testing every metric against 'what decision does this drive?'
In your business
- →5-8 metrics max - if it doesn't fit on one screen it's too much
- →Always show trend (last 12 weeks or months), not just current value
- →Each metric should tie to a decision - if no one acts on it, drop it