Ask questions in natural text

Ask questions about your data in everyday language. AP translates natural text queries to SQL queries and provides results in real time.

Summary report from individual records

Query for DHIS2 tracked entities and events. The correct columns are detected by comparing the intent of the user query with the data warehouse schema. Age groups with 5 year intervals are dynamically generated from the case data.

The generated SQL query uses the floor and count functions to dynamically calculate age groups from case data where age is reported by year.

Statistics with relative periods

Query for DHIS2 data values in natural language and aggregate the numbers, breaking the result down by quarter and regional administrative level. The resulting query will dynamically retrieve quarters for the last 5 years.

The generated SQL query uses the relative_yearly_period table, which is automatically kept up to date, to dynamically retrieve time periods.

Org unit analytics

Query for org units, like regions, districts and sites, which meets specific data criteria, such as number of people on treatment, in natural language.

The generated SQL query uses a variety of aggregation operators and filters.