I dare to predict that in a few years after SQL 11 ships, there will be two kinds of BI professionals – those who know the Business Intelligence Semantic Model and those who will learn it soon. By the way, the same applies to SharePoint. What can you do to start on the path and prepare while waiting for BISM? Learn PowerPivot, of course, which…
Read articleOur online Microsoft BI classes for December 2010 and January 2011: Class Mentor Date Price Applied SSRS 2008 Teo Lachev 12/14-12/16 12:00-5:00 EDT $799 Register Applied SSAS 2008 Teo Lachev 1/11-1/13 12:00-5:00 EDT $799 Register Applied PowerPivot Teo Lachev 1/25-1/26 12:00-4:00 EDT $599 Register Visit our training page to register and more details.
Read articleIn SQL 11, the VertiPaq column store that will power the new Business intelligence Semantic Model (BISM) will be delivered in three ways: 1. PowerPivot – in-process DLL with Excel 2010. 2. A second storage mode of Analysis Services that you will get by installing SSAS in VertiPaq mode. 3. A new column stored index in the SQL RDBMS. The third option picked up my…
Read articleUPDATE 11/14/2010 This blog probably will be the most updated blog I've ever written. I have to admit that my initial reaction to BISM was negative. For the most part, this was a result of my disappointment that Microsoft switched focus from UDM to BISM in Denali and my limited knowledge of the BISM vision. After SQL PASS, I exchanged plenty of e-mails and Microsoft…
Read articleIt looks like this year SQL PASS was the one to go. A must read blog from Chris Webb who apparently shares the same feelings and emotions about the seismic change in Analysis Services 11 as I do. A must read…
Read articleNow that the official word got out during the Ted Kummert's keynote today at SQL PASS, I can open my mouth about Crescent – the code name of an ad-hoc reporting layer that will be released in the next version of SQL Server – Denali. Crescent is a major enhancement to Reporting Services and Microsoft Self-Service BI strategy. Up to now, SSRS didn't have a…
Read articleGreg Galloway just published a ResMon cube sample on CodePlex that aggregates execution statistics (rolls up information about Analysis Services such as memory usage by object, perfmon counters, aggregation hits/misses, and current session stats) from Analysis Services dynamic management views (DMVs) and makes it easily available for slicing and dicing in a cube. I think this will be a very useful tool to analyze the…
Read article
