On-prem, cloud, hybrid

Pyramid can be installed natively on both Windows and Linux servers, offering seamless deployment across various environments. Whether you choose to host it on-premises, in the cloud, or within a hybrid infrastructure, Pyramid is flexible enough to adapt to your organization's specific needs.

Managed hosting

Pyramid offers managed hosting services for its all-in-one platform, taking care of setup, administration, and ongoing support of your servers and application.

Kubernetes-based architecture

Pyramid’s mini-services architecture is built for scalability, ensuring it can handle any level of demand with ease. By leveraging containerized Kubernetes deployments, the platform takes this flexibility even further, automatically scaling up or down as needed.

This means it intelligently adjusts to usage patterns, optimizing resources in real time. Whether the number of users spikes or workloads shift, Pyramid maintains consistent performance and response times, so you never have to worry about slowdowns or inefficiencies.

Data sources

Pyramid works directly on top of your existing data infrastructure, eliminating the need for data duplication or complex migrations. It features over 250 built-in connectors, enabling instant access to a wide range of data sources.

Direct query engine

PYRANA, Pyramid’s high-performance direct query engine, eliminates the need to download, move, or copy data. It streamlines workflows, allowing users to query data in place without the delays, costs, and complexities associated with traditional data movement. Additionally, it includes an extremely deep analytical function set to perform advanced, cross-dimensional, hierarchical, and semi-additive calculations.

Modeling

Pyramid’s platform empowers users across all skill levels, even those without technical expertise, to easily build, customize, and share sophisticated data models. With intuitive tools and robust capabilities, Pyramid unlocks critical benefits for organizations. No matter the data structure, relational, dimensional, or hierarchical, Pyramid gives users the tools to turn complex, messy data into clear, actionable insights.

Universal semantic layer

Pyramid’s semantic data model lets admins define how users structure and interact with their data. Virtual semantic models sit on top of any data source, no data duplication or ingestion required. This streamlined approach allows users to easily add complex elements like data joins, hierarchies, and additive or semi-additive measures. It’s a flexible, efficient way to shape data for analysis without the heavy lifting.

Master flow

Pyramid’s Master Flow feature lets users build and manage multiple data flows across different models, using fully customizable conditions and success criteria. Whether you're using the intuitive point-and-click interface or diving into PQL scripting, Master Flow offers the flexibility to handle everything from simple to complex workflows.

Data Science

Pyramid’s data science workbench empowers data professionals and citizen data scientists to build, train, apply, and deploy machine learning against data sets to discover patterns, detect anomalies, make predictions, and optimize decisions.

Automate

Pyramid uses intelligent heuristics to automate key parts of the data modeling process, accelerating the path from raw data to actionable insights. These heuristics automatically establish relationships between tables, define measures, classify columns, and organize the data model into logical structures.

Generative BI (GenBI)

GenBI makes it easy for anyone, from business users to data pros, to explore data without writing a single line of code. Just ask a question in plain language, and the chatbot will translate it into complex queries behind the scenes, delivering clear, insightful results in seconds.

Data exploration and visualization

Easily build queries by simply dragging and dropping attributes and measures into dedicated zones to drive over 200 types of visualization with extensive formatting and layout options. Explore your data with ease using intuitive no-code context menus to slice, dice, and drill into the details. You can also create quick, point-and-click calculations and perform actions like pivoting, filtering, sorting, and totaling.

Tabulate

Use familiar spreadsheet formulas to create blended visualizations and business models from multiple data sources.

Advanced analytics

Go beyond basic analysis to extract deeper, more meaningful insights from your data. Use Forecasting to anticipate future trends based on historical patterns, and leverage Outliers to identify data points that fall significantly outside expected ranges. When working with date-time data, Pyramid automatically provides a variety of useful groupings and calculations—such as full month, year-to-date, and day-over-day comparisons—you can easily add to your visualizations. Regression functions let you examine relationships between multiple metrics, helping you understand how one variable may impact another.

Formulate

