It took a year (of me being mostly lazy) before I turned the really nice dataset from SG BusLeh [get it from iTunes | Google Play] into a visualisation.
I didn’t know what to ask. So I just explored the data willy-nilly. In part, to try Tableau on different datasets; in part, to quickly generate visualisations to find questions.
Here’s what I found:
- There’s a difference between how SG Bus Leh is used on weekdays and weekends.
Most folks take it later on the weekends
- People seem to take a while to get “into the groove” after a weekend. On Mon and Tue, folks ping the app during perceived rush hour timings (7 to 830am). From Wed to Fri, they’re actually getting out of the house earlier
- Lotsa pings on Fri night. No surprises there
I’ve put up the visualisations on Tableau Public: How often is SG Bus Leh Used?
Appreciate any feedback on them!
Shouts to SG BusLeh (iTunes | Google Play) for releasing their data
Visualisations on Tableau Public: How often is SG Bus Leh Used?
I’ve been prepping reports and cleaning datasets for the last few weeks.
It’s no different from my other data projects – except that I’m using Tableau to visualise the reports. I’ve always thought that visualising data was really all vanity.
Now I’m a convert. Visualising the data makes it so easy to see relationships between dimensions! The Viz below (go to Tableau Public for a live demo) is a Google Keyword Search & Competition Visualiser.
I built the Keyword Visualiser to answer this question:
I got 1,100 keywords from Google Keyword Planner.
How do I know which ones to focus my social listening efforts on first?
Continue reading When Possible, Visualise DATA