Details

Introduction. <p><b>Part I: Introduction.</b></p> <p>Chapter 1 Self-Service Business Intelligence and Microsoft PowerPivot.</p> <p>Chapter 2 A First Look at PowerPivot.</p> <p><b>Part I: Creating Self-Service Bi Applications Using PowerPivot.</b></p> <p>Chapter 3 Assembling Data.</p> <p>Chapter 4 Enriching Data.</p> <p>Chapter 5 Self-Service Analysis.</p> <p>Chapter 6 Self-Service Reporting.</p> <p><b>Part II: IT Professional.</b></p> <p>Chapter 7 Preparing for SharePoint 2010.</p> <p>Chapter 8 PowerPivot for SharePoint Setup and Configuration.</p> <p>Chapter 9 Troubleshooting, Monitoring, and Securing PowerPivot Services.</p> <p>chaPter 10 Diving into the PowerPivot Architecture.</p> <p>Chapter 11 Enterprise Considerations.</p> <p><b>Part IV: Appendix.</b></p> <p>Appendix A: Setting Up the SDR Healthcare Application.</p> <p>Appendix B: DAX Reference.</p> <p>Index.</p>

<p><b>Sivakumar Harinath</b> is a Senior Test Manager on the SQL Server Analysis Services team and a coauthor of <i>Professional Microsoft SQL Server Analysis Services 2008 with MDX.</i> <p><b>Ron Pihlgren</b> is a 15-year Microsoft veteran and member of the SQL Server Analysis Services team as a senior test manager. <p><b>Denny Guang-Yeu Lee </b>is a member of the SQL Customer Advisory team and a coauthor of <i>Professional Microsoft SQL Server Analysis Services 2008 with MDX.</i> <p><b>Wrox Professional guides</b> 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.

<p><b>PowerPivot brings the power of Microsoft Business Intelligence to Office 2010!</b> <p>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. <p><i>Professional Microsoft PowerPivot for Excel and SharePoint:</i> <ul><li>Shows how to use PowerPivot for Excel to generate rich and interactive analysis solutions</li> <li>Explores different ways to bring data into PowerPivot</li> <li>Addresses sharing and collaborating on user-generated BI solutions in a SharePoint Server 2010 environment</li> <li>Shows you how to troubleshoot, monitor, and secure PowerPivot services</li> <li>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</li></ul>

US