An AI-powered tool for analyzing student enrollment and completion data. Ask questions in plain English and get instant answers with charts and insights.
This toolkit lets you:
- ✅ Analyze student retention rates
- ✅ Track GPA trends by demographics
- ✅ Explore graduation patterns
- ✅ Ask questions in plain English (powered by AI)
- ✅ Generate reports automatically
All with synthetic IPEDS-style data included.
Choose your operating system:
Follow the Windows Setup Guide →
Each guide is written for complete beginners. No command line experience needed!
Time to install: 10 minutes Time to get first result: 2 minutes after installation
Once installed, you'll be able to:
- Start the tool - Double-click
start.bat(Windows) or run./start.sh(Mac) - Ask questions - Type questions like "What's the retention rate for freshmen?"
- Get instant answers - See SQL code, results, and explanations
- "How many students are in each program?"
- "What are the retention rates by race and ethnicity?"
- "Show me average GPA by class year"
- "Which programs have the highest graduation rates?"
- "How many students dropped out vs graduated?"
create_ipeds_db_schema.py- Creates the database structureSyntheticDataforSchema2.py- Generates realistic student dataai_sql_python_assistant.py- AI-powered query interfacevalidate_data.py- Data quality checksanonymize_data.py- Privacy tools
setup.bat/setup.sh- One-click installersstart.bat/start.sh- One-click launchers- Automatic database creation
- Sample data generation
- Windows Setup - Step-by-step for Windows
- Mac Setup - Step-by-step for Mac
- Python 3.8+ (installation guide included in setup docs)
- 10 minutes for installation
- Internet connection to download packages
- OpenAI API key (optional, for AI features - can be added later)
Ask questions in plain English. The AI generates SQL queries, runs them, and explains the results.
Pre-loaded with 2,000+ synthetic students across 8 years, including:
- Enrollment records
- Course grades
- Retention tracking
- Graduation data
- Demographics
- All data is synthetic (no real students)
- Anonymization tools included
- Works completely offline (except for AI features)
- SQLite database format
- CSV export options
- Compatible with Excel, R, Python, Tableau
Check the setup guides:
"Python not found"
- Follow Step 1 in the setup guide for your OS
"Web page won't open"
- Make sure you see "Running on local URL: http://127.0.0.1:7860"
- Open your browser and go to http://localhost:7860
"AI queries don't work"
- You need an OpenAI API key (get one at https://platform.openai.com)
- Add it to the
.envfile (instructions in setup guides)
- students - Demographics and IDs
- enrollments - Term-by-term enrollment with retention flags
- courses - Course catalog
- course_enrollments - Individual course grades
- completions - Degrees and certificates awarded
Follows IPEDS (Integrated Postsecondary Education Data System) standards for higher education reporting.
This is an educational and research tool. All generated data is synthetic and does not represent real individuals.
- Install Python (see setup guide for your OS)
- Download this repository (green "Code" button → "Download ZIP")
- Run the installer (
setup.baton Windows,./setup.shon Mac) - Start the tool (
start.baton Windows,./start.shon Mac) - Open your browser to http://localhost:7860
- Start analyzing! 🎉
Ready to get started?