Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Pro SharePoint 2010 Business Intelligence Solutions

Pro SharePoint 2010 Business Intelligence Solutions [Kindle Edition]

Steve Wright , Sahil Malik , Srini Sistla

Print List Price: £51.45
Kindle Price: £29.05 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £22.40 (44%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £29.05  
Paperback £44.13  
Kindle Daily Deal
Kindle Daily Deal: At least 60% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Customers Who Bought This Item Also Bought

Product Description

Product Description

What differentiates good organizations from bad? The good ones are those that take advantage of the data they already have and use the feedback that business intelligence gives them to improve their processes. SharePoint is now the delivery platform of choice for Microsoft’s business intelligence products, and in this book we reveal how to get the most from developing business intelligence solutions on SharePoint 2010.

To understand the various business intelligence offerings in SharePoint 2010, you need to understand the core SQL Server business intelligence concepts, and the first part of the book presents a comprehensive tutorial on those fundamentals. Pro SharePoint 2010 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including:

  • Visio Services
  • Excel Services
  • SQL Server Reporting Services
  • Business Connectivity Services
  • PerformancePoint Services
All of this is done using a practical, hands-on format, with enough examples to empower you to use these products in your real-life projects. As compelling as SharePoint and SQL Server business intelligence are together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver such business intelligence solutions. With this book in hand, you become part of that select group.

What you’ll learn

  • Understand the fundamentals and framework of business intelligence.
  • Learn how to integrate Visio Services, and discover the developer story.
  • Practice working with the Secure Store Service.
  • Experience authoring and publishing reports using Report Builder and how to re-purpose published reports in Reporting Services.
  • Glean practical advice about deploying and developing for PerformancePoint Services in SharePoint 2010.
  • Learn about the advances in Excel Services and PowerPivot, and their application within SharePoint to practical situations.
  • Gain a deep understanding of the Business Data Services featureset in SharePoint 2010.

Who this book is for

This book offers SharePoint developers an essential BI foundation experience and an introduction to SQL Server 2008 tools for business intelligence. This book will also benefit SQL Server developers and administrators who require knowledge of setting up the basic infrastructure on the SharePoint platform for business intelligence.

Table of Contents

  1. Business Intelligence Basics
  2. Visio Services
  3. Reporting Services
  4. Business Connectivity Services
  5. Excel Services
  6. PerformancePoint Services

About the Author

Sahil Malik has been working as a consultant in Microsoft technology for about 9 years now. He has worked for many top notch clients across the globe including many fortune 100 companies and government organizations within the United States. Malik started programming in a DOS world, moved to Win32 API, Borland C++, MFC, VC++/ATL, VB 6, and eventually to .NET in both VB.NET and C# worlds. He is currently helping architect a highly visible public website using ASP.NET 2.0/SQL Server 2005, and also leads the office of emerging technologies at a prominent government office. Malik frequently speaks at local user groups and conferences. He also co-wrote Pro ADO.NET with VB .NET 1.1. For his community involvement and contribution, he has also been awarded the Microsoft MVP award.

Product details

  • Format: Kindle Edition
  • File Size: 18868 KB
  • Print Length: 432 pages
  • Publisher: Apress; 1 edition (14 Dec 2010)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B004VHJIJ2
  • Text-to-Speech: Enabled
  • X-Ray:
  • Amazon Bestsellers Rank: #495,844 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars  18 reviews
9 of 10 people found the following review helpful
5.0 out of 5 stars Awesome book on SharePoint 2010 BI technologies 5 Jan 2011
By Josh from Maryland - Published on
One of the best SharePoint 2010 books that I have seen. Here are the 2 main reasons I decided to buy the book:

1) Specific domain expertise around BI using SharePoint, and not a general SharePoint book that tries to boil the ocean by covering many large topics within one chapter each (but leaves you without enough in-depth coverage and expertise developed in any area).
2) I have heard Srini Sistla speak at a couple of SharePoint events on the east coast, and he knows a lot about SharePoint development. I usually buy books by authors who I am familiar with and that I know are active in the SharePoint community.

I'm glad I got it! Here is what I think and what I liked most:

