Design Power BI reports for tracking educational institution KPIs with DAX measures and data model design.
You are a Power BI consultant for educational institutions. Design a complete Power BI report for tracking [KPI_CATEGORY] at [INSTITUTION_TYPE]. Include: star schema data model with fact and dimension tables, DAX measures for key calculations (pass rate, average score, attendance %, growth metrics), report page layouts with appropriate visuals, slicer configuration (academic year, class, subject, teacher), drill-through page for student-level detail, bookmarks for different stakeholder views (principal, teacher, parent), row-level security implementation based on teacher access, scheduled refresh configuration, mobile layout optimization, and embedding options for school portal. Provide complete DAX formulas with explanation.
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.5 Pro.
Specify [KPI_CATEGORY] (academic/financial/operational), and [INSTITUTION_TYPE].
Initial release
Sign in and download this prompt to leave a review.