Sivakumar Harinath & Ron Pihlgren 
Professional Microsoft PowerPivot for Excel and SharePoint 

The next wave of business intelligence, Self-Service BI, seeks to meet the demands of powerful hardware and shorter decision time frames. This book introduces Power Pivot for Excel and Share Point, showing you how to use this innovative software for self-service analytics and reporting. Authored by key members of the Microsoft team that built the product, this book will guide you through the use of in-memory BI server technology, data analytics e Xpressions, and report gallery. The book also discusses how to deploy and manage sandbox servers, and a companion website provides sample reports and applications.

Содержание

Introduction.

Part I: Introduction.

Chapter 1 Self-Service Business Intelligence and Microsoft Power Pivot.

Chapter 2 A First Look at Power Pivot.

Part I: Creating Self-Service Bi Applications Using Power Pivot.

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 Share Point 2010.

Chapter 8 Power Pivot for Share Point Setup and Configuration.

Chapter 9 Troubleshooting, Monitoring, and Securing Power Pivot Services.

cha Pter 10 Diving into the Power Pivot Architecture.

Chapter 11 Enterprise Considerations.

Part IV: Appendix.

Appendix A: Setting Up the SDR Healthcare Application.

Appendix B: DAX Reference.

Index.

Об авторе

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.

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.