From the Back Cover
A hands-on guide to Microsoft's Business Intelligencetoolset
An ideal starting point for anyone new to the world of BusinessIntelligence (BI), this unique book-and-DVD package introduces youto the Microsoft BI toolset and provides you with information youneed to perform basic business analysis and reporting with Exceland SharePoint. The expert authors begin with a basic primer on BIand data modeling and go on to show you step by step how to use SQLServer Integration Services, Analysis Services, Reporting Services,Excel BI (including PowerPivot), and SharePoint. Each lesson in thebook has an accompanying tutorial on the DVD, making your learningexperience thorough and understandable.
Knight's Microsoft Business Intelligence 24-Hour Trainer:
Breaks down data warehousing and Business Intelligence intodigestible pieces
Escorts you through solving common scenarios involving SQLServer Integration Services
Details the ways to configure a data source and a data sourceview in SQL Server Analysis Services
Demonstrates how to develop, deploy, and administer SQL ServerReporting Services, use maps in your report, and build a matrixreport or dashboard
Teaches you to deploy and use Reporting Services, ExcelServices, and PowerPivot for Excel 2010 and SharePoint 2010
Wrox guides are crafted to make learning programming languagesand technologies easier than you think. Written by programmers forprogrammers, they provide a structured, tutorial format that willguide you through all the techniques involved.
On the DVD
Don't just learndo!
The lessons within the book are each accompanied by aninstructional demonstration on the DVD.
You'll learn to:
Use control flow and data flow
Solve common SSIS scenarios
Load dimensions as well as a fact table
Configure a data source and a data source view
Add new dimensions and measure groups
Build a matrix report
Deploy and administer SSRS
Use Report Builder
Load data into a PowerPivot workbook
Deploy and use Reporting Services in SharePoint 2010
Please see the DVD appendix for details and complete systemrequirements.
About the Author
Brian Knight, SQL Server MVP, is the founder of Pragmatic Works.He is author of more than a dozen books.
Devin Knight is an author, consultant, and trainer withPragmatic Works.
Adam Jorgensen is an author, trainer, consultant, and Presidentof Pragmatic Works Consulting.
Patrick LeBlanc, SQL Server MVP, is a BI Architect, consultant,and trainer with Pragmatic Works.
Mike Davis is an author, developer, consultant, and trainer withPragmatic Works.