Sometimes we at Distilled go a little far out with our posts about statistics and data and all that, but not all of that is applicable to everyday work. Not all tasks are so complicated—some are fairly cut and dry, like figuring out which landing pages have received the most traffic over the last year. That’s straightforward, right? At some level this is clerical work—but that’s all the more reason to get it over with as quickly as possible.
Often we can slow ourselves down by organizing data in inefficient ways. These methods might seem smart or fast at the time, and yet they can often make it more difficult to get what we really need out of our data set. Maybe you are trying to figure out which page received the most traffic over the last year—and this is what your Excel file looks like: