Metric Store: Your Centralized Business Logic
The Metric Store is a centralized repository for all of your organization's key performance indicators (KPIs) and business logic. It's where you define the authoritative formulas for your most important calculations—from "Monthly Recurring Revenue" to "Customer Churn Rate"—and make them available as reusable components across the entire Arkham platform.
By defining metrics in one place, you eliminate the risk of inconsistent calculations and empower all users to work from a single source of truth. A metric is no longer a snippet of SQL hidden in a single dashboard; it's a governed, versioned, and discoverable asset.
How the Metric Store Works
Metrics are built on top of the Objects and Properties defined in the Ontology. You create a metric by defining an aggregation (SUM, COUNT, AVG) on a specific Object Property, along with any necessary filters.
When a user includes a metric in a Workbook or asks TARS a question, the platform queries the Metric Store, which in turn uses the Semantic Layer to generate the correct SQL to execute on the Lakehouse.
Key Benefits for Technical Champions
- Don't Repeat Yourself (DRY) Analytics: The Metric Store brings the DRY principle to your analytics code. Define complex business logic once, and it can be reused in hundreds of downstream applications. If the definition of "active user" changes, you update it in one place, and every report and dashboard that uses that metric is instantly updated.
- Guaranteed Consistency: By forcing all analytics to be built from a single, governed set of metrics, you eliminate the primary source of conflicting reports and organizational mistrust in data. Everyone from the CEO to a junior analyst will see the exact same number for "Total Sales."
- Business and IT Collaboration: The Metric Store provides a perfect interface for collaboration. Business analysts can define the metrics they need in clear, semantic terms, and data engineers can focus on ensuring the underlying Objects and data pipelines are robust and performant.
- Agility and Speed: Analysts can self-serve and build new reports with confidence, simply by combining existing, trusted metrics. This dramatically reduces the time it takes to go from a business question to a production-ready dashboard.
- Governance and Discoverability: Every metric is a governed asset. You can see its definition, track its lineage, and understand where it's being used. This makes your analytics landscape far easier to manage and evolve.
