We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Maveryx Success Stories

Learn how Alteryx customers transform their organizations using data and analytics.

Showcase your achievements in the Maveryx Community by submitting a Success Story now!


The Academy Group Summer Program

7 - Meteor

Name: Caleb Catalano
Title: Consultant
Collaborators: Alteryx for Good/Slalom Consulting
Academy Group Logo.PNG
Overview of Use Case

The Academy Group had a need for systematic daily data entry and dashboard reporting (based on that data) for their 2017 Summer School program. Using a combination of Google Forms, Alteryx Designer w/ Scheduler, and Google Data Studio The Academy Group (in partnership with Alteryx for Good), was able to create daily on-demand reporting for their Summer Program.


Describe the business challenge or problem you needed to solve

The Academy Group was a brand-new organization when this engagement began. They were not yet at a level of maturity in their data strategy to quickly capture and report data. As the Summer School Program began, leaders realized they needed a way to track daily student metrics, including attendance, engagement, grades, and behavior. There was very little budget for this work and a short turnaround time before the program started. Alteryx served as the centerpiece for combining and transforming multiple data streams into a rapid reporting framework that delivered on their data requirements. Alteryx Scheduler ensured that the daily data inputs were processed at frequent and consistent intervals, funneling actionable insights to dashboards which teachers relied on for daily status monitoring.

Describe your working solution


8x Google Forms (data input)

12x Google Sheets (gradebook input)

Alteryx Designer (using Google Sheets Input/Output and Listrunner tools)

Alteryx Scheduler

7x Google Data Studio Dashboards

Describe the benefits you have achieved

This solution provided the Academy Group with end-to-end individualized and aggregate reporting on their students. Most importantly, it allowed teachers to spend their time in the classroom, instead of toiling away in Excel. The automated data pipeline allowed for rapid insight gather which lead to improved interventions for students. 


Related Resources
Case Study Deck Attached