Familiarity with Microsoft Excel and Microsoft SharePoint are very helpful, because PowerPivot built in both products. This book covers the first version PowerPivot, which ships with SQL Server 2008 R2 and enhance Microsoft Office 2010. Through the extended example, it shows how to build an application PowerPivot from end to end. Companion Web site includes all sample applications and reports are discussed. What This Book Covers After discussing the self-service BI and motivation to create PowerPivot, this book provides quick, end-to-end tutorial shows how to create and publish simple PowerPivot applications. He provides a high level view of the two components that make up PowerPivot - PowerPivot for Excel and PowerPivot for SharePoint. Chapter 2, "A First Look at PowerPivot," walks you through simple examples make PowerPivot applications from end to end. In the process, it shows how to set up two PowerPivot components, and describe the normal workflow to make application simple PowerPivot. Chapter 3, "Assembling Data," beginning of Part II of the book, and explains how to bring data into PowerPivot from various external data sources. It also introduces examples convey that you will build in this chapter and the next. Chapter 4, Enriching the Data, "shows" how to improve the data brought into your application by creating relationships and using the expression language's PowerPivot, Expression Data Analysis (DAX). Chapter 5, Self-Service Analysis, "explaining" how to use the data PowerPivot with various features of Excel such as PivotTables, PivotCharts, and slicers for analysis. Chapter 5 also dig deeper into DAX, shows how to create and use the steps DAX. Chapter 6, Self-Service Reporting, "shows" how to publish your workbook to the server side PowerPivot PowerPivot (PowerPivot for SharePoint), and take advantage of its features to view and update reports PowerPivot. It describes the components of SharePoint 2010 that are relevant to PowerPivot, and see how SharePoint PowerPivot to interact with the components. Chapter 8, "PowerPivot for SharePoint Setup and Configuration," provides instructions on how to set up and configure SharePoint farm machinery multi that contains PowerPivot for SharePoint. Chapter 9, "Troubleshooting, Monitoring, and Securing Services PowerPivot," gives tips on how to solve the problem PowerPivot for SharePoint. It also shows how to monitor the health of your PowerPivot for SharePoint environment, and discuss relevant security issues. Chapter 10, "dive into PowerPivot Architecture," describes on a deeper level PowerPivot architecture, both client and server. It also describes the Windows Identity Foundation and discuss the use of Kerberos in the context PowerPivot for SharePoint. Chapter 11, "Enterprise Considerations," to talk about general PowerPivot SharePoint enterprise for consideration: capacity planning, optimize the environment, upgrade considerations, and upload performance. Appendix A provides instructions for preparing the source data used to build the Healthcare SDR extended example in Chapter 3 to 6. In addition, two "bonus" elements which are available online at this Web site companion book: Appendix B is a comprehensive reference that describes all DAX DAX functions and provide a code snippet that shows how to use it.