Professional Microsoft PowerPivot for Excel and SharePoint

  • 8h 2m
  • Denny Guang-Yeu Lee, Ron Pihlgren, Sivakumar Harinath
  • John Wiley & Sons (US)
  • 2010

With PowerPivot, Microsoft brings the strength of Microsoft's Business Intelligence (BI) toolset to Excel and PowerPoint users. Authored by 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

About the Authors

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.

In this Book

  • Self-Service Business Intelligence and Microsoft PowerPivot
  • A First Look at PowerPivot
  • Assembling Data
  • Enriching Data
  • Self-Service Analysis
  • Self-Service Reporting
  • Preparing for SharePoint 2010
  • PowerPivot for SharePoint Setup and Configuration
  • Troubleshooting, Monitoring, and Securing PowerPivot Services
  • Diving into the PowerPivot Architecture
  • Enterprise Considerations
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE