Agenda

• Define project scope and data sources
• Define enrollment type classification
• Define program parameters
• Define marketing tracking requirements
• Define expected outcome

Minutes

Project

• Title: Atlas (renamed from Adminless)
• Scopes: IONs, EPN

Data Sources

• Kuitansi (receipts / transactions)
• Siswa (students)
• Aktivitas Marketing
  • Judul (title)
  • Tanggal (date)
  • Target

Timeframe dimensions

• Tahun sekarang (current year)
• Tahun lalu (last year)
• Tahun terbaik (all-time best year)

Enrollment Types

• Siswa Baru — no prior enrollment across any unit
• Siswa Lanjut — re-enrolled within 1 year
• Siswa Alumni — re-enrolled after more than 1 year

Program Parameters

• Program and program category columns already exist in source data
• Examples: German Regular, Japanese Regular, Korean Regular, Privat Non English, Spanish Regular

STP (Segmenting, Targeting, Positioning)

• Segmenting: Jenjang studi (education level)
• Targeting: Sekolah (schools)
• Positioning: TBD

Marketing

• Categories: Konvensional, Digital Marketing
• Tracking: Target vs Realisasi (target vs actuals)
• Channel metrics:
  • Jumlah respon masuk = siswa lanjut (leads = renewal students)
  • Jumlah follow up (follow-ups)
  • Jumlah siswa closing = dari data keuangan (closings sourced from financial data)

Conclusion

• A new structured database is needed as a single source of truth
• System will normalize data from existing xlsx sources
• Pipeline evolved to: Sync → Transform (dbt) → Format → Present
• Architecture adopted: Modern Data Stack, ELT, DuckDB (analytical) + LibSQL (operational)
• Project renamed from Adminless to Atlas

Actions

• Define full data model in model.md
• Create glossary mapping Indonesian terms to internal English terms
• Design sync adapter for xlsx sources
• Define analytics layer in analytics.md
• Define architecture in architecture.md
• Build @packages/db — Drizzle schema
• Build @packages/sync — xlsx adapter
• Build @packages/transform — dbt models
• Build @packages/format — report assembler
• Build @services/present — PPTX generator
• Build @services/dashboard — TanStack Start app