power-bi-model-design-review
Comprehensive Power BI data model design review framework for evaluating architecture, relationships, and optimization.
- Covers schema architecture, relationship design, and storage mode strategy with detailed assessment checklists across fact tables, dimensions, cardinality, and filter directions
- Includes three-phase review process: model architecture analysis, performance and scalability evaluation, and maintainability/governance assessment
- Provides specialized review types for pre-production validation, performance optimization, and modernization assessment with tailored deliverables
- Offers executive summary templates, detailed report structures, and quick (30-minute) to comprehensive (4-8 hour) review checklists for different engagement scopes
Power BI Data Model Design Review
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.
Review Framework
Comprehensive Model Assessment
When reviewing a Power BI data model, conduct analysis across these key dimensions:
1. Schema Architecture Review
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
More from github/awesome-copilot
git-commit
Execute git commit with conventional commit message analysis, intelligent staging, and message generation. Use when user asks to commit changes, create a git commit, or mentions "/commit". Supports: (1) Auto-detecting type and scope from changes, (2) Generating conventional commit messages from diff, (3) Interactive commit with optional type/scope/description overrides, (4) Intelligent file staging for logical grouping
30.2Kgh-cli
GitHub CLI (gh) comprehensive reference for repositories, issues, pull requests, Actions, projects, releases, gists, codespaces, organizations, extensions, and all GitHub operations from the command line.
21.2Kprd
Generate high-quality Product Requirements Documents (PRDs) for software systems and AI-powered features. Includes executive summaries, user stories, technical specifications, and risk analysis.
17.4Kdocumentation-writer
Diátaxis Documentation Expert. An expert technical writer specializing in creating high-quality software documentation, guided by the principles and structure of the Diátaxis technical documentation authoring framework.
17.4Kexcalidraw-diagram-generator
Generate Excalidraw diagrams from natural language descriptions. Use when asked to "create a diagram", "make a flowchart", "visualize a process", "draw a system architecture", "create a mind map", or "generate an Excalidraw file". Supports flowcharts, relationship diagrams, mind maps, and system architecture diagrams. Outputs .excalidraw JSON files that can be opened directly in Excalidraw.
16.4Krefactor
Surgical code refactoring to improve maintainability without changing behavior. Covers extracting functions, renaming variables, breaking down god functions, improving type safety, eliminating code smells, and applying design patterns. Less drastic than repo-rebuilder; use for gradual improvements.
16.1K