Professional Microsoft Powerpivot for Excel and Sharepoint ePub (Adobe DRM) download by Sivakumar Harinath

Professional Microsoft Powerpivot for Excel and Sharepoint

Wrox
Publication date: May 2010
ISBN: 9780470913444
Digital Book format: ePub (Adobe DRM)
Rating starRating starRating star 1 user rated this ebook - write a review of Professional Microsoft Powerpivot for Excel and Sharepoint.

Buy ePub

Our price:
$29.99
GET THIS EBOOK
FOR FREE!
Join our Facebook sweepstake, share and
get 10 likes. Winners
get notified in 24H!
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.

What This Book Covers

After discussing self-service BI and the motivation for creating PowerPivot, the book presents a quick, end-to-end tutorial showing how to create and publish a simple PowerPivot application. It then drilsl into the features of PowerPivot for Excel in detail and, in the process, builds a more complex PowerPivot application based on a real-world case study. Finally, it discusses the server side of PowerPivot (PowerPivot for SharePoint) and provides detailed information about its installation and maintenance.

Chapter 1, "Self-Service Business Intelligence and Microsoft PowerPivot," begins Part I of the book. This chapter describes self-service BI and introduces PowerPivot, Microsoft's first self-service BI tool. It provides a high-level look at the two components that make up PowerPivot - PowerPivot for Excel and PowerPivot for SharePoint.

Chapter 2, "A First Look at PowerPivot," walks you through a simple example of creating a PowerPivot application from end to end. In the process, it shows how to set up the two components of PowerPivot, and describes the normal workflow of creating a simple PowerPivot application.

Chapter 3, "Assembling Data," starts off Part II of the book, and explains how to bring data into PowerPivot from various external data sources. It also introduces the extended example that you will build in this and subsequent chapters.

Chapter 4, "Enriching Data," shows how to enhance the data you brought into your application by creating relationships and using PowerPivot's expression language, Data Analysis Expressions (DAX).

Chapter 5, "Self-Service Analysis," describes how to use your PowerPivot data with various Excel features, such as PivotTables, PivotCharts, and slicers to do analysis. Chapter 5 also delves further into DAX, showing how to create and use DAX measures.

Chapter 6, "Self-Service Reporting," shows how to publish your PowerPivot workbook to the server side of PowerPivot (PowerPivot for SharePoint), and make use of its features to view and update PowerPivot reports. It also shows how to use the data in a PowerPivot workbook as a data source for reports created in other tools such as Report Builder 3.0 and Excel.

Chapter 7, "Preparing for SharePoint 2010," is the first chapter in P

Please sign in to review this product.
Devices:
Professional Microsoft PowerPivot for Excel and SharePoint ePub (Adobe DRM) can be read on any device that can open ePub (Adobe DRM) files.

File Size:
16699 Kb
Language:
ENG
Copy From Text:
Enabled. Limit of 5 selections within 365 days.
Printing:
Enabled and unlimited.
Professional Microsoft Powerpivot for Excel and Sharepoint ePub (Adobe DRM) download by Sivakumar Harinath
Wrox, May 2010
ISBN: 9780470913444
EAN:  9780470913444
ePub (Adobe DRM)
eBook price: $29.99
Professional Microsoft Powerpivot for Excel and Sharepoint PDF (Adobe DRM) download by Sivakumar Harinath
Wrox, June 2010
ISBN: 9780470912416
EAN:  9780470912416
PDF (Adobe DRM)
eBook price: $29.99
Other books by Sivakumar Harinath
Professional Microsoft SQL Server 2012 Analysis Services with MDX and Dax PDF (Adobe DRM) download by Sivakumar Harinath
Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
Sivakumar Harinath & Denny Guang Lee & Denny Guang-Yeu Lee & Ronald Pihlgren
Wrox, October 2012
ISBN: 9781118101100
Format: PDF, ePub
List Price: $38.99 Our price: $35.99
Professional Microsoft SQL Server Analysis Services 2008 with MDX PDF (Adobe DRM) download by Sivakumar Harinath
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Sivakumar Harinath & Sethu Meenakshisundaram & Robert Zare
Wrox, December 2009
ISBN: 9780470247983
Format: PDF, ePub
Our price: $32.99
MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase PDF (Adobe DRM) download by Sivakumar Harinath
MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
Sivakumar Harinath & George Spofford & Christopher Webb
John Wiley & Sons, Inc., May 2006
ISBN: 9780471748083
Format: PDF
List Price: $59.99 Our price: $56.99
Professional SQL Server Analysis Services 2005 with MDX PDF (Adobe DRM) download by Sivakumar Harinath
Professional SQL Server Analysis Services 2005 with MDX
Sivakumar Harinath & Stephen R. Quinn
Wrox, April 2006
ISBN: 9780764579189
Format: PDF
Our price: $32.99