Steven Mann - Microsoft Sharepoint 2010 Business Intelligence Unleashed

Steven Mann
Chuck Rivel
Ray Barley
Jim Pletscher
Aneel Ismaily

800 East 96th Street, Indianapolis, Indiana 46240 USA

Microsoft SharePoint 2010 Business Intelligence Unleashed

Copyright 2011 by Pearson Education, Inc.

All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-0-672-33551-8

ISBN-10: 0-672-33551-4

Editor-in-Chief
Greg Wiegand
Executive Editor
Neil Rowe
Development Editor
Mark Renfrow
Managing Editor
Kristy Hart
Project Editor
Andy Beaster
Copy Editor
Keith Cline
Indexer
Erika Millen
Proofreader
Charlotte Kughen
Technical Editor
Mark Meyerovich
Publishing Coordinator
Cindy Teeters
Book Designer
Gary Adair
Composition
Gloria Schurick

Library of Congress Cataloging-in-Publication Data is on file.

Printed in the United States of America

First Printing: May 2011

Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Pearson Education, Inc. cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.

Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an as is basis. The author and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.

Bulk Sales
Pearson offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales. For more information, please contact:

U.S. Corporate and Government Sales
1-800-382-3419

For sales outside of the U.S., please contact:

International Sales
+1-317-581-3793

Steve Mann was born and raised in Philadelphia, Pennsylvania, where he still resides today. He is an Enterprise Applications Engineer for Morgan Lewis and has more than 17 years of professional experience. Steve was previously a Principal Architect for RDA Corporation where he worked for over 13 years.

For the past 8 years, he has primarily focused on collaboration and business intelligence solutions using Microsoft technologies. Steve managed the internal BI Practice Group at RDA for several years. He was also heavily involved within RDAs Collaboration/Search Practice Group.

He has authored and co-authored several books related to the subject of SharePoint Server 2010. Steves blog site can be found at www.SteveTheManMann.com.

Chuck Rivel is currently employed at RDA as a Principal Architect which involves scoping, designing, developing and delivering custom data warehouse projects for many different industries. He has over 14 years experience working with MS technologies and the last 8 years have been focused on DW\BI development. Currently, he is the BI Technical Lead for RDA, which is responsible for the technical direction of the BI team within RDA and for creating training programs for existing RDA employees to learn the BI toolset.

Ray Barley is a Principal Architect at RDA Corporation and has worked as a developer, analyst, project manager, architect, trainer and independent consultant. He has been focused on architecting and delivering Business Intelligence solutions since 2005. Ray helps to run the Baltimore SQL Server User group, is a frequent speaker at local user group meetings, and a frequent contributor to MSSQLTips.com.

Jim Pletscher is a Senior BI Consultant with RDA and has worked in the IT field for more than 15 years. Jim first began exploring OLAP technologies with SQL Server 2000, and has worked extensively with SQL Server 2005 and 2008, developing Reporting and Analysis solutions for numerous clients in a variety of industries over the past 8+ years. He is originally from Pennsylvania, and lives there now, but has also lived in Northern California as well.

Aneel Ismaily was born and raised in Karachi, Pakistan and then moved to the United States at the age of 18. Since then he has lived in Atlanta, GA. Aneel joined Georgia State University in 2001 and finished his BS degree from there in Computer Science. He is currently enrolled in a professional MBA program at Georgia State University and expecting to graduate in Dec, 2012. Aneel brings over eight years of experience to RDA in designing, developing, deploying, and supporting Business Intelligence Solutions. He currently holds Sr. Software Engineer Position with RDA. Prior to RDA, Aneel was employed at BCD Travel as a BI Solution Developer and previously as a Database Administrator. You can learn more about Aneel at http://www.linkedin.com/in/aismaily.

To my family, especially my wife Jen, for being so excited for me on
getting the opportunity
to write the book and then pushing me to get it done.

Chuck Rivel

To my wife Karen, and our children Katelyn, Jessica
and Joshua. To my dad for teaching me the value of perseverance.

Ray Barley

Id like to thank RDA and my colleagues there for creating an environment
where we can learn together and encouraging me to take on
new challenges. Id also like to thank Ralph Cesea and Dominic
Eve who first got me interested in Business Intelligence technologies
many years ago.

Jim Pletscher

I dedicate this book to each and every member of my family for their
unconditional
support in all aspects of my life. I love you all!

Aneel Ismaily

Special thanks to Deepak Gupta from RDA for pitching the idea to me for a SharePoint BI book. In addition to Deepak, I really appreciated my colleagues efforts and assistance in authoring this with me - I wouldnt have had enough time or energy to complete this on my own. Thanks to Neil Rowe and Sams Publishing for allowing us to produce a focused authoritative guide within the Unleashed series.

Steve Mann

I want to thank all of the colleagues that I have worked with over the years. Because you shared your knowledge to me on the different technologies we have worked with over the years, those experiences gave me the confidence to want to share my thoughts in an effort to help others learn in the same way as I have learned from all of you. In addition, I want to thank Sams Publishing for providing this vehicle to me and my fellow coauthors. Lastly, special thanks to Steve Mann for asking me to come on board.

Chuck Rivel