powerbi

---

name: powerbi description: Business analytics workflow for Power BI: translate business questions into model needs, DAX measures, report pages, KPIs, and interpretation. Use for planning dashboards, cases, and analytical storytelling.

Power BI Business Analytics

Use this skill when the work is about the business question, KPI design, dashboard structure, or analytical interpretation.

Workflow

1. Clarify the business question:
   • Who is the audience?
   • What decision should the report support?
   • What is the grain of analysis?
   • What dimensions and filters matter?
2. Translate to model requirements:
   • fact tables
   • dimensions
   • relationships
   • required measures
3. Translate to report structure:
   • KPI row
   • main explanatory visual
   • supporting detail
   • slicers/filters
   • short interpretation text
4. Validate the result:
   • measures make business sense
   • visuals answer the question
   • assumptions/limitations are documented

Output format

Business question:
Audience:
Required data/model:
Measures:
Report page plan:
Interpretation:
Validation:

Good Power BI habits

• One page should answer one business question.
• Prefer explicit measures over implicit aggregations.
• Use business names, descriptions, and consistent formatting.
• Report conclusions should say what to do, not only what changed.