Symbol for representating 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

Symbol for representating business

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

Symbol for representating 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

Symbol for representating key highlight

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