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.
|Chapter 2: A First Look at PowerPivot|
|Chapter 3: Assembling Data||Download|
|Chapter 4: Enriching Data||Download|
|Chapter 5: Self-Service Analysis||Download|
|Chapter 6: Self-Service Reporting||Download|
|Appendix A: Setting Up the SDR Healthcare Application|
This file was added to the complete Appendix A download on 6/25/10.
|Appendix B: DAX Reference (Online Chapter)||Download|
This file was missing from the original Appendix A .zip file and is now available for download with the rest of the code download.
|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.
|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).
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.