The exhibit Big Band Data now has moved to Madrid and I was required to adapt my project based on Barcelona in order to show data from Madrid.

That was a good opportunity to adapt my project to another city because that would let me comparing behaviors between 2 cities. It took me a few hours to obtain and transform shapefiles from Madrid, retrieve all the data again and re-run all the data transformation process but the result worth it:

Captura de pantalla 2015-03-17 a la(s) 18.28.28

In this occasion not only the city but the neighborhoods and the community of Madrid are also plotted, so you have more insight about the movements of the customers.

As customers are grouped by their origin (based on its postal code), the fact of showing the paths traveled by all the customers from its origin to the point where the purchase is done reveals that some shopping center act as ‘demographic walls’, as customers from the city don’t move to city outsides and customers from neighborhoods don’t go into the city:

Comparing data between Barcelona and Madrid, notice that the behaviors of the customers is pretty similar: the number of transactions increase to a maximum during the previous days before Christmas. It’s then when the activity falls to a minimum. For the rest of the inspected period both cities share a similar behavior. Another expected point is that the amount of expenditure is much greater in Madrid (3x for city’s citizens and around 2x for citizens living close the city) customer-behaviours

Have your say

About me

Data Visualization · Interactive · HCI · Open Data · Data Science · Digital Humanities

More info here and here: