Professional Microsoft PowerPivot for Excel and SharePoint

丛 书 名：Programmer to programmer

版本说明：1

作     者：Sivakumar Harinath 

I S B N：(纸本) 9780470587379 

出 版 社：Wiley 

出 版 年：2010年

页      数：388页

主 题 词：wrox programmer sharepoint excel microsoft powerpivot professional 

学科分类：08[工学] 0812[工学-计算机科学与技术（可授工学、理学学位）] 

摘      要：This book introduces readers to PowerPivot for Excel and SharePoint, showing them how to leverage the power of self-service business intelligence. The book addresses the requirements of two groups of target users: business decision makers who use Microsoft Office, and IT professionals who deploy and manage the self-service business intelligence system. It includes insights and tips from the team that built the product to give readers a head start on this innovative new product. The authors fully cover each of the major new innovations that are part of PowerPivot and the SQL Server 2008 R2 release: In-memory Business Intelligence server technology: This is a new column-oriented storage technology that enables query execution speeds of seconds for data stores containing multiple millions of rows of data. Data Analytics eXpressions (DAX): This is an expression language designed to give Office users the ability to create powerful analytical calculations in Excel, without having to use the more complex MDX query language. Report Gallery: A SharePoint extension that makes reports published to Microsoft Office SharePoint Server easy and pleasing to view and navigate. Data Feeds:. An Atom-based syndication technology for data allowing PowerPivot reports to get automatic updates of data from sources such as SQL Server Reporting Services reports, *** Data Services, SharePoint lists, and Google Docs. The topics are covered following the typical workflow when using PowerPivot for self-service analytics and reporting. These steps include: Importing data from various sources Modeling the data to make analysis easier and more effective. Sharing the BI applications created using PowerPivot with Excel and SharePoint. Reporting the results In addition, the authors covers the important step of deploying and managing sandbox servers that allow PowerPivot to integrate with SharePoint Server. The book s companion website will provide all sample applications and reports describe