Microsoft's PowerPivot: Five things you need to know
It boosts your business intelligence. Even the most robust business intelligence shops create only a small percentage of the reports an organization needs, says Rob Collie, CTO for the consulting firm Pivotstream. Microsoft's PowerPivot lets managers execute many of the same types of queries and generate reports directly from Microsoft Office. Like a pivot table on steroids, it can pull large amounts of data into Excel from multiple sources.