CASE STUDY
Tracking Growth with Purpose: How Aspect Boosted Student Outcomes
Industry: Education (Special Needs & Inclusion)
Solution Area: Student Development & Academic Progress Monitoring
Client: Aspect (Autism Spectrum Australia)
Tools Used: Power BI, Microsoft SQL Server, Data Models

Business Impact
60% Time Saved
Automated reporting reduced manual data compilation efforts for teachers and administrators.
Early Intervention
Improved visibility into developmental milestones enabled support for at-risk students.
Informed Teaching Decisions
Class- and campus-level analytics guided resource allocation and tailored teaching strategies.
The Challenge
Aspect schools support students on the autism spectrum across multiple campuses. Teachers and administrators needed a centralised system to monitor student progress on social, emotional, and academic milestones. The existing reports were fragmented and inconsistent, making it difficult to answer key questions:
-
How are students progressing in communication and interaction skills?
-
Which areas require additional assistance or intervention?
-
How do outcomes vary across classes, campuses, and year levels?
-
Can data visualisations reveal early patterns of growth or challenges?
Educators were spending significant time compiling assessment results manually, leaving less time for instruction and one-on-one support.
Our Solution
GrowthBI developed a Power BI–based Academic Performance Dashboard that unified student assessment responses from all campuses into a single, interactive analytics view.
The solution enabled Aspect schools to measure student development systematically and use data to guide teaching strategies.
Key Features:
-
Student Progress Analysis: Tracks communication, social interaction, and behavioural milestones (e.g., initiating greetings, maintaining eye contact, recognising emotions).
-
Performance Segmentation: Categorises responses into Meeting Independently, Working with Assistance, and Not Meeting for actionable intervention planning.
-
Academic Engagement Analytics: Measures participation in classroom discussions and collaboration with peers.
-
Drill-Down Flexibility: Filters available by School, Campus, Class, and Student for detailed insight.
-
Response Distribution: Highlights the most frequently observed skills and learning gaps to prioritise support.
Dashboard Walkthrough
1️⃣ Student Progress Analysis
Purpose: Measure and visualise progress across developmental milestones.
Key Visuals:
-
Bar chart comparing Meeting Independently vs Working with Assistance vs Not Meeting by question category.
-
Impact: Enabled educators to identify specific developmental areas requiring focus and recognise students’ growth trajectories.
2️⃣ Academic Performance Analytics
Purpose: Evaluate classroom participation and learning outcomes.
Key Visuals:
-
Charts displaying frequency of independent participation and assisted engagement across various skills.
-
Impact: Provided clarity on both academic readiness and support dependency, guiding differentiated instruction.
3️⃣ Response Analysis
Purpose: Drill deeper into the types of responses and their distribution.
Key Visuals:
-
Segmented bar charts for Meeting Independently, Working with Assistance, and Not Meeting responses.
-
Impact: Highlighted top developmental priorities and recurring skill gaps across campuses.
4️⃣ Detailed Student Records
Purpose: Provide individual-level tracking for teachers and therapists.
Key Visuals:
-
Student-specific tables showing all questions, responses, and progress categories.
-
Impact: Simplified review meetings and parent communication with accurate, evidence-based reports.

Technical Architecture & Process
[SQL Server Database]
│
▼
[Data Model – Assessment Integration]
(Power Query M / Stored Procedures)
│
▼
[Power BI Data Model]
- Students Table (Name, Class, Campus, Year)
- Assessments Table (Skill, Response, Category)
- Question Table (Question ID, Learning Area)
- Performance Table (Meeting/Assistance/Not Meeting)
│
▼
[Power BI Dashboards]1️⃣ Student Progress Analysis
2️⃣ Academic Performance Analytics
3️⃣ Response Analysis
4️⃣ Student Records
1) Data Extraction:
-
Student assessment results extracted from the central SQL Server database.
-
Consolidated across all schools and year levels.
2) Transformation & Modeling:
-
Power Query transformations applied for data cleaning and normalization.
-
Categorisation logic applied to segment responses into Independent, Assisted, or Not Meeting.
3) Visualization Layer:
-
Power BI visuals designed for clarity and accessibility.
-
Role-Based Access (RLS) ensures teachers can only view their respective classes and campuses.
-
Export and sharing options integrated for progress reviews.
Conclusion
The Aspect Academic Performance Dashboard transformed fragmented assessments into actionable insights for teachers, specialists, and administrators.
By consolidating developmental and academic progress data across all campuses into a unified, interactive platform, Aspect schools gained real-time visibility into each student’s learning journey. The solution empowered educators to plan timely interventions, personalise learning, and continuously improve outcomes for students on the autism spectrum.