power-bi-model-design-review
Comprehensive Power BI data model design review framework
by githubFree
Description
power-bi-model-design-review is an agent skill from the github/awesome-copilot collection that reviews the design of a Power BI data model. It evaluates the architecture across several dimensions, starting with schema, where it checks for star schema compliance: a clear separation of fact and dimension tables, consistent grain in each fact table, descriptive attributes in dimensions, minimal snowflaking, and bridge tables for many-to-many relationships. It then reviews the relationships, covering cardinality and filter direction, and the storage mode strategy. Each area has a checklist, so a review is consistent and nothing is skipped. It is useful for modelers who want a second opinion on a model before it grows, and for teams taking over a model they did not build. A review reads the model's design rather than running it, so the findings are a guide to what to check, and any change to a production model should be tested on a copy with the reports that depend on it. The skill is installed with the skills CLI from the github/awesome-copilot repository. Its skills.sh page showed about 8.9K installs and passing results from three security audits at the time of the scan.…
Highlights
- Star schema compliance checklist
- Fact and dimension separation and grain
- Cardinality and filter direction review
- Storage mode strategy
- Installs with the skills CLI
Ratings & Reviews
No ratings yet
Be the first to rate power-bi-model-design-review.
People also visit
powerbi-modeling
Semantic modeling assistant for building optimized Power BI data models
power-bi-report-design-consultation
Comprehensive Power BI design consultation framework covering chart selection
snowflake-semanticview
Build and validate Snowflake semantic views using Snowflake CLI
power-bi-model-design-review FAQ
What does the review check?
Schema architecture, star schema compliance, relationships including cardinality and filter direction, and storage mode.
Is the model run during the review?
No. It reviews the design, so the findings are a guide to what to verify.
How should changes be applied?
Test them on a copy of the model and the reports that depend on it before changing production.
How do I install it?
Run npx skills add https://github.com/github/awesome-copilot --skill power-bi-model-design-review.
What security audits does it have?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best power-bi-model-design-review alternatives?
Popular alternatives to power-bi-model-design-review include powerbi-modeling, cosmosdb-datamodeling and power-bi-dax-optimization. See all power-bi-model-design-review alternatives