This book and video package introduces IT professionals, DBAs, and business analysts who are just starting to get a handle on Microsoft Business Intelligence tools, (It is therefore intended to be the first book to read---and the first video to watch--before moving on to Wrox books that focus on each of the individual Microsoft BI components.) The book and accompanying video give the novice reader just enough experience with the product to perform basic business analysis and reporting.The book covers all components and related tools that comprise the Microsoft BI toolset. These include SQL Server Integration, Reporting, and Analysis Services, data mining, plus the new BI features of Office 2010. Background theory is given as needed to provide context for those readers with no prior BI knowledge or experience.The book starts with a basic primer on business intelligence and data modeling. The following sections provide step-by-step lessons that show readers how to use: SQL Server Integration Services SQL Server Analysis Services SQL Server Reporting Services Excel BI, including PowerPivot SharePointThe book tightly integrates instructional videos--provided on the book's accompanying DVD--with each of the hands-on lessons found in the book. Each lesson comprises three major components: An Introduction that describes how a certain component or process works. A "Try It Out" section that gives readers the chance to practice what they've learned A Video showing how the author works through each lesson