Video description
Welcome to the video portion of Knight's
Microsoft® Business Intelligence 24-Hour Trainer
A book-and-video introduction to
Microsoft's Business Intelligence tools
If you are just starting to get a handle on Microsoft
Business Intelligence (BI) tools, this book and accompanying video
provides you with the just the right amount of information to
perform basic business analysis and reporting. You'll explore the
components and related tools that comprise the Microsoft BI toolset
as well as the new BI features of Office 2010. After a basic primer
on BI and data modeling, the expert team of authors provides you
with step-by-step lessons in the book and videos on the
accompanying Video on how to use SQL Server Integration Services,
SQL Server Analysis Services, SQL Server Reporting Services, Excel
BI (including PowerPivot), and SharePoint.
Integrates instructional videos with each of the lessons
found in the book to enhance your learning experience
Explores the Microsoft Business Intelligence (BI) toolset as
well as the new BI features of Office 2010
Encourages you to practice what you've learned in "Try It
Out" sections
Contains video demonstrations that walk you through how to
tackle each lesson featured in the book
With Knight's Microsoft Business Intelligence 24-Hour
Trainer, veteran authors present you with an ideal
introductory book-and-video package so that you can get started
working with the BI toolset immediately!
Table of Contents
Lesson 2: Dimensional Modeling
00:16:39
Lesson 3: Fact Table Modeling
00:13:15
Lesson 4: Understanding SSIS
00:17:28
Lesson 5: Using the Control Flow
00:11:48
Lesson 6: Using the Data Flow
00:16:51
Lesson 7: Solving Common SSIS Scenarios
00:14:08
Lesson 8: Loading Dimensions
00:15:33
Lesson 9: Loading a Fact Table
00:10:30
Lesson 10: Deploying SSIS Packages
00:07:23
Lesson 11: Understanding SSAS (Whiteboard Video)
00:04:32
Lesson 12: Configuring a Data Source and a Data Source View
00:20:23
Lesson 13: Using the Cube Wizard
00:12:01
Lesson 14: Editing Your Dimension
00:12:38
Lesson 15: Editing Your Cube
00:10:59
Lesson 16: Adding New Dimensions and Measure Groups
00:13:53
Lesson 17: Using MDX
00:21:15
Lesson 18: Creating Calculations
00:12:37
Lesson 19: Data Mining
00:22:54
Lesson 20: Administering the SSAS Instance
00:16:22
Lesson 21: Understanding SSRS (Whiteboard Video)
00:01:35
Lesson 22: Using Report Wizard
00:05:09
Lesson 23: Building a Matrix Report
00:11:05
Lesson 24: Parameterizing Your Reports
00:11:30
Lesson 25: Building Reports on Your Cube
00:18:48
Lesson 26: Using Maps in Your Report
00:11:30
Lesson 27: Building a Dashboard
00:18:23
Lesson 28: Deploying and Administering SSRS
00:15:23
Lesson 29: New Reporting Services Visualizations-Sparklines, Data Bars, and Indicators
00:12:16
Lesson 30: Using Report Builder
00:12:52
Lesson 31: Reporting Against a Cube with Excel
00:09:25
Lesson 32: Loading Data into a PowerPivot Workbook
00:10:18
Lesson 33: Creating a PowerPivot Report
00:11:35
Lesson 34: Data Mining in Excel
00:10:13
Lesson 35: Understanding SharePoint for Business Intelligence
00:08:56
Lesson 36: Deploying and Using Reporting Services in SharePoint 2010
00:15:41
Lesson 37: Building PerformancePoint Dashboards in SharePoint 2010
00:21:37
Lesson 38: Deploying and Using Excel Services
00:17:49
Lesson 39: Deploying and Using PowerPivot in SharePoint
00:19:06
Lesson 40: Managing SharePoint Business Intelligence
00:08:01