Pyramid 2018

Pyramid 2018 is a brand new, tightly integrated Analytics and BI platform that supports reporting, dashboards, analysis, data discovery, business user oriented data preparation with machine learning and self-service BI. The suite uses modern standards such as HTML5, Java and RESTful APIs. It was first introduced in 2017 as the successor to BI Office suite with extended functionality, for instance in the area of data preparation and data source connectivity.

Founded in 2009, Pyramid Analytics is a privately held software company with more than 175 employees. The company is now headquartered in the Netherlands and has offices in the United States, the United Kingdom and Israel. With backing from Sequoia Capital, the company continues to grow and now boasts more than 750 customers.

Its first product, BI Office Suite, was launched in 2012. Its current flagship product, Pyramid 2018, was released in late 2017. Pyramid 2018 is an integrated Analytics and BI platform suitable for various Analytics and BI usage scenarios such as dashboards, data discovery, ad hoc reporting and formatted reporting. This Analyst Verdict will primarily focus on Pyramid 2018, with some side notes on BI Office Suite.

Started as a BI contender for companies that were all-in with Microsoft, Pyramid Analytics has now moved to a broader audience with its Pyramid 2018 platform. To achieve this, the software was rewritten using Java which is not Microsoft dependent (i.e., .NET, SQL Server, BING, etc.) anymore. Therefore, openness is one of the major changes in this product line compared to BI Office Suite. Besides the new code, Pyramid 2018 is equipped with number of connectors and engines to offer better support for different data sources as well as additional functionality, especially for data preparation and advanced analytics.

To strengthen this new strategic approach, the vendor now positions Pyramid 2018 as an analytics OS. It is intended to be the platform to serve all the future analytics needs of its customers. Like BI Office Suite, Pyramid 2018 offers broad functionality to meet requirements in the BI space. It still focuses on enabling business users by ensuring governed content usage, and it still does not offer planning and budgeting functionality.

Pyramid Analytics’ former product – BI Office Suite – was built on Microsoft SQL Server Analysis Services (SSAS), making it ideal for Microsoft BI customers who had had limited success integrating Microsoft’s various BI products (e.g., Excel, SharePoint, SQL Server), spanning multiple platforms and product releases. In contrast, BI Office Suite was a single BI platform that gave customers integrated BI functionality with a single install.

Pyramid 2018 is a fully web-based client-server application. In contrast to BI Office Suite, which was dependent on Microsoft technologies such as Silverlight, Pyramid 2018 is Java-based, which makes OS-independent deployment possible. The web client is built using HTML5. This has the advantage of allowing the product to run on any device with automatic screen resizing, and with no desktop software or plug-ins to install or maintain. The product was designed to be run on-premise or private cloud. Currently, Pyramid Analytics does not offer a public hosted service.

User & Use Cases

Demographic data shows off the breadth of scenarios BI Office can handle. Customers use it for basic data analysis, dashboards, ad hoc query and enterprise reporting. 23 percent use the solution’s built-in statistical functions to perform advanced analytics and a further 58 percent have plans to do so in the future. Customers willing to upgrade to Pyramid 2018 will have broader feature set for predictive analytics.

With its broad functionality, BI Office focuses on serving mid-sized companies with an enterprise BI platform to fit the needs of various user types. The mean number of 100 users using the platform is also higher than The BI Survey 18 average of 75.

35 percent of business users model or enrich data with Pyramid Analytics, even more than do so with Tableau. This seems to be a result of using BI Office in Microsoft-oriented scenarios where Pyramid Analytics is able to show its strength for mashing up data and providing self-service capabilities for business users while creating native data models in SQL Server.

Current vs. planned use


5 products most often evaluated in competition with Pyramid Analytics


Percentage of employees using Pyramid Analytics


Number of users using Pyramid Analytics


Tasks carried out with Pyramid Analytics by business users


Company size (number of employees)


Want to see the whole picture?

BARC’s Vendor Performance Summary contains an overview of The BI Survey results based on feedback from Pyramid 2018 users, accompanied by expert analyst commentary.

Purchase the Vendor Performance Summary

Pyramid 2018

Peer Groups Americas-focused vendors, Dashboarding-focused products, Embedded analytics-focused products, EMEA-focused vendors, OLAP analysis-focused products, Self-service reporting-focused products
VendorPyramid Analytics
Number of responses31
ProductPyramid 2018
OfficesNetherlands (HQ), US, UK and Israel