Belfast Bike Hire Rentals & Returns

Screenshot of the Tableau Dashboard. Available [here] and at the end of this post.

 [Note: the dashboard is best viewed in Full Screen (F11) Mode]

 This Visualisation uses two datasources provided by OpenDataNI. The first is the Belfast Bike Hire Rentals and Returns dataset (https://goo.gl/fjkRj3). Along with the numbers or Rentals and Returns, it is broken down by Location, Month, and Year. Each location name is accompanied by a Station Number. This is used as the key to join to the Belfast Bike Hire Stations dataset (https://goo.gl/CxpjXM) which, among other things, has contains the Latitude & Longitude (even if it is mistitled 'Longfitude'). There are a number of location naming inconsistencies in the Rentals data, so I've used the names as supplied in the Stations resource instead.

The left side of the visualisation is taken up with a map of central Belfast. There is a dot for every Bike Station, sized by the number of Rentals or Returns & coloured on a diverging Red-Blue palette for added clarity. The colour palate is continued on the bar chart to the right, listing Bike Stations by popularity. Above this, a trending a simple line chart plots the popularity of Rentals and Returns by month.

 To this I have added a very simple Pickup vs Drop Off Analysis. I've simply subtracted the numbers of Rentals from the Returns and graphed the differences. Positive numbers (in the blue colour) indicate that more bikes were picked up at these locations than were dropped off. The other end of the graph shows the minus figures (in orange) indicating locations where more bikes were dropped off rather than picked up. A preliminary analysis of this data indicates that, on the whole, bikes were picked up at locations peripheral to the city and deposited in the centre, rather than the other way about.

The data can be investigated further using the Date Range Callipers and the filter to switch between Rentals, Returns, or show both together. As always, clicking on a dot or bar (Ctrl+click for multiple selections) filters the other graphs accordingly.

Icon by Freepik from www.flaticon.com is licensed by CC 3.0 BY

 If there are issues with this embedded version, try the dashboard on my Tableau Public page [here]. Best viewed in Full Screen (F11) Mode

Location: Belfast, UK

Comments

Post a Comment

Popular posts from this blog

Renewable Heat Incentive (RHI) non-domestic beneficiaries: an interactive analysis of the data

Image
Screenshot of the Tableau Dashboard. Available [ here ] and at the end of this post. (Updated: see notes at end) After much legal wrangling and foot-dragging, the Northern Ireland Department of the Economy have finally published a partial list of recipients of money from the botched Renewable Heat Initiative scheme . At present only limited companies and limited liability partnerships who received in excess of £5,000 (cumulative) are listed. The data runs from the start of the scheme to 28 February 2017. After the list was published (16 March 2017) a number of people complained that they should treated as individuals, and not as limited companies. These corrections were made and a second list was issued the same afternoon. The dataset used here is based on this second list. The first thing I want to note about the document made available by the Department of the Economy is that it is presented as a PDF. This is data! To analyse data you need it in a suitable format su...
Read more

Emergency Care Waiting Times in Northern Ireland 2008-2017 and forecasting the future

Image
Screenshot of the Tableau Dashboard. Available [ here ] and at the end of this post. [Note: the dashboard is best viewed in Full Screen Mode ( F11  or icon at bottom right )] Having attended the rather excellent Open Data Camp 5 , held in Belfast over the weekend of 21-22 October 2017, I have returned to OpenDataNI’s datasets with renewed vigour and fervour. The first of these I’ve turned my attention to is the recently published  Emergency Care Waiting Times dataset. The Dataset The dataset is just over 2100 lines, representing monthly entries per Northern Irish hospital and running from April 2008 to June 2017. The dataset gives the numbers of patients who waited up to four hours, five to twelve hours, and over twelve hours. A further column gives the total number of patients in these three categories. As noted, the hospital name is given for each entry, and this is supplemented by the NHS Trust they work under and the Type of Emergency Department (1-3) p...
Read more

United States Federal Executive Orders

Image
Screenshot of the Tableau Dashboard. Available [ here ] and at the end of this post. [Note: the dashboard is best viewed in Full Screen (F11) Mode] Back in early 2016, when Trump was still seen as unelectable, he directed a portion of his Twitter barrage against President Obama on the latter’s use of Federal Executive Orders . I’m not going to pretend that I’m so politically astute that these comments caught my attention at that time. However, when commentators started to contrast Trump’s statements with his actions once in office, I immediately felt that this was a place where a visualisation of the data would be of use and interest. In my defence, I would note that I’m not so naïve that I believe that actual facts and figures hold sway any longer in either US or British politics … we can but try! The datasource My initial experimentations and explorations of this data started with the List of United States federal executive orders Wiki page. This is quite high-level d...
Read more