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.

To get ahead in today's hyper-competitive marketplace, your business has to take advantage of the data you already have and mine that data to give you new insight, metrics, and clues to what drives successful customer interactions. In Pro SharePoint 2013 Business Intelligence Solutions, you'll learn exactly how to unlock that magic, build business intelligence facilities on SharePoint, and glean insights from data to propel your business to the next level. To understand the various business intelligence offerings in SharePoint 2013, 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 2013 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including: Visio Services Excel Services SQL Server Reporting Services Business Connectivity Services Power View and PerformancePoint Services Authors Manpreet Singh, Sha Anandan, Sahil Malik, and Steve Wright walk you through all of this material comprehensively in practical, hands-on format, with plenty of 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. Get your copy of Pro SharePoint 2013 Business Intelligence Solutions today!

Learn to build and deliver SharePoint BI applications Written by a team of leading SharePoint and Business Intelligence (BI) experts, this unique book-and-DVD package shows you how to successfully build and deliver BI applications using SharePoint 2010. Assuming no previous SharePoint experience, the authors deliver a clear explanation of what SharePoint will do for your BI and information management capabilities. Each lesson in the book is reinforced with a helpful tutorial on the DVD and cover topics such as interactive reporting with Excel, document sharing for collaborative reporting, and controlling data sources. As you learn best practices for configuring and securing SharePoint 2010 BI applications and planning and implementing your SharePoint BI project plan, you'll be well on your way to gaining a solid foundation of understanding and working with SharePoint 2010 and BI. Provides an invaluable training book-and-DVD package that takes you through building and delivering BI applications using SharePoint 2010 Features an accompanying video tutorial for each lesson covered in the book, along with a "Try It" section at the end of each lesson Covers interactive reporting with excel Covers Power Pivot advanced analytics Details report and document sharing for collaborative reporting Shows how to use SharePoint lists and libraries for data sources repositories in your BI projects Explains how to control data sources, reports and business intelligence content with permissions and workflow approvals. With this unique book-and-DVD combo, you'll be well on your way to successfully building and delivering BI applications using SharePoint 2010. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

SharePoint 2010 is today’s leading presentation and deployment system for Business Intelligence (BI) solutions based on Microsoft technologies. This book brings together all the information you need to successfully implement and use SharePoint 2010’s powerful BI capabilities. It reflects the unsurpassed real-world experience of five expert consultants at RDA, a Microsoft Gold Partner specializing in delivering advanced BI solutions with SharePoint. You’ll first learn how to prepare SharePoint 2010 for the deployment of BI solutions. Next, the authors walk through integrating, configuring, and using Reporting Services, PerformancePoint Services, PowerPivot, Visio Services, and other key related technologies. Building on what you’ve learned, you’ll walk step-by-step through constructing and integrating two end-to-end BI solutions. Finally, in a comprehensive troubleshooting section, the authors present today’s most common SharePoint BI issues, identify proven solutions, and teach effective problem-solving techniques. Get started fast, by using the Business Intelligence Center’s prebuilt site collection and template Build integrated, end-to-end SharePoint BI solutions Present business data to the enterprise through Excel Services Install, configure, and integrate Reporting Services and the Reporting Services Add-In for SharePoint Define document library content types and manage reports Use Report Viewer Web Parts to render reports on SharePoint web pages Build enterprise dashboards with PerformancePoint Services Secure dashboards via data source delegation, SharePoint permissions, and groups Analyze enormous datasets with PowerPivot for Excel and SharePoint Publish Visio 2010 data-driven web diagrams that integrate multiple data sources Utilize the fine-grained security available through Visio Graphics Service Troubleshoot problems with Reporting Services, PerformancePoint Services, PowerPivot, and Visio Services

Comprehensive coverage on Business Connectivity Services within SharePoint 2010 As Microsoft’s new multipurpose portal technology, Business Connectivity Services (BCS) is a brand new way for SharePoint users to seamlessly access and integrate data from any application or databases within SharePoint 2010. With this in-depth guide, a team of SharePoint experts walks you through the features of the new BCS, including the ability for users to view and modify the data from SharePoint 2010 with BCS. You’ll explore how to use BCS, deploy solutions, create external content types and lists, create .NET host connectors, and more. Business Connectivity Services (BCS) allows you to seamlessly access and integrate data from any application or databases within SharePoint 2010 Demonstrates how to create BCS solutions with the SharePoint Designer in SharePoint 2010 and Office Provides a clear overview of the BCS API Addresses creating external content types and lists Explains how to develop search-based solutions with BCS Professional Business Connectivity Services in SharePoint 2010 provides you with thorough coverage on this new multipurpose portal technology.

An authoritative guide to extending SharePoint's power with cloud-based services If you want to be part of the next major shift in the IT industry, you'll want this book. Melding two of the hottest trends in the industry—the widespread popularity of the SharePoint collaboration platform and the rapid rise of cloud computing—this practical guide shows developers how to extend their SharePoint solutions with the cloud's almost limitless capabilities. See how to get started, discover smart ways to leverage cloud data and services through Azure, start incorporating Twitter or LinkedIn into your solutions, find the best ways to secure everything, and much more. Shows developers how to use Microsoft SharePoint 2010 to create scalable, cloud-based solutions Melds the hottest new trend in the industry—developing, hosting, managing, or storing code in the cloud—with what SharePoint developers need to know to weave these technologies into their solutions Provides developer patterns, real-world examples, and invaluable walkthroughs Topics include SQL Azure for data management and BI, building an Azure-based corporate tax service, connecting Linked In and SharePoint profile data, creating a filterable Twitter dashboard, leveraging Bing Maps Geo services, maintaining security, and more SharePoint developers, discover exciting new ways to extend SharePoint's functionality with this practical and content-rich guide.

Learn from Pro SharePoint Migration on how to migrate your existing farm - infrastructure, upgrade approaches, code, branding, and impact of new features of SharePoint 2010 - in a strategic way that results in smooth transition. Noted author Sahil Malik, with Srini Sistla, work together to provide detailed strategies and tools to assess, plan and execute a SharePoint 2010 migration that is efficient and cost-effective—and that doesn't use expensive third-party software. The "clean slate" approach embraced by this book, coupled with flexible tools designed by Microsoft and the author, will provide you with the statistics, charts, and diagrams necessary to perform a meaningful assessment of your current SharePoint 2007 environment. You'll then be able to plan the lowest-cost, least-hassle way to migrate your current environment, and its applications and data, to SharePoint 2010, and how to map your existing use of SharePoint 2007 to the new features and enhancements in SharePoint 2010. Pro SharePoint Migration will help you: Gain a better understanding of high level comparison and changes you need to learn between the two versions To migrate or not? Learn about new functionality that might replace your existing custom built code or non-code based solutions. Build a strong toolset to create, update, administer, and migrate 90% of the most commonly used SharePoint objects Grasp the intricacies of the SharePoint 2010 application programming interface (API) Become a better SharePoint 2010 administrator in your newly-migrated environment