BI Everywhere: Microsoft Is Worth Your Attention

Updated: June 16, 2010

Microsoft's new offerings center around greater support for services in SQL Server 2008 R2; the ability of Excel users to use BI-type reporting tools on both their own and data-warehouse data, presented in an Excel-type user interface; and the ability to share reports over Microsoft SharePoint. Little or nothing of this goes beyond what IBM/Cognos and Oracle, in particular, have done already. Rather, the significance lies in the Microsoft installed base to which this is being offered.

It is already a truism that Microsoft Office is the almost universal tool of most business employees. In the last few years, Microsoft Sharepoint has been approaching that kind of penetration (by some estimates, approximately 70% of Office users now also use Sharepoint). This predominance represents not only mind share among IT buyers and corporate executives, but also dominance across businesses and industries among individual employees. In other words, Microsoft has the ear not merely of the business market, but of a consumer market looking for solutions that will be of use in their work.

This marks a fundamental difference between Microsoft and all other competitors in the BI market. An SAP/Business Objects or a Microstrategy sells to, designs for, and focuses on BI specialists using a central data warehouse. Even successful attempts by such vendors to design "BI for the masses" are crowded out of much of the business-user market by a work force that tends to learn and use only a few tools for all of their tasks - most of them Microsoft. By contrast, if Microsoft decides to focus on BI that all can use, it has a user interface (Excel), a way of collaborating (SharePoint), and other tools for displaying the results of the work (Word, PowerPoint) that are entirely familiar to most workers. It is far less of a stretch for the average worker to employ these tools for BI than it is to apply, say, Oracle OLAP tools. In Oracle tools, Excel is supported, but Oracle lacks control over look and feel and has a more distant relationship with the ultimate consumer/customer.

This is not to say that Microsoft's new offerings support a full "BI for the masses" solution. On the contrary, on both the BI and the "masses" end, functionality and integration is missing. Microsoft has only begun to use its services support to implement and encourage BI-type applications available through Excel or integrated with SharePoint. Nor do Microsoft's OLAP tools yet match Oracle's and IBM's in the ability to do fancy analyses. Governance and workflow are often left to IT; predictive analytics are not as feature-rich; and not all BI features available via SQL Server are fully integrated with Excel and Sharepoint.

Therefore, feature-by-feature comparisons and TCO/ROI studies that compare Microsoft to other BI vendors will often show the superiority of the other vendor. When it comes to the many potential BI users who will not use BI through another vendor in the next few years, however, Microsoft isn't superior: it's just the only possible game in town.

Featured Research
  • How VoIP is Transforming the Healthcare Industry

    The healthcare industry, like many industries, is in the midst of an era of rising costs and an ever increasing pressure to drive down expenses. Now, what if we were to tell you that there was a simple solution to these problems? The answer is VoIP. And to make it sweeter, it allows for your hospital staff to utilize modern mobile devices as resources instead of antiquated phone systems. more

  • Don't Make These 10 CRM Mistakes

    Finding and buying a CRM is exciting. It is also quite daunting as you want to be as prepared as possible so as to avoid making a costly mistake. We have seen that many businesses fail when implementing a CRM, as they repeatedly make the same errors over and over again. more

  • Video Conferencing Goes to Court

    Think technology can’t be utilized in the courtroom? Think again. Video Conferencing within the court system can be extremely cost-effective, efficient, and time-saving. Courtrooms can benefit greatly by video conferencing in expert testimonies, translators, witness testimonies, and much more. more

  • Can Gamification Improve Contact Center Performance

    We have all heard the phrase "all work and no play". Well, would you believe us if we were to tell you that by implementing gamification you can INCREASE contact center engagement, morale, and overall performance? Spoiler alert: 89% of contact center employees believe that a point system within their contact center would boost their engagement! more

  • [Infographic] 8 Common Pain Points UC Eliminates

    Every company has moments of frustration, it is when these moments become extended periods of inefficiency, or pain points, where we start to see loss in productivity and employee morale. What truly sets a successful business apart from those of its competitors, is how they take these pain points and use them as opportunities to improve upon procedures and systems to eliminate pain points and move beyond what was the status quo. more