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.
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Part I: Introduction.
Chapter 1 Self–Service Business Intelligence and Microsoft PowerPivot.
Chapter 2 A First Look at PowerPivot.
Part I: Creating Self–Service Bi Applications Using PowerPivot.
Chapter 3 Assembling Data.
Chapter 4 Enriching Data.
Chapter 5 Self–Service Analysis.
Chapter 6 Self–Service Reporting.
Part II: IT Professional.
Chapter 7 Preparing for SharePoint 2010.
Chapter 8 PowerPivot for SharePoint Setup and Configuration.
Chapter 9 Troubleshooting, Monitoring, and Securing PowerPivot Services.
chaPter 10 Diving into the PowerPivot Architecture.
Chapter 11 Enterprise Considerations.
Part IV: Appendix.
Appendix A: Setting Up the SDR Healthcare Application.
Appendix B: DAX Reference.
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.