Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligence—and business value—exactly where users want it. Discover how to: 
<li>Manage the development life cycle and build a BI team</li> <li>Dig into SQL Server Analysis Services, Integration Services, and Reporting Services</li> <li>Navigate the Business Intelligence Development Studio (BIDS)</li> <li>Write queries that rank, sort, and drill down on sales data</li> <li>Develop extract, transform, and load (ETL) solutions</li> <li>Add a source code control system</li> <li>Help secure packages for deployment via encryption and credentials </li>
<li>Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models</li> <li>Create and implement custom objects using .NET code</li> <li>View reports in Microsoft Office Excel and Office SharePoint Serverook</li>

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008

Business & Money

Langit, Lynn

Goff, Kevin S.

Mauri, Davide

Malik, Sahil

Welch, John C.

Management & Leadership

Microsoft Press

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.

Microsoft SharePoint 2010: Building Solutions for SharePoint 2010 (Books for Professionals by Professionals)

Computers & Technology

Computer Science

Apress

Business Intelligence (BI) software is everywhere. It is the code and tools that allow you to view different components of a business using a single visual platform, making comprehending mountains of data easier. With SharePoint 2010, Microsoft has married one of the most-used team collaboration tools with its business intelligence products, including PerformancePoint Services and Excel Services. Now, users of SharePoint can have a single place to get a view of their business, its organization and processes, and its financial performance. Constructing this type of portal is a process unique to each business. With Pro SharePoint 2010 Business Intelligence Solutions, authors Sahil Malik and Srini Sistla take you through the different tools, services, and frameworks available for building a BI portal atop SharePoint 2010. With comprehensive coverage of Visio Services, PerformancePoint, Excel Services, and a practical look at building scorecards, dashboards, and other reporting solutions, this book answers the fundamental questions about why and how BI can work for your business. What you'll learn Understand the fundamentals and framework of BI. 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

Pro SharePoint 2010 Business Intelligence Solutions (Expert's Voice in Sharepoint)

Wright, Steve

LLC, Winsmarts

Sistla, Srini

Expert SharePoint 2010 Practices is a valuable compendium of best practices, tips, and secrets straight from the most knowledgeable SharePoint gurus in the industry. Learn from the experts as you dive into topics like multitenancy, solution deployment, business intelligence, and administration. Our team of carefully chosen contributors, most with Microsoft's Most Valuable Professional (MVP) designation bestowed upon them, shares with you the secrets and practices that have brought them success in a wide variety of SharePoint scenarios. Each contributor is passionate about the power of SharePoint and wants to help you leverage the capabilities of the platform in your business but in the proper way. Go beyond procedures and manuals, and benefit from hundreds of years of combined experience, which the authors of Expert SharePoint 2010 Practices provide in these pages. Learn from the masters and take control of SharePoint 2010 like you never have before with Expert SharePoint 2010 Practices! What you'll learn How to design and architect public-facing SharePoint sites Best practices for building business applications with SharePoint Foundation 2010 How to bridge the Office-SharePoint gap that exists in many organizations Best practices around solution deployment in SharePoint 2010 Who this book is for Expert SharePoint 2010 Practices is a book geared toward professional (that is, intermediate- to advanced-level) solution developers, administrators, and architects. Each chapter will stand alone, so all audiences will find valuable advice and reference within the text. Readers should be familiar with SharePoint in their respective capacities and have more than a beginner-level understanding of its features and capabilities. Table of Contents Workflows Bridging the Office-SharePoint Gap Leveraging Content Types Automating Document Assembly Practical Document Management with SharePoint 2010 Forms Services and InfoPath The

Expert SharePoint 2010 Practices (Books for Professionals by Professionals)

Bishop, Darrin

Musters, Ed

Farnhill, Brian

bin Rais, Razi

Richard, Ed

McDermott, Matthew

Orange, Mark

Loriot, Cory R.

Networking & Cloud Computing

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, mo

Pro SharePoint Migration: Moving from MOSS 2007 to SharePoint Server 2010 (Expert's Voice in Sharepoint)

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: 
<ul>
<li>Visio Services </li>
<li>Excel Services </li>
<li>SQL Server Reporting Services </li>
<li>Business Connectivity Services </li>
<li>Power View and PerformancePoint Services </li>
</ul>
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!

Pro SharePoint 2013 Business Intelligence Solutions

Singh, Manpreet

Anandan, Sha

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.

Visio Services Quick Guide: Using Visio with SharePoint 2013 and Office 365

See the best price to sell, buy, or rent books by Malik, Sahil. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Malik, Sahil