- eBook:Professional Microsoft PowerPivot for Excel and SharePoint
- Author:Sivakumar Harinath, Ron Pihlgren, Denny Guang-Yeu Lee
- Edition:1 edition
- Data:June 15, 2010
- Pages:384 pages
This book is for people who want to learn about PowerPivot from end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products.
This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end.
The companion Web site includes all the sample applications and reports discussed.
Chapter 1: Self-Service Business Intelligence and Microsoft PowerPivot
Chapter 2: A First Look at PowerPivot
Part II - Creating Self-Service BI Applications Using PowerPivot
Chapter 3: Assembling Data
Chapter 4: Enriching Data
Chapter 5: Self-Service Analysis
Chapter 6: Self-Service Reporting
Part III - IT PROFESSIONAL
Chapter 7: Preparing for SharePoint 2010
Chapter 8: PowerPivot for SharePoint Setup and Configuration
Chapter 9: Troubleshooting, Monitoring, and Securing PowerPoint Services
Chapter 10: Diving into the PowerPivot Architecture
Chapter 11: Enterprise Considerations
Download Professional Microsoft PowerPivot for Excel and SharePoint PDF or ePUB format free