| 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
- 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?
- Translate to model requirements:
- fact tables
- dimensions
- relationships
- required measures
- Translate to report structure:
- KPI row
- main explanatory visual
- supporting detail
- slicers/filters
- short interpretation text
- 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.
