
[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# 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)



# 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 »](/natural-text-queries)

# 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 »](/embedded-superset-dashboards)



# 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 »](/platform-overview)



# 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.

[Read more »](/workflows)

# 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](https://learn.microsoft.com/en-us/dax/) expressions for Power BI.

[Read more »](/dhis2-indicators-power-bi-dax)



# 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 »](/r-scripting)

# Deploy anywhere

Whether you prefer the scalability of the cloud, with support for AWS,
Azure and GCP, 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
Systems.



# 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.


# Data warehouse flexibility

AP is integrated with a variety of data warehouse providers.



# 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 »](/python-scripting)



# 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 »](/conversational-analytics)

# CSV file upload

AP lets you upload your data files in CSV and Parquet format and
instantly make data available for analytics, allowing everyone to
collaborate and share the same view while removing the need for manual
work.

[Read more »](/csv-file-upload)


![Natural text data
science](/assets/images/natural-text-data-science-small.png)

# Natural text data science

Turn your ideas instantly into execution without having to be a coding
expert. Describe what you want to achieve in plain language, and let the
AI-powered editor in AP write the Python script for you.

[Read more »](/natural-text-data-science)

# Data quality notifications

Create rigorous data quality checks to detect outliers and
inconsistencies and guard against invalid data. Get instantly notified
about issues as they arise, enabling you to take timely action and avoid
making decisions on bad data.

[Read more »](/notifications)

![Data quality notification
flow](/assets/images/data-quality-notification-flow-small.png)

# Looks interesting?

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

[Contact us](/contact)

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# No-code connectors

AP provides connectors to the most popular information systems in
international development, allowing you to load data effortlessly and
make it ready for analysis without writing custom code.


# Azure Blob Storage

The Azure Blob Storage connector extracts data from CSV and Parquet data
files from Blob storage containers, automatically detects columns and
data types and loads the data in the AP data warehouse, represented in
an easy-to-navigate schema.


# BHIMA

The BHIMA connector extracts key information including depot, inventory,
stock, lot, requisition, usage and satisfaction data, and loads the data
in the AP data warehouse, represented in an easy-to-navigate schema.


# CommCare

The CommCare connector extracts key information including survey forms
and case data, loads the data in the AP data warehouse, and creates
views optimized for analytics, represented in an easy-to-navigate
schema.


# CSV file upload

The CSV file upload connector allows you to upload your data files in
CSV format, and automatically detects columns and data types and loads
the data in the AP data warehouse, represented in an easy-to-navigate
schema.


# DHIS2

The DHIS2 connector extracts metadata, aggregate data, events and
tracked entities from DHIS2, loads the data in the AP data warehouse,
represented in an easy-to-navigate schema with wide analytics tables
optimized for analytics.


# FHIR

The FHIR connector extracts FHIR resources including code system,
encounter, location, medication, observation, organization, patient,
person, practioner and questionnaire, and makes the information
available for analytics.


# Global Health Observatory

The GHO connector allows you to specify indicators and load global
health data from the GHO public data portal, including indicators,
dimensions and dimension values, represented in an easy-to-navigate
schema.


# Google Sheets

The Google Sheets connector allows you to specify ranges for header and
data, detects columns and data types and loads the data in the AP data
warehouse, represented in an easy-to-navigate schema.


# iHRIS

The iHRIS connector extracts key human resouce information including
staff employment records, references and facts, and loads the data in
the AP data warehouse, represented in an easy-to-navigate schema.


# Kobo Toolbox

The Kobo Toolbox connector extracts survey data, detects data type for
each survey field and loads the data in the AP data warehouse,
represented in an easy-to-navigate schema, with one table per survey.


# MS SQL Server

The MS SQL Server connector allows you to automatically replicate entire
tables, or select data with a SQL query, and have AP load the data in
the AP data warehouse, ensuring data is consistent and always up to
date.


# MySQL

The MySQL connector allows you to automatically replicate entire tables,
or select data with a SQL query, and have AP load the data in the AP
data warehouse, ensuring data is consistent and always up to date.


# ODK

The ODK connector extracts survey data, detects data type for each
survey field and loads the data in the AP data warehouse, represented in
an easy-to-navigate schema, with one table per survey.


# Ona

The Ona connector extracts survey and form data, detects data type for
each survey field and loads the data in the AP data warehouse,
represented in an easy-to-navigate schema, with one table per survey.


# Oracle

The Oracle connector allows you to automatically replicate entire
tables, or select data with a SQL query, and have AP load the data in
the AP data warehouse, ensuring data is consistent and always up to
date.


# Parquet file upload

The Parquet file upload connector allows you to upload your data files
in Parquet format, and automatically detects columns and data types and
loads the data in the AP data warehouse, represented in an
easy-to-navigate schema.


# PostgreSQL

The PostgreSQL connector allows you to automatically replicate entire
tables, or select data with a SQL query, and have AP load the data in
the AP data warehouse, ensuring data is consistent and always up to
date.


# Public dataset

The public dataset connector allows you to effortlessly integrate data
from a library of curated public datasets, and have AP load the data in
the AP data warehouse, ensuring the data is consistent and always up to
date.


# Amazon Redshift

The Amazon Redshift connector allows you to automatically replicate
entire tables, or select data with a SQL query, and have AP load the
data in the AP data warehouse, ensuring data is consistent and always up
to date.


# Amazon S3

The Amazon S3 connector extracts data from CSV and Parquet data files
from S3 buckets, automatically detects columns and data types and loads
the data in the AP data warehouse, represented in an easy-to-navigate
schema.


# Talamus

The Talamus connector extracts aggregate data from patient records in a
secure way, including data element, facility and disaggregation, and
loads the data in the AP data warehouse, represented in an
easy-to-navigate schema.


# UNICEF Data

The UNICEF Data connector allows you to ingest global data on children
and women from the UNICEF data portal, based on the SDMX standard
including data flows, dimensions and indicator data, represented in an
easy-to-navigate schema.


# World Bank Open Data

The World Bank Open Data connector allows you to ingest global
development data from the World Bank Open Data portal for selected
indicators, including indicator metadata and data, represented in an
easy-to-navigate schema.

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Insights on demand

Chat with your data in natural text and get the insights you need, when
you need it. Powered by AI.

Your browser does not support the video tag.

# Conversational analytics for DHIS2

With the Convo app for DHIS2, you can ask questions about your data in
natural language and have visualizations, tables and interpretations be
created automatically using AI.

![Convo dual-axis bar
chart](/assets/images/convo-dual-axis-bar-chart.png)

# Intelligent visualizations

Visualizations are automatically designed, using line charts for time
series data, bar charts for organisational unit comparison, sunburst and
pie charts for categorical data and gauge charts for percentage-based
indicators.


# Data intepretations created with AI

With the Convo app, data interpretations are provided automatically,
helping users to make sense of their data and take action.


# On-demand dashboards

Information systems tend to get overloaded with dashboards, making it
challenging for users to find the data they need. With conversational
analytics and the Convo app, visualizations can be created instantly
based on natural text questions, allowing users to get the data they
need, when they need it.


©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Centralized inventory of all your data assets

Create a comprehensive data catalog with a unified view across all your
systems and sources, making it easy to manage and explore your data.


AP lets you ingest and merge, in real time, data from multiple and
varied data sources together in a scalable data warehouse. The AP is
designed with easy-to-use connectors for platforms, systems and tools
commonly used by governments and development organizations supporting
them.

# Integrated data repository

AP follows the ELT approach for data loading and integration. Data
pipelines are responsible for retrieving data of interest from source
systems and loading it into the platform. From there, data can be
mapped, transformed and aggregated using materialized **SQL views**, **R
scripts** and **Python** scripts.

![Integrated data
repository](/assets/images/integrated-data-repository.png)

# Bring your own analytics tools

AP makes it easy to consume from a variety of BI and data visualization
tools. **Apache Superset** is the default data exploration tool. Users
can easily connect the cloud and desktop versions of BI tools including
**Power BI** and **Tableau**. Dashboards can be embedded within DHIS2
with the **Super BI** web app.

![Superset
dashboard](/assets/images/superset-immunization-dashboard.png)

# Key platform features

**Data ingest and integration:** The platform provides no-code
connectors to systems, databases and tools commonly used in the
international development sector, allowing for near real-time data
loading.

**Data transformation:** Data can be transformed and enriched using SQL
views, Python scripts and R scripts upon ingestion. Furthermore, data
sets can be parsed and joined to create unique data views for enhanched
analysis.

**Natural text queries:** Users can ask data questions in natural text
and have AP convert to SQL queries for informational retrieval, allowing
non-technical users to ask complex questions and analyze and retrieve
data.

**R and Python:** Users can develop R and Python scripts with the
web-based, integrated scripting editor and execution compute, allowing
for statistical calculations, data modelling, data science and machine
learning.

**Data warehousing:** Data is organized and stored in a scalable
cloud-based warehouse. AP integrates with ClickHouse, PostgreSQL, SQL
Server, Amazon Redshift, Azure SQL Database and Anzure Synapse.

**Import of public data sets:** The platform offers easy import of
publicly accessible data sets. A range of datasets exist within the
library, including from the UN, WHO Global Health Observatory and World
Bank.

**User management:** Users and user groups can be created and managed.
AP offers a fine-grained access control and security model, where each
access to each individual object can be granted to users and user
groups.

**Monitoring, logging and alerts:** The platform provides monitoring and
logging for data pipelines and workflows, and alerts on failures so that
issues can be immediately detected and corrected.

**Workflow mananagement:** Users can orchestrate complex, multi-step
data processes with a powerful workflow builder, handling data loading,
transformation with SQL, R and Python, pushing data to destination
systems.

**Analytics and BI tool integration:** The platform supports most
leading analytics and business intelligence tools, including Power BI,
Tableau, and Superset, to create customized visualizations and
dashboards.

**Embedded visualization:** Data visualization and dashboards can be
embedded in popular systems including DHIS2 using the Super BI web app,
allowing visualizations to be consumed with existing user accounts.

**Security:** Data is encrypted during transit and at rest in the data
warehouse. AP offers firewall management for BI tool connections. The
managed service from BAO Systems includes web application firewall (WAF)
and application scanning.

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Complex workflow management

Orchestrate complex, multi-step data processes with our powerful
workflow builder, ensuring your data is always up-to-date.

# Automated workflows

Workflows allow you to orchestrate and automate data loading from a
variety of data systems and sources, data transformations using SQL,
Python and R, and pushing data to operational systems and data portals.

![Workflow high-level
overview](/assets/images/workflow-script-transformation.png)

# Job orchestration

With workflows, a range of jobs can be scheduled and automated,
including loading data with data pipelines, refreshing of materialized
views, executing Python and R scripts, running data quality checks and
pushing data to destination.


# Parallel job processing

Workflows contain steps, each acting as a container for individual jobs.
Within a step, jobs can be orchestrated sequentially or in parallel to
maximize efficiency and reduce processing time.


©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# DHIS2 indicators to Power BI DAX

Instantly convert DHIS2 indicator expressions to Microsoft Power BI DAX
measures, eliminating complex and cumbersome manual work.

# Convert DHIS2 indicators

From the indicators tab in the DHIS2 data pipeline overview, every
indicator in the DHIS2 system is displayed. After selecting an
indicator, the indicator expression is automatically converted to a
Microsoft Power BI [DAX](https://learn.microsoft.com/en-us/dax/)
expression.

![DHIS2 indicator DAX
converter](/assets/images/dhis2-dax-indicator-converter.png)

# Create DAX measures in Power BI

After loading data with the DHIS2 data pipeline and creating a semantic
model in Power BI, you can instantly create new measures by simply
copying the generated DAX expression from AP and pasting it directly
into Power BI.

![Power BI DAX data
model](/assets/images/dhis2-dax-power-bi-data-model.png)

# Create Power BI dashboards

In the Power BI report designer, new measures can be easily added to
visualizations. In the example below, the measure is used on the Y-axis
of a column chart grouped by region and year.


# Compare with DHIS2 dashboards

In DHIS2, a similar set of visualizations can be created to verify
consistency of the calculations. In the DHIS2 dashboard example below,
the numbers can be seen to match up with Power BI.


©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Integrated Python scripting

The Python scripting environment enables data analysts and scientists to
deploy integrated, complex data models and analytical workflows.


AP provides a web-based editor for Python scripting with syntax
highlighting and code completion, direct connection to the data
warehouse and a console for script output, making it straightforward to
access data and write scripts.

# Automate complex transformations

Include Python scripts as jobs in data workflows, in combination with
data pipelines, SQL transformations and destinations. Create flexible,
complex orchestrated data movement and transformation.

![Workflow script
transformation](/assets/images/workflow-script-transformation.png)

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Integrated R scripting

The integrated R scripting environment empowers data scientists to
perform sophisticated statistical computations with ease.


AP provides a web-based editor for R scripting with syntax highlighting
and code completion, direct connection to the data warehouse and a
console for script output, making it straightforward to access data and
write scripts.

# Automate complex transformations

Include R scripts as jobs in data workflows, in combination with data
pipelines, SQL transformations and destinations. Create flexible,
complex orchestrated data movement and transformation.

![Workflow script
transformation](/assets/images/workflow-script-transformation.png)

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# From ideas to data science with natural text and AI

Perform advanced data science in Python using natural text.

Your browser does not support the video tag.

Turn your ideas instantly into execution without having to be a coding
expert. Describe what you want to achieve in plain language, and let the
AI-powered editor in AP write the Python script for you.

# Outlier detection

The script editor lets you specify a natural text description of the
outcome you want to achieve in plain text. As an example, you can ask
the platform to perform outlier detection using the modified Z-score
statistical algorithm.

![Outlier detection in natural
text](/assets/images/script-outlier-detection-natural-text.png)

Once the script is generated it can be inserted into the query area and
executed. The script output will appear in the console area. In this
example, the most significant data outliers are identified, allowing you
to improve data quality by correcting the outliers which impact data the
most.

![Outlier detection in
Python](/assets/images/script-outlier-detection-python.png)

# Light-weight data connector

The conversational script editor is ideal for creating light-weight data
API connectors. Simply specify which data API you would like to retrieve
data from and how you want to transform the data in natural text.

![Outlier detection in natural
text](/assets/images/script-data-connector-natural-text.png)

The script output can be stored in a data warehouse table, allowing for
combining the data with other tables, integrating it in workflows and
visualizing it in data exploration tools.

![Outlier detection in
Python](/assets/images/script-data-connector-python.png)

# Forecasting

The script editor provides access to all popular Python libraries for
data science and forecasting. This means you can perform advanced data
forecasting by specifying the outcome in plain language.

![Outlier detection in natural
text](/assets/images/script-forecasting-natural-text.png)

For example, you can dynamically retrieve population data from the World
Bank data portal and ask for a prediction of the population size by
country for the next 10 years using linear regression.

![Outlier detection in
Python](/assets/images/script-forecasting-python.png)

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Insights on demand

Chat with your data in natural text and get the insights you need, when
you need it. Powered by AI.

Your browser does not support the video tag.

# Conversational analytics for DHIS2

With the Convo app for DHIS2, you can ask questions about your data in
natural language and have visualizations, tables and interpretations be
created automatically using AI.

![Convo dual-axis bar
chart](/assets/images/convo-dual-axis-bar-chart.png)

# Intelligent visualizations

Visualizations are automatically designed, using line charts for time
series data, bar charts for organisational unit comparison, sunburst and
pie charts for categorical data and gauge charts for percentage-based
indicators.


# Data intepretations created with AI

With the Convo app, data interpretations are provided automatically,
helping users to make sense of their data and take action.


# On-demand dashboards

Information systems tend to get overloaded with dashboards, making it
challenging for users to find the data they need. With conversational
analytics and the Convo app, visualizations can be created instantly
based on natural text questions, allowing users to get the data they
need, when they need it.


©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Instantly load CSV and Parquet data files

Upload your data files in CSV and Parquet format and instantly make data
available for analytics, removing the need for manual work.

Your browser does not support the video tag.

# Upload CSV and Parquet files

CSV data files are found everywhere, often sent as email attachments and
creating multiple versions of truth. AP lets you upload data files and
instantly ingest it into the data warehouse, allowing everyone to
collaborate and share the same view.


# Automatic data type conversion

When uploading a data file, AP automatically detects the data type of
each column, creates a corresponding data table in the data warehouse
and loads the data rows efficiently, removing the need for manual,
time-consuming work.

![CSV file upload data
structure](/assets/images/csv-file-upload-data-structure.png)

# Integrated data view

Once the data files are integested into the data warehouse, it can be
viewed, queried and joined together with all of your existing data
sources, allowing you to effortlessly enrich data analysis.

![CSV file upload data
preview](/assets/images/csv-file-upload-data-preview.png)

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")


[Platform](/platform/)[Connectors](/connectors/)[Docs
↗](https://docs.ap.baosystems.com)[Download
↗](https://docs.ap.baosystems.com/downloads/overview/)[Contact](/contact/)[BAO
Systems ↗](https://baosystems.com)

# Instant data quality notifications

Create rigorous data quality checks and get notified about issues.

# Data quality checks and notifications

Create data quality checks to detect data value outliers, spikes and
dips and invalid data. Have the right people be notified about data
quality issues as they arise. Schedule data quality checks to run as
part of workflows. AP provides detailed notification messages, enabling
you to take timely action.

![Data quality notification
flow](/assets/images/data-quality-notification-flow.png)

# Notification messages

Notification messages will be sent by email, and allow for fully
customizable content. Each data quality check is displayed with a title,
description and a summary table, providing immediate insight into data
quality issues.

![Notification email
message](/assets/images/notification_email_message.png)

©2025 BAO Systems

[baosystems.com](https://baosystems.com)

- [](https://bitbucket.org/baosystems/analytics-platform-site "Bitbucket")
- [](https://www.linkedin.com/company/bao-systems "LinkedIn")
- [](https://www.facebook.com/BAOSystems "Facebook")
