Business Intelligence (BI) has become increasingly important in today's marketplace, from the smallest businesses up to the largest firms. Understanding what makes good BI starts with proper foundations.
Those foundations are best understood by asking "What is BI?", working through a few common approaches and finishing by diving into building a real BI solution. We'll use Microsoft technologies to build many of the common BI foundational components including a warehouse, an ETL process, an OLAP database with dimensions and a cube and Excel Pivot Tables.
Another important foundation of a successful BI project is the organization of the project collateral during the development lifecycle. This session will cover the usage of Visual Studio 2008, building up all of the BI collateral into one VS2008 solution.
Be prepared to be exposed to the following technologies in this session: SQL Server 2008 database engine, SQL Server Analysis Services 2008, SQL Server Integration Services 2008, SQL Server 2008 Management Studio, Visual Studio 2008 SP1, Visual Studio for Database Professionals GDR R2 (Data Dude), Business Intelligence Development Studio 2008 and Excel 2007 with Pivot Tables and Pivot Charts.