Status
Not started
About project
Provide an overview of the project’s goals and context
Action items
Documents
Embed Google Drive
Embed Figma
Power BI Dashboard Inspiration: QS World University Rankings Analytics
📊 Dashboard Architecture & Page Structure
‣
Page 1: Executive Overview (Landing Page)
‣
Page 2: Geographic & Regional Analysis
‣
Page 3: Institutional Characteristics (Size, Focus, Research)
‣
Page 4: Performance Indicators Deep Dive
‣
Page 5: Diversity & Internationalization
‣
Page 6: Year-over-Year Trends & Ranking Movement
‣
Page 7: Employment & Sustainability Insights
‣
Page 8: University Detail Profile (Drill-Through)
‣
🎨 Design & Formatting Guidelines
‣
🔄 Interactivity & User Experience
‣
📱 Mobile Layout Optimization
‣
📊 Advanced Features to Showcase Skills
‣
🎯 Portfolio Presentation Tips
‣
📋 Data Model & Relationships
‣
🚀 Performance Optimization
✅ Final Checklist Before Publishing
Data Quality:
No blank/null values in key fields (impute or filter)
Consistent text formatting (Title Case for Institution names)
All measures return expected values (spot-check)
Date table created and marked as Date Table (if temporal analysis)
Visuals:
All charts have descriptive titles
Axes labeled clearly
Legend positioned consistently (right side preferred)
Color scheme consistent across pages
No overlapping text or visuals
Interactivity:
All slicers work as expected
Cross-filtering behaves correctly (use Edit Interactions if needed)
Drill-through functions properly
Bookmarks capture intended states
Tooltips display relevant info
Performance:
All pages load in <3 seconds
No red flags in Performance Analyzer
File size <100 MB (compress if needed)
Documentation:
Add "About" page explaining data source, update date, methodology
Include your name/contact in footer
Add "Last Updated" date in page header
Testing:
Test on Desktop, Service (web), and Mobile
Share with colleague for UX feedback
Verify with different filter combinations
💡 Additional Ideas to Stand Out
- AI Narrative Generator: Use Power BI's AI narratives visual to auto-generate insights per page.
- Custom Visuals:
- Chiclet Slicer: More stylish than default slicer
- Timeline Slicer: If you have multi-year data
- Sankey Diagram: Show flow of universities between ranking tiers
- Radar Chart: Compare universities on all indicators
- R or Python Visuals:
- Correlation matrix heatmap (Python: seaborn)
- Cluster analysis (Python: scikit-learn K-means) to group similar universities
- Row-Level Security (RLS):
- If sharing with university administrators, set up RLS so each sees only their institution
- Roles table:
UserRole[Email] = USERPRINCIPALNAME() - Automated Refresh:
- Set up scheduled refresh in Power BI Service (requires Premium or Pro)
- Useful if rankings update annually
- Export to PowerPoint:
- File → Export → PowerPoint
- Creates slides of each page for presentations
- Publish to Web (if appropriate):
- File → Publish to Web → Generate embed code
- Share dashboard on LinkedIn/portfolio site
- Warning: Only for non-sensitive data
🎓 Learning Resources Referenced
Power BI Concepts Used:
- Grouping & Binning Data
- What-If Parameters
- Field Parameters
- Drill-Through Pages
- Report Tooltips
- Sync Slicers
- Bookmarks
- Mobile Layout
- Conditional Formatting
- DAX Measures & Variables
- Star Schema Modeling
- Performance Analyzer
Where to Practice These:
- DAX: DAX Studio (free tool) + your dataset
- Visuals: Power BI Playground (sample datasets)
- Modeling: AdventureWorks database (Microsoft sample)
This comprehensive guide gives you a professional, multi-page dashboard structure that showcases advanced Power BI skills while being practical for analyzing university rankings. You can copy-paste sections into Notion and adapt specific visuals/DAX to your needs.
Next Steps:
- Import your dataset into Power BI Desktop
- Create dimension tables for clean modeling
- Build Page 1 (Executive Overview) first as your foundation
- Progressively add pages 2-8, testing interactivity as you go
- Apply design theme and conditional formatting
- Test thoroughly before publishing
Let me know if you'd like me to elaborate on any specific page, DAX measure, or visual technique!