Business Intelligence For All Businesses
SAP, SAS, Oracle, IBM and Microsoft together control about 3/4th of the market.
As of Jan 2011, even though at 5th position in market share Gartner BI magic quadrant put Microsoft in the leader quadrant. Microsoft’s BI offering has grown 23.6% in 2010.
Gartner BI Magic Quadrant 2011
In Microsoft’s current offering in the market, SQL Server 2008 R2 combined with Office 2010 and SharePoint 2010 offer rich capabilities as part of Microsoft’s BI stack. In the IT managed BI world, SQL Server Analysis services(SSAS) powered by SQL Server Reporting Services (SSRS) have offered centrally managed BI services. SQL Server Integration Services provides capabilities needed to bring data from preexisting IT infrastructure for Sales, Marketing, Finance and other operation management systems by SAP, Oracle, Siebel etc.
In the more recent trends of partial and complete Self serviced BI – Excel with Excel Services and PowerPivot, Microsoft Performance Point and SharePoint are great choices to enable the end users with BI capabilities.
Performance point services in Microsoft SharePoint Server 2010 enables analysis and monitoring of Business Performance and Corporate Performance. Performance point enables power users create rich dashboards with ability to navigate to drill down data and perform deeper analysis all on the browser. With the ability to connect to a host of data sources including SQL Server and Excel, this empowers a power user to build necessary strategic intelligence, collaborate and share it.
Excel’s Power pivot add-in is a simple and powerful way to analyze data by end user. SharePoint 2010′s ability to host an Excel document with power pivot and offer the same analysis capability on the browser makes this analysis collaborative yet protecting the data.
There are significant improvements in the reporting capabilities in the next version of SQL Server code named Denali and the BI offering code named Crescent. Stay tuned to this blog for more on that.
Straggling upon business grow? Call consultants to reduce expenses in a company and increase operational activity!