Visualizing Barcelona Datasets

Mani Yaswanth
4 min readSep 25, 2019

--

In this blog we will cover how to visualize given data using appropriate medium and how to condense dashboard in such a way that at one glance audience must understand everything without sacrificing anything important or compromising clarity

Coming to Barcelona data-sets, here there are 15 data-sets that tells 15 different things about Barcelona and their people.

First we start with accidents data-set, Of course it is obvious that every person wants to have a safe journey when they travel. So, Accidents data-set provides us the information about where all accidents are happening. By this each person will know that what are accident prone areas and what are not. Next time if he is going in that area, he will be careful. We will see how to visualize this data.

Graph 1:

Horizontal bar Graph(Fig1)

From this figure we can see that we were given information about 10 districts and some unknown district information which means that we know that accidents have happened but we don’t know that it’s from which district. In this case we use bar graph because bars are best for comparing categories. From this graph we can easily tell that Eixample is having more number of accidents. By this information if someone wants to go to Eixample will be careful;)

Graph 2:

Horizontal Bar Graph (Fig2)

In this graph we will see that the rate in which accidents are happening with respect to month. By knowing this information user may be careful that particular month or we can also perceive like according to busy months accidents are more like in may it is holidays time so roads will be busy so there are so many chances for accidents.

*From Fig2 we can see that the rate of accidents are more in November followed by May, October, …

Here is an important lesson. We know that whenever we are having an interval scale like Jan, Feb, …… we use line graph but here we used bar graph because though we are having interval scale we are comparing between months to check the rate of serious injuries in every month. So, in this case we use bar graph.

Graph 3:

We wanted to check the rate of accidents in year w.r.t to month, in this case we use line graph because we are seeing the rate at which accidents are happening with respect to month whether it is increasing or decreasing.

Graph 4:

we will see a part to whole graph. As we know that pie chart is best for part to whole data. But pie chart is not used usually because of the visual ambiguity in some cases which is some of the slices may be around same percentage where in that case those slice may be indistinguishable. So, pie charts are not recommendable.

Now we will get some insights from births data

Graph 5:

Actually in this graph we can include table instead of bar graph, but if we include table it will be difficult for the user to compare between different cells of the table. In this way it will be best for the user to actually differentiate between each district and their information.

Graph 6:

This graph is used because we are comparing two categorical variables with one domain(Year). So, we are using these graph instead of using single bar graphs or part to whole bar graphs

Graph 7:

Actually why we have used line graph in the above situation, We have used line graph because we are showing the trend of births across years. By this, we will know whether birth rate is increasing or decreasing across years.

These are some basic graphs, these graphs are used for some basic plotting. In my next blog I will show some advanced graphs and where we can use those.

Here is the link for my next blog consisting of some advanced graphs

--

--