A complete business intelligence platform that includes reporting, analysis (OLAP), dashboards, data mining and data integration (ETL). Use it as a full suite or as individual components that are acce... More
When we recently covered the results of North Bridge Partners' 2009 Future of Open Source Survey, I noted that many of the respondents said that they see open source Business Intelligence (BI) applications as highly likely to cause disruption in the next five years. For many people, though, this application category is murky and hard to understand. What do the applications do, and what can you get in the free, open source offerings?

While frugality isn't by any means the only reason a business should consider open source software, it would be foolish to think that the current economic situation isn't making it more attractive to companies. There is often, however, an imposing barrier standing in the way of all-out adoption. The mythical "learning curve" involved in moving to open source isn't half so steep or intimidating as that first step -- where do we go, what applications are best for us, and how do we put it all together and make it all work?
This week, Red Hat and IT services distribution provider, SYNNEX, announced the formation of the Open Source Channel Alliance. The Alliance's aim is to help value-added resellers and solutions providers deliver all the benefits of open source applications to their customers.
Ever heard of OpenMRS? It's a community-developed, open source electronic medical record system framework. As anybody in the United States knows, it's not that easy to put together any kind of functional electronic system for medical records. OpenMRS has an additional challenge, though: It's focused on making these systems work in developing countries, where AIDS, tuberculosis, and malaria cause suffering for millions of people. OpenMRS helps educate and support people in developing countries on how to keep up a sustainable medical records system. Now, open source business intelligence software provider Pentaho is part of the mix.
I'm looking for something that can easily process flat files from a variety of sources - quickbooks, excel sheets, sugarCRM - easy to install and intuitive to setup and run reports on a regular basis. The reports aren't too complicated and I probably could get this setup in Excel but was hoping for something that looks a little more appealing :)
I've briefly looked at Jasper Reports and Pentaho but was looking for something a little more intuitive and easier to manage in an excel like interface, something that could be managed by for a non-technical person (accounting clerk)
Thanks.
Heard these guys raised a boatload of cash from investors but I haven't used this and don't know anyone who has.
Any thoughts on how this compares to other leading (Cognos, BI, etc.) BI suites out there?