Microsoft is unveiling a host of new business intelligence (BI) features that will be available in the next version of Microsoft Office, code-named Office 12, in an effort to push the software as more than just a productivity suite.
In a Web conference hosted by president of the Microsoft Business Division, Jeff Raikes, Microsoft unveiled BI enhancements to Office 12's Excel and SharePoint Products and Technologies, which both will integrate with SQL Server 2005, the next version of Microsoft's database.
Microsoft plans to launch SQL Server 2005 November 7, and Office 12 is expected to ship sometime next year.
New features in the Office 12 version of Excel are support for SQL Server 2005 Analysis Services, more spreadsheet capacity, improved sorting and filtering capabilities and improved data visualisation schemes, according to the company. All of these are aimed at making it easier for business users of Excel to more securely access, analyse and share information between databases and enterprise applications, according to Microsoft.
Office 12 also will add Excel Services to SharePoint Products and Technologies. These server-side Excel capabilities will enable customers to better secure, share and manage spreadsheets over a server and allow those spreadsheets to be viewed through a Web browser or downloaded to a user desktop, according to Microsoft.
SharePoint also would be updated so users could more easily build personalised dashboards that combines data and charts from various sources, and found reports and spreadsheets by using improved search capabilities, the company said.
Raikes also is expected to talk up a new product, Microsoft's Business Scorecard Manager, which will be available on November 1. Business Scorecard Manager uses both Microsoft Office and SQL Server to enable business users to track business performance indicators against company goals in a collaborative environment, according to Microsoft. Business Scorecard Manager will cost about $US5000 for the server, with a client access license of $US175 per user.
Microsoft executives have been touting the next version of Office as a BI tool for some time, hoping to convince the industry it is more a platform for business collaboration than just a desktop suite. It has not always been easy for the vendor to convince Office users to upgrade to new versions of the software when they are made available.
Corporate vice-president of Microsoft's Information Worker Product Management Group, Chris Capossela, said in July that many customers are not upgrading their Office suite because they believe the older versions are sufficient to compete in the current business environment. Microsoft is keen to change this perception, according to executives.