Case Study
How SchoolTool Deploys New Insights 3x Faster by Migrating Legacy Dashboards to Amazon QuickSight
Last Updated: November 11, 2026
Update: The dashboards built in this project became Mindex Advanced Analytics®, now a standalone platform that works with any student information system (SIS), not just SchoolTool.

At a Glance
Customer
SchoolTool, an all-in-one student management system built for New York State K–12 schools.
Industry
K–12 Education
Services
Application Modernization & Data Analytics & Visualization
Supporting capabilities: Amazon QuickSight dashboard migration, serverless data architecture, ETL with AWS Glue, and row-level security.
Challenge
Custom JavaScript legacy dashboards with an outdated interface, months-long update cycles, and heavy reliance on a dedicated development team.
Results
New insights brought to market 3x faster, user-built dashboards, and old dashboard databases that can now be retired for a 10% annual cost reduction.
Technology
Amazon QuickSight (SPICE, Row-Level Security), AWS Glue, Amazon S3, AWS Step Functions, AWS Lambda, SQL Server, and Parquet.
3x
Faster to deploy new insights
10%
Annual cost reduction from database retirement
Customer Profile
About SchoolTool
Built for New York State K–12 schools, SchoolTool is an all-in-one student management system that offers intuitive, data-driven, and time-saving tools to manage student information.
In 2009, Mindex introduced SchoolTool Dashboards (IQ) with a strong focus on providing valuable educational insights. The dashboards are integral to the SchoolTool product and have been managed by a small development team.
Opportunity
The Challenge: Aging Custom JavaScript Dashboards That Took Months to Update
- Bringing new data sets and visualizations to market took considerable energy, because each dashboard update required changes to the data warehouse, application layer, and front-end components.
- A new dashboard often took months rather than weeks to reach the market.
- The dashboards relied heavily on a dedicated development team to write custom JavaScript code for every update.
- The custom JavaScript UI had started to show signs of aging, appearing tired and outdated.
Mindex Approach
The Solution: An Amazon QuickSight Dashboard Migration on a Serverless AWS Architecture
Mindex decided to revamp the dashboards into a scalable, cloud-based solution. This Amazon QuickSight dashboard migration moved SchoolTool from custom JavaScript legacy dashboards to a cost-effective, scalable architecture.
- Mindex selected Amazon QuickSight as the advanced business intelligence tool, eliminating the need for a dedicated development team to write custom JavaScript code for dashboard updates.
- The high-level architecture embraces serverless computing and stores data in flat files, departing from the traditional data warehouse approach.
- AWS Glue extracts data from SQL Server, performs transformations, and writes to Amazon S3 in Parquet format.
- AWS Step Functions handles orchestration, and AWS Lambda handles custom SDK API calls.
- QuickSight SPICE caches the data so the dashboards perform seamlessly.

Outcomes
The Results: New Insights Deployed 3x Faster
- Live pilot dashboards: The initial SchoolTool Advanced Analytics pilot test dashboards are now live and fully customizable by Regional Information Centers (RICs) and districts. The team can now respond to dashboard requirements quickly and seamlessly integrate third-party data.
- Democratized dashboard development: Users now have access to the data to build their own dashboards for their specific needs, which was not possible with the custom JavaScript implementation.
- Elevated data security standards: Row-Level Security (RLS) increases data security by eliminating the need to remove personal information from data, giving users full access to relevant data without compromising privacy.
- 3x faster deployment of new insights: What would have taken months can now be brought to market within weeks, helping SchoolTool keep its competitive edge and freeing team members for other critical projects.
- Database retirement and cost savings: The old dashboard SQL Server databases can be retired, leading to a 10% cost reduction annually across all school districts. Those savings can be reinvested into more advanced SchoolTool features, including generative AI.
Where It Is Today
From SchoolTool Dashboards to Mindex Advanced Analytics®
The architecture proven in this project became the foundation for Mindex Advanced Analytics®, a standalone data visualization platform for K–12 districts and higher education institutions on any SIS. Districts can author their own dashboards from the SIS they already use, bring in third-party data and CSVs, ask questions in plain English to generate charts, and create AI-crafted data stories and executive summaries, all protected by row- and column-level security.

Ready to Modernize Your Dashboards?
Turn Your Data into Custom Dashboards and Insights
Whether you’re replacing legacy reporting or building from scratch, our data analytics team designs custom dashboards on AWS that connect your data sources, surface the insights that matter, and scale as your needs grow. Let’s talk about what your data could be telling you.
