Paste your Google Webmaster Tools verification code here

Idescat’s 250m grid population data

We are glad to announce that population data in a 250m grid from Idescat is now available. Here you can find the following fields from the 2011 census ‘Registre de Població’ from January 1st of 2014:

  • Total population
  • Men and women population
  • Population by ages: 0-14, 15-64, more than 64 and more than 85


Click to enlarge
Click to enlarge

You can also find the (R) code to create the map of any of the variables above in the BcnAnalytics github account

We would like to thank Idescat for their support.




Personalization in CRM event review

On March 9th, 2015 BCNanalytics was proud to host its second conference, “Personalisation in CRM”.

  • 198 people registered
  • 165 people atteneded
  • 83 empty beer bottles by the end of the event

The event was hosted at the Mobile World Centre and was attended by people representing  industries like banking, e-commerce, consulting, gaming, fashion, telecom, as well as academia and independent entrepreneurs.

To start off the event we had Manuel Bruscas, co-founder of BCNanalytics, present some of the key news of our organisation, like the creation of a job board on our site and some of the potential events we would like to organise like a hackathon or workshops.

Manuel presenting

We had Pau Agulló, also co-founder of BCNanalytics, introduce our two keynote speakers and later serve as moderator during the Q&A session.

Pau  presenting speakers

Our first speaker was Pier Paolo Rossi, current director of Business Intelligence at Banc Sabadell. Pier Paolo’s presentation covered a wide range of examples coming from his multi-industry experience having worked in telecomms (Movistar), retail (Caprabo) and lately banking (Banc Sabadell). He showed how personalisation can be applied to pricing, product, information layout and other areas of your business to expand the lifetime engagement and experience of your customers. His talk highlighted two points we would all do well to remember: “you can’t manage what you can’t measure” and “your customer is the most important thing”.

Pier Paolo Rossi

Our second speaker was Llorenç Solà, Director of CRM and Customer Strategy for Vistaprint Europe. Llorenç explained us that using personal content in communication wins over non-personalised approaches because it allows a business or organization to become more relevant to their users. He also reminded us that appropriate personalisation is by no means easy to achieve, since it always involves: data storage, analysis, statistical modelling and a user friendly strategy around frequency of touch points. There was particular emphasis given on the last point applied to email practices. In his opinion if long term performance is desired then email campaigns should not be measured simply by gross revenue. That would only lead to the controversial practice of mass emailing, which can arguably degrade your ability to communicate and influence your customers. Instead performance should be measured by the efficiency by which you get customers to interact with your communication.

Llorenç Solà

After the presentations our keynote speakers formed a panel and we discussed what had been presented. The audience was actively engaged with many questions for our presentors. Regarding the role of privacy in personalisation, one opinion was that if done right, personalisation is welcomed by customers. When asked which channel to use for communication the answer was that you should make your customer choose the channel for communication that they want. Other questions addressed the role of people and technology, as well as further discussion on the impact of limiting the amount of emails sent to customers in favor of more personalised content.

The conference closed with a networking event with free beers provided by our sponser Estrella Damm. People took this opportunity to ask further personal questions to our keynote speakers as well as meet fellow members of Barcelona’s analytics community. Thank you all for making this event a success. Please help us decide on our next event as well as ideas for other events by filling out this survey.

Beer time!!

 




Upcoming event: 9th March Personalisation applied to CRM

We are pleased to announce our upcoming BcnAnalytics meeting. The focus will be on: “Personalisation applied to CRM”. In other words we address one of the key topics for many organisations: ‘how to better manage the relationship with your customers’.We will have a panel with Pier Paolo Rossi (Director Inteligencia y Desarrollo de Negocio at Banco Sabadell), Llorenç Sola (CRM Director – Vistaprint Europe) and Inés Urés (CMO at Groupalia).

If you want to attend, please register at the following link.

When:

9th March, at 19:00 (doors open at 18:30)

Where:

Mobile World Center (next to Plaça Catalunya).

Fontanella, 2. Barcelona.

Who:

Pier Paolo RossiPier Paolo Rossi  is the Business Intelligence Director at Banc Sabadell since September 2014. Previous to that, he was the Customer Marketing Director at Caprabo. He has a broad range of experience applying data analysis in such different industries as retail and banking . He holds an MBA from IE and a degree in Industrial Engineering from UPC with the specialization in nuclear energy.

 

Llorenç SolàLlorenç Solà  is Head of CRM and Customer Strategy at Vistaprint Europe (Nasdaq: VPRT). More than 15 years developing data driven marketing strategies and CRM. International career in strategy consulting advising multinationals in Europe, America and Middle East. He is also one of the cofounders of BCNAnalytics.

 

inesInés Ures is the CMO at Groupalia, e-commerce leader in health & beauty, leisure and retail discounts. She’s a mathematician and an engineer, and a lover of data based marketing. In the past, Inés has held different positions in marketing and project management in Atrapalo.com and she has also worked at Deloitte and Sara Lee.

 




Participation in 2012 catalan elections

Created in 2014 by Josep Marc Mingot from Arcvi – Full Screen Map


http://www.newbalanceshoesinc.com new balance 993
The data was extracted from the Barcelona City Council report about the 2012 elections. This data has already been integrated in the R package bcndataaccess.
http://www.nikefreerunshoesplus.com nike free 5.0 trainer
The visualization has been done using the CartoDB map visualization software that let you visualize maps and share the results as interactive plots. The administratives divisions of Barcelona (by districts) can be found at the GeoportalBCN as shape files . The shape files can then be esaliy updated to CartoDB.




Visualizing Barcelona’s Public Bikes Usage

Created in 2014 by Nikolay Nenov from Datalect – Original Post
http://www.nikefreerunshoesplus.com 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.
http://www.airmaxfreedom.com nike air max
bici

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.http://www.nikefreerunshoesplus.com 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 .
http://www.nikefreerunshoesplus.com 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.
http://www.nikefreerunshoesplus.com 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!
http://www.airmaxfreedom.com 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.

When:

13th November, at 19:00

Where:

Centre de Cultura Contemporanea de Barcelona (CCCB).

Montalegre, 5. Barcelona.

Who:

cristina

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

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.
http://www.newbalanceshoesinc.com 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.
http://www.newbalanceshoesinc.com new balance 2000
http://success.adobe.com/en/na/programs/products/digitalmarketing/analytics/1405-50811-data-storytelling-nike/w4Uu47AR.html?ev=event35&faas_unique_submission_id=%7bEA2CF805-EA2B-D809-BF20-D8AD5FEB6D48%7d&s_cid=70114000002JBzTAAW

 




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.

http://www.newbalanceshoesinc.com new balance 710




Barcelona Data Lovers