Geocoding and Finding Nearest Station with Google Web Services

This posted started as a question on the Alteryx community about finding the nearest underground (subway if you prefer!) station to an address. I don’t have much experience working with addresses and map data, but thought their was probably a way leveraging the APIs Google maps provide. This feels very much like “standing on the…

Trying out Web Data Connector In Tableau

Having been looking forward to the Web Data Connector from the announcement at last years Tableau conference, I am currently enjoying trying out the Beta. With just some simple JavaScript you can wrap any web data into something directly accessible from the Data connections tab within Tableau. Starting with something I am familiar with, I thought…

Connecting Tableau to Web Data (part 2) – Quandl

My main goal is to connect Tableau in an easy way to my company’s Asp.Net WebAPI site. We use JSON as our interchange format between server code (C#) and the client code (JavaScript and HTML). While that data is only available within my company network it is easy enough to find some JSON data sources…

Connecting Tableau to Web Data (part 1)

I am starting to use Tableau more at work and find it to be generally very good. We have a reasonably large code base built in C#. More and more we have been developing our in-house tools as Web apps within Asp.Net MVC and Asp.Net Web API. In general we use JSON for passing data…

Stupid Date Formats…

I have the annoying task of converting a text file into data (sufficiently annoying I am motivated to create my long delayed blog!). Within the same file there were two date entries: Mon Oct 06 05:19:38 EDT 2014 201486 The first is simple enough, though as quick search will show that EDT could refer to either Eastern…