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
Extremely superb post, very beneficial information. Never believed I’d obtain the facts I would like right here. I’ve been looking all around the net for some time now and had been starting to get frustrated. Fortunately, I came across your site and received exactly what I had been hunting for.
Although I would’ve loved it more if you added a video or at least photos to back up the description, I still thought that your article quite valuable. It is normally challenging to make a problematic issue look easy. I appreciate your site and will sign up to your feed so I will not miss out on anything. Amazing articles or blog posts
This is certainly my initial stop by and I really like what I’m seeing. Your weblog is so much fun to look over, quite compelling as well as informative. I’ll undoubtedly recommend it to my friends. Nevertheless, I did have some problem with the commenting. It kept giving me an problem whenever I clicked on publish comment. I hope, that can be fixed. Many thanks
I thought it was going to be some boring old post, but it really compensated for my time. I will post a link to this page on my blog. I am sure my visitors will find that very useful
Have you ever considered adding more videos to your blog posts to keep the readers more entertained? I mean I just read through the entire article of yours and it was quite good but since I’m more of a visual learner,I found that to be more helpful well let me know how it turns out
In searching for sites related to web hosting and specifically comparison hosting linux plan web, your site came up.
I suppose the same ideas could be applied to someone that offers no products but only advertising space on their blog. I guess that could be considered as a product
I usually don’t post in Blogs but your blog forced me to, amazing work.. beautiful …
Keep your chin up
Pretty insightful post. Never thought that it was this simple after all. I had spent a good deal of my time looking for someone to explain this subject clearly and you’re the only one that ever did that. Kudos to you! Keep it up
Pretty insightful post. Never thought that it was this simple after all. I had spent a good deal of my time looking for someone to explain this subject clearly and you’re the only one that ever did that. Kudos to you! Keep it up
Good ideas there. Congrats on getting linked from ProBlogger! Keep up the good work.
Thanks for sharing these nice stuffs!! I’ll certainly put it into practice!!
Good read. Needed more pictures though.
Super-Duper site! I am loving it!! Will come back again – taking you feeds also, Thanks.
You know what, I liked this.
The current economic climate forces all entrepreneurs to work harder whether thats face to face selling or marketing your website online.
I can see that you are an expert at your field! I am starting a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business.
Good read. A good quick read.
We didn’t lose the game! We just ran out of time. Vince Lombardi- Keep the good work!
Do you actually consider that?