Back to work
Data Engineering·2025·Outlearn (Nu High School)
Outlearn Engagement Analytics
PowerBI engagement dashboard for an EdTech platform, delivered in a 48-hour window. Letter of recommendation from the client.
PowerBIDAXM LanguageStar Schema
- Context
- Outlearn (Nu High School) needed to see where students disengaged across lessons, professors, and subjects, delivered inside a 48-hour window.
- Timeline
- Delivered 2025, 48-hour turnaround
- Role
- Data modeling, DAX, report design
What I built
- A star-schema model with a dedicated Calendar dimension.
- DAX measures for trailing 7-day, 30-day, and year-over-year engagement.
- Lesson performance broken out by professor and subject, plus a view showing exactly where the platform loses users.
Architecture
Modeling
Star schemaCalendar dimension
Measures
DAXTrailing windowsYoY
Visuals
Engagement trendProfessor/subject breakdownDrop-off funnel
Interesting decisions
Decision
One Calendar table, not ad-hoc date math
Trailing 7-day, 30-day, and year-over-year windows need consistent date logic across every visual. A single Calendar dimension kept the DAX predictable under a 48-hour deadline instead of repeating date math per measure.
Result
Delivered inside the 48-hour window, with a letter of recommendation from the client afterward.
More case studies
Full-stack
Jumbo / InterStar
Full e-commerce and ERP system. Storefront returning soon after a compliance update.
Read case study
Data Engineering
Lab Data Pipeline
Manual lab operations replaced with a self-updating cloud pipeline.
Read case study
AI & Automation
Competitive Intelligence Agent
An AI agent that runs weeks of market research in minutes.
Read case study