Microsoft turns up the BI heat

“The vision of Microsoft is to bring business intelligence (BI) to the masses,” says Cassandra Nuttall, marketing manager for Server Solutions at Microsoft UK. It is a strategy that has, by stages, transformed Microsoft from a non-player in business intelligence (BI) software to one of the market’s main most significant – and feared – vendors.


Company: Microsoft

Main products: SQL Server 2000 Enterprise Edition (includes Analysis Services & Data Transformation Services); Data Analyzer; Excel

CEO: Steve Ballmer

HQ: Redmond, Washington

Status: Publicly listed on Nasdaq

Key financials: Microsoft does not break out figures for its business intelligence products. Revenues of $25.3 billion for financial year 2001; net income of $7.3 billion for the same period.

Key competitors: Cognos, Hyperion, Oracle

Infoconomy opinion: Microsoft's bundling of its business intelligence tools with its relational database software, SQL Server, has enabled it to become a major force in the online analytical processing (OLAP) market. But, as its acquisition of data analysis software company Maximal shows, Microsoft's ambitions run deeper.



Aside from the widespread use of its SQL Server relational database in BI applications, the company has taken the online analytical processing (OLAP) product market by storm. In the three years since it acquired highly-rated technology from Israeli BI company Panorama, it has grabbed over a fifth of the global OLAP market, making it joint market leader with Hyperion Solutions, according to figures for 2001 by Business Intelligence analyst Nigel Pendse.

Fundamental to this success was Microsoft’s early decision to bundle its OLAP tool, Analysis Services, with SQL Server, effectively making it a free add-on. Analysis Services provides multi-dimensional views of cubes of data, allowing sales managers, for example, to conduct analyses across related variables such as sales, customers, geographical areas, and targets.

But Microsoft’s BI ambitions run deeper. It provides extraction, transformation and loading capabilities through its Data Transformation Services toolset, and has progressively added ever-more sophisticated BI facilities to its Excel spreadsheet.

But it is the company’s move into front-end data analysis, query and reporting tools that could shake up the sector most of all. The company’s most aggressive push here came with its mid-2001 acquisition of Israel-based Maximal Innovative Intelligence, vendor of Max, an analytic and visual toolset developed specifically to front end Analysis Services. As it is OLAP-specific, the product (sold as Data Analyzer by Microsoft) has only had minimal impact on mainstream BI tools vendors such as Cognos, Crystal Decisions, Business Objects and Information Builders. But the writing is on the wall, warns Pendse: “It is probably only be a matter of time before Microsoft moves deeper into their space.”

Avatar photo

Ben Rossi

Ben was Vitesse Media's editorial director, leading content creation and editorial strategy across all Vitesse products, including its market-leading B2B and consumer magazines, websites, research and...

Related Topics