1:30pm - 3:00pm
This session covers the trio of Integration Services, Analysis Services, and Reporting Services.
After a funny intro video (including some snide back and forth between an "IT Pro" and a "Developer". Not sure what an IT Pro was supposed to be, but it sounds like it's the new Microsoft lingo for administrative type roles. The video included comments like the developer calling the IT Pro a "glorified DJ", and the IT Pro saying about development "A monkey could do that". Quite funny), the session got underway. This was a full house, and covered topics like integration services (formerly DTS - which has seen some huge improvements), including a demonstration of its performance improvements (processing and importing 2 million rows in seconds), data cleansing and "AI" abilities, among other advances.
The discussion then moved on to Analysis services, XML/A and unified dimensional model, data mining (such as the demonstrated associative model), key performance indicators, and the dashboard. Very informative.
It then moved to reporting services, demonstrating how developers could create and deploy reports, and how even relatively untrained users could do the same.
