Wednesday, January 28, 2015

Open Source Business Intelligence: Pentaho

Pentaho Demo? Looks sweet. 
Business Intelligence has been around for a few years, but the underlying foundation of BI has been around forever. Since data has existed, businesses have wanted to summarize that data and extract valuable information from it like blood from a stone. When modern accounting was codified by Luca Pacioli in the 15th century, he demonstrated not only the double-entry book-keeping system but also ways to summarize that data. You could even go back to Mesopotamia to see early reports.

Wait. BI is just reporting?

Why, yes. That's true. In fact. However, BI tends toward the more modern, the more technical, the more visual, the more flashy. Also, BI might lean a little bit more towards the ... intelligent side of things. KPIs and such.

What kind of offerings does Microsoft have out there?

Excel and SharePoint has some really awesome BI tools thanks to Microsoft's recent initiatives. They want to compete with SAP, Tableau Software, and so forth. But guess what? Those tools are massively expensive and SharePoint is ridiculously hard to install and configure. (There's an MCSE for SharePoint if that gives you any clue).

So what's the cure to all software expensive? Open source, of course.

The one that looks most intriguing right now? I just found Pentaho Community. It looks pretty slick. I'm about to try the Pentaho Hosted Demo. Wish me luck! I'll report back -- if I make it back!

UPDATE: Here's a direct link to the Pentaho demo. Username and password are under the link that says "Login as an Evaluator."


  1. You have shared a nice article here about the Business Intelligence. Your article is very informative and useful to know more about the open source Business Intelligence. unbiased offers the best business intelligence data analytics service at an affordable price.

  2. The Knowledge base develops as the feed into social and various leveled database the board frameworks develop to give level-label assignments and aid the possible control that will be fundamental for fruitful extraction of important true information to help build up a knowledge in understanding science course in pune

  3. This is a great blog that explains why an individual need his way around with Microsoft SQL Server, Access, Excel, and PostgreSQL. If you are looking for mobile app development services company for more information.