About Introduction to SQL Server 2008 BI Solution Development

Introduction This modular 12-hour clinic is a solution-oriented training that takes you through the entire process of developing a BI solution with Microsoft technology. The clinic covers the following topics. Dimensional Modeling Techniques ETL Techniques Using SSIS SQL Server Reporting Services SSAS Data Mining Models Building Dashboards in PerformancePoint Server 2007 The prerequisites for this clinic are as follows: Participants must have development experience with C# and/or VB.NET. Participants must have basic understanding of SQL and relational database technology. Participants must have end-user experience with Excel pivot-table and pivot-chart functionality. Participants are encouraged to have basic understanding of MDX and OLAP technology. Participants are encouraged have basic understanding of SharePoint portal technology. Objectives At the end of the course, students will be able to: Learn how to develop a complete BI solution using the Microsoft Business Intelligence platform, applicable to SQL Server 2005 and SQL Server 2008. Learn the fundamentals of dimensional modeling, OLAP cube design, ETL and integration of analytics into web and desktop applications.