Dive into the business intelligence (BI) features in SharePoint 2010—and use the right combination of tools to deliver compelling solutions. This practical guide helps you explore several BI application services available in SharePoint 2010 and Microsoft SQL Server 2008 R2. You’ll learn each technology with step-by-step instructions, and determine which ones work best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst. Choose the BI tools that meet your needs—and learn how they work together Examine the BI lifecycle, from determining key performance indicators to building dashboards Take Microsoft Excel further—gain more control and functionality with web-based Excel Services Mash up data from multiple sources using PowerPivot for Excel 2010 Create data visualizations with objects, context, and metrics using Microsoft Visio Services Build dashboards, scorecards, and other monitoring and analysis tools with PerformancePoint Services Use SharePoint to view BI reports side by side, no matter which tools were used to produced them Your companion web content includes: Interactive exercises that help you try out concepts or techniques Code samples that enable you to work with the exercises

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

This book provides a fresh take on Microsoft’s premier collaboration solution. A critical resource if you’re developing on the SharePoint platform, this book features a complete focus on the new features and capabilities of SharePoint 2010. Through a thorough treatment of sites, web parts, data management, portal solutions, and business intelligence capabilities, you’ll appreciate author Sahil Malik’s concise yet highly readable text. With this book, you’ll gain intermediate-level guidance for designing and deploying exciting business solutions based on Microsoft SharePoint 2010.

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.

The Only Book That’s Completely Focused on Maximizing the Business Value of SharePoint 2010 Solutions Essential SharePoint® 2010 approaches Microsoft SharePoint Server 2010 from a strict business value perspective, explaining exactly how to plan and implement SharePoint solutions to achieve superior business results. The authors are leading enterprise SharePoint consultants and draw on their unsurpassed experience to focus on the SharePoint features that offer the most real-world value. You’ll find practical advice about how to succeed with knowledge management, business intelligence, and process improvement, and how to derive value from new innovations such as social tagging and mashups. The book includes comprehensive, “in the trenches” guidance on planning, architecture, governance, training, and other key issues most SharePoint books ignore. The authors identify success factors, intangibles, and “gotchas,” helping you systematically reduce project risk and time-to-value ratio. Learn how to Customize your best portal or collaboration strategy Sustain a portal for continual, measurable value Leverage the new community and social features in SharePoint 2010 Succeed with enterprise content management Streamline business processes with Workflow and Forms Choose the right roles for Web collaboration, search, and Microsoft Office Plan for secure external collaboration Migrate smoothly from SharePoint 2007 Train and communicate for a successful launch Whether you’re a business leader, IT manager, architect, analyst, developer, or consultant, this book will help you tightly align SharePoint projects with business strategy to deliver outstanding results.

Get the critical, in-depth information you need to administer SharePoint 2010. Led by SharePoint MVPs and featuring insights from the SharePoint community and members of the SharePoint Team at Microsoft, you'll discover how to plan, design, deploy, and manage strategic solutions using SharePoint 2010, Microsoft SQL Server, Windows PowerShell, and other key technologies. Topics include architecture, deployment scenarios, design considerations, security best practices, high availability, performance, centralized administration, disaster recovery, customization, solution development, and upgrade and migration strategies. Key solutions include building and managing a server farm, automating tasks, FAST search application management, enterprise and web content management, and business intelligence. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Build Data-Driven Web Applications with SharePoint 2010 Leverage the revolutionary development capabilities in SharePoint 2010 to build web-based business applications. Microsoft SharePoint 2010 Web Applications: The Complete Reference gets you up and running on the platform and explains how to integrate application services such as content management, business intelligence, offline synchronization, and workflow into your applications. After reviewing the fundamentals of SharePoint 2010, this comprehensive resource covers the presentation, application services, and data access layers, and discusses the key tools and techniques that are most appropriate for delivering functionality within each layer. Packaging, deployment, and configuration are also covered in this hands-on guide. Real-world examples illustrate specific features, and the code samples contained throughout the book can be used in your own applications.

PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files. PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence

The Wrox SharePoint 2010 SharePoint911 Three-Pack combines the contents of three full e-books written by the experts from SharePoint911. That's over 1800 pages of hands-on advice from Todd Klindt, Shane Young, Laura Rogers, Randy Drisgill, Jennifer Mason, John Ross, and Larry Riemann, among others. In Beginning SharePoint 2010: Building Business Solutions with SharePoint (ISBN 978-0-470-61789-2) by Amanda Perran, Shane Perran, Jennifer Mason, and Laura Rogers, readers learn the core concepts, terminology, and features of SharePoint 2010. In Professional SharePoint 2010 Branding and User Interface Design (ISBN 978-0-470-58464-4) by Randy Drisgill, John Ross, Jacob J. Sanford, Paul Stubbs, and Larry Riemann, the reader gets a deep dive into branding a SharePoint site. In the third book of the set, the SharePoint bestseller Professional SharePoint 2010 Administration (ISBN 978-0-470-53333-8) by Todd Klindt, Shane Young, and Steve Caravajal, the authors provide a detailed look at the administration tools available in SharePoint 2010.

The SharePoint 2010 Wrox 10-Pack Digital Library contains these ten books, priced at a considerable savings off of the combined list prices to give you a complete SharePoint 2010 e-book library: Professional SharePoint 2010 Administration ISBN: 9780470533338 Professional SharePoint 2010 Development, 2nd edition ISBN: 9781118131688 Real World SharePoint 2010: Indispensable Experiences from 22 MVPs ISBN: 9780470597132 Professional Business Connectivity Services in SharePoint 2010 ISBN: 9781118043790 Professional SharePoint 2010 Cloud-Based Solutions ISBN: 9781118076576 SharePoint 2010 Enterprise Architect's Guidebook ISBN 9780470643198 SharePoint Server 2010 Enterprise Content Management ISBN: 9780470584651 SharePoint 2010 Field Guide ISBN: 9781118105054 SharePoint 2010 Six-in-One ISBN: 9780470877272 Professional SharePoint 2010 Branding and User Interface Design ISBN: 9780470584644