What problem does it solve? Power BI data models often suffer from poor schema design, inefficient relationships, and performance bottlenecks that are hard to spot without a structured review process. This Skill provides a systematic framework for auditing model architecture, identifying optimization opportunities, and ensuring adherence to star schema and Microsoft best practices. ## Core Features & Use Cases - Comprehensive Model Assessment: Evaluates schema architecture, relationship cardinality, storage mode strategy (Import, DirectQuery, composite), and DAX efficiency across three review phases. - Structured Review Outputs: Produces executive summaries, prioritized recommendations, and detailed reports with implementation guidance and rollback considerations. - Specialized Review Types: Supports pre-production go/no-go reviews, performance optimization audits, and modernization assessments with tailored checklists. - Use Case: A BI team inherits a slow Power BI model with many-to-many relationships and bidirectional filters. Use this Skill to run a performance optimization review and receive a prioritized roadmap of fixes. ## Quick Start Ask the assistant to review your Power BI data model design, providing the model's tables, relationships, storage modes, and any known performance concerns.
