Posts

Office 2007 Business Intelligence Videos

Microsoft has released several cool Business Intelligence-related webcasts that target the forthcoming Office 2007. The webcasts are taken from the corresponding breakout session delivered at the Microsoft Office System Developers Conference 2006.

BI Market Share Report

The latest research by IDC shows Microsoft is ahead of the pack in terms of growth in the business intelligence (BI) tools market. Microsoft ranked fourth in the overall market share and had the highest growth (25%) for the period 2004-2005. The release of SQL Server 2005 and the acquisition of ProClarity (evaluated separately on the report) will most likely gain additional momentum.

OWC to Bite the Dust

Just learned from the David Gainer’s post, that Microsoft has made a decision to retire Office Web Components (OWC) in favor of Excel Services. This is definitely sad news for me. While I agree that Excel Services could fulfill some of the integration scenarios mentioned in the comments for that post, I can think of at least two scenarios where this won’t be the case:



  1. You need a cost effective and easy way to provide OLAP features in your applications. The Office Server pricing model has not been announced yet but it could be intimidating for small companies or application vendors. Not to mention that SharePoint requires Windows Server.

  2. You need to embed an OLAP browser in your Windows Forms application. Currently, I don’t know of a way to embed an Excel spreadsheet on a Windows Form (VSTO, Excel Services, VBA, etc. don’t support this). Not to mention that if browsing cubes is the only thing you need, installing and maintaining the entire Office Server stack may be a difficult proposition.

IMO, it could have been great if the OWC were replaced with a web and Windows Forms OLAP viewers similar to the VS.NET report viewers for SSRS 2005. This would have given developers a light-weight alternative for UDM application integration. Now, we have to wait for third-party vendors to fill in the void. Sigh…

AdventureWorks DW Workspaces Templates Available for Microsoft Office Business Scorecard Manager

These samplesThese samples will get you up and running with Microsoft Office Business Scorecard Manager 2005 utilizing the sample OLAP database provided with Microsoft SQL Server and Analysis Services 2005 called AdventureWorks DW. The purpose of the AdventureWorks DW database is to provide a sample database for exploring the possibilities of OLAP. will get you up and running with Microsoft Office Business Scorecard Manager 2005 utilizing the sample OLAP database provided with Microsoft SQL Server and Analysis Services 2005 called AdventureWorks DW.

Microsoft’s Performance Management Gambit

An interesting article on TDWI about PerformancePoint Server.

PerformancePoint Server Announced

As a follow-up to previous post, during the webcast Microsoft announced a new product called PerformancePoint Server due to be released in mid-2007 alongside Office 2007. PerformancePoint will be a convergent product of Scorecard Manager, ProClarity, and Biz# (yes, Microsoft finally let the cat out of the bag about the strictly confidential so far Biz# initiative). The product will be designed as a web-based portal and will offer performance management, planning and forecasting capabilities.


I personally very excited about this new product offering. PerformancePoint will definately help Microsoft to compete better with other heavy-weight BI players, such as Cognos. More information about PerformancePoint can be found on its website.

Microsoft’s Business Intelligence Product Roadmap Webcast

Jeff Raikes, President of Microsoft’s Business Division and Lewis Levin, Corporate Vice President of Microsoft’s Office Business Applications Group, will present a Live Meeting webcast at 11 am (PDT) regarding Microsoft’s Business Intelligence product roadmap. Click here to register.

Chris Webb’s Review

Chris Webb, whose latest book “MDX Solutions” is a must-read for everyone who’s serious about Analysis Services 2005 and MDX, has written a review for my book “Applied Microsoft Analysis Services 2005”.  Thank you, Chris!

Cumulative hotfix package (build 2153) for SQL Server 2005 is available

Microsoft has released a post-SP1 hotfix which addresses various bugs and issues in SQL Server 2005 and its add-on services.  

Join me in the "hub"

I’ve just learned that I’ve been selected to present at TechEd 2006 US in Boston! I’ve been honored to present Reporting Services for three consecutive years at TechEd. This time, I will change things a bit and instead of focusing on the development area, I will talk about integrating Reporting Services and Analysis Services. As of now, the main topics I am planning to include are:


1. SSAS report actions
2. MDX Query Designer
3. Server aggregates
4. Building data mining reports
5. Ad-hoc reporting
6. CLR integration


See you in the “hub”!