Pyramid Analytics BI Office Suite

Pyramid Analytics was founded in 2009 and is headquartered in Amsterdam. It is a privately held company and has about 200 employees. The vendor also has offices in the UK, France and USA. Research and development is based in Israel, while marketing and sales are driven out of the United States.

The Pyramid Analytics BI Office Suite, based on Microsoft technology, seeks to bridge the gap between enterprise and departmental BI tools. It features four business-oriented BI tools on one common platform, offering modules for reporting/publication, dashboards/story boards, data discovery and data modeling; all of which closely resemble Microsoft’s Office products in their design standards.

While Microsoft SQL Server is currently the most frequently used data source, the product can also read from multiple data sources and its long-term plan is to support most database vendors. These additional data sources include Excel, Access, delimited text files, Oracle, DB2, MySQL, zendesk, Salesforce, Redshift, SQL Server and SQL Azure within front-end enterprise mashups for data visualization.

User & Use Cases

BI Office is versatile. A large proportion of customers say they use it for dashboards, basic data analysis, standard reporting and ad hoc query. 75 percent of respondents also plan to use the suite for advanced analysis in the future.

Pyramid Analytics typically sells its software to mid-sized companies and has a good median number of users, well above The BI Survey 16 average of 100.

64 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 present 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

N = 36

5 products most often evaluated in competition with Pyramid Analytics

N = 75

Percentage of employees using Pyramid Analytics

N = 35

Licensing models

N = 32

Number of users using Pyramid Analytics

N = 34

Tasks carried out with Pyramid Analytics by business users

N = 33

Company size (number of employees)

N = 35

Summary of Pyramid Analytics BI Office Suite highlights

Pyramid Analytics is mainly used in larger mid-sized companies for a range of different BI use cases. The software seems to impress customers so much they often choose it as their standard BI solution.

Pyramid Analytics achieves outstanding results for performance and self-service in this year’s BI Survey. The combination of a business-oriented front end with Microsoft SQL Server as a platform seems to work pretty well: BI Office delivers good performance while providing self-service features to business users. These features range from creating ad hoc queries and reports to individual data models. The vendor is perceived as an innovator by customers thanks to its focus on business users as well as good support for trending areas such as location intelligence and mobile BI.

Customer experience – Top ranked

Peer group: dashboarding-focused products

Chosen as standard – Top ranked

Peer group: dashboarding-focused products

Self-service– Top ranked

Peer group: self-service reporting-focused products

Want to see the whole picture?

Purchase the Vendor Performance Summary

Contains a product review by BARC's analyst team plus user ratings from The BI Survey 16

BI Survey 16 Awards

Pyramid Analytics BI Office Suite

Peer Groups Dashboarding-focused products, EMEA-focused vendors, OLAP analysis-focused products, Self-service reporting-focused products
VendorPyramid Analytics
Number of responses36
OfficesNetherlands (HQ), Israel, USA, UK and others
Employees175+
Customers650+
Revenues (2015)Not disclosed
Web sitewww.pyramidanalytics.com

Test Drive Pyramid Analytics BI Office Suite

Go here to get a free trial version of Pyramid Analytics BI Office Suite:

Get Free Trial

Product Video

Screenshots from Pyramid Analytics BI Office Suite

Quotes from the BI Survey 16

Outstanding results in the Ease of Use, Self-service, Performance satisfaction, and Recommendation KPIs put Pyramid Analytics on top of the pile for customer experience in all its peer groups, showing that BI Office users are extremely satisfied with the solution.
The BI Survey 16
One of its strengths lies in the way BI content can be distributed: reports cannot only be scheduled but also deployed as feeds to recipients. Customers can easily implement end-of-day reporting, which is sent automatically to end users. In addition the vendor provides particularly good features for setting individual alerts, which can execute custom actions such as sending a report based on identifiable characteristics in the data.
The BI Survey 16
The software seems to impress customers so much they often choose it as their standard BI solution.
The BI Survey 16
64 percent of business users model or enrich data with Pyramid Analytics, even more than do so with Tableau.
The BI Survey 16