Visualizing Barcelona’s Public Bikes Usage

Created in 2014 by Nikolay Nenov from Datalect – Original Post nike free 5.0 reviews
Did you know that Spain has the greatest number of bicycle sharing systems in the world? Having a high demand for these makes a lot a sense – the mild winter leaves one no bad-weather-excuses for not biking; and in the summer the bicycle is the most pleasant transport method for going to the beach. But if you have ever tried to go to the beach on the bici (that’s how the public bikes are called in Barcelona) on a lovely Sunday morning, you’ve probably stumbled on your closest station being empty. So you walk under the scorching Spanish sun to the next station, and quite possibly – to the one after that, until you can find a bicycle. Once you finally arrive to the beach, all the stations are now full, and there’s a line of people waiting to return their bicing.

Each time this happened to me, it got me thinking that there should be a way to forecast the demand in order to improve the supply. Fortunately, the guys at CityBikes have provided an API with the momentary availability of bikes. So, I scraped a several days worth of data, averaged the bikes per station and produced the following image. nike air max

The white dots are the stations that are on average (almost) full and the reds are (again almost) always empty.
Great, but this doesn’t help at all with the forecast, because even though the station which is closest to my apartment is in yellow (meaning that on average there are bikes), it is always empty in the morning and always full at night. The obvious solution would be to average the bikes on each station by time of the day and then create an animation with that. And I did. Here’s the result, conclusions and R source code to generate it. nike free shoes

New data set with demographic information by inAtlas

People from the BcnAnalytics community can enjoy the data set provided by inAtlas. It includes information at censal tract level of all Catalonia of the following quantities:

  • Age
  • Gender
  • Nationality

You can download the data set here or via R through the BcnDataAccess package, writing BcnDataSources$inAtlas . footlocker nike free


We want to thank inAtlas for their help.

New dataset: demographic data at census tract level, provided by Idescat

A new data set is at our disposal, containing demographic information of Barcelona at census tract level by gender, provided by Idescat. This data has been obtained from the census of 2001. The data set contains:

  • Age
  • Knowledge of catalan
  • Level of education
  • Main activity
  • Profession
  • Place of birth

You can download the data set here. You have also direct acces from R through the package BcnDataAccess, writing BcnDataSources$Idescat$Cens2001. nike free 5.0 v2
We want to  thank Idescat for providing the data.

BCNAnalytics Inaugural Event is here!

Finally we are launching and this next week we have our inaugural event. It will be at CCCB in Barcelona at 19:00 .

The event will have a formal presentation of the project and a Q&A session with our pannelists. We are very honoured to have among us Cristina Bellido (Data Mining Director at LaCaixa), Frederic Udina (Managing Director Idescat) and Mikael Journo (VP CRM, King Entertainment). After that, we will have some time for networking! air max 90 premium

Come and join us in the BCN Analytics inaugural event where we bring together some of the most famous speakers of the area to explain us how analytics affect their business. Contact us for invitation.


13th November, at 19:00


Centre de Cultura Contemporanea de Barcelona (CCCB).

Montalegre, 5. Barcelona.



Cristina Bellido – Data Mining Director at LaCaixa

Cristina Bellido is the Data Mining Director at La Caixa where she has lead the analytics transformation for the last 12 years applying it to customer and campaign intelligence, geomarketing, among others. Current challenges include the continuous development of the multi-channel strategy and the use of big data. Additionally, she is a professor of CRM marketing at ESADE Business School. Cristina holds a PhD in Economics from the University of Chicago and a degree in Business from ESADE.


Frederic Udina, director de l'Idescat

Frederic Udina – Managing Director Idescat

Frederic Udina is the general manager at the Statistics Bureau of Catalonia since 2011 and president of the Catalan Institute of Public Policy Evaluation (Ivàlua) since 2013. Frederic is also professor in math, probability and statistics at Universitat Pompeu Fabra and at the Barcelona Graduate School of Economics. He holds a PhD in math from the Universitat Politècnica de Catalunya and a degree in math at the Universitat Autònoma de Barcelona. He has published numerous articles, has participated in multiple international research groups and performed consulting in statistics for Morgan Stanley, among others.



Mikael Journo – VP CRM, King Entertainment

Mikael is Vice President CRM for the gaming leader King Entertainment. Mikael has extensive experience leading international strategic, marketing any analytics teams. Prior to King Entertainment Mikael led the analytics and CRM teams at Vistaprint, a global ecommerce leader in its area. Mikael developped his career at strategy consulting companies Boston Consulting Group and Diamond Cluster, currently Oliver Wyman.





