Project Benson - MTA Exporatory Data Analysis

Project Benson - MTA Exporatory Data Analysis

A foray into Exploratory Data Analsyis to optimize placement of teams for Event Advertisement.

Back Story

An email from a potential client:

David & Alice

It was great to meet with you and chat at the event where we recently met and had a nice chat. We’d love to take some next steps to see if working together is something that would make sense for both parties.

As we mentioned, we are interested in harnessing the power of data and analytics to optimize the effectiveness of our street team work, which is a significant portion of our fundraising efforts.

WomenTechWomenYes (WTWY) has an annual gala at the beginning of the summer each year. As we are new and inclusive organization, we try to do double duty with the gala both to fill our event space with individuals passionate about increasing the participation of women in technology, and to concurrently build awareness and reach.

To this end we place street teams at entrances to subway stations. The street teams collect email addresses and those who sign up are sent free tickets to our gala.

Where we’d like to solicit your engagement is to use MTA subway data, which as I’m sure you know is available freely from the city, to help us optimize the placement of our street teams, such that we can gather the most signatures, ideally from those who will attend the gala and contribute to our cause.

The ball is in your court now—do you think this is something that would be feasible for your group? From there we can explore what kind of an engagement would make sense for all of us.

Best,

Karrine and Dahlia

WTWY International

Results and Response

Karrine and Dahlia,

It was a pleasure to meet you and present you our findings and recommendations. Our team was rather excited once David and Alice gave us the opportunity to explore the MTA Turnstile data in order to provide WTWY recommendations for strategies of how best to deploy street teams.

We have included here, for your future reference, a link to a web-friendly version of our presentation.

And should you be curious to explore the deeper aspects of our analsis, we have made available several Jupyter notebooks as well.

Do not hestitate to contact us if you wish to explore this further.

Once again, thank you for this opportunity. We wish you the best.

Dean, Derrick, Joseph and Kendall

Presentation

Project Benson Presentation

Appendix

Jupyter Notebooks for Project Benson

  1. Project Benson - Data Clean (small)
  2. Project Benson - Data Clean (large)
  3. Project Benson - Data Analysis
  4. Project Benson - Visualization

© 2017. All rights reserved.