ACS Commuting Statistics Dashboard in Tableau

ACS Commuting Statistics Dashboard in Tableau

After creating the Tableau Web Data Connectors (WDCs) in the previous posts, I thought I’d learn how to create some basic visualizations in Tableau using them to extract US Census data. In keeping with another popular theme of the blog, I focused on the commuting data available in the US Census American Community Survey. I’m not sure exactly what I expected from Tableau. It is really popular right now and is, no doubt, a slick presentation tool. Like any complex…

Read More Read More

Mapping Census Tracts in Tableau

Mapping Census Tracts in Tableau

As a follow up to my previous post on the US Census Tableau web data connector I created, I wanted to also share another web data connector that allows Tableau users to selectively import Census Tract shapes for mapping within Tableau. The Census Tract is a key geography within US Census data, and it is the one that my commute map was based on. I wanted to figure out how to map at this level as I played with the…

Read More Read More

Tableau, Census Data, and Web Data Connectors

Tableau, Census Data, and Web Data Connectors

Tableau seems to be very hot right now. At least I seem to see it listed frequently when I’m looking through job postings. From my perspective, Tableau takes a lot of the presentation power of Excel (not so much the high power modeling features of Excel) and moves it into a more contemporary platform, by which I mean it is browser-based. I’ve developed many, many scorecards, charts, visualizations, reports, and analytical tools within Excel and it makes perfect sense to…

Read More Read More

Azure Machine Learning, Knime, and Spinning Your Own Hadoop Cluster

Azure Machine Learning, Knime, and Spinning Your Own Hadoop Cluster

As part of learning about Big Data, I took an online course on machine learning and played around with some of the concepts. They are two different things that get conflated frequently. Big Data is a field of deriving value from and managing huge amounts of data, levels of data beyond what organizations have ever had to deal with before. Machine learning is a discipline┬áthat uses algorithms and statistical methods to find patterns in test data that can be applied…

Read More Read More

Commuter Map Redux (England & Wales)

Commuter Map Redux (England & Wales)

This post is all about the interactive commute map for England & Wales. You’d almost certainly rather play with that than read this. In addition to spending a week in Italy on a somewhat deserved vacation, I’ve been working on some projects that haven’t made it here yet. I’ve neglected this blog a bit, but I have a few different things that will shortly come to fruition that I will post about soon. The commute map got picked up by…

Read More Read More

ACS Commuter Data Visualizations

ACS Commuter Data Visualizations

This blog concerns an interactive visualization I put together that, for technical reasons, isn’t directly imbedded in this blog post. Go to http://bigbytes.mobyus.com/commute.aspx to see and play with the visualization. A month or two ago, I ran across a compelling visualization of commuter data done by Alasdair Rae, a geographer and urban planner based at the University of Sheffield. He runs a very cool blog called Stats, Maps n Pix that focuses on geographically oriented data and related visualizations. His…

Read More Read More

Kaggle

Kaggle

Working on a few things this week. In addition to keeping up with the Hadoop course I mentioned in a previous post, I’m working on prepping some data to create visualizations related to commuting in Michigan. This is publicly available data and I’ll post more about it soon. In addition, I stumbled across a website called kaggle.com. If you’re interested in the topic of big data analytics, you should take a look at their site. They host worldwide competitions, many…

Read More Read More

The Story So Far

The Story So Far

You can get a sense of my background in the previous┬ápost: I’ve done a lot of work developing analytics and processes to help businesses get better, faster, and more efficient results. This was usually in a garden-variety enterprise IT landscape: data warehouses, production systems, and PC-based tools. Now I’m working on learning how companies make sense of the massive quantities of data never before available to help make better decisions. I’m taking a series of online courses from UC San…

Read More Read More

Welcome

Welcome

Since I got my first real job, I’ve always gravitated to the most technical aspects of the work. Over time, as my aptitude and skills became clearer I moved into roles that were specifically in the technical realm and I always felt comfortable there. Being really good at something is a surefire way to fall in love with doing it, and that’s what happened to me. In the beginning, there was no Internet. PC’s were connected via a LAN and…

Read More Read More