1. From Claude Dashboards to Claude Data
Traditional self-serve business intelligence either traps business teams in multi-week ticket queues or lets unvetted AI prompts invent conflicting SQL numbers. Claude Data (introduced in beta as Claude Dashboards) bridges that gap by pairing conversational warehouse exploration with auditable SQL, semantic governance, and narrative storytelling formats.
Quick Navigation
Why Auditable SQL + Semantic Governance Beat Black-Box Charts
When you ask a generic chatbot to analyze a CSV paste, hallucinations hide inside static images and stale snapshots. Inside Claude Data, Claude never guesses arithmetic in token memory: it discovers your connected schema, checks your organization’s Certified Queries and semantic MCP layer, runs deterministic SQL against your warehouse, stamps every visual with a refresh timestamp, and lets you pivot the exact same verified dataset into four distinct presentation formats.
Architecture: Warehouses & Semantic Layers → Claude Data → 4 Native Formats
2. Plans, Connectors & Output Format Decision Matrix
Claude Data runs across paid Claude tiers while scaling governance controls for multi-team organizations. Matching the right connection pattern and output format upfront saves hours of rework.
- Pro & Max: Full access to personal warehouse/MCP connectors, interactive dashboards, Scrollytellers, Visual Shorts, and Visual Analyses for individual analytical workflows.
- Team: Adds workspace-scoped Live Sharing so teammates view refreshed dashboards without sharing database passwords, plus shared project metric context.
- Enterprise: Unlocks organization-wide Certified Queries registries, Admin connector allowlists, SSO/OAuth enforcement, audit logs, and governed BI partner handoffs.
- Native Warehouse Connectors: Authenticate Snowflake, BigQuery, Redshift, ClickHouse, or Databricks using OAuth or a dedicated
CLAUDE_READONLYanalytical role. - Connected SaaS Apps: Link Salesforce via OAuth so Claude queries live Opportunity, Account, and Stage History objects respecting CRM permissions.
- Semantic MCP Servers: Attach Lightdash MCP, dbt Semantic Layer, or
mcp-grafanaso Claude inherits pre-modeled joins and KPI formulas automatically.
Claude Data 4-Format Decision Matrix: Choosing the Right Deliverable
| Native Output Format | Primary Audience & Cadence | What Claude Builds Automatically | Best Moment to Use It |
|---|---|---|---|
| 1. Interactive Dashboard | Operators, PMs, RevOps & weekly KPI standups | Multi-tile KPI cards, time-series & cohort charts, dropdown filters, refresh button, and expandable SQL drawer. | Ongoing self-serve monitoring where viewers slice regions, plans, or date windows. |
| 2. Scrollyteller (Narrative Web Story) |
Board members, leadership & cross-functional launches | A magazine-style scrolling story where chapters of crisp prose trigger coordinated chart transitions and callouts. | Monthly business reviews or postmortems where why a metric moved matters most. |
| 3. Visual Short (Narrated Video) |
Slack channels, async global teams & all-hands | A 60–90 second animated, voice-narrated walkthrough highlighting headline deltas, anomalies, and next actions. | Monday morning metric digests when busy stakeholders will not open a full BI tool. |
| 4. Visual Analysis / Letter | Founders, finance leads & investment memos | An executive brief weaving concise analytical paragraphs with inline proof charts, variance tables, and SQL citations. | Decision memos (pricing changes, QBRs) requiring rigorous written argumentation. |
When to Stay in Claude Data vs. Push Deeper into Specialized BI Tools
Use Send to Sigma or export to Omni when a prototype needs spreadsheet-grid writeback, complex row-level multi-tenant embedding, or permanent governed workbooks.
Push SQL into Hex when data scientists need Python cells, scikit-learn forecasting, Monte Carlo simulations, or multi-cell reactive notebooks alongside SQL.
Keep sub-minute infra alerting in Grafana, and deep session-replay or client SDK funnel experimentation in Amplitude, Mixpanel, or PostHog.
3. Annotated Tour: Claude Data & Dashboard Studio
Claude Data splits your workspace into a conversational analyst thread on the left and a live, auditable artifact canvas on the right—complete with interactive filters, Certified Query badges, SQL inspection, and credential-safe sharing.
net_dollar_retention and ending_arr by segment and signup cohort. Add region & plan filters and flag churn spikes.
cert_saas_arr_monthly (1.4s) & cert_cohort_ndr (1.9s) in UTC. Excluded internal sandbox orgs automatically.
analytics.cert_cohort_ndr) 5
Refreshed: 2026-11-12 14:05 UTC • ↻ Refresh
Interface Controls Legend (Pins 1–7)
1 Connected Sources & Semantic MCP Panel: Shows active read-only warehouse roles (Snowflake, BigQuery, Redshift, ClickHouse, Databricks), CRM links, and semantic layers (Lightdash/dbt).
2 Interactive Parameter & Date Controls: Dropdown slicers for region, plan tier, and UTC time windows re-filter or re-query tiles without editing prompts.
3 KPI Cards & Anomaly Callouts: Headline metrics paired with automated variance flags (such as Month-3 SMB churn spikes) and version-history rollback.
4 Certified Query Verification Badge: Emerald seal confirming the chart runs an analytics-approved SQL metric definition rather than an ad-hoc table guess.
5 Inspect SQL & UTC Refresh Drawer: Expandable audit bar on every tile displaying exact ANSI SQL, row counts, execution duration, and last refreshed timestamp.
6 Native 4-Format Switcher: Pivots the verified board into a narrative Scrollyteller, a narrated Visual Short video, or an executive Visual Analysis.
7 Credential-Safe Live Share Badge: Publishes a workspace link where teammates view fresh results without inheriting your warehouse role or raw SQL console access.
WHERE filters and join keys match finance rules.
4. Connecting Warehouses, Semantic Layers & Auditable SQL
Great natural-language analytics starts before the first prompt. Pointing Claude Data at clean analytical schemas and semantic MCP layers eliminates messy raw-table guesswork and sluggish full-table scans.
- Snowflake & Databricks: Grant
USAGEandSELECTonly on curatedANALYTICS.MARTSschemas—never raw ingestion staging or PII vaults—and attach a 30-second query timeout warehouse. - BigQuery & ClickHouse: Enforce partition-filter requirements on large event tables (
require_partition_filter = true) so exploratory prompts always boundevent_date. - Redshift & Salesforce: Pair workload-managed read queues with scoped Salesforce OAuth profiles limited to standard pipeline fields.
- Zero Join Hallucinations: A Lightdash MCP or dbt Semantic Layer exposes pre-tested join paths, dimension hierarchies, and metric YAML directly to Claude.
- Business Vocabulary Alignment: When a PM asks for “Active Paid Teams,” Claude calls the semantic metric
active_paid_workspacesinstead of guessing which raw event table counts logins. - Instant Telemetry Context: Pair warehouse KPIs with
mcp-grafanato correlate revenue dips against API latency spikes.
Provisioning a Safe Read-Only Warehouse Role (Snowflake ANSI SQL Example)
-- Create a dedicated read-only role bounded to curated marts and a small auto-suspend warehouse:
CREATE ROLE IF NOT EXISTS CLAUDE_DATA_READONLY;
GRANT USAGE ON WAREHOUSE ANALYTICS_XS_WH TO ROLE CLAUDE_DATA_READONLY;
GRANT USAGE ON DATABASE PROD_ANALYTICS TO ROLE CLAUDE_DATA_READONLY;
GRANT USAGE ON SCHEMA PROD_ANALYTICS.MARTS TO ROLE CLAUDE_DATA_READONLY;
GRANT SELECT ON ALL TABLES IN SCHEMA PROD_ANALYTICS.MARTS TO ROLE CLAUDE_DATA_READONLY;
GRANT SELECT ON ALL VIEWS IN SCHEMA PROD_ANALYTICS.CERTIFIED TO ROLE CLAUDE_DATA_READONLY;
ALTER WAREHOUSE ANALYTICS_XS_WH SET STATEMENT_TIMEOUT_IN_SECONDS = 45 AUTO_SUSPEND = 60;UTC vs. local CRM dates), (2) Join cardinality (COUNT(DISTINCT account_id) when joining one-to-many invoice lines), and (3) the Last Refreshed timestamp so you never quote yesterday’s cached snapshot during a live close.
5. Iterative Dashboard Building & Analytics Prompt Anatomy
The fastest analysts never ask for a 12-chart mega-dashboard on Turn 1. They validate grain and totals first, assemble interactive tiles on Turn 2, and layer controls and anomaly annotations on Turn 3.
The 4-Turn Iterative Dashboard Loop
Ask Claude to list matching Certified Queries or semantic models first and return a compact summary table for last month. Reconcile the headline total against your finance close before drawing charts.
Promote the verified query into a structured board: 3 top KPI scorecards, a primary trend or cohort retention chart, and a bottom segment breakdown table sorted by dollar impact.
Add interactive dropdowns (Region, Plan Tier, Date Range picker, Cohort Toggle) and ask Claude to flag any week or segment exceeding 2 standard deviations from its 8-week trailing mean.
Every edit saves a numbered artifact snapshot. If an experimental secondary axis or filter makes the layout noisy, click the version selector to restore v3 cleanly in one click.
5-Tag Analytics Prompt Anatomy
Weak Vague Prompt vs. Governed Claude Data Prompt
| Dimension | Weak Prompt (Causes Metric Drift) | Governed Claude Data Prompt (Production-Ready) |
|---|---|---|
| Metric Source | “Show me our monthly revenue growth.” | Names PROD_ANALYTICS.CERTIFIED.cert_monthly_arr or Lightdash metric ending_arr. |
| Time & Cutoffs | “Over the past year” (mixes partial current month & local TZ). | “Trailing 12 complete months in UTC, plus separate MTD pacing badge.” |
| Exclusions | Includes test accounts, refunded invoices, and $0 trials. | Explicitly requires is_test_account = FALSE AND invoice_status = 'paid'. |
| Auditability | Accepts chart bars blindly at face value. | Requests distinct entity counts and SQL drawer verification before sharing. |
FY starts Feb 1), standard exclusion predicates, and preferred color palette inside Project Instructions so every teammate’s dashboard inherits them automatically.
6. Certified Queries: Ending “Two Numbers for Revenue”
Every fast-growing company hits the same analytics failure mode: Marketing presents $51.2M ARR at 9:00 AM, Finance presents $48.6M ARR at 9:15 AM, and the meeting derails into debugging SQL filters. Certified Queries solve this permanently inside Claude Data.
Raw tables mix test workspaces, failed card retries, annual proration quirks, and PST-vs-UTC boundary mismatches that skew totals by 4–9%.
Data engineering publishes canonical SQL definitions with approved slice parameters. Claude prioritizes Certified Queries whenever those KPIs are asked.
Charts backed by an unmodified Certified definition earn the green Certified Query badge; ad-hoc overrides drop to Exploratory SQL transparently.
Canonical Certified Query Example (Clean ANSI SQL — Zero Drift)
-- Certified Metric: enterprise_net_dollar_retention_monthly (Owner: Finance & Data Eng • Reviewed Quarterly)
WITH clean_mrr AS (
SELECT DATE_TRUNC('month', s.snapshot_date_utc) AS report_month, a.customer_id, a.sales_region, a.plan_tier,
SUM(s.normalized_mrr_usd) AS mrr_usd
FROM prod_analytics.marts.fct_subscription_daily s
INNER JOIN prod_analytics.marts.dim_accounts a ON s.account_id = a.account_id
WHERE a.is_internal_test = FALSE AND a.is_refunded_dispute = FALSE
AND s.billing_status IN ('active', 'past_due_grace') AND s.snapshot_date_utc = LAST_DAY(s.snapshot_date_utc)
GROUP BY 1, 2, 3, 4
),
cohort_pair AS (
SELECT curr.report_month, curr.sales_region, curr.plan_tier,
COUNT(DISTINCT prev.customer_id) AS retained_customers,
SUM(prev.mrr_usd) AS start_mrr_12m_ago, SUM(COALESCE(curr.mrr_usd, 0)) AS end_cohort_mrr
FROM clean_mrr prev
LEFT JOIN clean_mrr curr ON prev.customer_id = curr.customer_id AND curr.report_month = ADD_MONTHS(prev.report_month, 12)
GROUP BY 1, 2, 3
)
SELECT report_month, sales_region, plan_tier, retained_customers,
ROUND(end_cohort_mrr * 12, 0) AS certified_cohort_arr_usd,
ROUND((end_cohort_mrr / NULLIF(start_mrr_12m_ago, 0)) * 100.0, 2) AS certified_ndr_pct
FROM cohort_pair WHERE start_mrr_12m_ago > 0 ORDER BY report_month DESC, sales_region;The 4 Foundational KPIs Every Analytics Team Should Certify First
| Foundational KPI | Hidden Edge Cases Locked Down by Certification | Approved Slice Dimensions |
|---|---|---|
| 1. Ending ARR / MRR | Multi-currency FX normalization to USD, annual contract proration, excluding sandbox/partner comps. | report_month, sales_region, plan_tier, channel |
| 2. Net Dollar Retention | Parent-account hierarchy rollups (subsidiary upgrades), churn timing at contract end vs. cancellation click. | cohort_quarter, segment, industry_vertical |
| 3. Active Weekly Teams | Excludes automated bot pings, synthetic health checks, and 1-seat QA workspaces; requires ≥2 human actions. | week_utc, plan_tier, core_feature_module |
| 4. Cloud & AI Gross Margin | Maps Stripe net recognized revenue against AWS/GCP compute + LLM token inference spend per tenant ID. | report_month, plan_tier, model_family |
7. Beyond Charts: Scrollytellers, Visual Shorts & BI Handoffs
Dashboards answer what happened for people who already know where to look. Narrative formats—Scrollytellers and Visual Shorts—align busy executives in two minutes without sacrificing warehouse rigor.
A Scrollyteller pairs sticky animated charts with chapter-by-chapter narrative prose that zooms into specific cohorts as the reader scrolls:
- Chapter 1 (Headline Hook): Company-wide ARR & NDR vs. quarterly plan target.
- Chapter 2 (Driver Decomposition): Chart highlights EMEA Enterprise expansion (+31%) lifting overall retention.
- Chapter 3 (Risk Spotlight): Zooms into Month-3 SMB self-serve churn spike after onboarding flow v2.
- Chapter 4 (Decision Ask): Quantifies revenue upside of restoring guided onboarding for 5–20 seat teams.
Visual Shorts turn live query results into crisp, narrated motion walkthroughs ready to drop into Slack or open an all-hands meeting:
- Scripted on Verified Numbers: Every spoken percentage is bound directly to the underlying SQL result set—zero ad-libbed rounding errors.
- Paced for Async Review: Aim for 60–90 seconds covering 3 scenes: Scoreboard → Biggest Surprise → Recommended Action.
- Pair with Live Link: Pin the Live Shared Dashboard link right beneath the video in Slack so curious leads drill in immediately.
BI Ecosystem Handoff Playbook: Graduating Prototypes to Production Stacks
| Destination Platform | How Handoff Works from Claude Data | Ideal Downstream Workflow |
|---|---|---|
| Sigma (Send to Sigma) | One-click push exports your Claude Data prototype, SQL logic, and layout into a governed Sigma workbook. | Finance writeback tables, row-level customer portals, and 100k-row interactive spreadsheet pivots. |
| Hex & Omni | Export clean CTE SQL blocks from the Audit Drawer directly into Hex SQL cells or Omni curated topic views. | Python statistical modeling, churn propensity scoring (Hex), or governed enterprise semantic dashboards (Omni). |
| Grafana | Pair SQL/PromQL queries via mcp-grafana to turn incident investigations into permanent Grafana panels. |
24/7 PagerDuty threshold alerting, SLO burn-rate boards, and token latency telemetry. |
| Amplitude • Mixpanel • PostHog | Use Claude Data to join warehouse billing with product cohorts, then deep-link behavioral cohorts in product analytics. | Session replays, feature-flag A/B experiments, and multi-step UI clickstream conversion funnels. |
8. 5 Real-World Copy-Paste Claude Data & Dashboard Recipes
Adapt the schema or semantic metric names in brackets and paste these prompts straight into Claude Data. Every recipe enforces UTC boundaries, clean exclusions, and SQL auditability.
| Recipe & Persona | Connectors Used | Copy-Paste Prompt Blueprint | Output & Audit Gate |
|---|---|---|---|
| 1. SaaS Net Retention & Churn Cohort Board VP Finance / RevOps |
Snowflake or BigQuery + Certified Queries | “Using cert_monthly_arr and cert_cohort_ndr over trailing 12 complete UTC months, build an interactive Retention Board: 3 KPI cards (Ending ARR, NDR %, Gross Churn %), a stacked monthly MRR bridge (New, Expansion, Contraction, Churned), and a quarterly signup cohort heatmap. Add Region and Plan dropdowns; exclude is_sandbox = TRUE.” |
Interactive Dashboard + MRR bridge reconciliation check. |
| 2. Salesforce Pipeline Velocity & Win-Rate CRO / Sales Ops |
Salesforce OAuth + Warehouse Targets | “Query live Salesforce Opportunity and OpportunityFieldHistory joined to Q4 quota targets. Calculate Pipeline Coverage ratio, Stage-to-Stage conversion %, median days in Stage 3+, and Rep Win-Rate for deals >$25k. Highlight stalled deals untouched >14 days and add Segment & Territory filters.” |
Interactive Dashboard + downloadable stalled-deal action table. |
| 3. Cloud & AI Token Spend Anomaly Monitor Platform Eng / FinOps |
ClickHouse or Databricks + mcp-grafana |
“Query daily cloud compute + LLM inference billing in finops.fct_daily_usage over the last 60 UTC days (partitioned on usage_date). Plot unit cost per 1,000 active requests by model family and customer tier, flag daily spikes >2.5 SD above trailing 14-day mean, and cross-check latency via Grafana.” |
Dashboard + Send to Grafana / Sigma FinOps review. |
| 4. Monthly Board Update Story + Video CEO / Chief of Staff |
Lightdash Semantic MCP + Certified SQL | “Take our verified Monthly Executive KPI Dashboard and generate two narrative assets without altering any SQL query: (1) a 5-chapter Scrollyteller walking the Board from headline ARR beat to enterprise expansion and unit economics, and (2) an 80-second Visual Short summarizing our top 3 wins and 1 Q1 priority.” | Scrollyteller web story + 80s narrated Visual Short. |
| 5. Raw SQL Audit & Certification Extractor Analytics Engineer |
Warehouse Metadata / Project SQL | “Inspect the 6 exploratory SQL queries used across this project’s dashboards. Audit each for fan-out joins, missing UTC date truncations, unpartitioned scans, or inconsistent test-account exclusions. Output a unified, clean ANSI SQL candidate view with COUNT(DISTINCT ...) guards ready for our Certified Queries registry.” |
Visual Analysis audit memo + production dbt/SQL view. |
Once Recipe 1 or 2 renders, drill in conversationally without rebuilding the board: “Keep the current layout pinned, add a drawer tab isolating the 15 largest contracted accounts in Q3, and join their Salesforce loss/downgrade reason codes.”
Ask Claude to write portable ANSI SQL using standard schema.table identifiers and explicit CAST(... AS NUMERIC) calls so Certified views migrate cleanly across Snowflake, Databricks, Postgres, and DuckDB tests.
WHERE event_date >= CURRENT_DATE - INTERVAL '60' DAY) so your warehouse scans megabytes instead of terabytes.
9. Credential-Safe Live Sharing & Enterprise Governance
Historically, sharing a live AI-generated chart meant either sending dead screenshots or dangerously handing out shared database service-account keys. Claude Data’s Live Sharing architecture separates viewing approved visuals from holding raw database credentials.
- Authenticate with their own authorized warehouse OAuth token or read-only analyst role.
- Write exploratory prompts, inspect schema metadata, iterate on SQL joins, and publish approved tiles.
- Choose workspace visibility (specific colleagues, Team project, or org-wide link) and revoke live shares at any moment.
- CAN: Open the shared dashboard, Scrollyteller, or Visual Short, see fresh approved chart data, toggle pre-built filter controls, and read the Certified badge + timestamp.
- CANNOT: Inherit the creator’s database credentials, browse underlying warehouse tables, or run arbitrary ad-hoc follow-up SQL unless they authenticate their own warehouse role.
Defense-in-Depth Security Matrix Across Warehouse & Claude Workspace
| Governance Layer | How to Configure It Correctly | Risk Eliminated |
|---|---|---|
| 1. Read-Only Database Roles | Bind connectors exclusively to SELECT-only roles with zero INSERT, UPDATE, DROP, or COPY privileges. |
Guarantees no prompt can ever mutate, truncate, or alter production warehouse state. |
| 2. Dynamic PII Masking | Apply Snowflake Dynamic Data Masking or BigQuery Policy Tags on email, ssn, phone, and billing street addresses. |
Prevents customer PII from entering chart tooltips, SQL results, or shared executive links. |
| 3. Row-Level Security (RLS) | Pass per-user OAuth identity to warehouse row-access policies (or graduate external embeds via Send to Sigma). | Ensures regional managers querying directly only scan rows belonging to their assigned territory. |
| 4. Admin Connector Allowlists | In Claude Enterprise Admin settings, restrict MCP servers and native connectors to vetted corporate endpoints and SSO groups. | Blocks shadow-IT connectors or unapproved third-party MCP servers from touching corporate data. |
Warehouse PII Masking Policy Snippet (Snowflake Example)
-- Mask customer email addresses automatically whenever queried by analytical or AI dashboard roles:
CREATE OR REPLACE MASKING POLICY analytics.mask_customer_email AS (val STRING) RETURNS STRING ->
CASE
WHEN CURRENT_ROLE() IN ('COMPLIANCE_OFFICER_ROLE') THEN val
ELSE CONCAT('***@', SPLIT_PART(val, '@', 2))
END;
ALTER TABLE prod_analytics.marts.dim_users
MODIFY COLUMN work_email SET MASKING POLICY analytics.mask_customer_email;10. Cross-Tool Synergy Pipeline Across Your Stack
Claude Data shines brightest as the connective hub of a quarterly planning loop—pulling governed warehouse truth upstream and feeding financial scenario models, strategy whiteboards, executive stories, and deep Python notebooks downstream.
Step-by-Step Quarterly Business Review (QBR) Playbook
Connect Snowflake + Lightdash MCP inside Claude Data. Run your Certified Q4 ARR, NDR, and Salesforce pipeline queries first so Finance, Sales, and Product start from one identical, UTC-stamped dataset.
Export the clean monthly summary table into Claude in Excel / Sheets to model Base, Upside, and Downside Q1 hiring and burn scenarios driven by live historical retention rates rather than static assumptions.
Bring the Month-3 SMB churn findings into a collaborative planning canvas or whiteboard session: map onboarding friction points, assign engineering owners, and attach target metric lift milestones.
Publish a 5-chapter Scrollyteller + 90-second Visual Short via Live Sharing for company alignment, push the SQL to Hex for predictive churn scoring, and click Send to Sigma for ongoing RevOps tracking.
11. Troubleshooting Clinic & Pre-Flight Checklist
Almost every natural-language analytics hiccup comes down to timezone cutoffs, join cardinality, partition filters, or intentional credential boundaries. Keep this page handy before publishing any board.
Top 7 Issues & 10-Second Fixes
| Symptom / Failure Mode | Root Cause | 10-Second Fix |
|---|---|---|
| 1. Two teammates get slightly different revenue totals | One prompt queried raw invoices in local TZ; the other excluded test orgs in UTC. |
Pin a Certified Query (green badge) and enforce explicit DATE_TRUNC('month', ts_utc) in Project Instructions. |
| 2. Slow 45-second scan or warehouse timeout error | Query scanned an unpartitioned multi-billion-row raw clickstream table. | Point Claude at pre-aggregated dbt marts or require an explicit partition filter (WHERE event_date >= ...). |
| 3. Viewer blocked from running follow-up SQL on a Live Share | Expected security boundary: Live Sharing never delegates creator DB credentials. | Add interactive filter dropdowns for common slices, or grant the colleague their own read-only warehouse OAuth role. |
| 4. Global ARR inflated by ~8–15% across regions | Multi-currency rows (EUR, GBP, JPY) summed directly without FX conversion. |
Check Inspect SQL; join dim_fx_rates or query normalized amount_usd columns exclusively. |
| 5. Customer or deal count looks 3× higher than CRM | One-to-many fan-out join (for example, joining accounts to invoice_line_items). |
Open the SQL drawer and replace COUNT(*) with COUNT(DISTINCT a.account_id) or pre-aggregate child CTEs. |
| 6. Dashboard shows yesterday’s pipeline numbers | Viewing the last cached execution result from an earlier session. | Check the Last Refreshed UTC timestamp in the tile footer and click Refresh to re-execute live SQL. |
| 7. Warehouse or Lightdash MCP missing in sidebar | Connector not yet enabled on Enterprise Admin allowlist or OAuth token expired. | Have a Workspace Admin enable the connector under Admin Settings → Connectors and re-authorize OAuth. |
6-Point Pre-Flight Checklist Before Sharing Any Executive Asset
Core company KPIs (ARR, NDR, WAU, Gross Margin) pull from Certified Queries or Lightdash/dbt semantic definitions rather than raw staging tables.
Opened Inspect SQL on every tile to verify COUNT(DISTINCT ...) guards, normalized USD currency columns, and sandbox exclusions.
Trend charts plot complete periods (excluding half-finished current weeks unless labeled MTD/WTD) and show a fresh UTC refresh timestamp.
Connector uses a SELECT-only role with statement timeouts, partition filters, and zero unmasked customer emails or personal identifiers.
Operators get an interactive Dashboard; Board & leadership get a chaptered Scrollyteller; Slack channels get a 60–90s Visual Short + live link.
High-traffic prototypes are promoted to Certified Queries or handed off via Send to Sigma, Hex, or Grafana when permanent apps are required.