Tim Wilson BLOG

The Power of Combining Number Formatting and Conditional Formatting in Excel
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 »

10 Tips for Building a Dashboard in Excel
By on October 19, 2014

This post has an unintentionally link bait-y post title, I realize. But, I did a quick thought experiment a few weeks ago after walking a client through the structure of ... read more »

Exploring Optimal Post Timing…Redux
By on October 4, 2014

Back in 2012, I developed an Excel worksheet that would take post-level data exported from Facebook Insights and do a little pivot tabling on it to generate some simple heat ... read more »