Professional Microsoft PowerPivot for Excel And SharePoint

✍ Scribed by Sivakumar Harinath, Ron Pihlgren, Denny Guang-Yeu Lee

• Publisher: Wiley Publishing, Wrox Press
• Year: 2010
• Tongue: English
• Leaves: 388
• Category: Library

✦ Table of Contents

WroxBooks
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