Overview

Date: 2023-11-09

Objective: Weekly space for deep dive topics

Participants: (kindly only add your own names, not those of other participants)

• Dragos Dobre

• Uwe Wahser

• BlueSquare

• Swiss TPH

• Harry Larbi

• Wojciech Zgliniecki

Topic Proposals:

• BI options in openIMIS (Part I)

Presentations / Attachments

Minutes

BlueSquare - Supersets (recorded)

• OLAP dashboards

• direct database queries on a replica of the production db of openIMIS

• data sets can be defined by an admin user, while dashboards and charts can be defined by a regular user only on predefined data-sets

• caching

• definition of datasets is key to valid results - whoever creates the query for the data-set needs to know the openIMIS DB-Details

Y-Note - Metabase

• similar set up as supersets

• need to query the openIMIS DB directly (on a replica)

STPH - DHIS2

to be done next time

Questions

• also look at

  • Apache Droid

  • Google open health stack

    
    

Additional Resources