Tag Archives: Visualisation

“Where’s the Bus Leh?” Visualising How Singaporeans Ping SG BusLeh

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:

  1. There’s a difference between how SG Bus Leh is used on weekdays and weekends.
    Most folks take it later on the weekends
  2. 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
  3. 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

image

image

image

Visualisations on Tableau Public: How often is SG Bus Leh Used?

When Possible, Visualise DATA

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.

image

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