PowerPivot with SQL Server 2008 R2 One of the prime-time features of Microsoft SQL Server 2008 R2 is provided by the “Project Gemini” technology known as PowerPivot for “Self Service BI”. Working with ...

A new component in SQL Server 2008 R2 gives users the autonomy to set up business intelligence functionality in Excel without taking control of the process away from IT. PowerPivot is Microsoft's new ...

This article provides a resolution for the problem that occurs when you try to use a PowerPivot for Excel workbook as a data source in SQL Server Analysis Services. This article helps you resolve the ...

I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, ...

Microsoft SQL Server PowerPivot for Excel, or PowerPivot for short, is an in-memory business intelligence (BI) engine that enables Excel users to interactively create pivot tables over large data sets ...

Have you found this content useful? Use the button above to save it to your profile. Business intelligence expert Philip Taylor (aka ExcelCrafter) puts the case for using the PowerPivot add-in for ...