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 developingbusiness intelligencesolutions on SharePoint 2010.
To understand the variousbusiness intelligenceofferings in SharePoint 2010, you need to understand the core SQL Serverbusiness intelligenceconcepts, andthe first part of the book presentsa comprehensive tutorial on those fundamentals. Pro SharePoint 2010 Business Intelligence Solutions then focuseson specific SharePoint business intelligence investments including:
Visio Services Excel Services SQL Server Reporting Services Business Connectivity Services PerformancePoint Services What you'll learn Understand the fundamentals and framework of business intelligence. Learn how tointegrateVisio Services, and discoverthe 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 practicaladvice about deploying and developing forPerformancePoint Services in SharePoint 2010. Learn about the advances in Excel Services and PowerPivot, and their application within SharePoint to practical situations. Gaina deep understandingof the Business Data Services featureset in SharePoint 2010. Who this book is for

This book offersSharePoint developersanessential BI foundation experience andan introduction toSQL Server 2008 tools for business intelligence. This book will also benefit SQL Server developersand administrators who require knowledge of setting up the basic infrastructure on the SharePoint platform for business intelligence. Table of Contents Business Intelligence Basics Visio Services Reporting Services Business Connectivity Services Excel Services PerformancePoint Services

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 What you'll learn * A high level comparison of MOSS 2007 and SharePoint 2010, asking what's new * Available supported and unsupported upgrade choices * Migration strategies to minimize disruption * Strategies for migrating old settings to new * Changes to security model, lists, libraries, and more * Visual changes, the impact on branding, and how to address overall branding artifacts * Statistics, monitoring and usage analysis of existing and new farms * Learn about ribbon changes and customizations * A discussion of being a savvy business user developer, using SharePoint designer 2010 and InfoPath 2010 * Overview of new changes and enhancements to enterprise content management features * Changes to SharePoint APIs Who this book is for Pro SharePoint Migration is for intermediate to advanced SharePoint administrators, and developers who are interested in migrating from SharePoint 2007 to SharePoint 2010 without third-party software.

In this fast-paced 100-page guide, you'll learn to load, display and interact with dynamic, data-powered Visio diagrams in SharePoint 2013 or Office 365. Visio Services Quick Guide gives you the tools to build anything from a simple project workflow to an organizational infrastructure diagram, powered by real data from SharePoint or SQL Server. Colleagues can load your diagrams entirely in the browser, meaning that a single Visio client installation is enough to get started. Readers with JavaScript experience will also find out how to get additional control over Visio diagrams using the JavaScript mashup API, and how to build a custom data provider. The final chapter covers some useful information on administering Visio Services. Get started bringing your Visio diagrams to life with the Visio Services Quick Guide.

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 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 Power View and PerformancePoint Services in SharePoint 2013. * 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 feature set in SharePoint 2013. Who this book is for Pro SharePoint 2013 Business Intelligence Solutions offers SharePoint developers an essential BI foundation experience and an introduction to SQL Server 2012 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.