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 »
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 »
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 »
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 »
[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 »
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 »
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 »
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 »
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 »
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 »