// portfolio & end solutions

Your data. Every angle.

The same student insight can reach a principal through a Power BI dashboard, a teacher through a Slack alert, a parent through a text message, or a school board through an animated presentation. This portfolio shows how to build all of it — and teach others to do the same.

📊 Tableau ⚡ Power BI 📱 SMS / Text 💬 Teams 🟣 Slack 🥽 AR Glasses ✦ Same Data, Different Views
🎯
Right Data, Right Person
A teacher needs to know about one student. A principal needs to see a whole school. A board needs district trends. The delivery format should match who's receiving it.
⏱
Right Format, Right Moment
A 40-page PDF is useless at 7:45 AM before first period. A text message with one flag is perfect. The medium shapes whether people act on the insight.
🔄
Same Analysis, Many Surfaces
The delta calculation doesn't change — what changes is how it's wrapped. Build once in Python, deliver everywhere. This curriculum shows you how.
// platform 01
📊
Tableau
Interactive dashboards for exploration and presentation

Tableau turns your Python-generated datasets into interactive dashboards that administrators can explore themselves — filtering by grade, teacher, time period, or risk level without needing code. It's the tool that makes your analysis feel alive in a boardroom.

District-wide attendance heat map — color-coded by week, filterable by school, grade, and demographic. Hover over any cell to see the delta from the prior week.
Early warning dashboard — students in the top quartile of declining trajectories, updated nightly. Clickable to individual student history pages.
Intervention outcomes tracker — before/after GPA and attendance for every intervention type, with comparison group included.
Community interest overlay — geographic map of district with local event venues, economic indicators, and student home clustering.
Early Warning Dashboard · District 4
// attendance delta · all schools · week 6
Stable
Watch
Declining
23
Flagged
−8%
Avg Delta
6
Critical
// platform 02
⚡
Power BI
Automated reporting integrated with Microsoft 365

Most school districts are already in the Microsoft ecosystem — Teams, Outlook, SharePoint. Power BI drops directly into that world, letting administrators see live reports inside their existing workflow without opening a new tool. Automated refresh means the principal's dashboard is always current.

Weekly executive summary — auto-generated report delivered to school leadership every Monday morning showing the prior week's top 10 students by declining trajectory.
Staff analytics report — teacher assignment history, experience distribution, and turnover impact on student outcomes, updated monthly.
Intervention pipeline — which students are referred, what for, who handles it, and what the measured outcome is. Built for the counseling team.
Board presentation package — scheduled PDF export of key metrics, formatted for school board meetings. No manual work required.
District Analytics · Power BI
Weekly Student Risk Summary — Week of Oct 14
18
At Risk
34
Watch
189
Stable
7
Improving
// platform 03
📱
SMS / Text Alerts
Push the right flag to the right person at the right moment

Not every educator is sitting in front of a dashboard. A counselor walking the hallway, a vice principal in a meeting — the most actionable alerts go to wherever people already are. SMS-based early warning systems push the right signal at the right moment, without requiring anyone to log in.

Morning attendance flag — counselors receive a text by 9:30 AM for any student who has been absent 3+ consecutive days, with a link to their attendance history.
Grade delta alert — teachers receive a weekly summary text of students whose assignment-level GPA dropped more than 0.5 points in their class that week.
Parent notification — opt-in, FERPA-safe messaging that gives families a weekly "your student's engagement score" without exposing raw data.
Intervention reminders — scheduled check-in reminders to counselors when a student's follow-up window is approaching or has passed.
Messages · DLI Alerts
Today 9:14 AM
⚑ EARLY WARNING: Marcus T. (Gr 8) — 4th consecutive absence. Att. rate: 68% (↓28% from Week 2). Action recommended.
9:22 AM
Thanks — I'll follow up this morning. Is this the same pattern as last month?
Yes. Last month delta was −12%. This month −28%. Trajectory is accelerating. Link: [attendance history]
Weekly Digest · Friday 4:00 PM
📊 WEEKLY: 3 students flagged for GPA decline >0.5 pts this week. 1 student showing food insecurity pattern (lunch-only, Day 22+). Full report: [link]
// platform 04
💬
Microsoft Teams
Alerts and bots inside the collaboration platform staff already use

Teams is where many school districts already communicate — meetings, documents, announcements. A DLI bot drops early warning alerts directly into the channels where the right people are already watching, complete with clickable cards and action prompts.

