Self‑Serve Analytics Onboarding Checklist

{ "Title": "Self‑Serve Analytics Onboarding Checklist", "IntroductionHtml": "

Welcome

This interactive checklist helps new platform users get up to speed safely and consistently. Complete each item, run the sample queries, and answer the short quiz to validate readiness. Responses are saved so your analytics team can follow up where help is needed.

What's included

• Account & access checks
• Data literacy primer and naming/metric conventions
• How to find canonical datasets and owners in the catalog
• Basic chart creation walkthrough
• Sensitive-data and privacy reminders
• Support & escalation path
• Recommended guardrails and sample queries
• A short quiz to validate readiness

Estimated time

Plan 30–60 minutes to complete the checklist and quiz, longer if you follow additional learning links.

Recommended guardrails (quick)

• Use canonical datasets where available — prefer reuse over copies.
• If you create derived datasets, record lineage, ownership, and purpose.
• Publish dashboards with clear data source tags and version notes.
• Mask or remove sensitive fields before sharing externally.
• Follow the escalation path for access, data quality, or privacy issues.

Sample queries (examples)

-- 1) Quick row count
SELECT COUNT(*) FROM analytics.sales_canonical;

-- 2) Simple aggregation with date
SELECT date_trunc('month', order_date) AS month, SUM(amount) AS total_sales
FROM analytics.sales_canonical
GROUP BY 1
ORDER BY 1;

-- 3) Validate a join (compare totals)
SELECT COUNT(*)
FROM analytics.orders o
JOIN analytics.customers c ON o.customer_id = c.id
WHERE c.region = 'West';

If a sample query returns unexpected results, stop and raise a data quality request to the dataset owner.

", "SubmitLabel": "Save progress", "SuccessMessage": "Onboarding progress saved. If you requested help or flagged issues, the analytics team will follow up.", "DataType": "self-serve-onboarding-checklist", "SchemaVersion": "1.0", "Fields": [ { "Key": "participant_name", "FieldType": "text", "Label": "Your name", "HelpText": "Enter your full name.", "Required": true }, { "Key": "team", "FieldType": "text", "Label": "Team / role", "HelpText": "Your team or role (helps assign the right reviewer).", "Required": false }, { "Key": "account_setup", "FieldType": "yesno", "Label": "Account & access", "HelpText": "I have an active account and necessary permissions (BI tool, data catalog, required datasets).", "Required": true }, { "Key": "data_literacy_primer", "FieldType": "yesno", "Label": "Data literacy primer", "HelpText": "Completed the primer covering basic terms, data types, measurement, bias, and limitations.", "Required": true }, { "Key": "naming_metric_conventions", "FieldType": "yesno", "Label": "Naming & metric conventions", "HelpText": "Understand how datasets, fields, and metrics are named and where canonical metrics live.", "Required": true }, { "Key": "find_canonical_datasets", "FieldType": "yesno", "Label": "Finding canonical datasets", "HelpText": "Can find canonical datasets and check lineage/owners in the data catalog.", "Required": true }, { "Key": "basic_chart_creation", "FieldType": "yesno", "Label": "Basic chart creation", "HelpText": "Created a basic chart and can change chart types, filters, and aggregations.", "Required": true }, { "Key": "sensitive_data_awareness", "FieldType": "yesno", "Label": "Sensitive data & privacy", "HelpText": "Know which fields are sensitive and how to handle or mask them (PII, PHI, personal data).", "Required": true }, { "Key": "support_escalation", "FieldType": "yesno", "Label": "Support & escalation path", "HelpText": "Know how to request help or escalate data quality, access, or privacy issues.", "Required": true }, { "Key": "guardrails_understood", "FieldType": "yesno", "Label": "Platform guardrails", "HelpText": "Understand publishing rules, dataset ownership, versioning, and approvals.", "Required": true }, { "Key": "sample_queries_tried", "FieldType": "yesno", "Label": "Sample queries tried", "HelpText": "Ran the recommended sample queries and validated outputs against examples.", "Required": true }, { "Key": "readiness_confidence", "FieldType": "scale", "Label": "Confidence to produce/reuse analyses safely", "HelpText": "1 = Not confident, 5 = Very confident", "Required": true, "Min": 1, "Max": 5 }, { "Key": "quiz_q1", "FieldType": "radio", "Label": "Quiz 1: When should you create a private copy of a canonical dataset?", "HelpText": "Choose the best answer.", "Required": true, "Options": [ { "Value": "never", "Label": "Never — always use canonical" }, { "Value": "always", "Label": "Always — copies are safer" }, { "Value": "private_changes", "Label": "Only for private changes that cannot be applied to the canonical dataset; record lineage and notify owners" }, { "Value": "performance", "Label": "Only for performance reasons (and notify owners)" } ] }, { "Key": "quiz_q2", "FieldType": "radio", "Label": "Quiz 2: Which action best preserves reproducibility?", "HelpText": "Choose the best answer.", "Required": true, "Options": [ { "Value": "overwrite", "Label": "Overwrite the canonical dataset" }, { "Value": "publish_tags", "Label": "Publish derived reports with clear data source tags and versioning" }, { "Value": "share_private", "Label": "Share private files via email" }, { "Value": "none", "Label": "No special action needed" } ] }, { "Key": "quiz_q3", "FieldType": "radio", "Label": "Quiz 3: If you find personally identifiable data in an analytical dataset, you should:", "HelpText": "Choose the best answer.", "Required": true, "Options": [ { "Value": "ignore", "Label": "Ignore and proceed" }, { "Value": "mask_report", "Label": "Mask or remove sensitive fields and notify the data owner and privacy team" }, { "Value": "download", "Label": "Download and delete locally" }, { "Value": "ask_colleague", "Label": "Ask a colleague what to do" } ] }, { "Key": "quiz_notes", "FieldType": "textarea", "Label": "Quiz & training notes", "HelpText": "Optional: what confused you or what you'd like help with.", "Required": false }, { "Key": "completion_notes", "FieldType": "textarea", "Label": "Completion notes & next steps", "HelpText": "Optional notes, follow-ups requested, or specific training needed.", "Required": false } ] }