Unlock insights from your data

AP makes it simple to load, integrate and provide insights from data.

No-code data connectors

Connect all your data sources instantly and without any coding. AP no-code data connectors eliminate the hassle of manual loading and complex ETL jobs, so you can integrate and access your data in an automated, consistent and simple way.

Read more »

Connectors
Text to SQL

Explore data in natural text

AP translates your questions in plain, everyday language into SQL data queries, giving you real-time results to complex questions, all without the technical expertise needed to write SQL or Python code. AP utilizes AI and LLMs to understand your natural text queries and automatically retrieve answers.

Read more »

Embed Superset dashboards in DHIS2

Leverage the power of Apache Superset visualizations directly within your DHIS2 instance. With the Super BI web app you can seamlessly embed interactive Superset dashboards and visualizations within your DHIS2 platform, creating a unified experience without the need to move or duplicate any data.

Read more »

Super BI dashboards
Change log

Monitor data loading

Maintain complete control over your data pipelines and workflows with the centralized monitoring dashboard. Effortlessly track the status of every data loading task, view logs, and configure automated alerts to get notified instantly if something goes wrong.

Create a data inventory

Establish a centralized, searchable inventory of all your data assets. This comprehensive data catalog provides a unified view of data from all your systems and sources, making it easy to browse tables, view field details, and preview data, ensuring your team can quickly find and access the right information.

Read more »

Data inventory
Workflows

Workflows

Orchestrate complex, multi-step data processes with our powerful workflow builder. Create automated pipelines that handle everything from data ingestion and transformation to updating materialized views and pushing data back into operational systems, ensuring your data is always up-to-date.

DHIS2 to Power BI DAX

Using Microsoft Power BI with DHIS2 data is popular, though recreating DHIS2 indicator calculations is often a challenge. AP lets you instantly convert DHIS2 indicator expressions to DAX expressions for Power BI.

Read more »

BI tools
Script

Integrated R scripting

AP offers an integrated scripting experience for the R language, allowing data scientists to create advanced data transformations and statistical computations, and schedule scripts as part of complex data workflows.

Read more »

Deploy anywhere

Whether you prefer the scalability of the cloud, with support for AWS and Azure, or the control of an on-premise server environment, AP is designed to meet your infrastructure needs. For a completely managed solution you can take advantage the managed SaaS offering from BAO.

Deployment
Secrets

Protect your secrets

Safeguard sensitive information such as passwords and API tokens with the AP variable management system. Store secrets safely while allowing easy access from data pipelines and workflows, ensuring credentials are never exposed in plain text.

Connect any BI tool

Maintain the freedom to use your preferred business intelligence tools. Connect your favorite BI tools like Power BI and Tableau directly to your data in AP, and use our firewall management to grant specific users direct data access, empowering your team with the tools they already know and love.

BI tools

Data warehouse flexibility

AP is integrated with a variety of data warehouse providers.

Data warehouses
Analytics for DHIS2

Advanced, real-time analytics for DHIS2

AP lets you do advanced analytics on data, events and tracked entities from DHIS2 in real time. Create cross-program, tracked entity relationship and cohort analytics, have it load almost instantly, all while preserving access control.

Integrated Python scripting

AP provides an integrated coding environment for the Python scripting language, empowering users to do predictive modeling, machine learning and orchestrate custom code execution within automated workflows.

Read more »

Script
Converstational analytics with Convo

Conversational analytics for DHIS2

With the Convo app for DHIS2 you can chat with your data in natural text and get the insights you need, when you need it. Visualizations, interpretations and dashboards are generated on-demand with AI.

Read more »

Looks interesting?

Our team of experts is available to give you a demo and discuss how to meet your needs.

Book a demo