Denis Gobo : OLAP, SSAShttp://sqlblog.com/blogs/denis_gobo/archive/tags/OLAP/SSAS/default.aspxTags: OLAP, SSASenCommunityServer 2.1 SP2 (Build: 61129.1)Business Intelligence Screencastshttp://sqlblog.com/blogs/denis_gobo/archive/2007/12/13/3937.aspxFri, 14 Dec 2007 01:31:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:3937Denis Gobo1http://sqlblog.com/blogs/denis_gobo/comments/3937.aspxhttp://sqlblog.com/blogs/denis_gobo/commentrss.aspx?PostID=3937http://sqlblog.com/blogs/denis_gobo/rsscomments.aspx?PostID=3937<P>Channel 9 has posted a lot of Business Intelligence screencasts. In case you are bored below is the list. Strangely enough they skip numbers</P> <P><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365549#365549" target=_blank>Business Intelligence #01a: Introduction to Microsoft BI</A> <BR>This screencast provides an overview of Business Intelligence including basic database design concepts, ETL, reporting and analytics. <BR><BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365559#365559" target=_blank>Business Intelligence #01b: Introduction to SQL Server 2005 Tools and Sample Databases</A> <BR>This screencast introduces the tools within the Microsoft Business Intelligence platform as well as a look at the Adventure Works OLTP and OLAP databases. <BR><BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365566#365566" target=_blank>Business Intelligence #03a: Loading and Integrating Data from Multiple Sources</A> <BR>This screencast introduces the concept of Data Flow within SQL Server Integration Services (SSIS) including the use of Merge Join and Derived columns. <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365575#365575" target=_blank>Business Intelligence #04a: Identifying and Importing New Customers by Using Fuzzy Lookup</A> <BR>This screencast introduces the concept of fuzzy lookup and highlights SQL Server Integration Services (SSIS) support within a Data Flow for performing these tasks. <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365588#365588" target=_blank>Business Intelligence #04b: Implementing Slowly Changing Dimensions in the Data Flow</A> <BR>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). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365594#365594" target=_blank>Business Intelligence #04c: Advanced Package Design</A> <BR>This screencast quickly covers some of the more advanced concepts such as Event Handlers, Logging and Package Configurations using SQL Server Integration Services (SSIS). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365601#365601" target=_blank>Business Intelligence #05a: Designing a Basic Report</A> <BR>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. <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365608#365608" target=_blank>Business Intelligence #05b: Adding Interactivity to a Report</A> <BR>This screencast shows the viewer how to add parameters and drill through to reports developed using SQL Server Reporting Services (SSRS). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365619#365619" target=_blank>Business Intelligence #06a: Developing a Report Model and Designing a Report Builder Report</A> <BR>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). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365629#365629" target=_blank>Business Intelligence #07a: Deploying and Accessing Reports</A> <BR>This screencast shows how to embed and deploy SQL Server Reporting Services (SSRS) reports into your applications. <BR><BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365636#365636" target=_blank>Business Intelligence #09a: Designing Dimensions</A> <BR>This screencast covers building dimensions on a cube built using SQL Server Analysis Services (SSAS). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365643#365643" target=_blank>Business Intelligence #09b: Advanced Dimension Design</A> <BR>This screencast covers optimization of the dimensions built in the previous screencast using SQL Server Analysis Services (SSAS). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365653#365653" target=_blank>Business Intelligence #09c: Using the Cube Wizard</A> <BR>This screencast covers the use of the Cube Wizard including some tips and tricks in SQL Server Analysis Services (SSAS). <BR><BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365662#365662" target=_blank>Business Intelligence #09d: Introducing Cube Calculations</A> <BR>His screencast adds to the three previous screencasts by adding calculations to an SQL Server Analysis Services (SSAS) cube. <BR><BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365667#365667" target=_blank>Business Intelligence #10a: Designing Reports on the UDM</A> <BR>This screencast covers optimization of the dimensions built in the previous screencast using SQL Server Analysis Services (SSAS). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365675#365675" target=_blank>Business Intelligence #10b: Exploring Analysis Features of Microsoft Excel 2007</A> <BR>This screencast covers the use of Excel as a tool for viewing data within a cube built with SQL Server Analysis Services (SSAS). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365678#365678" target=_blank>Business Intelligence #11a: More Analysis with Microsoft Excel 2007</A> <BR>This screencast covers using Excel as a powerful tool drill deeper into your information. <BR><BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365682#365682" target=_blank>Business Intelligence #12a: Introducing Data Mining</A> <BR>This screencast covers general Data Mining techniques using SQL Server Analysis Services (SSAS). <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365688#365688" target=_blank>Business Intelligence #12b: Introducing the Table Analysis Tool for Excel 2007</A> <BR>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. <BR><BR><A class=entry-title-link href="http://channel9.msdn.com/ShowPost.aspx?PostID=365690#365690" target=_blank>Business Intelligence #14a: Building a PerformancePoint Scorecard</A> <BR>This screencast covers building and publishing scorecards with PerformancePoint. </P><img src="http://sqlblog.com/aggbug.aspx?PostID=3937" width="1" height="1">Business IntelligenceOLAPSSAS