Register now or log in to join your professional community.
Excel is an application that provides you with an electronic spreadsheet, or worksheet,
environment you can use to manage numbers and calculations more easily.
Specifically, you’ll be able to extract data from People Soft and insert it into Excel
workbooks where you can manipulate the data in any way you need to see it.
When you use PowerPivot data in an Excel workbook or a Reporting Services report, you must have the PowerPivot software that loads and calculates PowerPivot data in the background. On a client workstation, PowerPivot for Excel provides the data processing software that loads and calculates the data. However, a server environment requires a server-based solution. PowerPivot server software, running on SharePoint, provides the background processing that enables you to use a Web browser to access workbooks and reports that use PowerPivot data.
