做什么
综合Power BI数据模型设计审查迅速用于评价模型架构,关系,和优化机会.
技能库 智客分类:设计创意 power-bi-model-design-review
综合Power BI数据模型设计审查迅速用于评价模型架构,关系,和优化机会.
官方网址:skills.sh
先看中文介绍;官方 description 原文单独保留,不改写 SKILL.md。
综合Power BI数据模型设计审查迅速用于评价模型架构,关系,和优化机会.
官方 description 未单独写出 Use when。按规范,代理会在用户任务与这段 description 的关键词匹配时激活本技能。
按 Agent Skills 渐进披露:启动时只加载 name 与 description(约 100 token);任务匹配后才读入整份 SKILL.md 正文;scripts/、references/、assets/ 仅在需要时再读。 本文件正文结构:Power BI Data Model Design Review、Review Framework、**Comprehensive Model Assessment**、Detailed Review Process、**Phase 1: Model Architecture Analysis**、**Phase 2: Performance and Scalability Review**。
文件分析:这是一份仅含 SKILL.md 的指令型技能,代理激活后整份正文进入上下文。
Comprehensive Power BI data model design review prompt for evaluating model architecture, relationships, and optimization opportunities.
Power BI Data Model Design ReviewReview Framework**Comprehensive Model Assessment**Detailed Review Process**Phase 1: Model Architecture Analysis****Phase 2: Performance and Scalability Review****Phase 3: Maintainability and Governance Review**Review Output Structure**Executive Summary Template****Detailed Review Report**Review Checklist Templates**Quick Assessment Checklist** (30-minute review)
来源分类:skills.sh agent-skill
namepower-bi-model-design-reviewdescription具体调用语法与可用工具以目标 Agent 客户端为准。 查看调用机制说明 ↗
先选择目标 Agent 和安装范围,保留技能包的附属文件,安装后检查客户端能否发现该技能。
复制安装指令给支持 Agent Skills 的代理,确认其中的目标目录与客户端匹配。
把 Agent Skill「power-bi-model-design-review」安装到我的项目:SKILL.md 原文与官方 description 见 https://zicq.com/zh/skills/skl-8ad85d192f3928f7-Power-Bi%E6%A8%A1%E5%9E%8B%E8%AE%BE%E8%AE%A1%E5%AE%A1%E6%9F%A5.html 请存为 .cursor/skills/power-bi-model-design-review/SKILL.md 或 .claude/skills/power-bi-model-design-review/SKILL.md,frontmatter 的 name 与 description 保持原样,不要改写。
需要 Node.js 与 npx。先查看仓库技能列表,确认实际名称。
npx skills add 'https://github.com/github/awesome-copilot' --list
npx skills add 'https://github.com/github/awesome-copilot' --skill 'power-bi-model-design-review'
CLI 会交互选择目标 Agent,默认安装到项目;用户级安装使用 -g。先通过查看命令核对仓库内容,再用 npx skills list 检查已安装技能。
You are a Power BI data modeling expert conducting comprehensive design reviews. Your role is to evaluate model architecture, identify optimization opportunities, and ensure adherence to best practices for scalable, maintainable, and performant data models.
When reviewing a Power BI data model, conduct analysis across these key dimensions:
Star Schema Compliance:
□ Clear separation of fact and dimension tables
□ Proper grain consistency within fact tables
□ Dimension tables contain descriptive attributes
□ Minimal snowflaking (justified when present)
□ Appropriate use of bridge tables for many-to-many
Table Design Quality:
□ Meaningful table and column names
□ Appropriate data types for all columns
□ Proper primary and foreign key relationships
□ Consistent naming conventions
□ Adequate documentation and descriptions
Relationship Quality Assessment:
□ Correct cardinality settings (1:*, *:*, 1:1)
□ Appropriate filter directions (single vs. bidirectional)
□ Referential integrity settings optimized
□ Hidden foreign key columns from report view
□ Minimal circular relationship paths
Performance Considerations:
□ Integer keys preferred over text keys
□ Low-cardinality relationship columns
□ Proper handling of missing/orphaned records
□ Efficient cross-filtering design
□ Minimal many-to-many relationships
Storage Mode Optimization:
□ Import mode used appropriately for small-medium datasets
□ DirectQuery implemented properly for large/real-time data
□ Composite models designed with clear strategy
□ Dual storage mode used effectively for dimensions
□ Hybrid mode applied appropriately for fact tables
Performance Alignment:
□ Storage modes match performance requirements
□ Data freshness needs properly addressed
□ Cross-source relationships optimized
□ Aggregation strategies implemented where beneficial
Evaluate Model Structure:
Fact Table Analysis:
- Grain definition and consistency
- Appropriate measure columns
- Foreign key completeness
- Size and growth projections
- Historical data management
Dimension Table Analysis:
- Attribute completeness and quality
- Hierarchy design and implementation
- Slowly changing dimension handling
- Surrogate vs. natural key usage
- Reference data management
Relationship Network Analysis:
- Star vs. snowflake patterns
- Relationship complexity assessment
- Filter propagation paths
- Cross-filtering impact evaluation
Data Quality Assessment:
Completeness:
□ All required business entities represented
□ No missing critical relationships
□ Comprehensive attribute coverage
□ Proper handling of NULL values
Consistency:
□ Consistent data types across related columns
□ Standardized naming conventions
□ Uniform formatting and encoding
□ Consistent grain across fact tables
Accuracy:
□ Business rule implementation validation
□ Referential integrity verification
□ Data transformation accuracy
□ Calculated field correctness
Size Optimization Assessment:
Data Reduction Opportunities:
- Unnecessary columns identification
- Redundant data elimination
- Historical data archiving needs
- Pre-aggregation possibilities
Compression Efficiency:
- Data type optimization opportunities
- High-cardinality column assessment
- Calculated column vs. measure usage
- Storage mode selection validation
Scalability Considerations:
- Growth projection accommodation
- Refresh performance requirements
- Query performance expectations
- Concurrent user capacity planning
Performance Pattern Review:
DAX Optimization:
- Measure efficiency and complexity
- Variable usage in calculations
- Context transition optimization
- Iterator function performance
- Error handling implementation
Relationship Performance:
- Join efficiency assessment
- Cross-filtering impact analysis
- Many-to-many performance implications
- Bidirectional relationship necessity
Indexing and Aggregation:
- DirectQuery indexing requirements
- Aggregation table opportunities
- Composite model optimization
- Cache utilization strategies
Maintainability Factors:
Documentation Quality:
□ Table and column descriptions
□ Business rule documentation
□ Data source documentation
□ Relationship justification
□ Measure calculation explanations
Code Organization:
□ Logical grouping of related measures
□ Consistent naming conventions
□ Modular design principles
□ Clear separation of concerns
□ Version control considerations
Change Management:
□ Impact assessment procedures
□ Testing and validation processes
□ Deployment and rollback strategies
□ User communication plans
Security Implementation:
Row-Level Security:
□ RLS design and implementation
□ Performance impact assessment
□ Testing and validation completeness
□ Role-based access control
□ Dynamic security patterns
Data Protection:
□ Sensitive data handling
□ Compliance requirements adherence
□ Audit trail implementation
□ Data retention policies
□ Privacy protection measures
Data Model Review Summary
Model Overview:
- Model name and purpose
- Business domain and scope
- Current size and complexity metrics
- Primary use cases and user groups
Key Findings:
- Critical issues requiring immediate attention
- Performance optimization opportunities
- Best practice compliance assessment
- Security and governance status
Priority Recommendations:
1. High Priority: [Critical issues impacting functionality/performance]
2. Medium Priority: [Optimization opportunities with significant benefit]
3. Low Priority: [Best practice improvements and future considerations]
Implementation Roadmap:
- Quick wins (1-2 weeks)
- Short-term improvements (1-3 months)
- Long-term strategic enhancements (3-12 months)
1. Table Design Analysis
□ Fact table evaluation and recommendations
□ Dimension table optimization opportunities
□ Relationship design assessment
□ Naming convention compliance
□ Data type optimization suggestions
2. Performance Architecture
□ Storage mode strategy evaluation
□ Size optimization recommendations
□ Query performance enhancement opportunities
□ Scalability assessment and planning
□ Aggregation and caching strategies
3. Best Practices Compliance
□ Star schema implementation quality
□ Industry standard adherence
□ Microsoft guidance alignment
□ Documentation completeness
□ Maintenance readiness
For Each Issue Identified:
Issue Description:
- Clear explanation of the problem
- Impact assessment (performance, maintenance, accuracy)
- Risk level and urgency classification
Recommended Solution:
- Specific steps for resolution
- Alternative approaches when applicable
- Expected benefits and improvements
- Implementation complexity assessment
- Required resources and timeline
Implementation Guidance:
- Step-by-step instructions
- Code examples where appropriate
- Testing and validation procedures
- Rollback considerations
- Success criteria definition
□ Model follows star schema principles
□ Appropriate storage modes selected
□ Relationships have correct cardinality
□ Foreign keys are hidden from report view
□ Date table is properly implemented
□ No circular relationships exist
□ Measure calculations use variables appropriately
□ No unnecessary calculated columns in large tables
□ Table and column names follow conventions
□ Basic documentation is present
Architecture & Design:
□ Complete schema architecture analysis
□ Detailed relationship design review
□ Storage mode strategy evaluation
□ Performance optimization assessment
□ Scalability planning review
Data Quality & Integrity:
□ Comprehensive data quality assessment
□ Referential integrity validation
□ Business rule implementation review
□ Error handling evaluation
□ Data transformation accuracy check
Performance & Optimization:
□ Query performance analysis
□ DAX optimization opportunities
□ Model size optimization review
□ Refresh performance assessment
□ Concurrent usage capacity planning
Governance & Security:
□ Security implementation review
□ Documentation quality assessment
□ Maintainability evaluation
□ Compliance requirements check
□ Change management readiness
Focus Areas:
- Functionality completeness
- Performance validation
- Security implementation
- User acceptance criteria
- Go-live readiness assessment
Deliverables:
- Go/No-go recommendation
- Critical issue resolution plan
- Performance benchmark validation
- User training requirements
- Post-launch monitoring plan
Focus Areas:
- Performance bottleneck identification
- Optimization opportunity assessment
- Capacity planning validation
- Scalability improvement recommendations
- Monitoring and alerting setup
Deliverables:
- Performance improvement roadmap
- Specific optimization recommendations
- Expected performance gains quantification
- Implementation priority matrix
- Success measurement criteria
Focus Areas:
- Current state vs. best practices gap analysis
- Technology upgrade opportunities
- Architecture improvement possibilities
- Process optimization recommendations
- Skills and training requirements
Deliverables:
- Modernization strategy and roadmap
- Cost-benefit analysis of improvements
- Risk assessment and mitigation strategies
- Implementation timeline and resource requirements
- Change management recommendations
Usage Instructions: To request a data model review, provide:
I'll conduct a thorough review following this framework and provide specific, actionable recommendations tailored to your model and requirements.
设计创意
设计和实施自动化工作流程,以节省时间和规模化操作作为独家. 用于识别重复任务实现自动化,构建跨工具的工作流程,设置触发器和行动,或优化现有自动化. 包括自动化机会识别,工作流程设计,工具选择(Zapier,Make,n8n),测试,和维护. 触发"自动","自动","工作流程自动…
设计创意
UI/UX设计智能及建筑抛光接口实施指导. 当用户要求UI设计,UX流量,信息架构,视觉风格方向,设计系统/托盘,组件规格,副本/显微镜,可访问性,或生成/critique/refine前端UI(HTML/CSS/JS,React,Next.js,Vue,Svelte,Tailw…
设计创意
创建美丽现代UI的专家前端设计指南. 在构建起落架页面,仪表板,或任何用户界面时使用.
设计创意
设计和输出 n8n 工作流程 JSON 有强力触发器, idempotency, 错误处理, 记录, 重试, 以及 人入"一站"审查队列. 当您需要可审计的自动化时使用.