New Data Warehouse Integrations for PowerMetrics

Metric-first analytics are taking the BI world by storm. Companies of all sizes are exploring how to implement a robust metrics strategy that enables consistent metric definitions, exploration, and visualization—directly within their existing data stack. From popular data warehouses housing their gold-standard corporate data, to cloud service APIs, on-premise systems, and spreadsheets, data teams are tasked with building a future-proof metrics strategy that grows and evolves alongside their data infrastructure.

After months of development, we’re very excited to release our integration with seven leading data warehouses (Snowflake, Google BigQuery, Databricks, Microsoft Azure SQL, Amazon Redshift, PostgreSQL, and MariaDB). These new solutions not only give data teams more metric strategy options, PowerMetrics also adds value for business users, with an interactive metric catalog, advanced analysis, visualization, and dashboards.

PowerMetrics is the only hybrid metrics solution available today that supports data warehouse metrics, semantic layer metrics (from Cube and dbt Labs Semantic Layer), and a custom modelling and hosted data solution used to create metrics with data pulled from hundreds of cloud based services, such as Shopify, Facebook Ads, and Zendesk, files, such as Excel, Google Sheets, Smartsheet, and Airtable, and direct REST/API queries for custom data applications. The reality is data teams work with data of varying quality - from raw to business-level, pre-aggregated, and analytics-ready data. PowerMetrics’ adaptable, futureproof metrics strategy connects to all of these sources and grows with you as your data stack evolves.

Are your data scientists or analysts using an enterprise BI solution, like Tableau, Power BI, or Sigma? PowerMetrics is designed to work alongside these tools, while providing a better experience that business users will love. This BI combination enables metric creators and consumers to use the application and interface that meets their needs.

Why data warehouse metrics?

Metrics created based on data warehouse tables/views have several advantages for data teams. One of the most important benefits is there’s no external storage of data. The single source of truth (SSOT) that exists in a company’s modern data stack is maintained and extended through to the metrics layer. The cleansing and transformation of data occurs within the data warehouse. This means preferred technologies, such as dbt Core or dbt Cloud, can be used to create the gold standard data required to be metrics-ready. Data teams have full control over the data transformation process, the exact columns in each table, the name of the table, and any optimizations they need to make. Finally, all the power and performance of the underlying data warehouse can be leveraged directly.

Our new data warehouse integrations enable:

• The fastest creation of metrics, based on data warehouse tables/views, in the industry
• Data teams to easily create metrics from tables or views from the most popular data warehouses
• All queries to be performed in real time on the data warehouse - no data is transferred externally
• The true power and performance of the data warehouse to be leveraged - no data size limitations
• PowerMetrics to update as soon as the underlying table or view in the data warehouse changes via a webhook
• Data teams to clean and define their own metrics-ready data within their data warehouse - no vendor lock-in or proprietary table formats
• Data teams to empower their business users to consume and visualize metrics from data warehouses in a true self-service fashion, all while maintaining full control of the underlying data stack
• Data warehouse metrics to be used interchangeably with semantic layer metrics, data feed metrics, calculated metrics, and instant metrics.

Level up data-driven decision making

Make metric analysis easy for everyone

Get Started Now

Data warehouse customer snapshot

Media Propulsion Laboratory (MPL) is a large digital advertising consultancy using PowerMetrics and BigQuery to visualize client campaign data.

Part of the Craft&Crew group of companies, MPL has clients including Google and Conagra Brands. MPL needed to visualize and share their marketing and ad campaign data internally and with customers. They moved from Looker Studio to PowerMetrics because of its user-friendly design. PowerMetrics solved their need for a professional, yet intuitive solution as most of their users work in marketing, not data teams. As such, they needed a less technical solution to enable their clients to make data-driven decisions.

MPL uses data from a wide array of marketing services including Pinterest, Google Analytics 4, and Facebook, but they store all their data in BigQuery. They connect to BigQuery data using the PowerMetrics data warehouse integration which allows a table/view within the data warehouse to be used across multiple metrics. Metrics are then shared with business stakeholders and made available to them via the metric catalog. Consumers access this “buffet of metrics” and instantly know which metrics to analyze - they’re the metrics certified by the data team. Non-technical users are able to easily analyze single or multiple metrics and create dashboards and reports. The data team has full control over which user can see or edit which metric or dashboard.

PowerMetrics has transformed our approach to data analytics at Media Propulsion Laboratory. The intuitive look and feel, coupled with the remarkable ease of use, have empowered our teams throughout the company. Klipfolio’s fast-moving, responsive, knowledgeable, and collaborative approach made the entire experience truly exceptional.

Richard Marginson, General Manager, Media Propulsion Laboratory

Get started today

Connect today to your data warehouse, create and curate metrics, and enable self-serve analysis, visualization, and dashboard creation for your business users. These new integrations are all available now.

Let PowerMetrics help you streamline your analytics journey and ensure your metrics strategy remains adaptable and resilient. Try it for yourself and we look forward to your feedback!