Events

From BYOD School Systems to Trusted, Actionable Insights Every school records attendance — but very few truly trust it. Different systems, different rules, late corrections, partial absences, compliance requirements… attendance data is messy by nature.This hands-on training shows you how to turn attendance data from any school system into a reliable, operational analytics platform using Microsoft Fabric. Whether your school uses TASS, Compass, Sentral, Synergetic, or another SIS, you’ll learn a BYOD (Bring Your Own Data) architecture that adapts to your systems — not the other way around. 🔍 What Makes This Training Different This is not system training.It’s data architecture and analytics training for schools. Instead of teaching you how to click buttons, we teach you how to: ingest attendance data from any source standardise inconsistent attendance records model period-level attendance properly detect risk patterns early design analytics that support real school decisions The techniques apply whether your data comes from: TASS Compass Sentral Synergetic custom databases or APIs 🛠 What You Will Build (Hands-On) By the end of the training, you will have built a complete, production-ready attendance analytics solution using your own school data (BYOD) or a provided reference structure. You will build: ✔ A source-agnostic ingestion pipeline using Microsoft Fabric✔ Incremental (CDC-style) data loads — no daily full reloads✔ A period-level attendance fact table that handles: late to school late to class partial absences full-day absences acceptable vs unacceptable absences ✔ Business views that turn raw data into: trusted daily attendance reporting late minutes calculation consecutive absence detection recurring late-day patterns ✔ A star-schema semantic model optimised for Power BI✔ Reusable DAX measures for attendance, lateness, and risk✔ A repeatable orchestration pattern you can reuse across other school data 👥 Who This Training Is For This training is designed for: School Data & Analytics Leads IT Managers and Integration Specialists Power BI / Fabric Developers in education System administrators supporting SIS platforms Anyone responsible for attendance, wellbeing, or compliance reporting You don’t need to be locked into a specific system — this training works because it isn’t. 🎯 Learning Outcomes After completing this training, you will be able to: Design attendance analytics that work across multiple systems Implement auditable, incremental ETL pipelines in Fabric Translate messy attendance events into meaningful insights Identify attendance risk patterns early Build reports teachers and leaders actually trust Extend the same architecture to behaviour, wellbeing, and engagement data 🧠 Why Attendance (and BYOD) Matters Attendance is the foundation dataset in schools — but it’s also the most inconsistent. By learning how to model attendance correctly in a BYOD environment, you gain a blueprint you can reuse for: behaviour wellbeing assessments engagement compliance reporting This training doesn’t just solve attendance — it teaches you how to think about school data. 🧪 Format & Approach Fully hands-on BYOD (bring your own school data) friendly Step-by-step build Real school scenarios and edge cases SQL, Microsoft Fabric, and Power BI together Clear explanations of why each design choice matters 🚀 What You’ll Walk Away With A working attendance analytics pipeline built for your school Reusable patterns you can apply to any other dataset Greater confidence in Microsoft Fabric for education A clear path from raw data to operational insight