|
DataCubes 101 with SQL Server 2005
Level:
Introductory
Track:
n/a
Starts:
Apr 6 2008 1:55 PM
Ends:
Apr 6 2008 3:10 PM
Room:
Providence
Speaker:
Pat Tormey
In this session Pat Tormey and Tom Uellner will be presenting an introduction to data cubes with SQL Server 2005 using a real life database.. Not AdventureWorks!
The session will show how to bring data into your warehouse using SQL Server Integration Server (SSIS) then set up the structures to create the Server Analysis Server (SSAS) cube with a SQL Job to keep things in sync SQL Reporting Service with SharePoint 2007 to publish the results, and Excel 2003/2007 for client side analysis.
First time cubists will learn that cubes aren’t mysterious once you learn the impressive jargon, and the results are amazing!
|