The Academy Group Summer Pilot - PowerPoint Presentation

Slide1

The Academy Group Summer Pilot

An Alteryx Case Study

Caleb Catalano – Slalom ConsultingSundeep Vira – The Academy Group

1

2

Introduction

Alteryx for Good

The Partnership

The Mission

The WorkQ&A

Today’s Agenda

3

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.

DENVER

LONDON

MINNEAPOLIS

BOSTON

HARTFOR

D

TORONTO

PORTLAND

ATLANTA

NEW YORK

SEATTLE

SAN FRANCISCO

SILICON VALLEY

BOISE

PHILADELPHIA

PHOENIX

ORANGE COUNTY / SAN DIEGO

LOS ANGELES

SALT LAKE CITY

WASHINGTON D.C.

4,000+

employees internationally

5 delivery centers

Providing cross-market support via

25 markets

Offices in

Our Markets

4

ST. LOUIS

DETROIT

CHICAGO

DALLAS

HOUSTON

FORT WORTH

5

Slalom: Information Management and Analytics (IM&A) capabilities

Advanced Analytics

Predictive Analytics

Optimization

SimulationModel DeploymentText AnalyticsBusiness IntelligenceData Visualization & DiscoveryDashboardsSelf-ServiceMobile BI

Data Discovery

Data Visualization

Data Management

&

Modern Data Architecture

Data Modeling

Data Warehousing

Big Data Ecosystem

Scalability

Performance

Information Governance

Data Governance

Master Data Management

Security

Data Quality

Data Integration

Information Strategy

Roadmap

Change Management

Operating Model

Program Management

Alteryx Partner of the Year 2016 & 2017

Over 20 Alteryx Certified Consultants in Chicago

Academy Group – About Us

The Academy Group is a new enterprise established to create a sustainable source to educate students from underserved communities.Launched in 2017, The Academy Group

anticipates establishing Academies in cities nationwide, with up to 20,000 young people in the pipeline. The Academy Group is acquiring partners across multiple sectors in order to secure job placement for our graduates

Academy Group companies invest earned revenue in the human capital engine

, creating a sustainable approach to ensuring the nation’s best talent will rise

The Academy delivers world class academics, college/career training, and supports to ready youth for exceptional futures

Build

foundational

&

business

skills ...

...

Open doors

to

industry ...

Internship opportunities for high school and college with top tier firms

Unparalleled access to commercial leaders

Custom college counseling and test prep (ACT/SAT)

...Support the journey

Scholarships support for all program graduates

Targeted social and academic supports

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

Exceptional youth from

underserved

communities enter programming...

... Exit upon entry

into careers and executive track

Summer Pilot Overview

Grades 3-5

Grades 6-8

Grades 9-12

School year programming

CollegeSummer programmingSupports provided

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

Summer internships

Placement at top tier firms to build resumes and hard skills

Networking opportunities

Chances to grow social capital with commercial leaders

College counseling

College credit bearing coursework

ACT/SAT prep

Career and summer job placement services

Personalized support finding roles

World class 6 week long summer program

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

Academic services

College/career services

The Academy Group Summer Pilot

9

General Program Overview

:

6-week instructional program

30 third graders from Chicago Public SchoolsFour SubjectsBusinessTechnology

Fitness

Justice

Three subcategories within each subject

Excellence

Determination

Excellence

8 Google Forms, 12 Google Spreadsheets and 113 student demographic fields

The Academy Group Summer Pilot

10

Desired Outcomes (Measurables)

:

Improve student outcomes on standardized metrics

Evaluate program efficacy

Project OverviewPARALLEL CONTENT

11

Google Forms

Alteryx

Google Sheets

Google Data Studio

Teachers input data to Google forms:

Attendance

Grades (Google Sheets)

Classroom observation

Merits/Demerits

And more…

Using Google D

rive 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

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

Dat

a studio source data live from Google sheets.

Permissioned through email address

12

Teacher enters student data into forms daily.

Google Forms

Google Forms provides a simple way to teachers to

enter data the same way each data,

Ease of use

Google Forms creates a ridged structure around data collection that ensure data

values are entered within range, and data structure is consistent.

Data Validation

1

2

Google Forms allows the sender to provide unique access to participants and logs user activity on each Form.

Security

3

slalom.com

13

Runs transformations on Google Forms data daily.

Alteryx

Alteryx takes lives data from Google Forms/Sheets

Input

Google Forms/Sheets data is cleaned, unpivoted and blended with student demographics.

Transformations

1

2

Resulting data files are output to Google Sheets

Output

3

slalom.com

14

Creates live, interactive visualizations based on Google Forms inputs.

Google

Dat

a Studio (beta)

Google

Dat

a Studio sources data live from Google Sheets.

Live Data

All Google Data Studio visuals are filterable by a range of values and dimensions

Interactivity

1

2

Google

Dat

a Studio provides reasonably robust visualizations for free!

Free

3

slalom.com

15

Alteryx allowed The Academy Group to swiftly stand-up a reporting process using freely available tools.

Pairing Alteryx and the G-Suite allowed a non-profit organization high quality rapid cycle reporting that would have been much more expensive to execute using other BI tools.

Alteryx bridges the data

gap and adds utility to otherwise desperate and simple platforms.

If your organization already has Alteryx, this can be a low-cost data visualization solution – but beware of potential data governance issues. Potential use cases for Alteryx and Google Data Studio are numerous.

Why Alteryx?

16

As we look forward, we intend to continue to build out new and different ways to analyze the data we collect.

Future Reporting

We look forward to developing the ability

to batch out report cards/summary status reports about each student on-demand.

Alteryx PDF Reporting

When the pilot is finished, we intend to investigate potential interplay between variables and access program efficacy.

Data Analysis

1

2

A critical piece of our on-going work is to obtain a license for Alteryx scheduler so that we can automate our processes.

Scheduling

3

slalom.com

17

Q&A

slalom.com

18

Caleb Catalano

caleb.catalano@slalom.com

Thank you!