Saturday, November 28, 2009

Microsoft Going for Big Corporate BI

On the 23rd of November 2009, SearchDataManagement.com posted an article about Microsoft's latest foray into the Business Intelligence software space, competing with the other megavendors Oracle, SAP, and IBM.

Click on this link to read Jeff Kelly's article.

Back in the 1990s, IT shops did not see Microsoft SQL Server as a true enterprise database and went with vendors such as Oracle or IBM instead.  That attitude has since changed dramatically -- SQL Server now easily competes with large capacity databases such as Oracle, DB2, and Teradata.

Not content with terabytes, Microsoft is working on massive parallel processing capabilities which will take SQL Server into the petabytes size.  On the BI front-end, Microsoft is adding in-memory processing capabilities for fast online analytics.

Even though Microsoft Excel is probably the most common tool for analyzing data, is it really a BI software product? 

Once limited to 64K rows, Excel used to only be appropriate for use at the small departmental or individual level.  Bringing in enterprise data from disparate sources was well beyond the abilities of an end-user.  Even with a "PowerPivot" front-end and powerful database processing, will Microsoft really be able to convince companies that Excel is an effective alternative to true BI products such as Cognos, Business Objects, WebFOCUS, Actuate, and Microstrategy?

No comments:

About Me

My photo

I am a project-based consultant, helping data-intensive firms use agile methods and automation tools to replace legacy reporting and bring in modern BI/Analytics to leverage Social, Cloud, Mobile, Big Data, Visualizations, and Predictive Analytics. For several world-class vendors, I led services teams specializing in providing software implementation and custom application development. Based on scores of successful engagements, I have assembled proven methodologies and automated software tools.

During twenty years of technical consulting, I have been blessed to work with smart people from some of the world's most respected organizations, including: FedEx, Procter & Gamble, Nationwide, The Wendy's Company, The Kroger Co., JPMorgan Chase, MasterCard, Bank of America Merrill Lynch, Siemens, American Express, and others.

I was educated at Valparaiso University and the University of Cincinnati, graduating summa cum laude. In 1990, I joined Information Builders, the vendor of WebFOCUS BI and iWay enterprise integration products, and for over a dozen years served in branch leadership roles. For several years, I also led technical teams within Cincom Systems' ERP software product group and the custom software services arm of Xerox.

Since 2007, I have provided enterprise BI services such as: strategic advice; architecture, design, and software application development of intelligence systems (interactive dashboards and mobile); data warehousing; and automated modernization of legacy reporting.