Tim Wilson BLOG

Should Digital Analysts Become More Data Scientific-y?
Should Digital Analysts Become More Data Scientific-y?
By on July 4, 2016

The question asked in this post started out as a simpler (and more bold) question: “Is data science the future of digital analytics?”  It’s a question I’ve been asking a lot, ... read more »

Shiny Web Analytics with R
By on May 16, 2016

It’s been a a couple of months since I posted about my continued exploration of R. In part, that’s because I found myself using it primarily as a more-powerful-than-the-Google-Analytics-Chrome-extension access ... read more »

Announcing: Excel with Excel for Digital Analysts: 5/11/2016 in Chicago
By on March 12, 2016

No single tool is as universally holstered in the toolbelts of digital analysts as Microsoft Excel. While it’s neither an advanced BI tool nor the most robust data visualization platform ... read more »

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 »