Analytics Team

PTS has some good tricks for using Excel’s auto filters including using auto filters with pivot tables

When you make a stacked column chart in Excel, the columns are normally stacked in whatever order you put the series in. Check out this how-to guide for reorganizing the columns so the largest values are on the bottom of each column.

Werner Vogels, CTO of Amazon, provides these tips to keep your database simple and running fast on his blog at All Things Distributed.

1 to 1 Media had a good article today about the basics of segmentation – I.D.I.C. A refresher never hurts.

Identify
Differentiate
Interact
Customize

Here’s a hack for excel that explains how to better chart related series on two axes without the confusion associated with the normal excel way of doing it.
http://www.juiceanalytics.com/weblog/?p=296

Back in the days of DOS, everyone knew what the function keys did, but now most people don’t use them at all. Check out this article to find out what all the function keys do. It will likely save you some time.
http://www.compukiss.com/sandyclassroom/tutorials/article894.htm

Someone just asked me how to do this so I am going to post my solution in case it will help others…
Situation: You have a table of email addresses (and that’s it) of clients from the Boston DMA. You want to add a new field called DMA and assign all records the value of “Boston”
Solution: [...]