Oliver Lock points out to this nice visualization of Foursquare check-ins revealing the pulse of London. The Data Team at Foursquare have created a series of videos like this for Istanbul, London, Chicago, Tokyo San Francisco and New York City.
For those interested in the topic, Anastasios Noulas's PhD thesis can work as a good reference: Human Urban Mobility in Location-based Social Networks: Analysis, Models and Applications.
