Monthly Archives: July 2014

Beer!

Beer is awesome! What else is new, right? I’ve been thinking about doing a beer post and started looking around the internet for data. If you’re a fan of beer, you’ve noticed the rise in new brewers over the last decade. In fact, Denizens Brewing Co. just opened across the street from my office. I’ve heard rumors our engineering team is looking at ways to boost our wifi signal, allegedly of course. The explosion of craft beer has been great for beer nerds like myself. I love trying a new beer with friends and I keep finding new favorites. I prefer the IPAs but will try just about anything.

Off to the internet I went and I found data from the Beer Institute. The site has a downloadable excel with a wealth of beer information. The bar chart below shows active brewer permits by state and year. Use the slide filter to see the growth in permits issued.

Looking at the growth a little closer you can see YoY for the US as a whole and for each state. My home state of Maryland needs to step it up, while 40% is great, I know we can do better. :) Some states on the other hand are growing fast since 2004. Keep it up!

But the growth isn’t necessarily a great thing if you’re trying to break in the market. I’ve talked to the brewer of a local restaurant in Bethesda, MD and he says we’re going to start seeing many brewers close up shop. Many individuals are entering this space and not all will survive. But in the meantime, I’ll sample their beer.

Clearly California has the most active brewer permits, but it is the most populous state. How does 2012 brewer permits look when population is factored in? I found some data on adult population and blended it with the brewer data.  Note that adult here means 18 years of age or older, not 21, the legal drinking age in the US. I won’t go into it here much but I will say that I believe the drinking age should be 18, but the driving age should be 21.

Vermont has the least adults per active brewer permit and if you live in Mississippi, I’m sorry. I hope your state is importing other craft brews to help you out.

So now that I got you thinking about beer, you’re probably about to stop reading and head for the fridge. Wait!!! In order to help you make a selection, I scraped the web for prize winning beers. Using import.io, a fantastic web scraping tool, I downloaded a table of the Great American Beer Festival winners from 2013.

Use the filter to select the Category to view the Gold, Silver, and Bronze winners. I’m going to have to use this chart next time I’m on a beer run.

Now if you’ll excuse me, I just opened one of my favorites, Loose Cannon from Heavy Seas out of Baltimore. Have a great day!

loose cannon

 

 

Share Button

Tableau Server Tip

Tip time again. And this one focuses on Tableau Server. One of my favorite features of Tableau Server is the ability to publish data sources. I work for a global company and we constantly share data with teams in international offices. This data can range from SQL Server/Oracle data to Excel files stored on a multitude of share drives. Publishing data sources allows our global teams to all access data needed for a given project or report, without needing access to where the underlying data is stored. This has been advantage and allowed collaboration between regions, all while working with a single version of the truth.

Ok, now getting to the tip. Let’s say you’re given a workbook that already contains charts, tables, dashboards, and of course, calculated fields. The workbook is connected to a published data source on your server. You try to edit a calculated field and the only option is Edit Copy, which makes a new calculated field.

ScreenHunter_02 Jul. 24 16.45

This is not ideal because the calculated field you’d like to edit is already embedded in several locations of the workbook. So how do you edit the original field?

Easy, simply right click on the data source name and select Create Local Copy.

ScreenHunter_03 Jul. 24 16.48

Save the data source to your desired folder. You’ll now have a new data source.

ScreenHunter_04 Jul. 24 16.50

Next, swap data sources so the exists workbook sources from the local copy.

Select Data > Replace Data Source…

ScreenHunter_01 Jul. 24 19.59

Now when you right click to edit a calculated field, you’ll be able to edit the original field that is already being used throughout the workbook.

ScreenHunter_05 Jul. 24 16.51

From here, you can proceed with the needed task. Just remember that if you republish the data source, your calculated field edits will be available for others. So depending on your ultimate goal, know if you should overwrite the original published data source or not.

Thanks! And happy Tableau’ing!

Share Button

Post World Cup Viz

So I’m a little late to the party but I wanted to do a quick write up about the World Cup. As a Brazilian, I had deep emotions leading up to this tournament.

I made this quick bar chart that visually displays my interest level in the World Cup at different stages.

As you can clearly see, I was all in until Brazil decided to have a churrasco on the field instead of play defense. You can’t win them all but I really wanted this one.

Until the next post!

 

 

 

Share Button