I'm starting a project here at work to explore using OLAP techniques to start working more intelligently with our data. Towards this end I got familiar with Microsoft's Analysis Services designed some ...

On the advanced end of the spectrum, pivot tables can also be used to perform simple projections; for instance, you can see how the revenue of your company has changed over time by viewing a line ...