Close
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Search
Professional Microsoft PowerPivot for Excel and SharePoint: With Microsoft Office 2010 and SQL Server Gemini
Foyalty 87
Professional Microsoft PowerPivot for Excel and SharePoint: With Microsoft Office 2010 and SQL Server Gemini (Paperback)
Order now for Free delivery in the UK for orders over £10 or choose Express Delivery to receive in 2 business days. More on delivery...
Order Options List Price Online Price Save Availability Login for Quick Checkout
Delivery:

To home, business or free to our stores. Click for more info.

£29.99 £21.89 27%

Despatched in 1 business day.

Add to Basket
Click & Collect:

Order now to collect from 11am tomorrow. In stock items only. Click for more info.

£29.99 £29.99  

Stores - out of stock

 
New & Used:

Our marketplace sellers will deliver to your chosen address. Click for more info.

From £6.54  

In stock at one or more sellers.

Buy - Select Seller

Product Synopsis

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 Part III of the book. It describes the components of SharePoint 2010 that are relevant for PowerPivot, and looks at how PowerPivot for SharePoint interacts with those components. Chapter 8, "PowerPivot for SharePoint Setup and Configuration," provides instructions on how to set up and configure a multi-machine SharePoint farm that contains PowerPivot for SharePoint. Chapter 9, "Troubleshooting, Monitoring, and Securing PowerPivot Services," gives tips on how to troubleshoot PowerPivot for SharePoint issues. It also shows how to monitor the health of your PowerPivot for SharePoint environment, and discusses relevant security issues.

Chapter 10, "Diving into the PowerPivot Architecture," describes at a deeper level the architecture of PowerPivot, both client and server. It also explains the Windows Identity Foundation and discusses the use of Kerberos in the context of PowerPivot for SharePoint. Chapter 11, "Enterprise Considerations," talks about common PowerPivot for SharePoint enterprise considerations: capacity planning, optimizing the environment, upgrade considerations, and uploading performance. Appendix A provides instructions for setting up the data sources that are used to build the SDR Healthcare extended example in Chapters 3 through 6. Additionally, two "bonus" elements are available online at this book's companion Web site: Appendix B is a comprehensive DAX reference that describes all the DAX functions and provides code snippets that show how to use them. A special chapter describes real-world scenarios in which PowerPivot is used to solve common problems.

Computing & IT >> Computer hardwareComputing & IT >> Databases >> Data warehousingComputing & IT >> Databases >> Database software Publisher: John Wiley & Sons Inc Publication Date: 15/06/2010 ISBN-13: 9780470587379  Details: Type: Paperback Format: Books
Availability: Despatched in 1 business day. Login for Quick Checkout Add to Basket

More books by Sivakumar Harinath

More books by Ron Pihlgren

More books by Denny Guang-Yeu Lee

Leave Review

Delivery

Please note for the New & Used Marketplace different terms and conditions apply.

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.

Location1st BookEach additional bookAverage Delivery Time
UK Second ClassAvailable free for orders over £10* or £2.50Available free for orders over £10* or £1.003-7 Days
UK First Class£4.50£1.001-2 Days
UK Courier£7.00£1.001-2 Days
Western Europe** Courier£17.00£3.002-3 Days
Western Europe** Airmail£5.00£1.504-14 Days
USA / Canada Courier£20.00£3.002-4 Days
USA / Canada Airmail£7.00£3.004-14 Days
Rest of World Courier£22.50£3.003-6 Days
Rest of World Airmail£8.00£3.007-21 Days

* Available free for orders over £10 = When offered a delivery preference choose 'For Cheapest Postage' for our freepost in the UK offer. This is not available on the 'For Faster Delivery' option.

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

Delivery Help & FAQs

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

You might also like

A Generative Theory of Relevance
Lavrenko, Victor;
 
£78.50£70.6510%Add to Basket
Ad-hoc, Mobile and Wireless Networks ...
Coudert, David; Simplot-Ryl, David;...
 
£90.00£81.0010%Add to Basket
Advances in Computer Science and...
Sarbazi-Azad, Hamid; Parhami, ...
 
£153.00£137.7010%Add to Basket
Advances in Databases: Concepts,...
Kotagiri, Ramamohanarao; Krishna, P....
 
£144.00£129.6010%Add to Basket
Your Shopping Basket
Total number of items: 0
Sub total: £0.00
Edit Basket Go to Checkout
Select Currency: $ £
enCounter Culture
Signed Books and Copies
Animators Survival Kit
Latest Blog
Helping kids discover London's wildlife
23/10/2014

Autumn's natural wonders, even in a city like London, can offer all manner of fun and adventure this half-term, suggests Laura from our Royal Festival Hall shop.

GUEST BLOG: Poetry and art - a wartime romance
17/10/2014

Christiana Spens, illustrator and Director of 3:AM Press, looks at the the important relationship between books and the artwork that adorns them.

A book is for life, not just for GCSE
14/10/2014

Charlotte from our Bristol branch on how the books we read at school often resonate with us throughout lives, as well as starting us out on a lifelong journey of literary discovery.

View all Blog Entries
Twitter
© W&G Foyle Ltd
Version: 1.0.0.19527