This sounds like something for me to look into…
Chris Whong (@) had an interesting data journey which resulted in getting legal access (via FOIL) for the data file of the New York City’s Taxi & Limo Commission (TLC)’s full 2013 taxi tripsheet data. The ensuing collaborations continued the data as bit-torrent files, then as flat files, and more recently as a Google BigQuery project.
From here, I’ll show how to connect Tableau 8.2 to this large data set stored in Google BigQuery. After setting up the required Google account (aka gmail), this data should be freely accessible. Test access to it first through the Google BigQuery Browser tool. [ https://bigquery.cloud.google.com/table/833682135931:nyctaxi.trip_data ]. If it’s accessible there then Tableau access will work since it uses the same authentication. Once confirmed, here are the Tableau connection steps:
Step 1. In Tableau (I’m using 8.2 Mac), begin by selecting the Google BigQuery connection type. The Google Account prompt will appear. Enter credentials and accept the dialog for app…
View original post 483 more words
It Feels Good. And you can really see the dramatic difference in productivity now that my client’s team has some focus.
I’ve been playing with Yesware for a bit, where I’m a member of a Yesware team provisioned by a client. I like the Yesware interface, and its easy integration with Salesforce. And of course, the control freak in one gets addicted to the intel on when your missives are read (and re-read because they’re just that good). But just as I was getting ready to subscribe, I diligently took one more look through the app exchange, where I found that Cirrus Insight basically matches Yesware feature for feature (with the added bonus of having experience and opinions on both offerings).
What really stood out, however, was Cirrus GoogleDrive<–>Salesforce integration: unimaginatively named Cirrus Files.
As they pointed out somewhere in their mess of a site (the worst part of the entire experience is their website’s rather incoherent information architecture, with menus changing unexpectedly and rather jarring shifts in graphic design style: see contrasts below) Salesforce storage is costly; Google Drive is dirt cheap, and is easier to configure for collaboration with parties external to your organization. So, intrigued, I downloaded yet another package and set it up. (Kudos, kids: your video instructions are really in a pedagogical sweet-spot)
It only took a few minutes to deliver this result: