Date Calculations Cheat Sheet

Date Calculations are hard. I’ve personally spent about 1000 hours of my life writing the same date calculations over-and-over. I decided to consolidate these into a single document to make it easy to build the calculations with a few keyboard strokes and clicks of a mouse

Income Statement in Tableau

Sometimes Tableau takes a bad wrap for not being able to create the types of tables everyday users of Excel expect. This example shows how to create an income statement in Tableau.

Advanced Interactivity in Tableau

See how the functionality added to Tableau 2022.4 creates additional functionality not previously available to users of Tableau.

Blog Archives (2018 & Earlier)

The Lineup Lowdown

Every year I go to about ten Minnesota United matches a year. I have season tickets, I keep a pulse on top players, but I have no idea about the opposing team beyond their star players. I don’t know if

Read →

The #FutureZen Compliment

A number of times I’ve been paid the compliment of being told that I am worthy of the Tableau Zen Master title. It’s an amazing compliment, but sometimes I don’t feel worthy of such compliment. Here’s why: It’s the season

Read →

Tips for the Tableau Community (By the Community)

I recently asked for the top tips from the Tableau community on Twitter. Anyone want to share their favorite “hidden” feature in Tableau? I’m putting them together for a small presentation! — Luke Stanke (@lukestanke) April 10, 2018 And they

Read →

Building a Radial Line Chart in Tableau.

Below is a chart built for #WorkoutWednesday. It seems to have thrown people off a bit. Just as a reminder here are the requirements: Use sales for 2017. The size of the dashboard 500px x 600px. If you think of

Read →

My #YearInTableau2017

I've used Tableau just a little this year and I thought I'd share my year in Tableau AKA #DataMemories AKA #YearInTableau2017. To start the year I had simple goals when it came to all things Tableau. I'll get to those

Read →

13 Tips for Growing Data Science Teams

I recently presented to a local organization on setting/scaling up data science teams. We had a thoughtful one-hour conversation about the pseudo-prerequisites to accelerating the adoption of data science within an organization. Our conversation kept coming back to the same

Read →

Developing a Dynamic Ticket Viz

Tableau Public now supports Google Spreadsheets. I didn’t think of this as anything special. But after I realized cloud-based spreadsheets means dashboards that can be automatically update. I set out on a way to constantly update data in Tableau. Given

Read →

Most Downloaded R Packages of 2016

I was curious what packages are the most downloaded from CRAN. A quick google search of “most downloaded R packages 2016” produces outdated articles (see here, here, and here). Luckily the Rstudio CRAN keeps logs of the number of users

Read →

Visualize an .png in Tableau

I’ve always thought it was really awesome how some people could replicate images in Tableau. I thought I would give it a shot. I figured it’d take a long time to figure out, but it turns out it’s pretty easy

Read →

Target Store Locations with rvest and ggmap

I just finished developing a presentation for Target Analytics Network showcasing geospatial and mapping tools in R . I decided to use Target store locations as part of a case study in the presentation. The problem: I didn’t have any

Read →

Voronoi Diagrams with Weather Data

I wrote some code to make a voronoi diagram from point data using NOAA weather stations. The goal original goal was to find the closest weather station given any point in the US. I decided to show some examples of

Read →

Who should be the NFL MVP

It’s the end of the National Football League regular season tomorrow. With that, comes talk about who the best player — the MVP — will be. Since 2000, the MVP award has been won by 11 times by quarterbacks and

Read →

NFL Box Scores

I used to go to an awesome site to get important/cool data for playing fantasy football — Advanced Football Analytics — but it was bought by ESPN and the secret sauce/important information was no longer available to me. I had

Read →

MPS Unveils Behavior Dashboard

Just an update on my work: Over the last year, I’ve spent significant time developing a behavior data tool for the principals of Minneapolis Public Schools. We developed the tool because it was one a of a few areas where MPS principals could use

Read →

ESPN: Green Bay Packers 1-on-1 Blocking Drills

Over the past four years I’ve worked with Rob Demovsky of ESPN analyzing the Green Bay Packers one-on-one offensive/defensive line drill. We’ve found it to be a fantastic predictor of making the team. I’m going to post some more detailed

Read →

Reflections on Behavioral Referral Data Tool

Last fall, I spent significant time working on a data tool for schools that gathered information from many different sources. To create the tool, I had to develop reproducible code to gather information from our student information system,  develop an intermediate data

Read →

Thoughts on Standardized Testing

Let’s face it, standardized testing has been a white hot topic since the adoption of No Child Left Behind. There have been many voices expressing distaste for testing, even questioning the validity of standardized tests in Minnesota all-together or blaming the

Read →