Knight's Microsoft Business Intelligence 24-Hour Trainer : Leveraging Microsoft SQL Server Integration, Analysis, and Reporting Services with Excel and Share Point

by Knight, Brian; Knight, Devin; Jorgensen, Adam; LeBlanc, Patrick; Davis, Mike

• ISBN13: 9780470889633
• ISBN10: 0470889632
• Edition: 1st
• Format: Paperback
• Copyright: 2010-09-28
• Publisher: Wrox

Summary

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

Author Biography

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.

Table of Contents

Introduction

Data Warehousing and Section I: Business Intelligence

Why Business Intelligence?

Dimensional Modeling

Fact Table Modeling

SQL Server Integration Services

Understanding SSIS

Using the Control Flow

Using the Data Flow

Solving Common SSIS Scenarios

Loading Dimensions

Loading a Fact Table

Deploying SSIS Packages

SQL Server Analysis Services

Understanding SSAS

Configuring a Data Source and Data Source View

Using the Cube Wizard

Editing Your Dimension

Editing Your Cube

Add ing New Dimensions and Measure Groups

Using MDX

Creating Calculations

Data Mining

Administering the SSAS Instance

Reporting Services

Understanding SSRS

Using Report Wizard

Building a Matrix Report

Parameterizing Your Reports

Building Reports on Your Cube

Using Maps in Your Report

Building a Dashboard

Deploying and Ad ministering SSRS

New Reporting Services Visualizations - Sparklines, Data Bars, and Indicators

Using Report Builder

Containers

Reporting against a Cube with Excel

Loading Data into a PowerPivot Workbook

Creating a PowerPivot Report

Data Mining in Excel

SharePoint

Understanding SharePoint for Business Intelligence

Deploying and Using Reporting Services in SharePoint 2010

Building PerformancePoint Dashboards in SharePoint 2010

Deploying and Using Excel Services

Deploying and Using PowerPivot in SharePoint

Managing SharePoint Business Intelligence

Appendix: What's on the DVD?

Table of Contents provided by Publisher. All Rights Reserved.