The Academy Group Summer Pilot An Alteryx Case

The Academy Group Summer Pilot An Alteryx Case Study

Alteryx for Good is a network of passionate Alteryx users collaborating with nonprofit organizations and educators to enable their data to thrive. It’s their way of giving back to drive social change or support the development of the next generation of data analysts.

4, 000+ 25 markets 5 delivery centers

Business Intelligence Advanced Analytics Data Visualization & Discovery • • • Dashboards Self-Service Mobile BI Data Discovery Data Visualization Predictive Analytics Optimization Simulation Model Deployment Text Analytics Information Strategy Data Management & Modern Data Architecture • • Data Modeling Data Warehousing Big Data Ecosystem Scalability Performance • • Roadmap Change Management Operating Model Program Management Information Governance • • • Data Governance Master Data Management Security Data Quality Data Integration

Exceptional youth from underserved communities enter programming. . . Open doors to industry. . . • Internship opportunities for high school and college with top tier firms Build foundational & business skills. . . • Personalized academic advising • Year round, high dosage, customized tutoring • Innovative curricula including case method, seminar, and personalized learning formats • World-class 6 week immersive summer programs Top tier Academics Elite college / career programming Wraparound supports . . . Support the journey • Scholarships support for all program graduates • Targeted social and academic supports • Unparalleled access to commercial leaders • Custom college counseling and test prep (ACT/SAT) . . . Exit upon entry into careers and executive track

Academic services College/career services School year programming Grades 6 -8 Grades 9 -12 College Dedicated academic advisor provides support all throughout program into careers Academic programming delivered 1 -3 nights per week and select Saturdays High dosage tutoring • 2 -3 days per week • Builds foundation Enrichment • Introduce business concepts, advanced math practice High dosage tutoring • 2 -3 days per week • Accelerate growth Enrichment • Solve business problems, introduce analytics High dosage tutoring • As needed for academic success Enrichment: • Advanced case method coursework utilizing analytics • College counseling • College credit bearing coursework • ACT/SAT prep World class 6 week long summer program Summer programming Supports provided Grades 3 -5 • Evolving case-based seminar style curricula builds year over year enabling students to acquire deep experience solving business problems and build communication skills. Coursework covers finance, economics, accounting, strategy and marketing • Programming extends beyond business covering advanced topics critical to society (social justice) and foundational skills to leading industries (e. g. coding) Career exposure and pathway education • Opportunities to visit top tier local organizations from high profile industries • Guest speaker and career guidance series with leaders of local enterprises Career and summer job placement services • Personalized support finding roles Summer internships • Placement at top tier firms to build resumes and hard skills Networking opportunities • Chances to grow social capital with commercial leaders

General Program Overview: § 6 -week instructional program § 30 third graders from Chicago Public Schools § Four Subjects § Business § Technology § Fitness § Justice § Three subcategories within each subject § Excellence § Determination § Excellence § 8 Google Forms, 12 Google Spreadsheets and 113 student demographic fields

Desired Outcomes (Measurables): § Improve student outcomes on standardized metrics § Evaluate program efficacy

Google Forms Teachers input data to Google forms: § Attendance § Grades (Google Sheets) § Classroom observation § Merits/Demerits § And more… Alteryx Using Google Drive Developer API, and the Google Sheets Tools Alteryx sources live data from Google Forms and transforms data. § One data source per Dashboard § All sources blended with student demographics file Google Sheets Alteryx writes new unpivoted data files back to Google Sheets using Google Drive Developer API. Google Data Studio connects to Google Sheets data sources and creates interactive data visualizations § Dashboards in Data studio source data live from Google sheets. § Permissioned through email address

1 2 3

1 2 3

1 2 3

1 2 3

Thank you! Caleb Catalano caleb. catalano@slalom. com