Product Description
With PowerPivot, Microsoft brings the power of Microsoft s business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you re a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization s business intelligence systems, this guide will help you make the most of PowerPivot.Featuring insights and tips from the team that built the product, it offers a head start on mastering the features of PowerPivot. The companion Web site includes all the sample applications and reports discussed.
Coverage includes:
* Self-Service Business Intelligence and Microsoft PowerPivot
* A First Look at PowerPivot
* Creating Self-Service Bi Applications Using PowerPivot
* Assembling and Enriching Data
* Self-Service Analysis and Reporting
* Preparing for SharePoint 2010
* PowerPivot for SharePoint Setup and Configuration
* Troubleshooting, Monitoring, and Securing PowerPivot Services
* Diving into the PowerPivot Architecture
* Enterprise Considerations
You ll learn to use PowerPivot with Excel and SharePoint to improve your business intelligence system.
From the Back Cover
PowerPivot brings the power of MicrosoftBusiness Intelligence to Office 2010!With PowerPivot, Microsoft brings the strength of Microsoft s Business Intelligence (BI) toolset to Excel and PowerPoint users. Authoredby members of the Microsoft team behind the creation of PowerPivot, this book shows you how to use PowerPivot for Excel to create compelling BI solutions, perform data analysis, and achieve unique business insight. You ll learn how to use PowerPivot for SharePoint to share your BI solutions and collaborate with others. And your organization will learn how to use SQL Server 2008 R2 management tools to acheive more efficient results.
Professional Microsoft PowerPivot for Excel and SharePoint:
* Shows how to use PowerPivot for Excel to generate rich and interactive analysis solutions
* Explores different ways to bring data into PowerPivot
* Addresses sharing and collaborating on user-generated BI solutions in a SharePoint Server 2010 environment
* Shows you how to troubleshoot, monitor, and secure PowerPivot services
* Demonstrates how PowerPivot can meet the needs of Office, as well as how IT professionals can deploy and manage the self-service business intelligence system
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
About the Author
Sivakumar Harinath is a Senior Test Manager on the SQL Server Analysis Services team and a coauthor of Professional Microsoft SQL Server Analysis Services 2008 with MDX.
Ron Pihlgren is a 15-year Microsoft veteran and member of the SQL Server Analysis Services team as a senior test manager.
Denny Guang-Yeu Lee is a member of the SQL Customer Advisory team and a coauthor of Professional Microsoft SQL Server Analysis Services 2008 with MDX.
Product Details
* Paperback: 384 pages
* Publisher: Wrox (June 15, 2010)
* Language: English
* ISBN-10: 0470587377
* ISBN-13: 978-0470587379
Download :