Pyramid’s Formulate feature makes it easy to create and share custom calculations and business logic for reports and dashboards. With a visual, drag-and-drop interface, anyone can build custom KPIs, member lists, formulas, scripts, and more. You can add dynamic elements using parameters that adjust at runtime and tackle complex, context-aware calculations.

Automate

Pyramid uses advanced machine learning and AI to automatically analyze your data and generate smart insights. With powerful features like Explain and Explain the Difference, you can easily break down and understand your results in just a few clicks. Powered by augmentation engines and intelligent heuristics, Pyramid helps uncover hidden patterns and unexpected insights, all within a user-friendly, no-code environment designed for even the least technical business users.

Reports & dashboards

Pyramid provides both interactive augmented analytics and robust static report distribution. With powerful reporting tools, you can build a single template that generates personalized reports for different stakeholders or clients, ensuring each person sees only the data that matters to them. You can also fully customize your reports and embedded dashboards to match your brand’s colors and style. Design visually engaging presentations with custom charts, infographics, and real-time dashboards. Enhance them further with text, slicers, third-party content, images, and dynamic, data-driven elements—all tailored to tell your story more effectively.

File formats

Create pixel-perfect reports and export them to a format that fits your workflow. Pyramid supports a wide range of export options, including PDF, Word, Excel, PowerPoint, JSON, and image files, making it easy to share insights across teams, clients, or stakeholders. Whether you need a polished presentation, a detailed spreadsheet, or raw data for integration, Pyramid gives you the flexibility to deliver content in the right format, every time.

Embed into your apps & website

Pyramid lets enterprises embed powerful analytics directly into their apps and websites, giving both customers and internal teams access to the insights they need, right where they need them. By integrating analytics into existing workflows, users get a smooth, intuitive experience that encourages adoption and engagement. With Pyramid’s no-code, self-service tools, end users can explore, analyze, and interact with their data, without ever leaving your app.

Scheduled distribution

Schedule and automatically distribute pixel-perfect reports that align with your team’s workflows and timelines. Set the date, frequency, and report details in advance, ensuring stakeholders receive the latest insights directly to their inbox, right when they need them.

Trigger alerts

Keep your team informed in real time by automatically notifying the right people when key events occur. You can set up custom alerts based on specific conditions, like hitting a sales milestone, a sudden spike or drop in performance, or any other critical metric.

Annotations and comments

Turn dashboards into shared workspaces for faster, more informed decision-making with Pyramid’s built-in annotations and commenting features. Team members can leave comments directly on dashboards or on specific data points, providing context, asking questions, or flagging insights in real time.

Data snapshots

When you comment on a data point or start a conversation, you can attach a snapshot so that your colleagues see exactly what you saw.

Granularity

Pyramid offers robust, granular governance capabilities that give you complete control over who can access, view, or modify data, down to the smallest detail. Whether it’s an entire dataset, individual report, or even a single cell in a database, you can set precise permissions that align with your organization’s data policies and security requirements.

Tabulate

Your team can stick to the familiar spreadsheet format they’re comfortable with while still benefiting from enterprise-grade governance. Instead of multiple outdated versions of the same file floating around, Tabulate connects users to a single source of truth, ensuring everyone is working with the most up-to-date, accurate data. Permissions and access controls apply just as they do across the rest of Pyramid’s platform, so you can manage who can view, edit, or share content as needed.

Business logic

Pyramid’s business logic library allows you to centralize and standardize key calculations, metrics, and definitions, ensuring everyone in the organization is speaking the same analytics language. By managing business logic in a governed, centralized repository, you eliminate the risk of inconsistent formulas or conflicting KPIs being used in different reports or dashboards. This not only improves accuracy and trust in the data but also enforces consistency, streamlines collaboration, and supports compliance by making sure approved logic is reused across the platform.

Usage

Pyramid’s usage monitoring capabilities give you deep insights into resource consumption levels and how individuals and teams interact with the platform, helping you track adoption, identify power users, and uncover areas where additional training or support may be needed.