rweisssieker-xp Power BI Expert Review
Use this skill when the user wants to reduce dependency on many Power BI experts by standardizing review quality.
Review Priorities
- Business correctness: KPI definitions, grain, filters, date basis, exclusions.
- Model correctness: facts, dimensions, relationships, cardinality, ambiguity, many-to-many, role-playing dates.
- DAX quality: explicit measures, context handling, time intelligence, performance, naming, folders.
- Power Query and source design: folding, incremental refresh, privacy levels, gateway, credentials, schema drift.
- Report UX: page purpose, slicer consistency, visual choice, drillthrough, exception workflows.
- Security and governance: RLS/OLS, sensitivity, workspace, certification, deployment, ownership.
- Validation: source totals, row counts, financial reconciliation, RLS test users, refresh monitoring.
Output Requirements
- Lead with findings ordered by severity.
- Use concrete evidence from files, specs, DAX, or model descriptions when available.
- Separate blockers, high-risk issues, maintainability issues, and improvement opportunities.
- End with a short remediation checklist.
Assets
assets/review-checklist.md: reusable review checklist.