You can use this database in Excel or in Power View reports. In Excel, the workbook provides all of the data visualization and interaction features. Using the PivotTable reporting skills you already have, you can build sophisticated workbooks that are based on Excel’s rich data analytical tools.
Power View reports can use the workbook as an external data source for live, ad hoc reporting in SharePoint. Power View is a premium Reporting Services feature that is part of the SQL Server 2012 release. It is a server-side report designer that is built into SharePoint so that you can create your reports online.
As with any Excel workbook, in PowerPivot for Excel you can add data from a wide variety of data sources, including a relational database, a multidimensional database, data feeds, an Excel table, or a Reporting Services report. You can also add data from files on your local computer, and use data that you download from the Web.
However, unlike Excel, you can then create relationships between these data to form a single data set, and then perform analyses against this data. You are not limited to one million rows either — PowerPivot enables you to add and work with millions of rows of data locally, depending on the actual physical memory available on your desktop computer.
|ONE DAY WORKSHOP OUTLINE|
Register Online for this Course – Microsoft PowerPivot