菜单
Star schema patterns, key resolution strategies, synthetic key prevention, QVD layer design, multi-app architecture patterns, source architecture consumption strategies, and associative engine behavior for Qlik Sense data modeling. Load when designing or reviewing data models.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Post-load data quality validation patterns for Qlik development. Provides query templates for null rate analysis, referential integrity checks, value distribution analysis, row count validation, orphaned record detection, sparse field identification, and duplicate detection. Usable by the qa-reviewer when MCP or post-load data access is available. Also provides patterns for embedding validation checks directly into load scripts. Load when performing data quality validation or writing diagnostic scripts.
Captures existing platform patterns for brownfield Qlik projects. Provides structured templates for documenting existing app inventory, shared subroutine catalogs, naming convention maps, data connection standards, QVD storage conventions, and organizational coding standards. Used by requirements-analyst during Phase 0 context ingestion and by script-developer during Phase 4 for platform compatibility. Load when ingesting platform context or writing scripts that must integrate with existing platform conventions.
Deployment procedures for Qlik Sense Cloud and client-managed environments. Covers app import, data connection setup, task scheduling, security configuration, and environment-specific considerations. Invoke manually with /qlik-deploy when preparing deployment artifacts or runbooks.
Set analysis syntax and patterns, aggregation functions, TOTAL qualifier usage, Aggr() patterns, conditional expressions, null handling in expressions, dollar-sign expansion, expression performance optimization, and common anti-patterns for Qlik Sense expression development. Load when writing or reviewing Qlik expressions.
Script syntax reference, QVD optimization, incremental load patterns (insert-only, insert/update, insert/update/delete, dual-timestamp for SCD2), master calendar generation, variable definitions, error handling, logging patterns, null handling patterns, diagnostic and validation patterns, subroutine integration, and platform gotchas (SET vs LET, dollar-sign expansion timing, SET variable comma limitation). Load when writing or reviewing Qlik load scripts.
Field naming, variable naming, table naming, expression naming, and file naming standards for Qlik Sense development. Includes cross-layer naming strategy for tracing field names from source through every ETL layer to UI display name. Includes prefix/suffix conventions, reserved words, and correct vs. incorrect examples. Load when writing or reviewing any Qlik artifact.
| name | qlik-data-modeling |
| description | Star schema patterns, key resolution strategies, synthetic key prevention, QVD layer design, multi-app architecture patterns, source architecture consumption strategies, and associative engine behavior for Qlik Sense data modeling. Load when designing or reviewing data models. |
For detailed star schema pattern examples, see star-schema-patterns.md in this directory.
For multi-app architecture decision framework, see multi-app-architecture.md in this directory.
For source consumption patterns (Data Vault, OLTP, flat files), see source-consumption-patterns.md in this directory.
For anti-patterns to avoid, see anti-patterns.md in this directory.
