Gus Cavanaugh

Say No to Tableau

I don't care what the question is

Python, not Tableau, should be your next dalliance with data analysis outside of Excel. When I talk to people about data, invariably I hear the same refrain about Tableau. Everyone believes it is a silver bullet that will solve their heretofore Excel-driven data challenges. I hate to break it to you, but Tableau is not your answer.

. . .

Read More

May 29, 2015

VM - Go Full Screen!

Making your VMware Player Linux VM go full screen

If you have just started with Hadoop, you will likely have downloaded a quick start VM from Cloudera or HortonWorks. This means you downloaded VMware Player or VirtualBox to run your VM.

If you are like me, you choose (VMware Player)[]and noticed that . . .

Read More

May 18, 2015

Spark RDDs

Defining some terms for dummies like me

Read the Spark paper

If you are interested in Spark, you may have heard of the Spark paper,Resilient Distributed Datasets: A Fault-Tolerant Abstraction for In-Memory Cluster Computing. All the cool programmers reference these papers (GFS, MapReduce,BigTable, and while I certainly would not want anyone to confuse me with them, I . . .

Read More

May 11, 2015

Classy Excel Pivot Tables

Making Ron Burgundy proud with Classic Pivot Table view

There are few things in the world that will remain classics: Casablanca, John Daniels and choosing the Pivot Table “Classic View” when presenting. For those who were not around when the classic view was the standard view, you missed out on a design advantage. Much like how the bench seat in the front row of a car is far more helpful than . . .

Read More

May 10, 2015

Installing Spark locally on Windows

Easy for everyone except me

This should be easy. Of course, I screwed it up royally.

Make sure you download a pre-built version of Spark from their downloads page.
The default option is the source code, which requires you to build Spark with Maven.

Make sure you have Java Installed

Written instructions for installing Java on . . .

Read More

May 10, 2015

Why Code?

The Data

Willie Sutton, the bank robber, has much to teach us about coding. After he was finally captured by the authorities he was asked by a reporter why he robbed banks. As it is attributed (very likely misquoted but who cares - don’t let the truth interrupt a good story), he replied, “because that’s where the money is”. Similarly for you, the . . .

Read More

May 09, 2015

Stop Using VLOOKUP

For the love of God

Do you still get your music from Napster? How many friends do you chat with on AIM these days? You’ve moved on to sneakier ways of pirating music and chats with your friends that disappear. So why are you still writing VLOOKUPs?

I know those analogies are unfair. Downloading music from Napster was illegal and AIM is only beneficial . . .

Read More

May 09, 2015