Using the OLE DB Provider for SQL Server/Analysis Services, the end-user can connect to a Data Source directly and build a Pivot Table or PivotChart using standard Excel functionality.

You must know how to use these two essentials in order to get a different perspective on your marketing data through the pivot table function: Summarizing Data; Calculated Fields; If you’ve been using ...