Professional Microsoft PowerPivot for Excel and SharePoint

This book introduces readers to PowerPivot for Excel and SharePoint, showing them how to leverage the power of self-service business intelligence. The bookaddresses the requirements of two groups of target users: business decision makers who use Microsoft Office, and IT professionals who deploy and manage theself-service business intelligence system. It includes insights and tips fromthe 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 thatare part of PowerPivot and the SQL Server 2008 R2 release: In-memory BusinessIntelligence 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, ADO.NET Data Services, SharePoint lists, andGoogle Docs. The topics are covered following the typical workflow when usingPowerPivot for self-service analytics and reporting. These steps include: Importing data from various sources Modeling the data to make analysis easier andmore 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 described in the book.

• ISBN: 978-0-470-58737-9
• Editorial: John Wiley & Sons
• Encuadernacion: Rústica
• Páginas: 384
• Fecha Publicación: 25/06/2010
• Nº Volúmenes: 1
• Idioma: Inglés