Agile Query is not BI, but an ad-hoc query system that helps data analysts get insights from data in seconds and without SQL.
What is Agile Query
In Agile Query, you can define metrics using high-level analytical functions. For example, the growth_of function calculates the growth of any aggregate value by a date column. The segment function helps you to segment customers or products by one or more criteria for aggregate values.
Agile Query uses the simplest method to define and search for metrics. It allows you to freely combine multiple facts for different analysis cases and compile the SQL executed on database,
Key Features
- Multi-table calculation expression: It allows you to define a metric expression that creates an aggregate value from multiple tables.
- Nested aggregations: It allows you to use nested aggregation functions for multi-level aggregation metrics.
- Multidimensional aggregation calculation: It allows you to define a metric expression that contains factors from aggregations at different levels.
Metric Definitions for Retail Industry
1. Customer Price: Calculates the average sales per order per customer
SUM(order_details.quantity * order_details.unit_price)
/ COUNT(orders.order_id)DIVIDE(
order_details.quantity * order_details.unit_price,
COUNT(orders.order_id)
)2. Calcuates the sales of a category
SUM_IF(
categories.category_name = 'Seafood',
order_details.quantity * order_details.unit_price
)3. Calcuates the growth of total sales by monthly order date
GROWTH_OF(
SUM(order_details.quantity * order_details.unit_price),
orders.order_date,
'MONTHLY',
1
)Demo Show
The End
Agile Query is a product from China, the website (https://www.agiquery.com) is Chinese and will be translated to English quickly, if you want to concat me, please send a mail to yeongher@agiquery.com.
The data in the demo is an open data set that comes from Microsoft Northwind(https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs).
