Share the latest IT news with you
Bringing Business Intelligence to the Masses
One issue that regularly confounds supporters of business intelligence (BI) software has been the general lack of adoption. BI software clearly adds value, but end users have been loath to give up their spreadsheets in favor of richer BI applications that are often difficult to master. To solve this issue, some have argued that what was really needed was a less expensive approach to deploying BI applications using open source or software-as-a-service applications.
But what if the real problem is that users want the functionality of a BI application embedded inside the Microsoft Excel spreadsheet they already know how to use? When you take a good look at what Microsoft is really up to in Excel 2010, it becomes pretty apparent that the equivalent of a data mart is being baked into the application using OLAP database technology that Microsoft bought from Panorama Software. That means that rather than exporting data from Excel to another business intelligence application, Microsoft is positioning Excel as the underlying “database” that BI applications will be layered on using technology that is now marketed under the name SQL Server Analysis Services.
While this approach may not scale to meet the requirements of the most demanding BI applications, it will probably meet the need of the vast majority of end users. BI application partners such as Panorama will then invoke Microsoft’s MDX language to access data in the underlying Excel database, which is a new fact of BI life that even Oracle concedes is going to be a practical necessity.
Panorama also plans to make its NovaView software available in-memory for on-premise applications using Microsoft’s PowerPivot in-memory database. Eventually, the company will make the same technology available for its software-as-a-service implementation, which ironically can be also integrated with Google Apps. Once that’s available, performance of Panorama applications on top of an Excel framework should be a non-issue, say Panorama executives.
The real goal is to make BI applications one click away from the most popular analytic tools in use today, which happen to be spreadsheets from Microsoft and Google. So rather than trying to reinvent the BI wheel, maybe all we need to do is make the existing wheel a little bit bigger.
By Michael Vizard, Posted on IT Business Edge: 07-Dec-2009
Print article | This entry was posted by Wei on December 9, 2009 at 12:33 PM, and is filed under Business Technology Consulting. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
about 11 years ago
The large amount of quality content on your fantastic website has certainly made me realize the huge authority your site contains. Incredible posts and articles seemingly everwhere. Carry on with it.
about 11 years ago
Have you ever considered about including a little bit more than just your articles? I mean, what you say is important and all. Nevertheless just imagine if you added some great graphics or video clips to give your posts more, “pop”! Your content is excellent but with pics and clips, this site could definitely be one of the greatest in its niche. Very good blog!
about 11 years ago
Extremely educational content Impatient for much more articles in your blog
about 11 years ago
The awesome recent content keep me coming back here several times over. Thanks so much.
about 10 years ago
It all actually resolved my dilemma, thank you!
about 10 years ago
Quite nice post. I just stumbled upon your blog and wanted to say that I have truly enjoyed surfing around your weblog posts. Immediately after all I is going to be subscribing to your rss feed and I hope you write once more soon!
about 10 years ago
Dear admin, thanks for providing this blog post. I found it great. Take care,
about 10 years ago
I have been just reading through your site it’s very well crafted!
about 10 years ago
I’m not that much of a online reader to be honest but your internet sites really nice, keep it up! I’ll go ahead and bookmark your internet site to come back later.
about 10 years ago
Hello, I had been researching the net and I came across your own blog. Keep in the excellent work.
about 10 years ago
I’ve got a great concept with regard to.
about 10 years ago
I’ve already been examinating away a few of your tales and it’s pretty good things. I will certainly bookmark your blog.
about 10 years ago
I found your article very interesting, I think you’re a great writer.
about 10 years ago
Excellent site, keep up the great perform my colleagues would really like this”
about 10 years ago
I was very pleased to find this particular web-site.I wanted to appreciate it for your effort with this wonderful read!! I ACTUALLY certainly loving each little it and I’ve got you saved as a favorite to check out latest information you blog post.