Submit your viz to be pimped! There will be prizes! :D

July 10, 2014

In case you missed the announcement from last week, I’m doing a super fun talk at the 2014 Tableau Conference this year called Pimp My Viz!

In order to do this session, I’ll need your help! I need vizzes to pimp. If you’ve got a drab viz that could use a fresh coat of paint and a set of spinners on the wheels, fill out this form and submit it to Pimp My Viz! And guess what: there will be prizes!!!

You will be stuntin' in this dope shirt, dawg.

If your viz is chosen for Pimp My Viz, you will get this super cool one-of-kind custom made t-shirt! Pretty sweet, right?

But that’s not all! Every person who submits a viz and finds me at the 2014 Tableau Conference will get a limited edition totally rad VIZ BANDANA. These are so limited edition that I haven’t even made them yet. But I’ve already printed some test swatches of the fabric and they are going to be DOPE.

So what are you waiting for? Get in on all this fly swag and fill out this form and submit it to Pimp My Viz! I’ll be taking vizzes through the end of July!

My Can’t Miss #DATA14 Session: Pimp My Viz

July 3, 2014

I’m very VERY excited to announce that I will be holding a fantastic new session at this year’s Tableau Conference called Pimp My Viz. For those not familiar with the MTV classic “Pimp My Ride” host Xzibit wouldn’t just fix up a broken car; he’d add monitors in the headrests, spinners on the wheels, and flames shooting out the tailpipe. In the same fashion, this isn’t going to be an ordinary viz makeover. I’m going to take a few vizzes beyond just making them adhere to visual best practices and add all kinds of design flair, embed content, and other kinds of unnecessary awesomeness.

That being said, I need some broke-ass vizzes to pimp out. So if you have a dashboard that is lacking flare and in desperate need of pimping, please send them to me at or tweet them to me @jeweloree.

Data Feed: Prescribing of Opioid Pain Relievers by State

July 1, 2014

Y’all know how much I love datasets about sex, drugs, and rock and roll. This dataset was just released by the CDC titled “Variation Among States in Prescribing of Opioid Pain Relievers and Benzodiazepines — United States, 2012″

I choo-choo-choose you, vicodin!

It could be interesting to mashup this data with figures on opiate drug abuse or number of people on disability. Have at it, vizzers!

Pop Pot Viz: Mapping Potential Cannabis Retailers in Washington

June 6, 2014

Woohoo! Weed!

It’s been a long time coming since the passing of Initiative 502, which legalized the sale of cannabis for recreational purposes in the state of Washington. Since passing in 2012, the Liquor Control board, who was responsible for creating the rules and maintaining licenses for cannabusinesses, has dragged it’s feet when it came to handing out the licenses. Last month, they publicly announced a list of the latest license lottery winners. It’s my understanding (which I’ll admit is a little hazy…not because I’m stoned but because the rules around cannabusinesses are incredibly confusing) that this list will still be pared down even more, so not all of these potential shops will exist. Basically, the better the rank, the more likely that store is to exist. Use the slider on “Lottery Rank” to see the stores with higher potential to open. However, it was just announced that the first official recreational cannabis store is now licensed and slated to open July 1st, so hopefully I can get an updated list soon.

Learn About Tableau

Once stores are starting to open, I’ll make more maps of where they are and maybe some information about ratings/prices, etc. Hopefully that’ll be in time for all my lovely Tableau friends that’ll be coming to Seattle for Tableau Conference! ;)

You can be as happy as this guy!

When is the best time to get free food at Tableau?

June 2, 2014

I’m very thankful that I work at an awesome place that has a kitchen that is always stocked with all kinds of yummy stuff. However, even with the excellent food situation we are in, people still get excited if there’s leftovers from a catered lunch to be had. I went through my inbox and flagged every email offering free food. I used Access to import the folder of food emails and brought the results into Tableau.

You will see that the most offered food is breakfast. This is because there are a variety of trainings/orientations in which breakfast is provided, so there’s usually a couple of those a month. View the viz to see what else we are eating at Tableau:

Learn About Tableau

Pop Viz: Beat Connection

May 8, 2014

I’ve been trying to come up with a pun all morning, something to do with Beat Connection and Data Connection, but it’s too early and coffee hasn’t happened yet.

In honor of our big company party featuring a performance by my favorite local band, Beat Connection, I’ve made this dashboard on how much I’ve scrobbled plays on Of course, it’s a little less than how much I actually listen…. It doesn’t count all the vinyl plays I do:

Photo on 5-8-14 at 7.07 AM #2

