Channel 9 has posted a lot of Business Intelligence screencasts. This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that have been delivered around the globe by Microsoft and Microsoft Partners.  This training event takes the student through the Microsoft BI Platform giving a BI Developer the introduction and basic comfort needed to tackle a BI project using Microsoft technology.

#00: Microsoft BI Platform Integration

#01a: Introduction to Microsoft BI

This screencast provides an overview of Business Intelligence including basic database design concepts, ETL, reporting and analytics.

#01b: Introduction to SQL Server 2005 Tools and Sample Databases

This screencast introduces the tools within the Microsoft Business Intelligence platform as well as a look at the Adventure Works OLTP and OLAP databases.

 

 

 

#02a: Developing a Query-Driven E-mail Delivery System

This screencast shows how to use SQL Server Integration Services (SSIS), Microsoft's ETL tool, to send conditional email alerts during a load.

#03a: Loading and Integrating Data from Multiple Sources

This screencast introduces the concept of Data Flow within SQL Server Integration Services (SSIS) including the use of Merge Join and Derived columns.

#04a: Identifying and Importing New Customers by Using Fuzzy Lookup

This screencast introduces the concept of fuzzy lookup and highlights SQL Server Integration Services (SSIS) support within a Data Flow for performing these tasks.

#04b: Implementing Slowly Changing Dimensions in the Data Flow

This screencast covers one of the most common scenarios when building a data warehouse.  It introduces the concept of Slowly Changing Dimensions (SCD) and how to solve that challenge with SQL Server Integration Services (SSIS).

#04c: Advanced Package Design

This screencast quickly covers some of the more advanced concepts such as Event Handlers, Logging and Package Configurations using SQL Server Integration Services (SSIS).

#05a: Designing a Basic Report

This screencast covers the basics of using SQL Server Reporting Services (SSRS) including configuration of data sources and building basic reports.  A few small tip, tricks and best practices are also covered.

 

 

#05b: Adding Interactivity to a Report

This screencast shows the viewer how to add parameters and drill through to reports developed using SQL Server Reporting Services (SSRS).

#06a: Developing a Report Model and Designing a Report Builder Report

This screencast cover building a Report Model in Business Intelligence Development Studio and show how to connect a report using SQL Server Reporting Services (SSRS).

#07a: Deploying and Accessing Reports

This screencast shows how to embed and deploy SQL Server Reporting Services (SSRS) reports into your applications.

#09a: Designing Dimensions

This screencast covers building dimensions on a cube built using SQL Server Analysis Services (SSAS).

#09b: Advanced Dimension Design

This screencast covers optimization of the dimensions built in the previous screencast using SQL Server Analysis Services (SSAS).

 

#09c: Using the Cube Wizard

This screencast covers the use of the Cube Wizard including some tips and tricks in SQL Server Analysis Services (SSAS).

#09d: Introducing Cube Calculations

His screencast adds to the three previous screencasts by adding calculations to an SQL Server Analysis Services (SSAS) cube.

#10a: Designing Reports on the UDM

This screencast covers the use of building a SQL Server Reporting Services (SSRS) report on a SQL Server Analysis Services (SSAS) cube (Unified Data Model).

#10b: Exploring Analysis Features of Microsoft Excel 2007

This screencast covers the use of Excel as a tool for viewing data within a cube built with SQL Server Analysis Services (SSAS).

 

#11a: More Analysis with Microsoft Excel 2007

This screencast covers using Excel as a powerful tool drill deeper into your information.

 

#12a: Introducing Data Mining

This screencast covers general Data Mining techniques using SQL Server Analysis Services (SSAS).

#12b: Introducing the Table Analysis Tool for Excel 2007

This screencast cover the use of Data Mining Add-Ins for Office using SQL Server Analysis Services (SSAS) as the data mining engine on table data within Excel.

#14a: Building a Performance Point Scorecard

This screencast covers building and publishing scorecards with PerformancePoint.