Jun 18, 2016

Where to Live in Barcelona in a Dashboard


Barcelona best barrio visualization


Sometimes data can tell a story much faster and effectively than many words. That's why I´ve decided to start sharing more data stories via this blog, hoping to both:

  1. address specific topics readers want to dive in (often these will not be data-people, they would be new to my blog, probably coming after googling a specific questions e.g. "which are the best boroughs to live in Barcelona?").
  2. showcase data visualization tools and best practices to present your data (these are data-people, yes you my regular readers, you might like to see a tool in action).
I will mainly make use of Tableau Public to build and share the data visualizations. Tableau Public is basically the free version of Tableau Software. You can take advantage of the great analytics power offered by Tableau, make amazing visualizations quickly and share them on the web (remember that once published they are all freely accessible to everybody). There is a huge community of people sharing stories via Tableau Public (take a look at the Tableau Public Gallery here) and it is very popular in data journalism.

Back to this post, this quick data viz story is about the city of Barcelona and its boroughs. As the title says, the dashboard aims to help users explore and choose the best borough to live in, given a set of variables. These are:

  • rent price (avg. rent price for a 50 square meter apartment)
  • sales price (avg. sales price for a 50 square meter apartment) 
  • safety 
  • green areas 
  • a short tourism description
The dashboard is composed of three viz:

  1. A map showing how Barcelona it is divided by its 10 main boroughs ("distritos"). The colour scale indicates the average renting price: the darker is the colour and the more expensive is renting in that area. If you click on any of the borough, the correspondent tourism description will show up in the below section.
  2. A vertical bar chart which lets you compare boroughs by different variables using a drop-down filter.  
  3. A bottom section containing the tourism description of the borough selected in the map.
In the "data sources" I provided the sources of data.  


Below is the viz, I hope enjoy it. Any issue, you can view it here in my Tableau Public profile.




I know it's quite a simplified model in terms of variables considered. Choosing where to live is a complex decision and you'll probably take into account many more factors like proximity to your job/school, public transports, nightlife, etc. etc.  

But, like I did in other previous posts about dashboards, I like proof of concepts (POC) and this wants to be mostly a proof of concept. Can an interactive data visualization help you choose the best place to live in a city? I think so. At least it can narrow down your focus in your initial search for a house, especially when you are new to it. Often you need to check out many websites before you can get an idea of how a city is structured. A dashboard equipped with relevant information can help you explore a city much more quickly.

We need more dashboards about cities!

Why Barcelona? It´s one of my favourite cities. I have been to Barcelona 5 times, always as a tourist, and if you ask me which city would you like to move in the future.... guess which one?


PS: would you like to enrich this dashboard with more relevant info? Feel free to suggest other variables and sources of data and I will try to include them.

14 comments:

  1. Hey there! Quick question that's entirely off topic. Do you know making your site mobile friendly? My wepost looks weird when viewing from my iphone. I'm searching for a theme or plugin that will have the ability to fix this problem. When you yourself have any suggestions, please share. Cheers! Air Ambulance Service

    ReplyDelete
  2. Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though. live football

    ReplyDelete
  3. With almost everything which appears to be building inside this particular subject matter, all your points of view are rather stimulating. Nonetheless, I am sorry, but I can not subscribe to your whole suggestion, all be it radical none the less. It would seem to everybody that your commentary are actually not entirely validated and in reality you are your self not even fully confident of your point. In any case I did enjoy examining it. singapore ecommerce

    ReplyDelete
  4. I’ve read several good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to make such a great informative site.hearing aids batteries

    ReplyDelete
  5. Hi my friend! I want to say that this post is awesome, nice written and include almost all significant infos. I’d like to see more posts like this.eBay

    ReplyDelete
  6. I think this is one of the most significant info for me. And i am glad reading your article. But wanna remark on few general things, The web site style is ideal, the articles is really great : D. Good job, cheers. hire a PPC company

    ReplyDelete
  7. Simply desire to say your article is as amazing. The clarity on your post is simply great and that i could think you're knowledgeable in this subject. Fine along with your permission allow me to grab your RSS feed to keep updated with approaching post. Thanks 1,000,000 and please keep up the rewarding work. event agency in Singapore

    ReplyDelete
  8. This is really interesting, You're a very skilled blogger. I have joined your feed and look forward to seeking more of your great post. Also, I have shared your web site in my social networks! restaurant catering Singapore

    ReplyDelete
  9. I know this if off topic but I'm looking into starting my own blog and was wondering what all is required to get setup? I'm assuming having a blog like yours would cost a pretty penny? I'm not very web savvy so I'm not 100% certain. Any suggestions or advice would be greatly appreciated. search engine optimization explained

    ReplyDelete
  10. Hey! Do you use Twitter? I'd like to follow you if that would be ok. I'm absolutely enjoying your blog and look forward to new updates. Create a robots.txt file

    ReplyDelete
  11. Hello there! Would you mind if I share your blog with my myspace group? There's a lot of folks that I think would really enjoy your content. Please let me know. stem education

    ReplyDelete
  12. I think that thanks for the valuabe information and insights you have so provided here. Free Football stream link

    ReplyDelete
  13. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what youre talking about, why waste your intelligence on just posting videos to your blog when you could be giving us something enlightening to read? attractive call to action

    ReplyDelete
  14. Great info and straight to the point. I don't know if this is in fact the best place {to ask} but do you people have any thoughts on where to hire some professional writers? Thanks in advance :) responsive design

    ReplyDelete