Here’s the dashboard!

Learn About Tableau

Data Feed: Effectiveness of popular diets

April 30, 2014

This dataset comes from Lift, an app that helps you succeed at everything. The did an experiment to see which popular diets were the most effective. You can learn more about the study and download the data here.

BTW it's the 10th anniversary of Mean Girls today!

Data Feed: Cursing in Rap Lyrics

April 28, 2014

Here’s a fun dataset looking at swearing in rap lyrics from 1985-2013.

best rapper ever

It comes from a collection of datasets, mostly about sports, that are all formatted pretty nicely and look nice and ready to go to Tableau.

How to Scrape with

April 25, 2014

Earlier this week, I did a webinar with talking about how I used it to scrape the KEXP playlist. You can read more about it on their blog and watch the video here:

Pop Viz: 4 Years of Reddit and Using the JS API

April 14, 2014
Happy Cakeday to ME!

Last Saturday was my 4th “Cakeday” on everyone’s favorite time waster, Reddit! To celebrate another year of distraction, I wanted to update my Cakeday Karma Count dashboard from last year. I’ve learned a lot of tricks since then, so this new and improved dashboard has a couple of upgrades:

  1. Getting the data was way easier.
    Last year (and I shudder thinking about this) all my data was hand inputted into a spreadsheet. Now that I’ve learned a little more about the beautiful world of web scraping via, I was able to get all this data in just a couple minutes!
  2. I learned how to use Imgur URL Parameters.
    This is actually a fairly new discovery for me. I found out about it when one of the students in my DDJ class was playing with Reddit data and wanted an easy way to resize all the Imgur links. Just adding an “m” to the end of the ID made it easy for me to switch between the three images that change in the URL object without having to manually resize all of them.
  3. I learned how to use Tableau’s Javascript API to have URL actions work both on a Web page object on the dashboard and in a new tab!
    This is by far the best discovery. Mad props to JSAPI genius Michael Kovner for helping me with this solution. When I made the dashboard last year, I wanted people to be able to open up the links to my posts, but it would load where the image changed instead of in a new window. Turns out just a few lines of javascript can fix it! More about the solution after the viz!

If you click on a bubble, you’ll notice the picture change. If you click on the box/arrow symbol thingy in the table, it’ll open up the link to that post in a new window (pop-up blockers may mess with this). Try it out!

So here’s how the double URL action works.

I created a normal URL action that changes the picture while editing the dashboard. The action that controls opening a post in a new tab is done completely in the Javascript API. All I had to do before publishing is make sure that the sheet that I wanted to control this action had the proper URL dimension I wanted to use.

After I published the dashboard, I created a javascript file called reddit.js that looked like this:

window.onload = function() {

var sheetDiv = document.getElementById("visualization");
var sheetURL = "";
var sheetOptions = {
hideTabs: true,
hideToolbar: true,
width: "900px",
height: "1200px",
onFirstInteractive: function() {
viz = new tableauSoftware.Viz(sheetDiv, sheetURL, sheetOptions);

viz.addEventListener('marksselection', function(event) {
if(event.getWorksheet().getName() === "Post table") {
event.getMarksAsync().then(function(marks) {
if(marks.length === 0) {
link = marks[0].getPairs().get('Link').value;, '_blank');

Let’s dissect what some of these parts are. The first section there is really just setting up that this script is generating a viz and we are going to do stuff to it. If you wanted to re-purpose this code for your own viz, you would replace the “sheetURL” with your viz and the width and height with what your dashboard is sized to. The second part is the event that controls the URL action. This function tells the viz to open a URL dimension named “Link” from a sheet called “Post Table” in a new window. If you wanted to use this on your own dashboard it would look like this:

viz.addEventListener('marksselection', function(event) {
if(event.getWorksheet().getName() === "SHEET NAME HERE") {
event.getMarksAsync().then(function(marks) {
if(marks.length === 0) {
link = marks[0].getPairs().get('URL DIMENSION NAME HERE').value;, '_blank');

Once you have the code written, you’ll need to save the javascript file somewhere on your site. Then, when you are embedding, you’ll reference the Javascript API and your javascript file and call up the visualization like this:

(script src="")(/script)
(script type="text/javascript" src="reddit.js")(/script)
(div id="visualization")(/div)

Note: all the parentheses are supposed to be triangle brackets… I can’t put them in that way or WordPress will think I’m trying to actually use them. :P

That’s pretty much it! Thanks again to Michael Kovner for the awesome script and to my pal Josh Buchacher who helped me figure out how to embed this properly on my blog!

← Previous Page