Even a small business generates giant quantities of data, and a good business intelligence suite helps you analyze and make sense of it all. When you have an accurate picture of where you are, you'll see where you can go, and any of these excellent Linux-based small business intelligence suites will take you there.
Business intelligence (BI) software isn't magical, so don't go throwing a ton of money into it before thinking about what you want to accomplish with it. All of these suites are modular, so you can start small and add more modules as you get familiar with the software and figure out what sort of information you want.
Measuring actual results is a surprisingly neglected task in a lot of businesses, and is often an eye-opener -- is the new product really paying off, and what markets is it doing best in? What are your real costs and rewards in supporting a branch office, or in clinging to old equipment, or in staying open on Sundays and holidays? BI can identify bottlenecks and inefficiencies, and show you what's working and what isn't.
BI software requires some expertise to install, set up, and maintain. When you're shopping for BI software you need to consider:
- Do you have in-house expertise, or do you need to hire help?
- Integration with your existing databases and data sources
- Integration with other software (for example CRM/ERP apps like SugarCRM, Salesforce, Sage)
- Open data formats, support for multiple data formats
- Licensing mode: per server, per user, or something else? Per user licenses for a server product get expensive fast, and they make no sense. It's like charging per person for tap water.
- If you hire custom engineering services, how quickly will they have you up and running? All of the BI vendors in this roundup promise speedy service, as quickly as three to eight weeks.
All of these BI suites have more in common than they have differences: they run on proven open source technologies such as Apache Tomcat and JBoss, AJAX, Java, and various scripting languages, they support multiple databases and data sources, and multiple Web browsers. Competition is pretty fierce and you have good choices, so it may come down to which vendor understands your needs the best, and who gives you the best deal.
Figure 1: Pentaho Data Mining and Predictive Analytics. Image courtesy Pentaho
BI depends on well-organized databases, so you may have some cleanup and organizing to do before you get to play with shiny new BI software. When it's well-setup then non-technical users should be able to slice and dice data however they need to. It isn't a quick fix, but a long-term investment that, used well, pays for itself many times over.
Pricing BI Software
Pricing takes a bit of work to nail down; it pays to talk to the nice salespeople and let them help you sort it all out. All of these BI suites have free software downloads, and free community support. All of them offer multiple modules, custom support and engineering services, and training and documentation. So the answer to "how much will it cost" is always "it depends."
For example, Jaspersoft sells self-support packages for its free community edition that range from $99 to $999 per year for 1,800+ pages of product documentation, access to the knowledge base, and a number of Web-based support incidents. SpagoBI offers three levels of email support that range from about $1,300 to $6,500 per year.
Online training courses range from free to a few hundred dollars and even to $1,200+ for live online sessions.
Software licenses and custom engineering are especially "it depends." Your total first-year costs can easily hit $10,000 for a small shop. Presumably you'll spend less on support and training after your first year. Still, that's considerably less than the traditional proprietary offerings from SAP, IBM Cognos, SAS and other old-time proprietary BI vendors.
Jaspersoft claims to be the world's most-used BI software. JasperReports is everywhere; this is the popular core Java-based reporting engine used in many BI suites to pull data from multiple sources, and output it into multiple formats such as Web pages, PDF, XML, spreadsheet, DOC, and ODT.
JasperReports powers the Jaspersoft iReport Designer, which gives non-technical users the capability to create complex, sophisticated reports. In fact Jaspersoft's strength is its excellent tools for end-users to slice, dice, and present data without having to be ace database gurus.
Talend is the Jaspersoft ETL (extract, transform, load) module, which is also used in numerous BI suites. This is the middleware that integrates data from multiple sources. Nobody has a single harmonious squeaky-clean database; it's always ad-hoc and scattered, so an ETL layer is essential.
Jaspersoft is available as on-premises software, and of course as a hosted cloud service (which everyone, it seems, offers these days) and as a slick mobile BI interface for viewing and building reports. There is a free community edition, and multiple professional editions with different features and support levels.