foursquare data @ strata ny 2011

34

Upload: justin-moore

Post on 13-Jul-2015

654 views

Category:

Technology


2 download

TRANSCRIPT

Page 1: Foursquare data @ Strata NY 2011
Page 2: Foursquare data @ Strata NY 2011
Page 3: Foursquare data @ Strata NY 2011
Page 4: Foursquare data @ Strata NY 2011
Page 5: Foursquare data @ Strata NY 2011
Page 6: Foursquare data @ Strata NY 2011
Page 7: Foursquare data @ Strata NY 2011
Page 8: Foursquare data @ Strata NY 2011
Page 9: Foursquare data @ Strata NY 2011
Page 10: Foursquare data @ Strata NY 2011
Page 11: Foursquare data @ Strata NY 2011

San Francisco

Australia

Brooklyn

Page 12: Foursquare data @ Strata NY 2011
Page 13: Foursquare data @ Strata NY 2011

repeat checkin %

Page 14: Foursquare data @ Strata NY 2011

The Adjustment Bureau

Page 15: Foursquare data @ Strata NY 2011
Page 16: Foursquare data @ Strata NY 2011
Page 17: Foursquare data @ Strata NY 2011

Explore

Page 18: Foursquare data @ Strata NY 2011
Page 19: Foursquare data @ Strata NY 2011
Page 20: Foursquare data @ Strata NY 2011

Engineering

Page 21: Foursquare data @ Strata NY 2011

Our StackA

pp

licat

ion

Sta

ck

Scala/Liftweb API Machines WWW Machines Batch Jobs

Scala Application code

Mongo/Postgres/Flat Files

Databases Logs

Dat

a St

ack Amazon S3 Database Dumps Log Files

EMR Hadoop

Hive/Ruby/Mahout Analytics Dashboard Map Reduce Jobs

mongoexport

postgres dumpFlume

Page 22: Foursquare data @ Strata NY 2011
Page 23: Foursquare data @ Strata NY 2011

Massive Intersection Queries

select * from checkins

where user in friends

and venue in nearby

select * from similarities

where venue1 in myHistory

and venue2 in nearby

1

2

3

4

5

a

b

c

d

e

Page 24: Foursquare data @ Strata NY 2011

< 100ms

Page 25: Foursquare data @ Strata NY 2011

Analytics

Page 26: Foursquare data @ Strata NY 2011
Page 27: Foursquare data @ Strata NY 2011
Page 28: Foursquare data @ Strata NY 2011

Goals

• Simple Interface

• Scales with our data

• Cheap (free)

• Supports 90% use cases

• Fast

Page 29: Foursquare data @ Strata NY 2011

Our Internal Dashboard

EMR

Page 30: Foursquare data @ Strata NY 2011

The Team

Page 31: Foursquare data @ Strata NY 2011
Page 32: Foursquare data @ Strata NY 2011

The Anatomy of a Data Team

• Analytics (Stats)

• Science (ML)

• Engineering (CS)

• Mix of all of these!

Page 33: Foursquare data @ Strata NY 2011

Building a Data Team

• It’s hard

• Good references:

– http://radar.oreilly.com/2011/09/building-data-science-teams.html

– http://mathbabe.org/2011/09/25/why-and-how-to-hire-a-data-scientist-for-your-business/

Page 34: Foursquare data @ Strata NY 2011

Join us!

foursquare is hiring

www.foursquare.com/jobs

Justin Moore@injust

[email protected]