Profile

Cover photo
Felipe Hoffa
Works at Google
3,046 followers|888,631 views
AboutPosts

Stream

Felipe Hoffa

Shared publicly  - 
 
BigQuery UI secrets #2: You can auto-complete (press TAB)
16
2
Nawaid Shamim's profile photoFelipe Hoffa's profile photoFelipe Hoffa's profile photoRoberto Landrau's profile photo
2 comments
 
it's been there for a while :)
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
 
This is the most fun we've had in the office in a while. We've even made some of those 'Inceptionistic' art pieces into giant posters. Beyond the eye candy, there is actually something deeply interesting in this line of work: neural networks have a bad reputation for being strange black boxes that that are opaque to inspection. I have never understood those charges: any other model (GMM, SVM, Random Forests) of any sufficient complexity for a real task is completely opaque for very fundamental reasons: their non-linear structure makes it hard to project back the function they represent into their input space and make sense of it. Not so with backprop, as this blog post shows eloquently: you can query the model and ask what it believes it is seeing or 'wants' to see simply by following gradients. This 'guided hallucination' technique is very powerful and the gorgeous visualizations it generates are very evocative of what's really going on in the network.
32 comments on original post
2
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
How it feels when people don't want to try BigQuery.

(credits at http://www.reddit.com/r/bigquery/comments/38d8ty/humor_how_it_feels_when_people_dont_want_to_try/)
29
4
Jason Morrison's profile photoJean Joseph's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
Picture this: Briefly after meeting +Jaclyn Kollar, she mentioned she had her genome sequenced by 23andMe (so genotyping). I told her I knew how to use Google BigQuery to explore it - and so we did!

The future is now.

Google Genomics has a full cookbook on how to do this: http://googlegenomics.readthedocs.org/en/latest/
24
5
Charlie Wong's profile photoPeter Mancini's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
 
Cloud Dataflow in beta: already better than lambda in production?  Time to stop writing your code twice, in two different systems, to get both batch and streaming analytics.

(http://lambda-architecture.net/ if you're not familiar with that term.)
3 comments on original post
1
1
Maxim Ostapenko's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
 
My talk from the BigQuery meetup in Stockholm is now public. Mostly it is an introduction, but has some cool demos.
5 comments on original post
3
Add a comment...
Have them in circles
3,046 people
lark miller's profile photo
Juan Bernal's profile photo
roberto miranda's profile photo
Jordan Tigani's profile photo
Verónica Achá's profile photo
María Soledad Hermosilla's profile photo
Mainul Hasan's profile photo
Paul Altman's profile photo
Risto Päärni's profile photo

Felipe Hoffa

Shared publicly  - 
 
 
We recently switched from Godaddy dedicated servers to Google Cloud Compute VM servers and due to that, our system was running nice and cool during this record usage. Here's the CPU track showing a maximum of 27.5% utilization at the time of the record. Our (former) Godaddy server would have collapsed under this load. Godaddy doesn't offer a server powerful enough to handle our requirements. Google Cloud Compute offers plenty of power for about the same cost as the maxed out Godaddy system offered.
2 comments on original post
4
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
An in depth article on how to map the world news thanks to the new CartoDB+GDELT partnership. It even includes my BigQuery example :)

http://blog.cartodb.com/gdelt-api/
In the second addition of our series on clever mapping with GDELT data (see this post from last week), we wanted to take on some more advanced mapping t...
6
6
Deborah Lee's profile photoAlex Gordon's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
3
2
Felipe Hoffa's profile photoAlex Gordon's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
An awesome hackathon this June in Amsterdam! Join if you can (or tell your friends that might come)
 

BigQuery + OpenData hackathon, June 2-4

My buddies at Appsterdam are helping organize the Amsterdam Smart Cities hackathon June 2-4. It's cool for all the reasons hackathons are usually cool: cool location INSIDE the Amsterdam Arena, European-wide exposure, several cool IoT products in the mix (the lovely people at Glimworm iBeacon, and a neat early-startup called Trakkies)

Why should you be excited, other than just being a fun event?

Because I've worked with Tom (Appsterdam) and Jasper (Amsterdam Economic Board) to arrange that all Open Datasets are unified and available in BigQuery. That means you can do your mashups, exploration and analysis over all datasets in the same place. I'm pretty excited about this, there are some Open Datasets in BQ but this is the first time I've seen all data for a Hackathon in one unified place. This includes static data, but also realtime data from OV, Trakkies, energy sensors, more.

You'd start by exploring the data in the BQ web console (just write SQL), find some cool correlations and queries, then throw it into a visualization layer for cool charts, or write a website or mobile app with the many BQ libraries (Node.js, Java/Android, Go, .NET even!)

Signup at the Appsterdam meetup page!
Hack the City and the Amsterdam Arena! Join us for the first Smart City Hackathon at the famous Amsterdam Arena. This is a unique opportunity for programmers, designers & business developers to solve real issues of smart energy, smart mobility and event experience. We are co-organizing this hackathon with Appril. The event partners KPN, Huawei, FAN, Accenture, the City of Amsterdam and the Amsterdam ArenA are offering full access to open & live...
View original post
2
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
How to create a heatmap of worldwide coverage of news for the last 24 hours (in less than 1 minute!)

GDELT+BigQuery+CartoDB
13
23
Nicholas Tan's profile photoNash Maruvada's profile photo
Add a comment...

Felipe Hoffa

Shared publicly  - 
 
Christo Olivier comparing Hadoop (on Azure) vs Google BigQuery w/ 63GB of data.

Monthly costs $4840 vs $1, while magnitudes faster.

Discuss on http://www.reddit.com/r/bigquery/comments/33b5lm/hdinsight_hive_vs_bigquery_a_detailed_comparison/
A while ago I wrote about using Google BigQuery to deliver BI projects faster and for a fraction of cost. Google wrote the original white paper that gave rise to the Hadoop ecosystem we use today f...
9
4
Tyler Larson's profile photoJean Joseph's profile photo
Add a comment...
People
Have them in circles
3,046 people
lark miller's profile photo
Juan Bernal's profile photo
roberto miranda's profile photo
Jordan Tigani's profile photo
Verónica Achá's profile photo
María Soledad Hermosilla's profile photo
Mainul Hasan's profile photo
Paul Altman's profile photo
Risto Päärni's profile photo
Work
Occupation
Developer Advocate
Employment
  • Google
    Developer Advocate, 2013 - present
  • Google
    Software engineer, 2011 - present
Story
Tagline
From Chile. Working at Google. Living in San Francisco.
Bragging rights
"I find a duck's opinion of me is very much influenced by whether or not I have bread." --MH