01. Ingesting data from multiple sources
Users have data in different storage formats like CSV File, MySQL Database, DHIS2 instance, etc. that need to be analyzed. There are some built-in or external connectors for BI tools, like the DHIS2-to-Tableau connector
, but they don't cover all the data formats and require dealing with lots of different interfaces.
02. Organizing and selecting relevant data
Users are dealing with a lot of data sources of different sizes and content. Users don't always know if the data is relevant to their report. Or they know the data, but they don't need all of it, just a part of it. Big datasets result in a time-consuming data load to the BI tool.