Case Study 01
How leadership identified the drivers behind a 9% year-over-year enrollment decline.
Leadership observed a significant decline in credential-program enrollment but lacked visibility into where the decrease was concentrated.
The objective was to determine whether the decline was broad across the institution or driven by specific student segments, schools, or programs.
What was the overall YoY change in enrollment?
Which student segments were driving the decline?
Which academic schools were most affected?
Where should leadership focus their investigation first?
Design Strategy
I translated the leadership question into a dashboard structure that moves from executive signal to diagnostic detail: first the YoY decline, then the student segments, academic schools, and program-level views needed to investigate the drivers.
01
Which student groups and academic schools are driving the headcount decline?
02
Confirm the magnitude and direction of the decline over time.
03
Identify which student segments are contributing most to the change.
04
Pinpoint where losses are concentrated so leaders can prioritize review.
01
Show the key metrics first so leaders understand the overall impact quickly.
02
Make the direction and magnitude of change easy to read over time.
03
Expose the drivers of decline and show where losses are concentrated.
04
Use consistent colors and directional indicators to support fast decisions.
9% YoY decline in credential-program headcount.
International Visa students were the largest student-segment driver of the decline.
Continuing Education showed the largest academic-school decline.
Identify where to investigate first and prioritize actions.
Reduced ambiguity around whether the decline was broad or concentrated.
Repeatable view to monitor enrollment movement across years, schools, and student segments.
Requirements Gathering
Data Modeling
DAX Development
Dashboard UX Design
Stakeholder Validation
Power BI Deployment
Next Case Study
How data insights helped optimize classroom utilization and support strategic decision-making.
View case study