Professional Microsoft PowerPivot for Excel and SharePoint -- About the Authors -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You need to uSe thIS book -- conventIonS -- Source code -- errata -- p2p.Wrox.com -- Part I: Introduction -- Chapter 1: Self-Service Business Intelligence and Microsoft PowerPivot -- SQL Server 2008 R2 -- Self-Service Business Intelligence -- Power Pivot: Microsoft's Implementation of Self-Service BI -- Summary -- Chapter 2: A First Look at PowerPivot -- PowerPivot for Excel -- Setting the Stage -- PowerPivot for SharePoInt -- Summary -- Part II: Creating Self-Service BI Applications Using PowerPivot -- Chapter 3: Assembling Data -- Importing Data -- Other Ways to Bring Data into PowerPivot -- The Healthcare Audit Application -- Assembling Data for the Healthcare Audit Application -- Summary -- Chapter 4: Enriching Data -- Exploring the PowerPivot Window -- Enriching Data for the Healthcare Audit Application -- Summary -- Chapter 5: Self-Service Analysis -- PivotTables and PivotCharts -- The PowerPivot Field List -- Slicers -- DAX Measures -- PowerPivot and Other Excel Features -- AnalysIs in the Healthcare AudIt Application -- Summary -- Chapter 6: Self-Service Reporting -- Publishing PowerPivot Workbooks -- PowerPivot for SharePoint -- Adding Reporting to the SDR Healthcare Application -- Summary -- Part III: IT PROFESSIONAL -- Chapter 7: Preparing for SharePoint 2010 -- SharePoint 2010 -- Why Not SharePoint "Lite" BI Edition? -- Excel Services -- Key Servers in PowerPivot for SharePoint -- Key Services in PowerPivot for SharePoint -- Services Architecture Workflow Scenarios -- Summary -- Chapter 8: PowerPivot for SharePoint Setup and Configuration -- Required Hardware and Software -- Setup and Configuration -- Multi-Server Farm Setup.

Verify the PowerPivot for SharePoint Setup -- Optional Setup Steps -- Summary -- Chapter 9: Troubleshooting, Monitoring, and Securing PowerPivot Services -- Troubleshooting Tools -- TroubleshootIng Issues -- Monitoring PowerPivot Servic s -- Security -- Summary -- Chapter 10: Diving into the PowerPivot Architecture -- PowerPivot for Excel Architecture -- PowerPivot for SharePoint Architecture -- Summary -- Chapter 11: Enterprise Considerations -- Capacity Planning -- SharePoint WFEs -- SharePoint App Servers -- Sharepoint Databases -- Upgrade and Patching Considerations -- Upload Considerations -- Summary -- Part IV: Appendix -- Appendix A: Up the SDR Healthcare Application -- Setting Up the SQL Server Audit Database -- Setting Up the Database Group Name SharePoint List -- Setting Up the Client Address to State Report -- Index.