Professional Microsoft PowerPivot For Excel And SharePoint

Features of Professional Microsoft PowerPivot for Excel and SharePoint

With PowerPivot Microsoft brings the power of Microsofts business intelligence tools to Excel and SharePoint users Selfservice business intelligence today augments traditional BI methods allowing faster response time and greater flexibility If youre a business decisionmaker who uses Microsoft Office or an IT professional responsible for deploying and managing your organizations business intelligence systems this guide will help you make the most of PowerPivotProfessional Microsoft PowerPivot for Excel and SharePoint describes all aspects of PowerPivot and shows you how to use each of its major features By the time you are finished with this book you will be well on your way to becoming a PowerPivot expertThis 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 productsThis 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 endThe companion Web site includes all the sample applications and reports discussed