Professional Microsoft PowerPivot for Excel and SharePoint

  • ID: 1402732
  • Book
  • 384 Pages
  • John Wiley and Sons Ltd
1 of 5
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.

wrox.com

Programmer Forums
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.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

READ MORE
Note: Product cover images may vary from those shown
2 of 5
Introduction.

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.

Index.

Note: Product cover images may vary from those shown
3 of 5

Loading
LOADING...

4 of 5
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.

Note: Product cover images may vary from those shown
5 of 5
Note: Product cover images may vary from those shown
Adroll
adroll