Tim Wilson BLOG

So, R We Ready for R with Adobe Analytics?
So, R We Ready for R with Adobe Analytics?
By on February 3, 2016

A couple of weeks ago, I published a tutorial on getting from “you haven’t touched R at all” to “a very basic line chart with Google Analytics data.” Since then, ... read more »

Tutorial: From 0 to R with Google Analytics
By on January 17, 2016

(This post has a lengthy preamble. If you want to dive right in, skip down to Step 1.) R is like a bicycle. Or, rather, learning R is like learning  to ride a bicycle. Someone ... read more »

The Power of Combining Number Formatting and Conditional Formatting in Excel
By on September 25, 2015

I build a lot of dashboards in Excel, and I’m a bit of a stickler when it comes to data visualization. This post walks through some of the ways that ... read more »

Working with Variable-Row-Count Adobe Report Builder Queries
By on September 13, 2015

I use Adobe Report Builder a lot. It’s getting to the point where I have to periodically reassure my wife that my relationship with the tool is purely platonic. One of the ... read more »

Two (Only Two!) Reasons for Analysis: Opportunities and Problem Areas
By on May 26, 2015

A common — and seemingly innocuous — question that analysts get asked all the time, in one form or another: “Can you do some analysis tell us where you think we ... read more »

Is On-Demand Radio the Next Big Digital Channel?
By on March 1, 2015

The title of this post is really two questions: Is on-demand radio the next big channel? Is using “on-demand radio” instead of “podcast” in the title really just a sleezy linkbait move? I’ll ... read more »

Using Excel to Count Text Occurrences
By on January 19, 2015

[UPDATE 1/19/2015: A couple of comments have pointed out that COUNTIF would address this scenario in a single formula. That’s a great point…and one that had not occurred to me. ... read more »

Introducing the Digital Analytics Power Hour Podcast
By on January 5, 2015

Happy New Year! Reflecting on 2014, I have to give it high marks from a personal and professional fulfillment front, and I’m looking to outperform those results in 2015. Who Doesn’t ... read more »

Every Analyst Should Follow fivethirtyeight.com
By on December 30, 2014

I’ll admit it: I’m a Nate Silver fanboy. That fandom is rooted in my political junky-ism and dates back to the first iteration of fivethirtyeight.com back in 2008. Since then, ... read more »

Excel Dropdowns Done Right
By on November 5, 2014

Do you used in-cell dropdowns in your spreadsheets? I used them all the time. It’s both an ease-of-use and a data quality maneuver: clicking a dropdown is faster than typing ... read more »