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.
Christopher J. Barwick (Chris) is the Enterprise Data Analytics Team Lead for Big Hammer, a division of Edgenet. There he manages data for Fortune 500 clients and oversees many multi-terabyte projects in both SQL 2005 and SQL 2008.
Because of these high profile projects and his passion for digging into new technologies, he is often engaged in early adopter programs with Microsoft. From a recent deep dive training at Microsoft on StreamInsight, a new product in SQL Server 2008 R2, to being an early adopter of the very first beta of the .NET Framework, Chris went on to start and run the largest F# Forum site
http://www.hubfs.net. (Microsoft's F# Developer Center on MSDN actually uses his site for their forums!
http://msdn.microsoft.com/en-us/fsharp/default.aspx?ppud=4.)
Well versed with WCF, F#, C# and WPF, you can now find Chris working with VS2010 Beta 2, System.Threading (and System.Threading.Tasks) and the new XAML Windows Workflow 4.0.
When not digging into new Microsoft Technologies, he spends time teaching Machine Learning algorithms to his Jack Russell Terrier "Elsa".
Location: CVTC
Sponsor: CVTC