
Client
The customer is a Data Analytics, an organization that offers a specialized platform to perform data analysis for school improvements. It is a trusted partner for districts, schools, and educational agencies. They are a team of former teachers, principals, education experts, researchers, designers and data scientists, who have been revolutionizing K12 education for almost a decade

Business Requirement
The customer was struggling with onboarding new school districts, with accurate data, and within defined timelines. The entire process was being executed manually. It required a linear scale-up of capacity to cater to the growing list of school districts lining up for onboarding. The customer wanted a technology partner who had hands-on experience in Big Data & Analytics projects, sound experience in data ETL, with in-depth knowledge of the Education domain

Solution
- Magic performed Data Research within the SnapLogic reference implementation, including deep study and analysis of the data inconsistency patterns across the 120+ school districts
- This helped us design a solution that could be applied to various school districts, with the least customization, through templatized data pipelines
- These were useful and could easily be replicated for processing similar kinds of datasets of other school districts

Key Highlights
- Reducing the time spent in moving data into Google Sheets
- Integrations and new business templates were completely automated
- ETL’s Centre Of Excellence (COE) was successfully delivered