Tell me what your story is

As crazy as it might sound, we analysts should be first and foremost storytellers. We usually spend a lot time pooling and crunching data. That’s a must, no doubt… but that is not enough. We need to turn data into information and generate insights. Only then does our work start to make sense (Yes, I have an insight, I am happy man!).

How do I know when I have a good insight? A rule of thumb: if you cannot summarize it in less than 30 seconds then you probably do not have a true insight (or it is still underdeveloped, so keep analyzing!). But let’s say you have a great insight. Is that enough? Not really. At this point what becomes crucial is to present your results in a compelling way. Your goal becomes to connect with your audience (remember, not every audience is the same). The golden rule?  You need to create an emotional connection and make them feel your excitement. new balance 1500
How do I do that? I strongly recommend this fantastic presentation on “, an Analytics Evangelist working for Adobe. The first 10 minutes are a must. new balance 2000


The birth of a new community in Barcelona!

We love data and we love Barcelona. Data has the power to shape every aspect of our life, from the way we understand ourselves to the way we run our cities. Barcelona, the great enchantress, long ago caught us in her midst of great weather, fantastic food, beautiful architecture and passionate citizens (local and foreign). That is why over some beers we decided to join forces to accelerate Barcelona’s transformation into a data-driven city, a city where civil society, government and enterprises benefit from a smart and open use of data. BCN analytics is our non-for profit project whose ultimate goal is to make of Barcelona a European hub for Analytics. If you share a passion for data and Barcelona then join us by signing up and form part of group. new balance 710

An introduction to smart cities

The digital revolution has pushed the limits of our technology to new heights and it has had a deep impact into almost every aspect of human life. Amongst these is the way in which we manage the up-keeping and growth of our cities, where data is playing an ever increasing role. Many models have been imagined, and some of them tried, that leverage data to create what has been broadly termed as smart cities. In the article from The Economist, Mining the urban data, they give a good view of some of the most innovative cities worldwide, which range from Masdar in Abu Dhabi (a start-from-scratch project developing a new city which is planned to be completely powered by renewable energy), to the integration of data into cities like Singapore, which is at the forefront of this wave. The article argues that most smart cities will be built from the bottom up (as opposed to projects like Masdar), and those that do join will reap the benefits of higher productivity.

As we take a closer look at ourselves, what have we done to become a smart city? And what can we do better? nike total air foamposite max

Data driven personalisation: Gilt’s personalised flash sales

I am writing this post today on how Gilt (A leading American flash sales site) is leveraging further the power behind analytics to provide an improved customer experience. Gilt is starting to serve personlised daily offers based on an algorithm that takes into account factors like purchase data and past browsing behavior and combines it with direct customer preferences and feedback. They see it as a core element of their strategy to differentiate and get customer’s attention in a very competitive environment. In a recent interview with Tamara Guzbarg, senior director of analytics and research at Gilt, she stresses the importance of having a consolidated view of the customer across channels and devices to be able to provide real personalisation. new balance 1340

Can smartphone apps make better communities? (research commissioned by Google) has Spain ranking among the highest countries in terms of smartphone penetration (earlier research suggested it might have been even higher on the list only two years ago). Cities can and should leverage the widespread of smartphones to create better platforms of communication for their citizens. For example let’s take a look at what a suburban village of Chicago is doing. The Village of Gurnee has partnered with Nextdoor, an app that specializes in offering social networks for neighbourhoods, to offer a free app aimed at improving the communication among its residents.

If we take the cue from Gurnee and expand on it, the potential that this lends to cities is amazing. Apps could play a key role at creating/enhancing a sense of community, think about simple things like letting your building neighbours know that you will have some repairs done. It can also be a new and effective way to communicate to citizens, for example by letting a particular block know that their power will be shut off for system maintenance. It can also become a central repository for citizens to communicate with their government, by allowing them to log incidents and such. Of course all of this would also provide a host of very valuable data that could be leveraged to better improve the quality of life for the people living in these cities.

If smartphone penetration in Spain is any indication of Barcelona’s reality, then we cannot let this opportunity go unused (lest we forget that Barcelona is also the host to the most important mobile congress in the world). There are plenty of cities already taking advantage of all the opportunities that technology brings. What should we be doing? nike air max womens