アナリティクスエンジニアリングキット
トラッキングプラン、データディクショナリ、dbtプロジェクト標準、データ品質、指標定義、セマンティックモデル、ダッシュボード仕様、BIソリューション設計、データインシデントレビュー。
要求
Analytics Tracking Plan Template (Privacy-First, JSON Schema, GPC)
フルPrivacy-first tracking plan: tiers, object_action naming, events, property dictionary, JSON Schema 2020-12, SchemaVer, consent and GPC gating, PII rules, QA
JSON Schema 2020-12; W3C GPC (Working Draft); ePrivacy Art. 5(3); GDPR Arts. 6-7Data Dictionary Template
標準Business and technical definitions per attribute: type, format, allowed values, source, owner, classification, code lists, derived fields
構築
dbt Project Standard Template (Analytics Engineering)
フルLayers and folder layout, naming, sources and freshness, tests, contracts, versions, groups and access, docs, macros, environments, slim CI, review checklist, cost guardrails
dbt Core 1.11/1.12 concepts (Apache-2.0)Data Quality Standard Template (ISO/IEC 25012, ODCS)
フルOrganisation DQ standard: ISO/IEC 25012 vocabulary, tiers, rule catalogue, severity, enforcement points, observability, scorecard, issues, waivers
ISO/IEC 25012:2008 (names); ODCS v3.2.0; OpenLineage 2-0-2
仕様
Metric Definition Template (KPI)
標準One certified metric or KPI: question, definition, formula, grain, SQL sketch, filters, targets, owners, certification, MetricFlow type mapping
dbt MetricFlow metric types (Apache-2.0)Semantic Model Specification Template (Metrics Layer)
フルDatasets and entities, relationships and join keys, dimensions and time grains, measures, metric types, filters, access rules, certification, tests, interchange
dbt MetricFlow v0.213.0 concepts; Apache Ossie draft (emerging)Dashboard Specification Template (BI Report, WCAG 2.2)
フルAudience and decisions, questions, KPI list linked to metric definitions, wireframe, filters and drill paths, row-level security, refresh, WCAG 2.2, performance budget, sunset
W3C WCAG 2.2 (2024-12-12)