PASS Summit Wednesday Key Note 3
More demos using Analysis Services from R2. They're showing how you can refresh data & reports without having to write a bunch of SSIS packages. That's pretty cool too. You can actually connect to Excel now and pull data into SSAS to manage the data like it was a database. You're going to have to spend time managing these files like they were servers. Analysis services is starting to manage itself? I hate to say this, but I've heard that kind of statement before from MS. It wasn't true then. Is it true now? No idea yet, but the small part of me that doubts these things just fired up. The reports can be animated. Data in motion is pretty darn slick to watch. Powerpivot is a freebie that runs…