Playing with a little Tableau using open data from Los Angeles Open Data on “Residential water use by month averaged for fiscal year. Numbers represent Hundred Cubic Feet (HCF) of water use.”
Couple of observations with the data:
Water usage seems to correlate with residential density, eg. the high water usage in Downtown and Central City that have more high-density apartment blocks versus suburban tract homes that make up most of Los Angeles.
Water usage dropped dramatically in Fiscal Year 12/13, I’m almost wondering if that data was never fully populated. Either way, there seems to be a good downward trend which is good because of the CA drought and just being a region where water is scarce.
Tableau’s sum filters can be puzzling for those who aren’t familar with the platform when you filter the data – eg suddenly the scale is off so you have to reduce that filter to see the values.
A few process notes
I had to pivot the raw data a bit before bringing it to Tableau
I imported a custom shape for the water drop effect
I used the area chart for trend overtime to kind of hit home the point the amount of water usage rather than a simple line to show time series.
I couldn’t help noticing walking around how many people buy items like bottled water and have no place to recycle them even though NYC has a lot more public waste baskets than a lot of other cities. Taipei, I’m looking at you and all those days I carried my trash for miles.
I played with some of the NYC Open Data in Tableau and did confirm how few Public Recycling Bins are in NYC.
For some reason they’re particularly absent in Queens, outer Brooklyn, and Upper East Side. Population density seems to have no impact. Shrug, come on NYC, you “progressive bastion,” get your recycling on! It kills me seeing how many people here buy beverages in containers that could easily be recycled and toss them into a regular trash bin. It’s crazy.
Click here or the image below to see the visualized data:
First go at this dataset. I created an interactive dashboard-like view just looking at goal breakdowns by Major League Soccer teams overall for the 2015 season. Planning to add several views to this panel with the data.
I’ve really into soccer in general, especially international play, after my grad school project where I worked at the Annenberg Innovation Lab collaborating with Havas Sports and Entertainment and IBM on a research project studying soccer fans (see Fans.Passions.Brands, Fan Favorites, and Sports Fan Engagement Dashboard). I also did my degree practicum on Marketing to Female Sports Fans.
I’m now in another universe creating data visualization at an advertising agency and am trying to combine the geeky fandom with practical practice related to my daily work.
On that note, most of the statistics and visuals I’ve found through a just a cursory look are about wins and losses. I’m trying to show goal data by team in the MLS in a way that looks at performance based on other factors such as number of attempts and assists and not just the win-loss-draw type metrics I found in most of the soccer sites I saw.
I deliberately tried to use Tableau components and styling that was out of the out-of-the box template for the platform to emphasize the ability to size values on an additional data dimension. For instance, sizing each bubble based on number of goals or customizing labels out of the default. I notice a lot of users of Tableau don’t deviate much from the standard template, and I’m trying to train myself to go beyond that and also get better at the aesthetic piece of data viz.
I use Tableau at work on a daily basis. I personally think where Tableau shines is its exploratory data capabilities if you know how to prepare data in a form usable in Tableau. A few years ago, its explanatory data visualization capabilities were second to none in this space, but the desktop tool has lost some flash factor to D3 and HTML5 visuals, but definitely not substance in my opinion. Plan to expand on this with win-loss figures as well as analysis of kicks as the high number of goals by team didn’t necessarily line up with number of matches won.
I’ve actually watched all the videos in this series on the Tableau Training site, which are probably some of the most well-done training videos I have. This interactive tutorial is a nice brush-up for me and is better organizing than their docs for implementing work – in my opinion.
There are three categories of functions to select/interact with views, filter functions, switching tabs, and selecting values. The distinction is important for development and not that clear upfront (at least it wasn’t to me).
Methods generally different between different even handlers that take in single versus multiple values
REPLACE method to only show one filter value
ADD allows multiple filter criteria
REMOVE clears values from filter
Reading and Learning Data Visualization Theoretically/Critically:
Nathan Yau quoting Amanda Cox “All of the great chartmakers make me feel something: alarm, wonder, surprise, joy … something. Even, I think you might argue in the case of something like dashboard design, calm.” p. 69
I want the BI dashboard work I do to make people feel calm
Great example of drawing out simpe visual with humorous expression: Thisisindexed.com p. 71
Data art is a way to allow yourself to “immerse yourself in the data, which is both personal and easy to relate to” p. 81
Note to self: Haven’t been doing these as much lately, but incredibly helpful for learning how to communicate and to get ideas. Try to get at least three of these a week so you put in the extra thought to what you see and read.
Log scales allow you to include values that span orders to magnitude on x-axis and adjust grid lines so incremental change at different values of the y-axis reflects its relative significance. p. 100-101
Watch out for using non-comparable scales – readers expect a flat line for small increases and a steeper slope for bigger increases.
Charing the absolute values or the percentage changes from the initial data point yields the same shape for the graphs. The chart plotting the percentage changes accentuates the changes from the baseline. p. 107