illumex stirs up the way you establish key performance indicators (KPIs) and critical metrics by introducing a groundbreaking bottom-up methodology. With the innovative Recommended Metrics feature, you gain the ability to incorporate commonly calculated metrics used by data engineers and analysts, in addition to the traditional top-down approach of defining a set of KPIs from the business down to the data.
By analyzing the queries executed by end users, whether through a business intelligence (BI) tool or directly on the Data Warehouse, illumex intelligently extracts frequently used aggregations, taking into account relevant logic, filters, WHERE clauses, and JOINs between tables. It then suggests converting these valuable insights into official metrics.
Similar to the Top-down metrics, Recommended Metrics also acquire crucial business context, becoming searchable, reusable, and serving as the definitive source for calculating and measuring the performance of specific processes.