A hands-on guide to Microsoft's Business Intelligence toolset
An ideal starting point for anyone new to the world of Business Intelligence (BI), this unique book-and-DVD package introduces you to the Microsoft BI toolset and provides you with information you need to perform basic business analysis and reporting with Excel and SharePoint. The expert authors begin with a basic primer on BI and data modeling and go on to show you step by step how to use SQL Server Integration Services, Analysis Services, Reporting Services, Excel BI (including PowerPivot), and SharePoint. Each lesson in the book has an accompanying tutorial on the DVD, making your learning experience thorough and understandable.
Knight's Microsoft Business Intelligence 24-Hour Trainer:
Breaks down data warehousing and Business Intelligence into digestible pieces
Escorts you through solving common scenarios involving SQL Server Integration Services
Details the ways to configure a data source and a data source view in SQL Server Analysis Services
Demonstrates how to develop, deploy, and administer SQL Server Reporting Services, use maps in your report, and build a matrix report or dashboard
Teaches you to deploy and use Reporting Services, Excel Services, and PowerPivot for Excel 2010 and SharePoint 2010
Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.
On the DVD
Don't just learndo!
The lessons within the book are each accompanied by an instructional 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 system requirements.
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 with Pragmatic Works.
Adam Jorgensen is an author, trainer, consultant, and President of 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 with Pragmatic Works.
I have read many technical books in the past. I did enjoy reading and trying the try it demos in this book. The video is awesome. Read morePublished 20 months ago by Ali M Zeidan
I received this book as a raffle prize at my local SQL Server user group meeting (MADPASS).
The book is a great mixture of text, screen shots and graphics. Read more
Microsoft SQL Server 2005 and 2008 include powerful Business Intelligence products: Analysis Services, Reporting Services and Integration Services. Read morePublished on March 11, 2012 by dotsnail
There are many books that have long discussion and gets you bored soon. This books has very short chapters that you can quickly finish, and better yet, has the accompanying VIDEO... Read morePublished on March 10, 2012 by M. Iqbal
I wasn't sure what to expect when I picked this book up, but I'm so glad I did! Brian and his team of authors from Pragmatic Works have unlocked the door to what is truly possible... Read morePublished on November 26, 2011 by Neilbu
Knight's BI is an excellent resource for IT professionals needing to make effective use of this ETL tool. Read morePublished on October 23, 2011 by A. Taveras