LinceBI

Open-source business intelligence platform with enterprise-grade analytics and no per-user license fees

Data Visualization Business Intelligence lincebi.com

Visit Website

Founded

N/A

Starting Price

€0

About LinceBI

LinceBI is an open-source business intelligence platform from Madrid-based Stratebi that packages the Pentaho stack (Kettle, Mondrian) with its own ST analytics tools into a modern BI portal. It covers ad hoc reporting, OLAP analysis, dashboards, balanced scorecards, and big data integration, and is sold as a hosted cloud service or a supported on-premise license with unlimited users and no per-seat license fees.

Pros & Cons

Pros

No per-user license fees — unlimited users on every plan, and the full platform is open source on GitHub
Very low-cost hosted BI compared to per-seat tools like Tableau or Qlik (25 users for €199/mo)
Built on the proven Pentaho stack (Kettle ETL, Mondrian OLAP) with a modernized portal on top
Covers the full BI lifecycle in one platform: ETL, OLAP, reporting, dashboards, scorecards, and ML
Flexible deployment: managed cloud, on-premise, or your own infrastructure via Docker/Kubernetes
Used by large enterprises including BBVA, Telefónica, Unilever, and Equifax

Cons

Interface and website feel dated compared to modern BI tools like Power BI, Looker, or Metabase
Paid licenses and cloud plans are purchased via email/contact form — no self-serve checkout or trial of paid tiers
Small community and limited third-party resources versus mainstream BI platforms; vendor is a single Spanish firm
Much of the documentation and marketing material is Spanish-first, which can slow down non-Spanish-speaking teams
Self-hosting the free open-source version requires real technical skill (Pentaho stack, Docker) — professional support is not included

Key Features

Global BI portal

Responsive web portal that unifies reports, dashboards, and analysis with search, tags, and tabs on top of the Pentaho BI Server

Ad hoc reporting

Drag-and-drop report builder with business-user-friendly models, corporate templates, and advanced filters

OLAP analysis

Drill-down and roll-up exploration, calculated fields on the fly, what-if analysis, and chart-based data exploration (STPivot)

Dashboards and scorecards

Wizard-driven dashboards plus balanced scorecards with custom KPI weights, thresholds, and traffic-light color coding (STDashboard, STCard)

Report bursting and scheduling

Scheduled report execution with automatic mailing and output to CSV, Excel, PDF, or HTML

Data integration

ETL over multiple data sources with data profiling and deployment automation, based on Pentaho Data Integration (Kettle)

Big data and real-time analytics

Data lake integration with Hadoop, Hive, Spark, Kylin, Vertica, and Elasticsearch, plus real-time and near-real-time analysis

Machine learning and data mining

Classification, regression, clustering, and time-series forecasting (ARIMA, Holt-Winters) for use cases like sales prediction and fraud detection

Enterprise security

Role-based access control, LDAP integration, single sign-on, and JDBC-based security

Flexible deployment

Hosted cloud plans, on-premise installs, and Docker/Kubernetes images with source code on GitHub

Pricing

Free (Cloud)

€0

Up to 1 user
20 GB disk space
2 TB traffic
1 weekly backup
Monitoring service
Ticket platform support

Bronze (Cloud)

€149/month

Up to 5 users
80 GB disk space
5 TB traffic
1 weekly backup
Monitoring service
Ticket platform support

Silver (Cloud)

€199/month

Up to 25 users
160 GB disk space
15 TB traffic
Custom brand
1 daily backup
STAdmin solution
Email and phone support

Gold (Cloud)

€399/month

Up to 200 users
240 GB disk space
20 TB traffic
Custom brand
1 daily backup
STAdmin solution
Email and phone support

Premium License (On-premise)

€7,950/year

All LinceBI modules
Installation and configuration
3 days of training
Annual support and maintenance
50 hours of custom development
Unlimited reports and dashboards
Tiered by 5 / 25 / +25 users

Best For

Enterprise BI without per-seat licensing

Organizations with hundreds of report consumers can roll out dashboards and reporting to unlimited users for a flat monthly or annual fee instead of paying per seat.

Migrating off expensive legacy BI

Teams on Oracle BI, Business Objects, Cognos, or MicroStrategy can replace them with an open-source stack while keeping OLAP analysis, bursting, and scheduled reporting.

Big data analytics on a data lake

Analyze structured and unstructured data through integrations with Hadoop, Hive, Spark, Vertica, and Elasticsearch, including IoT and real-time scenarios.

KPI scorecards for management

Build balanced scorecards with weighted KPIs, thresholds, and traffic-light indicators so executives can track performance and edit targets on the fly.