Business Questions
Define the key questions leadership needs answered.
Case 01
Enrollment Analytics for Executive Decision Support
Investigating enrollment decline across schools, programs, and student populations.
Academic leaders needed a reliable way to understand where enrollment was declining across academic schools and student populations. I designed a Business Intelligence solution that transformed fragmented reporting into trusted decision support, enabling leadership to identify where attention and intervention should be focused.
Industry
Higher Education
Higher Education
Role
Business Intelligence Analyst
Business Intelligence Analyst
Platform
Power BI
Power BI
Audience
Executive Leadership
Executive Leadership
Focus
Enrollment Analytics
Enrollment Analytics
Business Questions
Key Business Questions
The project was designed to answer five business questions that existing reporting could not consistently address.
- 01Where is enrollment declining across academic schools?
- 02Which student populations are driving the decline?
- 03Which programs require further investigation?
- 04How has enrollment changed over the last five academic years?
- 05Where should leadership focus planning and intervention?
Analytical Approach
Turning questions into decisions
A structured approach was followed to transform business questions into trusted insights and executive decision support.
Data Exploration
Validate, consolidate and understand enrollment data across multiple dimensions.
Analytical Model
Design reusable measures, KPIs and dimensional analysis to answer the business questions.
Executive Dashboard
Transform analysis into an intuitive reporting experience for leaders.
Business Insights
Enable leaders to identify trends, priorities and areas that require further investigation.
Solution Overview
The complete Business Intelligence solution
The final dashboard provides executive leaders with a trusted view of enrollment performance, student populations and academic school trends.
Executive KPIs
High-level monitoring of total students and FTE with year-over-year performance.
Student Segments
Compare enrollment changes across different student populations.
Academic Schools
Identify where enrollment declines are concentrated.
Five-Year Trend
Understand long-term direction and distinguish short-term fluctuations.
Key Business Insights
What the data revealed
The analysis highlighted where enrollment changes were concentrated and where leadership attention should be focused.
01
International Visa students experienced the largest decline.
02
Continuing Education showed the strongest year-over-year decline.
03
Enrollment decreases were concentrated in a limited number of academic schools.
04
Five-year trends helped distinguish temporary variation from sustained decline.
6. Design Decisions
Why the solution was designed this way
Every design decision was made to ensure clarity, trust, and usability for executive stakeholders who rely on this dashboard for planning and resource allocation.
Trust before speed
Validated metrics and business rules were prioritized over fast development to ensure executive confidence in the numbers.
Executives can make decisions with confidence.
Executive-first navigation
The information architecture was organized around key business questions to make insights easy to find and act on.
Leaders can quickly find the insights they need.
Reusable analytical model
Measures and dimensions were designed to support future reporting without rebuilding calculations.
Saves time and ensures consistency across reports.
Scalable architecture
The semantic model allows additional enrollment dashboards to reuse the same analytical foundation.
Built to scale as reporting needs grow.
Let’s connect
I'm always open to discussing data, analytics and opportunities.