How Do I: SharePoint and Office 2010: (Part 2 of 3): An Inside Look at PivotTables and SharePoint BI Integration
In the 2nd part of ALL DEMO series presenters will take a look at Office 2010 and SharePoint 2010. Specifically, they will look at integration and how these great new products are made to work together. one will see many of the newest features in action. They look at SharePoint Business Intelligence (BI) Integration and Excel PivotTables Business Intelligence Real-time Charting Graphical Drill Down into dataDecomposition TreeData Connections - predefined PivotTables - Look at real BI data in Excel PivotTableCreating PivotTableInsert Slicers - real-time filtering (slicing and dicing) of dataSaving locally or to SharePointPivotTable Row LabelsPivotTable Report filtersPivotTable YQMD field (Year Quarter Month Day)PivotTable Insert SparkLines - Inline graphical depiction of data great for looking at inline trend analysisPowerPivot - Connect to external datasource and merge with Excel ? work pivots with millions of rows of data.