* I felt like I learned something tangible after each chapter. Plenty of practical examples, and step-by-step instructions, to balance out theory.
* Good if you are looking for a practical and technical book to start using some of SharePoint's BI technology hands-on. It's not a book that will teach you BI, so don't look for it to teach you data warehousing and BI like a Ralph Kimball book would . This is more about applying SharePoint related technologies for common BI needs. Chapter 1 does go through the basics of BI, and an introduction to some of the related pieces in the Microsoft stack related to BI (SQL Server 2010, SSIS, etc).
* There aren't many books out there that have a thorough chapter on new SharePoint 2010 capabilities from a BI perspective, let alone a book focusing on them holistically (with real working code, case studies, etc). Coverage of Visio Services was a favorite, as there is so much new power with SharePoint 2010 that isn't covered much elsewhere (even by Microsoft). This book also covers in detail PerformancePoint Services, Excel Services (and Power Pivot), Reporting Services and Business Connectivity Services (BCS).
* The book also does a good job showing the inter-connectivity with other Microsoft technologies, without going off-track. The other technologies always relate to the topic at hand, and show you practical examples that you can leverage (such as with WCF, Office Applications, PowerShell, etc)
* Learning about BCS is a must for any enterprise that wants to properly leverage what SharePoint 2010 can offer. This book will leave you with new skills and clear examples of how they can be leveraged by 2010's BI suite, as well envisioning how the technologies and principles from Chapter 4 can be leveraged elsewhere. The BCS chapter also teaches you how to utilize Enterprise Content Types (ECT) with SharePoint Designer 2010 and Visual Studio 2010.
* You can run the examples yourself since it's using the Adventure Works database (book's code is online as well).
* Structure of the book: Each of the SharePoint BI Services (Visio, Excel, PerformancePoint, SSRS, BCS, etc) have one dedicated chapter a piece. Each of them start with an introduction and a clear overview of "what you will learn" by the end of the chapter. What I really appreciated is also going over any setup and configuration to get you started to use that Service (so it's all in one book, and no need to surf the web for setup details or find an Admin book). Next you have what the authors call a Problem Case, that outlines the goal and solution (step-by-step). There are usually more than one Problem Case in a chapter, and they all build on one another (so the set of Problem Cases are like a larger Case Study). This approach, and the practical and fun cases, make it very easy to follow along and actually "do it" and to help learn and retain the knowledge. Lastly, the chapters end with a 3-block roadmap that summarizes how all the pieces fit together (sort of like a summary slide in a presentation).
* Audience: This book is useful for anyone who works on SharePoint projects and plans to use it's BI components. It also addresses aspects that DBAs, Administrators and Architects would want to know as well. So many roles can use this book, and not just developers.

All in all a great book that I have enjoyed and learned a lot from, and that will serve as a handy resource for frequent reference as well.
3 of 3 people found the following review helpful
5.0 out of 5 stars Most Professionally written book on SharePoint 2010 Business Intelligence 23 May 2011
By vijay mahesh nandivada - Published on
This is one of the best books on Business Intelligence that I came across. One look through it and I couldn't help thinking how much experience has been put by the authors into writing this book. If you are on the search for a book on SharePoint 2010 BI that deals exhaustively on Business Connectivity Services, Reporting Services, Visio Services, Excel Services then I would highly recommend this book. I was particularly amazed by chapter on Visio services which is explained in detail in a comprehensible manner. Details on Business Connectivity services, which is the most important feature in SharePoint 2010, is well explained with illustrations and the code snippets provided is an another highlight feature of this book. The way in which each chapter was presented makes the reader get gradually into the subject and grasp most of it with a single reading. Over all the book was written keeping in mind the novice to the professionals. Truly, the most professionally written book on SharePoint 2010 Business Intelligence.
1 of 1 people found the following review helpful
5.0 out of 5 stars A must read for SharePoint developers and Admins! 15 May 2011
By Shishir Bhandari - Published on
I was inquisitive about Business intelligence in SharePoint but after my initial search i thought there aren't any good books in market, which deals with BI in SharePoint, And then i landed up with this book. It is exactly what i was looking for.

It has good layout. It discusses the topic in detail and then explains it by giving real life problem and step by step solutions. I liked the fact that the author has tried to show pictures and diagrams for explaining. "A picture is worth a thousand words"...this is really true. One of the best feature WHY this book should be sought after. Reading from book and trying to correlate as to where and how it looks in the site is quite some effort. I didnt have to go through that with this book.

Code snippets were beneficial since i was trying to execute the examples simultaneously.
I like the way book has been divided into various topics / chapters. Excel services, visio services are separate chapters. I can always refer to them while implementing it.

Overall a great book! A must have for SharePoint developers and admins who work on Business Intelligence or have interest in learning it!
1 of 1 people found the following review helpful
5.0 out of 5 stars A Systems Administrator's perspective 24 Feb 2011
By RMinSharePoint - Published on
Probably like most people, I only review two kinds of books: the ones
I really hate, and those that I really liked. This book is one of
those that I really liked and over all found useful - and here is why.

The first thing is that it actually illustrate exactly what it
advertise - solutions! Which for me as a system administrator ( and
not so much of a developer), is exactly what I want.

I particularly needed excel and performance solutions, but thanks to
this book I discovered the powerful report services that you can find
In Sharepoint.

Another fact I liked about this book are the vivid explanations. This
book makes sure that every little detailed is illustrated. That
doesn't mean that you will only find pictures pages, but great
explanations throughout the entire book.

If you are a medium to intermediate Sharepoint administrator, or simply if you are simply curious about about SharePoint and what real solutions look like, I absolutely recommend to add this book on your reading.
1 of 1 people found the following review helpful
5.0 out of 5 stars Exceptional Read !! 15 Feb 2011
By AN - Published on
When I started reading this book I was surprised at how easy it was. Most technical books are filled with acronyms and jargon that often distract the reader and makes them very difficult to read. Chapter 6 - Performance Point was my favorite chapter because not only did it provide a great overview of the concepts and technology, it also provided great practical examples. To confirm my thinking in this area, I gave the book to a SharePoint developer on my team who was interested in learning about Performance Point. Within a short time, he created an amazing Performance Point demo which we now use in our pre-sales activities. Overall, I think this is a great book and I will continue to recommend it to others!
Were these reviews helpful?   Let us know

Popular Highlights

 (What's this?)
With content types, all of the functionality of SharePoint is now available for use with PerformancePoint artifacts. This includes participating in workflows, using information rights management policies, and including PPS objects in any list or library where the PPS features and content types are active. &quote;
Highlighted by 3 Kindle users
The selections made are written to PerformancePoint's database for later use. If the user returns to that page days later, that selection will still exist. The number of days the selection is retained can be configured in SharePoint Central Administration. &quote;
Highlighted by 3 Kindle users
most of the business intelligence objects, including the dashboards themselves, are also stored in lists and libraries within SharePoint's content databases. &quote;
Highlighted by 3 Kindle users

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category