Unlock the value of metrics from
the dbt™ Semantic Layer for everyone

PowerMetrics is a self-serve metrics platform and complementary analytics solution. It enables data teams to manage organizational data while providing controlled access to business users with a metrics catalog and streamlined metric-centric analytics.

As a hybrid metrics solution, PowerMetrics has the ability to query data directly from your data warehouse, import metrics from your semantic layer and create native metrics from common file formats and hundreds of data services. Explore our hybrid integrations approach.

A metric catalog lists and organizes a company’s metrics in a centralized location. Curated, certified metrics, managed by the data team, give business users fast access to key data points, improve data consistency, reduce data duplication, and ensure all metrics are meaningful. Governance is assured by granting access rights and permissions at the user level to determine who can view or edit each metric.

A well-defined metrics framework enables faster, more reliable decision making. The consistent structure of metrics allows for effective data monitoring over time and makes it easier to quickly see when there are changes in the data.

Key members of the organization, through careful consideration, decide what each metric measures and how the data is processed. As a result, metrics represent deeply meaningful, well-understood information, based on agreed-upon standards and definitions. Learn more.

The simplest answer to this question is both! PowerMetrics enables everyone in the organization to work with centralized, trusted metrics, curated by the data team.

Data teams use PowerMetrics as an integration tool within their data stack. They import metrics from the semantic layer, query data from the data warehouse or build native metrics from common file formats and data services. All metrics get organized in a centralized catalog of metrics, with managed access for business users.

Business teams use PowerMetrics as a self-serve analytics tool by accessing metrics in the catalog, visualizing and exploring data, setting goals, and building their own dashboards and reports.

Please contact us for more details and your use case for the API. There are several ways you can interact programmatically with PowerMetrics. Most of our customers are interested in an asset management (CRUD) API related to metrics. This can also be used for sandbox environments.

PowerMetrics uses Amazon Web Services (AWS) in Canada to store and manage customer information and processed data and AWS in Ireland to back up this data. Read our Privacy Statement for more details.

We care deeply about the availability, confidentiality, and integrity of your data. Your continued trust in us is our top priority. Read more about how we protect and ensure privacy of your data.

Yes. You'll find lots of great information in our extensive Documentation and Support Centre. Our in-app chatbot is also available 24/7 to answer your questions. If you need more help, you can count on our top-rated Technical Support Team, who are happy to provide personalized email support. For additional resources, check out our YouTube channel and MetricHQ, the first community-driven dictionary for metrics and KPIs.

Yes. We collaborate closely with our partners, who, just like us, are on a mission to bring data analytics to everyone. Selected partners can also buy a partner license to help them grow their client base. Contact us to learn more.

Yes. You can create metrics from a wide range of data sources. No matter how they're created, all metric types can be combined and used interchangeably, in calculations, analysis, and visualizations. Learn more about PowerMetrics integrations.

Metrics in your semantic layer metrics evolve over time as new data is added to the database or the metric definitions are updated. To ensure metric consumers are always working with the latest version of the data, when changes occur, PowerMetrics is automatically updated to align with the data in the semantic layer.

dbt Semantic Layer: This is done using a webhook setup whenever a deployment job is successfully run in the semantic layer project. Users can also manually align data by clearing the cache for their connected semantic layer account in PowerMetrics.

Cube: During the profile configuration users will set the preferred cache period (TTL) or they can also manually align data by clearing the cache for their connected semantic layer account in PowerMetrics.

Yes. Regardless of which semantic layer you use, you can create metrics from data and from calculations based on other metrics. Semantic layer metrics can be combined with any other metric type to create calculated metrics. Calculated metrics combine metric values using an equation (with simple math - addition, subtraction, multiplication, and division) to create a metric that can be expressed as a number, a percentage, or a ratio. With calculated metrics, semantic layer users can create the equivalent of a ratio or derived semantic layer metric. As a bonus, unlike semantic layer ratio and derived metrics, calculated metrics can be built using metrics from any data source. Read more about creating calculated metrics.

dbt Semantic Layer metrics evolve over time as new data is added to the database or the metric definitions are updated. To ensure metric consumers are always working with the latest version of the data, when changes occur, PowerMetrics is automatically updated to align with the data in dbt Semantic Layer. This is done using a webhook setup whenever a deployment job is successfully run in the dbt Semantic Layer project. Users can also manually align data by clearing the cache for their connected dbt Semantic Layer account in PowerMetrics.

Yes. You can create metrics from data and from calculations based on other metrics. dbt Semantic Layer metrics can be combined with any other metric type to create calculated metrics. Calculated metrics combine metric values using an equation (with simple math - addition, subtraction, multiplication, and division) to create a metric that can be expressed as a number, a percentage, or a ratio. With calculated metrics, dbt users can create the equivalent of a ratio or derived dbt metric. As a bonus, unlike dbt ratio and derived metrics, calculated metrics can be built using metrics from any data source. Read more about creating calculated metrics.