Wiley.com
Print this page Share

Professional Microsoft PowerPivot for Excel and SharePoint

ISBN: 978-0-470-58737-9
384 pages
June 2010
Professional Microsoft PowerPivot for Excel and SharePoint (0470587377) cover image

Description

With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot.

Professional Microsoft PowerPivot for Excel and SharePoint describes all aspects of PowerPivot and shows you how to use each of its major features. By the time you are finished with this book, you will be well on your way to becoming a PowerPivot expert.

This book is for people who want to learn about PowerPivot from end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products.

This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end.

The companion Web site includes all the sample applications and reports discussed.

See More

Table of Contents

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.

See More

Author Information

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.

See More

Related Websites / Extra

http://content.wrox.com/wroxfiles/Chapter02.zip Chapter 2: A First Look at PowerPivot
http://content.wrox.com/wroxfiles/AppendixA.zip Appendix A: Setting Up the SDR Healthcare Application
See More

Downloads

Download TitleSizeDownload
ReadMe File 544 bytes Click to Download
Chapter 2: A First Look at PowerPivot
http://content.wrox.com/wroxfiles/Chapter02.zip
   
Chapter 3: Assembling Data 979.56 KB Click to Download
Chapter 4: Enriching Data 1.60 MB Click to Download
Chapter 5: Self-Service Analysis 1.70 MB Click to Download
Chapter 6: Self-Service Reporting 1.97 MB Click to Download
Appendix A: Setting Up the SDR Healthcare Application
http://content.wrox.com/wroxfiles/AppendixA.zip
   
DatabaseGroupName.xlsx
This file was added to the complete Appendix A download on 6/25/10.
9.23 KB Click to Download
Appendix B: DAX Reference (Online Chapter) 1.27 MB Click to Download
See More

Errata

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
Appendix A DatabaseGroupName.xlsx
This file was missing from the original Appendix A .zip file and is now available for download with the rest of the code download.
6/24/10
41 Error in Text
Currently says "Drag and drop the CalendarYear and CalendarYearMonthLabel columns from DimDate table to RowLabels."

There is no column named CalendarYearMonthLabel, needs to be CalendarMonthLabel as figure 2-15 on page 41 shows.
06/24/2010
42 Error in Text
Step 5 should say: Drag and drop ProductSubCategoryName column from DimSubProductCategory table to the Row Labels drop zone. On a PivotChart the bottem left drop zone is called: Axis Fields (Categories).
06/24/2010
247 Text correction
Error on page 247. The statement is: The last step ? PowerPivot System Service to Analysis Services ? is performed using Windows authentication via the Claims-To-Windows Token Service (c2wts) The statement should be: The last step ? PowerPivot System Service to Analysis Services ? is performed using Windows authentication via the PowerPivot System Service?s Windows service account.
08/23/10
See More

Buy Both and Save 25%!

+

Professional Microsoft PowerPivot for Excel and SharePoint (US $44.99)

-and- Beginning Microsoft SQL Server 2012 Programming (US $39.99)

Total List Price: US $84.98
Discounted Price: US $63.73 (Save: US $21.25)

Buy Both
Cannot be combined with any other offers. Learn more.

Related Titles

Back to Top