TechEd-Dev07: Day 2/3: DEMO: biTunes – Business Intelligence (BI) with Sql 2005

 

This was an interesting (and my first demo) track. Basically take the ITunes library as xml, transform it into normal xml using and publish it into a database with SQL Integration Services. Then create a cube with Analysis Services to let the use do some querying and use Reporting Services to create reports.

I’ve been interested in these SQL Server services for a while, but never had the need to look at them. This session gave a great overview on what you can do with them, the business case wasn’t that far off, ok you wouldn’t use a itunes library, but a big xml chunk as input is not that unusual. It was entertaining and showed that it’s not as hard as it looks (for the basic stuff).

Tags: TechEd-Developers