Pentaho Woos Excel Users to Open Source BI - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management

Pentaho Woos Excel Users to Open Source BI

Pentaho Spreadsheet Services lets business users access OLAP data using Microsoft Excel PivotTables.

Pentaho today rolled out a feature that sweetens its already-popular (more than a half million downloads to date) open source Pentaho BI Suite: Pentaho Spreadsheet Services, which lets business users access OLAP data using Microsoft Excel PivotTables. "There are plenty of people out there who still aren't familiar with BI, it's an ethereal term to them," notes Lance Walter, Pentaho's vice president of marketing. "But tons of people use Excel for data analysis and some level of reporting. Instead of asking them to learn to use a different tool or Java interface, we're letting them keep the tool they love." The new feature costs $90 per named user.

So who's using Pentaho BI (which is based on the Mondrian open source OLAP project and provides reporting, analytics, dashboards, and data integration) so far? Walter says that when he came to the company nine months ago, he expected to see organizations making a religious shift to open source -- switching to Linux, MySQL and so forth throughout the enterprise. In reality, such commitment is rare, and most companies buying Pentaho already have three or four traditional BI systems in place (e.g. Crystal Reports, Hyperion, Cognos, Business Objects), and they're trying the open source alternative for a new project. For instance, some are using it to provide new reporting tools to their HR department, or to build an extranet application that lets customers look at their online ordering and purchase histories. Such extranet applications make sense -- not only are open source BI's standards and architecture friendly to web applications, the CPU-based licensing model is more amenable than a named-user model to an extranet where thousands of people who are not employees interact with the tools.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Commentary
CIOs Face Decisions on Remote Work for Post-Pandemic Future
Joao-Pierre S. Ruth, Senior Writer,  2/19/2021
Slideshows
11 Ways DevOps Is Evolving
Lisa Morgan, Freelance Writer,  2/18/2021
News
CRM Trends 2021: How the Pandemic Altered Customer Behavior Forever
Jessica Davis, Senior Editor, Enterprise Apps,  2/18/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you.
Slideshows
Flash Poll