DHIS2 to PowerBI Connector скачать в хорошем качестве

DHIS2 to PowerBI Connector

DHIS2-to-Power BI connector Strengthening DHIS2 Data Visualizations Background Recently, the use of DHIS2 by several Ministries of Health, global health and development organizations to collect, manage and visualize routine program data has reached a new level of sophistication, with many countries using DHIS2 at national scale on several health areas and with increased data granularity. This has required more sophisticated and robust data use for adaptive program management, and data users are demanding more advanced analytics capabilities beyond DHIS2’s core functionality. In addition, organizations maintain databases housed in other formats such as Excel, Access, ODK/Kobo/ONA, SQL, Sharepoint, Salesforce, and others. As a result, there is demand for more robust data analytics platforms that enable data mashups from the variety of sources where data are stored as well as more advanced visualization features. One of many popular business intelligence (BI) tools used by organizations is Microsoft Power BI which enables the design of interactive visualizations that can be used to create reports, dashboards and custom visualizations. It also provides a desktop-based interface known as "Power BI Desktop" which offers data warehouse capabilities such as data preparation, data discovery and interactive dashboards. The use of PowerBI for visualizing DHIS2 data is increasing amongst global health and development organizations, however, users often require support to more efficiently exchange data between DHIS2 and Power BI. Currently, many users perform a manual and time-consuming data exchange process, exporting and importing clean, aggregate data from DHIS2 into PowerBI, rather than utilizing DHIS2’s API. In order to respond to the needs of data users, thanks to funding from Digital Square, BAO Systems in partnership with Population Services International (PSI) developed the DHIS2-to-PowerBI Connector as a user-friendly utility designed to enable users to more seamlessly: Connect to DHIS2 via user authentication Get data from DHIS2 for querying Create an optimal data model and shape data for robust analytics in PowerBI Refresh the data model with the latest DHIS2 data Please try it, use it and provide us with feedback so we can make this tool more useful and widely available within the DHIS2 community. We look forward from hearing from you all! Population Services International & BAO Systems