SunBio Team has good experience developing BI solutions for large Informatics database. This solution was built using Open Source Pentaho BI community edition.
You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/