Professional microsoft® powerpivot for excel® and sharepoint
With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility.
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Newark
WILEY
2010
John Wiley & Sons, Incorporated Wrox Wiley Pub |
| Edition: | 1 |
| Subjects: | |
| ISBN: | 0470587377, 0470912413, 9780470912416, 9780470587379 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
Table of Contents:
- 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