#early-warning channel — automated daily post listing students flagged overnight, with color-coded severity and one-click links to full history.
Intervention bot — counselors can type @DLIBot check Marcus T. and get an instant summary of attendance, GPA, and behavior deltas in the chat.
Weekly digest card — adaptive card posted to the leadership channel every Monday with key metrics, trends, and recommended actions.
💬 Microsoft Teams — DLI Early Warning Bot
💬
📣
📅
📁
# early-warning-alerts
DLI
DLI Alert Bot Today 8:01 AM
Good morning. Overnight analysis flagged 4 students for declining trajectories. 1 is critical.
⚑ CRITICAL — Marcus T., Grade 8
Attendance −28% over 4 weeks. GPA declining 2nd consecutive week. Recommend counselor contact today.
// platform 05
🟣
Slack
For districts and charter networks that run on Slack

Charter networks, innovative districts, and education nonprofits often run on Slack instead of Teams. The DLI alert architecture is platform-agnostic — the same Python pipeline routes to Slack channels, slash commands, and workflow automations just as cleanly.

Slack workflow triggers — when a student crosses a delta threshold, a Slack workflow fires automatically, notifying the assigned counselor in their DM.
/student command — any staff member with access types /student lastname and gets a private, FERPA-safe summary in 3 seconds.
Digest to #data-team — weekly summary with trend charts rendered as image attachments, giving the data team a running record of what the system caught.
🟣 DLI Workspace · #student-alerts
🤖
DLI Bot Today at 8:03 AM
📊 Weekly Digest — Oct 14
↓ 4 students declining · 2 improving · 3 new flags
→ View full report
JM
J. Martinez 8:17 AM
/student thompson
Aisha T. · Gr 7 · ID 1042
Att: 88% (↓6% wk) · GPA: 2.9 (↓0.3) · Behavior: stable
Risk level: ⚠ Watch
// the next frontier

Seeing Data From a Different Point of View

Smart glasses. Voice interfaces. Walking through your own data. The delivery surface is evolving — and the curriculum shows you how to think about data output for formats that didn't exist five years ago.

Coming Soon
🥽
AR Smart Glasses Overlay
A teacher walks into first period — and their AR glasses show a subtle overlay above each student's seat. Green ring: on track. Yellow: watch. Red: talk to them today. No device to check. No dashboard to open.
// concept output
Student: Marcus T. · Seat 3B
Att delta: −28% ⚑ · GPA: 2.4 ↓
Action: [counselor notified]
Concept
🗣️
Voice-First Data Queries
"Hey DLI, who do I need to talk to today?" — a voice interface connected to the early warning pipeline answers in plain language, without the educator needing to touch a screen. Designed for the hallway, not the office.
Q: "Who's declining this week?"
A: "Three students. Marcus T. is most urgent — attendance dropped 28% over four weeks. Want me to notify his counselor?"
Available Now
🎬
Animated Data Presentations
Flying through bar charts while narrating what's happening. Zooming into the inflection point. Watching a student's attendance graph animate week by week. This is how you make a school board feel the urgency — not just see the numbers.
Tools: matplotlib animate
+ ffmpeg + narration overlay
Output: MP4 ready for any meeting
Available Now
🗺️
Geographic Story Maps
Where do your students live? Where do your teachers come from? Overlay economic zones, transportation routes, and event venues. When you see it on a map, the equity gaps and community opportunities become impossible to ignore.
Tools: Folium / Kepler.gl
Layers: students · staff · economy
Output: Interactive HTML map
In Development
📲
Progressive Web App
A lightweight mobile PWA that counselors and teachers bookmark on their phone. Morning check-in shows their flagged students for the day. No login. Push notifications. Works offline. Designed for real school workflows.
Stack: Python backend
+ FastAPI + vanilla PWA
Push via web-push protocol
Exploring
🖥️
Hallway Display Boards
School hallway screens that show anonymized, aggregate data in real time — not individual students, but school-level trends. "This week 94% of students attended every day." Positive culture + data literacy for the whole building.
Output: Raspberry Pi display
Rotating slides · no PII
School pride + transparency
// same data, different audiences

One Analysis. Many Surfaces.

The delta calculation is the same for everyone. How it's packaged depends entirely on who needs to act on it — and when.

// classroom teacher
One Student. Right Now.
A teacher gets a Slack DM or text at 7:45 AM: one student name, one data point, one suggested action. No dashboard. No login. Just what they need before the bell rings.
SMSSlack DMTeams message
// school counselor
My Students. This Week.
A daily morning digest of every student on the counselor's caseload — sorted by urgency, with trend direction and recommended follow-up. Enough context to prioritize the day.
Power BIEmail digestPWA
// principal / admin
The Whole School. At a Glance.
An interactive Tableau dashboard showing school-wide trends — filterable by grade, teacher, risk tier, and time period. Updated nightly. Available on desktop or tablet.
TableauPower BITeams digest
// school board / district leadership
The Story. In Under 5 Minutes.
An animated presentation that flies through the key charts, highlights the patterns that matter, and delivers a clear narrative about what the data is saying — and what needs to happen next.
Animated videoStory mapPDF export